Custom filter and resource custom fields

[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 roles)
iii) Skills (Job skills like SharePoint, DBA, Project manager etc.)(can be
multiple skills)
Skills lookup table is as follows:

Application
Java
SharePoint
Cognos
Database
Oracle
Sybase
Project Management
MS Project
SAP

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"
Field Name: Skills
Test: contains
Value: sharepoint

When I hit "OK" button, i get this error:
"The specified filter cluase is invalid. Filter: [Skills contains
sharepoint]. Invalid invalid lookup. The valid values are Application,
Application.Java, Application.SharePoint, Application.Cognos, Database,
Database.Oracle, Database.Sybase,Project Management, Project Management.MS
Project, Project Management.SAP "

Could plz help me out to fix this? Or its by design of Project Server 2007?
Any help will be appreciated.

Cheers,
Aroh SHukla

 

[Robert]

On the filter you will have to use equals or does not equal.

You will also have to use the entire value in the lookup table as an example.
Lets say I have a lookup table with the value Milestone Task.
If I write the filter to look for Milestone it will bring back nothing.
Adding the entire name of Milestone Task to the filter I get every Custom
Field with the value of Milestone Task.

Use muiltiple equals in your filter and maybe create several views
containing the values you want to see.
--
Project Consultant

REJ Company

(e-mail address removed)

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 roles)
iii) Skills (Job skills like SharePoint, DBA, Project manager etc.)(can be
multiple skills)
Skills lookup table is as follows:

Application
Java
SharePoint
Cognos
Database
Oracle
Sybase
Project Management
MS Project
SAP

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"
Field Name: Skills
Test: contains
Value: sharepoint

When I hit "OK" button, i get this error:
"The specified filter cluase is invalid. Filter: [Skills contains
sharepoint]. Invalid invalid lookup. The valid values are Application,
Application.Java, Application.SharePoint, Application.Cognos, Database,
Database.Oracle, Database.Sybase,Project Management, Project Management.MS
Project, Project Management.SAP "

Could plz help me out to fix this? Or its by design of Project Server 2007?
Any help will be appreciated.

Cheers,
Aroh SHukla

 

[Aroh Shukla]

Thanks a lot for Robert.

Cheers,
Aroh

On the filter you will have to use equals or does not equal.

You will also have to use the entire value in the lookup table as an example.
Lets say I have a lookup table with the value Milestone Task.
If I write the filter to look for Milestone it will bring back nothing.
Adding the entire name of Milestone Task to the filter I get every Custom
Field with the value of Milestone Task.

Use muiltiple equals in your filter and maybe create several views
containing the values you want to see.
--
Project Consultant

REJ Company

(e-mail address removed)

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 roles)
iii) Skills (Job skills like SharePoint, DBA, Project manager etc.)(can be
multiple skills)
Skills lookup table is as follows:

Application
Java
SharePoint
Cognos
Database
Oracle
Sybase
Project Management
MS Project
SAP

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.

Filter "Position"

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"

Filter: Skills

Field Name: Skills
Test: contains
Value: sharepoint

When I hit "OK" button, i get this error:
"The specified filter cluase is invalid. Filter: [Skills contains
sharepoint]. Invalid invalid lookup. The valid values are Application,
Application.Java, Application.SharePoint, Application.Cognos, Database,
Database.Oracle, Database.Sybase,Project Management, Project Management.MS
Project, Project Management.SAP "

Could plz help me out to fix this? Or its by design of Project Server 2007?
Any help will be appreciated.

Cheers,
Aroh SHukla