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.

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.

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.

AutoNumber filter

An AutoNumber cell can be included in the unique key for a wrap, and automatically assigns a unique serial number to each wrap. As an example, all errors reported for a vehicle can get a unique serial number that advances by one for each new error report. Read more in the help for the AutoNumber unique key setting on the Wrap tab in WrapCreator.

To filter wraps on their AutoNumber, you can use an ordinary column filter. If you type 12842 in the text box above the AutoNumber column, you will retrieve the wrap with that autonumber. If this autonumber does not exist, the filtered list of wraps will be empty.

There are also three special cases that return exactly one wrap. These filters are specified in the Filter setting above the list of wraps.

  • The First wrap is the one with the lowest AutoNumber. It was the first wrap to be created, and it is the oldest.
  • The Last wrap is the one with the highest AutoNumber. It was the most recent wrap to be created, and it is the youngest.
  • The LastFrozen wrap is the one that was most recently frozen. This is often used when filtering for the most recent complete period of automatically saved KPIs.

If your report has an AutoNumber=LastFrozen filter, this is a secondary filter that will be applied on the records returned by primary filtering, which is restricted by MaxRows. If you have many wraps, you may have to increase the MaxRows number to accommodate all the wraps, of which only one can be the last frozen.

To increase performance and remove the need to increase MaxRows, MyWraps has an IsLastFrozen filter. If the IsLastFrozen property of a wrap is true, it tells you that this wrap was the one most recently frozen. When filtering wraps for AutoNumber=LastFrozen, you should always also filter for IsLastFrozen, e.g.

Options.AutoNumberFilter=LastFrozen&Filter.IsLastFrozen=true

The IsLastFrozen property is only available for wrap templates with an AutoNumber unique key designated on the Wrap tab in WrapCreator. A routine runs asynchronously to continuously reassign the IsLastFrozen property to the wrap that was most recently frozen.

MyWraps has limited error handling

Since MyWraps is intended for administrators, there may sometimes appear to be room for improvement of the user interface. If unexpected conditions occur, they may be presented to the developer as

Screenshot of the general "oops" message provided by MyWraps for unexpected conditions

Before you contact Client Services, please make a quick pass through the data you have entered to ensure that there are no errors. As an example, entering a column filter as “gte(5)” instead of “ge(5)” for a greater-than-or-equal comparison will result in the error message above.