Export Filters

Export filters allow you to narrow down the exported information. They are toggled by using the filter button filter in Extensions > Modules > ExcelPort, tab Export.

Enabling the export filters will display an interface which looks like this:

filter

Here you can add or remove filters for the various export types.

Important Filters are not used to customize the columns in the XLSX file. They only reduce the amount of exported rows.

Filters Conjunction

The possible values are:

  • AND: selecting this will export entities that match all specified filters
  • OR: selecting this will export entities that match any specified filter

Using filters

Every filter row has the following components:

<Field>

This depends on your export type. It specifies the entity field which will be filtered

<Operator>

This is used to determine the type of operation for the filter. Possible values are:

Operator Explanation
contains <Value> is part of the content of <Field>
does not contain <Value> is not a part of the content of <Field>
is exactly <Value> exactly matches content of <Field>
<Value> is a grater or equal number than the content of <Field>
<Value> is a smaller or equal number than the content of <Field>
> <Value> is a grater number than the content of <Field>
< <Value> is a smaller number than the content of <Field>
<Value> is a number equal to the content of <Field>
<Value> is a number different than the content of <Field>

<Value>

The value against which you want to filter. Allowed values for every <Field> are listed here: