Project Web Access

[Poonam]

I have created a custom field having lookup table with 3 level hierarchy. I
want to create a view where I can filter this custom field with a query like
FieldName contains a word in the first level of the hierarchy of the lookup
table. But I get the error:This field can only be evaluated with tests like
equal and does not equal

 

[Paul Conroy]

I'm running SP1, Infra Update and the Aug Cumulative Update and I have the
"contains" test available. (Project Center View).

If you're not running the latest updates, it would be worthwhile planning to
upgrade at the earliest opportunity.

If you are running with the latest updates, is this test missing from a
particular view?

 

[Poonam]

Thanks for your reply Paul.
I have the "contains" test available but is it possible to use this
"contains" test for a custom field having a lookup table? I actually want to
create a view where I can display details where the fieldname contains a
specific value e.g in a hierarchial structure like below:
testA
testA1
testA2
testB
testB1
testB2
I want to display only the values that are contained in testA(i.e
testA\testA1 and testA\test). When I try adding Fieldname contains testA, I
get the error :This field can only be evaluated with tests like equal and
does not equal.

 

[Paul Conroy]

to work around this limitation, you could use multiple "equals" filters. I
know this is not ideal, but I'm not aware of an alternative.