System filters for Reports

Note that all filters for reports are case-sensitive.

The characters ? and * can be used, where ? is translated as any one character, and * as any number of any characters; for instance, typing A?9 as filter would refer to records that start with A followed by any character and have 9 as their third character, like A19, Ab9, A-9, but typing A*9, would refer to records that start with A and end with 9, like A19, Ab9, A-9, A0000009, ABCDE9.

The system filters available in the Filter settings section of the Report batch pop-up are:

Filter Description Available by default? Example

Record name

(Text box)

Optional to use. Any record name(s) entered here will be included in the report.

Yes*

  • Order 849 would show a report with only one row (assuming that this record exists).

  • *1000* would show all records with name containing 1000.

  • Order 849;Order 1000 would show only two rows in the report.

    Keep this filter as * or empty in case you don’t need it.

Exclude record name

(Text box)

Optional to use. Any record name(s) entered here will not be displayed in the report.

Yes*

  • Order 849 would show a report with all records except this one.

  • *1000* would show all records except for those containg that value.

  • Order 849;Order 1000 would show all records except for these two.

    Keep this filter as empty in case you don’t need it.

Main record

(Selector box)

Mandatory to use (i.e., it is not possible to leave the record’s name box empty). One record name of the main table must be selected here. Once this is done, the report is queued, and the generated report file will contain only the selected record, and all the related records that are setup in the report configuration, if available.

No. The administrator must set proper setting to enable this filter.

*Once enabled, the first 2 filters "<Table name> record name filter (as text box)" and "" are disabled.

  • WO-0001