Filter for list of values - Project View (PWA)

[Daryl Cunningham]

How do you add a strings of values for a Project filter in PWA?

ex. filter for:

Field 1 CONTAINS Value1, Value2, Value3 OR
Field 2 CONTAINS Value1, Value2, Value3

??

 

[Gord Schmidt]

Hi Daryl,

There is no CONTAINS operator available in the Project filter in PWA.

I would suggest you create another custom field that uses a formula to
create a single value to test against.

Gord

 

[Daryl Cunningham]

Gord,

Thanks for the reply but the columns & fields available in the filter area
within ADMIN / PROJECTS are:

Field Operator Value*
And/Or

<OPTION VALUE="=">Equals</OPTION>
<OPTION VALUE="<>">Not equal to</OPTION>
<OPTION VALUE="Begins">Begins with</OPTION>
<OPTION VALUE="Contains">Contains</OPTION>
<OPTION VALUE=">">Greater than</OPTION>
<OPTION VALUE=">=">Greater than or equal to</OPTION>
<OPTION VALUE="<">Less than</OPTION>
<OPTION VALUE="<=">Less than or equal to</OPTION></SELECT>

 

[Gord Schmidt]

Hi Daryl,

Right. Sorry to confuse. The CONTAINS that is available is different than
what you are looking for if I understand what you are trying to do.

This is how CONTAINS works. The following filter...
Field: Enterprise Project Text 1
Operator: Contains
Value: project
....would return items where the text value contains the string "project"
within its entire value. So something like "Microsoft Project Server" would
be returned, but not something like "MPS".

I think you are looking for something like SQL Server's IN operator (ex.
WHERE EnterpriseProjectText1 IN ('Red', 'Yellow', 'Blue')), but that does not
exist for PWA filters.

Gord

 

[Daryl Cunningham]

You are correct. That's what I'm looking for but it doesn't exist. I guess
the only way I can do it is to add 1 "test" for each value I want to see.

Do you know if there is a "IS NOT EQUAL TO" = Null or blank value?

 

[Gord Schmidt]

Hi Daryl,

Off hand, I know there is a "NOT EQUAL TO" but I don't know if leaving the
Value field blank will work. Try it out.

As I said in my earlier post, I would suggest you create another custom
field that uses a formula to create a single value to test against.

Gord

 

[Daryl Cunningham]

Thanks again Gord. I ended up adding a customized calculated field within
the enterprise global and then filtered on the results of that test. The
only downside is that I need to open all schedules and re-save for it to
take.

Thanks again.

-daryl