A
Aroh Shukla
Hi all,
1)
I have created a 3 resource custom fields namely:
i) Position (Job position like Senior Software Engineer)
ii) Roles (Job role like, Senior Developer and Tester) (can be multiple for
a resource)
iii) Skills (Job skills like SharePoint, DBA, Project manager etc.)(can be
multiple for a resource.)
Skills look up table is something like this:
Application
Senior Developer
Developer
Database
Project Management
2) Create a new view with these columns:
View name: Software team (Singapore)
Columns: Resource name, Team Name, Position, Roles,Skills
3) Now I have problem when I filter using "Custom filter".
For e.g.Field name: Position
Test: CONTAINS
Value: senior
When I hit "OK" button, i get this error:
"The specified filter cluase is invalid. Filter: [Position contains senior].
Invalid test. The referenced custom field uses a lookup table. This can only
be evaluated with tests like equals and does not equal"
1)
I have created a 3 resource custom fields namely:
i) Position (Job position like Senior Software Engineer)
ii) Roles (Job role like, Senior Developer and Tester) (can be multiple for
a resource)
iii) Skills (Job skills like SharePoint, DBA, Project manager etc.)(can be
multiple for a resource.)
Skills look up table is something like this:
Application
Senior Developer
Developer
Database
Project Management
2) Create a new view with these columns:
View name: Software team (Singapore)
Columns: Resource name, Team Name, Position, Roles,Skills
3) Now I have problem when I filter using "Custom filter".
For e.g.Field name: Position
Test: CONTAINS
Value: senior
When I hit "OK" button, i get this error:
"The specified filter cluase is invalid. Filter: [Position contains senior].
Invalid test. The referenced custom field uses a lookup table. This can only
be evaluated with tests like equals and does not equal"