The selected file /tmp/filem4qYIk could not be uploaded, because the destination sites/default/files/css/css_a91cd284035e73ba34d112bfed2f5a16.css is not properly configured.
  The selected file /tmp/filedbeefc could not be uploaded, because the destination sites/default/files/css/css_de1aa27776f1462d2b0d83a80ce4b92d.css is not properly configured.

In order to use the Query Builder to get to a certain desired Item, it is often necessary to filter resulting Items based on chosen criteria.

There are many different available filters, which can be organized according to the type of object that is the basis of the filter.

Text-Type filters: These filters are available for text Fields as well as certain specialized text Fields (such as Email Address fields) and parts of multi-part Fields (such as the City part of an Address Field). The available filters are:

• Contains - This filter only displays Items where the Field or Field Part contains the specified/evaluated text.
• Does Not Contain - This filter only displays Items where the Field or Field Part does not contain the specified/evaluated text.
• Is - This filter only displays Items where the Field or Field Part is exactly the specified/evaluated text.
• Is Not - This filter only displays Items where the Field or Field Part is not exactly the specified/evaluated text.
• Is Empty - This filter only displays Items where the Field or Field Part is empty.
• Is Not Empty - This filter only displays Items where the Field or Field Part is not empty.
• Starts With - This filter only displays Items where the Field or Field Part starts with the specified/evaluated text.
• Ends With - This filter only displays Items where the Field or Field Part ends with the specified/evaluated text.

Number-Type Filters: These filters are available for number Fields as well as specialized number Fields (such as Currency Fields) and parts of some multi-part Fields (such as the Area Code part of the Phone Number Field). The available filters are:

• Is - This filter only displays Items where the Field or Field Part is exactly the specified/evaluated text.
• Is Not - This filter only displays Items where the Field or Field Part is not exactly the specified/evaluated text.
• Is Less Than - This filter only displays Items where the Field or Field Part is strictly less than the specified/evaluated number
• Is Greater Than - This filter only displays Items where the Field or Field Part is strictly greater than the specified/evaluated number.
• Is Between - This filter only displays Items where the Field or Field Part is greater than or equal to the first specified/evaluated number and less than or equal to the second specified/evaluated number.
• Is Not Between - This filter only displays Items where the Field or Field Part is strictly less than the first specified/evaluated number or strictly greater than the second specified/evaluated number.
• Is Empty - This filter only displays Items where the Field or Field part is empty.
• Is Not Empty - This filter only displays Items where the Field or Field Part is not empty.

Time-Type filters: These filters are available when filtering on a Date, Date and Time, or Time Field. They are:

• Is Before - This filter only displays Items where the time is strictly before the specified/evaluated time.
• Is After - This filter only displays Items where the time is strictly after the specified/evaluated time.
• Is Empty - This filter only displays Items where the time is empty.
• Is Not Empty - This filter only displays Items where the time is not empty.
• Is During - This filter only displays Items where the time is between the two specified/evaluated times (identical times pass as well).
• Is Not During - This filter only displays Items where the time is not between the two specified/evaluated times (identical times pass as well).

The “Is Before”, “Is After”, “Is During” and “Is Not During” filters have a second choice which determines what the times are evaluated against. These second choices are:

Custom - You are given the option to specify date(s).

Relative Date - Allows you to choose to evaluate against a time a certain amount of time before or after the current time.

Now - Evaluates against the current time.

Today - Evaluates against the current day.

This Week - Evaluates against the current week.

This Month - Evaluates against the current month.

This Quarter - Evaluates against the current quarter.

This Year - Evaluates against the current calendar year.

Yesterday - Evaluates against the previous day.

Last Week - Evaluates against the previous week.

Last Month - Evaluates against the previous month.

Last Quarter - Evaluates against the previous quarter.

Last Year - Evaluates against the previous year.

Tomorrow - Evaluates against the next day.

Next Week - Evaluates against the next week.

Next Month - Evaluates against the next month.

Next Quarter - Evaluates against the next quarter.

Next Year - Evaluates against the next year.

Item-type filters: These filters are available when an Item or multi-part Field is compared to another, such as when an Item Picker is filtered, when “Item” is chosen as a filter, or when a social security number is filtered. They are:

Is - This filter only displays items that have the same WorkXpress Item ID as the specified/evaluated Item.

Is Not - This filter only displays Items that don't have the same WorkXpress Item ID as the specified/evaluated Item.

Is Empty - This filter only displays Items where the Field or Field Part is empty.

Is Not Empty - This filter only displays Items where the Field or Field Part is empty.

Checkbox-type filters: These filters are only available for checkboxes. They are:

Is Checked - This filter only displays Items where the checkbox is checked.

Is Not Checked - This filter only displays Items where the checkbox is not checked.