Filter a list of wraps

The text fields at the top of a list of wraps allow you to filter the list using many different conditions, using the syntax described here.

When you work with ExcelWraps, you often arrive at lists of wraps that look almost the same anywhere you find them.

Creator filter

Some lists have a Creator filter that allows you to view only the Wraps that are created by Me (the logged-in user) or Any (created by anyone).

State filter

Some lists have a State filter that allows you to hide frozen wraps or show only wraps you need to sign or have signed.

  • Live – Show all wraps that are not yet frozen, i.e. work in progress. Wraps freeze when the last signature has been made to indicate the completion of a process.
  • Frozen – Show only wraps that are frozen and cannot be modified further.
  • AwaitingSignature – Show only wraps that are waiting for your signature.
  • SignedByMe – Show only wraps that you have signed.
  • In some lists, there is also an AutoNumber filter where you can explicitly select the First wrap (with the lowest auto number), Last (highest-numbered), or LastFrozen (most recently frozen).
  • Any – Shows you all the wraps.

Column filters

On top of each column in the list is a text field where you can enter a filter for the column.

Screenshot of the column filters at the top of a list of wraps

List of filter operators

The possible operators that you can use as column filters are:

  • hello – show only wraps where the field contains ‘hello’, co is the default operator for string values
  • co(hello) – show only wraps where the field contains ‘hello’
  • nc(hello) – show only wraps where the field does not contain ‘hello’
  • eq(hello) – show only wraps where the field contains only the exact string ‘hello’
  • ne(hello) – show only wraps where the field does not contain only the exact string ‘hello’
  • 10 – show only wraps where the field is equal to 10, eq is the default operator for numeric values
  • eq(10) – show only wraps where the field is equal to 10
  • ne(10) – show only wraps where the field is not equal to 10
  • gt(1) – show only wraps where the field is greater than 1
  • ge(1) – show only wraps where the field is greater than or equal to 1
  • lt(1) – show only wraps where the field is less than 1
  • le(1) – show only wraps where the field is less than or equal to 1
  • eq() – show only wraps where the field is empty
  • ne() – show only wraps where the field is not empty

Text filters

For text fields, you can enter any part of the value you wish to filter on and press Enter to hide the wraps that do not contain this value in the column.

Example: if you enter “y” in the text field above the month column and press Enter, only the May wrap will appear. This is an example of the co (contains) operator, which is implied for string values if no explicit operator is used.

You can also use explicit operators like eq (equal) or ne (not equal).

Numeric filters

For numeric fields, you can enter any value that you wish to filter on and press Enter to hide the wraps that do not have this value in the column.

Example: if you enter the current year in the text field above a year column and press Enter, you hide all wraps that are not from the current year. This is an example of the eq (equal to) operator, which is implied for numeric and date values if no explicit operator is used.

You can also use explicit operators like gt (greater than), ge (greater than or equal to), lt (less than), or le (less than or equal to).

Date filters

For dates, the filter must be in ISO-standard yyyymmdd format , e.g. lt(20211225) means any date before Christmas Day 2021.

DateTime filters must use a yyyymmddhhmmss format.