Display Filter Syntax - EcoSys - 3.01 - Help - Hexagon PPM

EcoSys Projects Help (3.01)

Language
English (United States)
Product
EcoSys
Search by Category
Help
EcoSys Standard Version
3.01

Each of the following commands can be put into Display Filter fields within a spreadsheet.

Text

These rules apply to text (ID, name, status, string, memo, etc.) columns only.

Command

Syntax/Examples

Contains

Includes rows where field contains the value typed in the display filter textbox. The filter is not case sensitive.

Does not contain (!)

Includes rows where the field does not contain the value typed in the display filter text box.

Text alphabetically before, or numeric value less than (<)

Includes rows where the field text starts with a character alphabetically before the value entered. Or, rows where numeric value is less than value entered.

For text values, this filter is case sensitive.

Text alphabetically after, or numeric value greater than (>)

Includes rows where the field text starts with a character alphabetically after the value entered. Or, rows where numeric value is greater than value entered.

For text values, this filter is case sensitive.

Contains an exact literal string

"…"

‘…’

This will include only values that contain exactly what is entered between the double or single quotes.

This is case sensitive.

Starts with or ends with value (*)

If * is used after a value, it will return fields that start with that value. If * is used before a value, it will return fields that end with that value

Contains at least one value from list of values (a,b,c)

Includes rows where any one of the values listed between commas is found within the field’s text. This is also known as an OR search.

Contains all values in list (a b c)

Includes rows where all values are found within the field’s text. This is also known as an AND search.

Only include blank values

" "

‘ ‘

Includes rows where the field’s value is blank.

  • If the data contains one of the special characters (! < > " ' ? * / , ~)? The filters will always find what is typed, AND if it matches one of the above patterns, it will find values matching the pattern. If you wrap what you’re looking for in quotes, the filters will find only that, and not match the pattern.

  • Quoted text can be copied/pasted from a Word document, a PDF, or a web page, because smart-quotes are treated just like double-quotes and single-quotes.

Numbers

These rules apply to number (Units, Costs, Percent, Count, etc.) columns only.

Command

Syntax/Examples

Equals(...) or (=...)

Simply type all or a part of whatever you are looking for.

Does not equal (!...)

Add an exclamation point in front of whatever value you don't want to appear.

Greater Than (>...) or Less Than (<...)

< Returns everything greater than a number, >returns everything less than a number.

Greater Than or Equals (>=...) or Less Than or Equals (<=...)

<= Returns everything equal to or greater than a number, >returns everything equal to or less than a number.

Between (a..b)

Simply type in two numbers separated by two periods (100..200) will return everything between 100 and 200.

Contains at least one (a,b,c)

Enter a list of values separated by comma to find one or the other or all of those strings e.g. bob, carol will find anything containing either 'bob' or 'carol' or both, and project, porject, proj will find any of those 3 variations of the word "project".

Contains all (a,b,c)

Separate words with a space to find them all, e.g. this that finds "this that" and "this or that", but not "this other" nor "other than that".

SHARED Tip In a screen layout, a hyperlinked (event source key) unit, cost, percent, & count column is filtered like a text column. An ID may look like a number, but it is filtered like text.