All

Apply to all items

Today

Searches time and date values for today

equals

Searches for values equal to the selected value

does not equal

Searches for values not equal to the selected value

is greater than

Searches for values greater than the selected value

is greater than or equal to

Searches for values greater than or equal to the selected value

is less than

Searches for values less than the selected value

is less than or equal to

Searches for values less than or equal to the selected value

blanks

Searches for records that contain nothing in the field specified by the search condition

non blanks

Searches for records that contain any value in the field specified by the search condition

like

Searches for records that contain the character string specified

Note: You can precede or follow text character strings with the % wildcard. For example, %app% would search for any text string that contained the characters app anywhere in the string.

not like

Searches for records that do not contain the character string specified

Note: You can precede or follow text character strings with the % wildcard. For example, %app% would search for any text string that does not contain the characters app in the string.

Yesterday

Searches for records with yesterday's date

This Week

Searches for records within this week

Last Week

Searches for records within the previous week

Last Month

Searches for records within the previous calendar month

Current Month

Searches for records within the current month

Last 6 Months

Searches for records within the last 6 months

Current Year

Searches for records within the current year

In the Past >

Searches for records more than X hours in the past

In the Future >

Searches for records more than X hours in the future

Before Now By

Searches for records from X hours ago until now (where “now” is when the BPA runs)

After Now By

Searches for records between now and X hours from now (where “now” is when the BPA runs)

Next Week

Searches for records within the week after the current week

Next Month

Searches for records within the next calendar month

Next Ninety Days

Searches for records within the next three months

Next Year

Searches for records within the next calendar year