I want to filter multiple collections. How can I do it?

Data Export has a filter option called "Regex" which can help you to filter multiple collections.

To access this filter option, click the "Edit" button to edit your report.

 Once you click the "Edit" button, the app will take you to the report page.

Now selected the fields you need for your report. To apply the filter, you need to select the collection field as well.

There are two collection fields, "Custom Collection" and "Smart Collection". You can select the field in which you have the data.

Once you have selected the necessary fields, click the "Filters" tab, which can be found under the "Report options" section:

After clicking the filter tab, you will see a drop down menu with two options "Regular Columns" and "Derived Columns".

Select the "Regular Columns" option:

Now, in the blank white box, type the field you have selected. If you have selected "Custom collection", then type the name of that field and select it:

Now, To selected the filter option, click the drop down menu and then select "Regex":

After selecting the "Regex" option, you need to enter the data which needs to be filtered.

For example, if you have multiple collections but want to see only "Sale" and "Pick and mix" collection, then you need to use the below parameter:

(Sale|Pick and mix)

You need to enter this parameter: (Sale|Pick and mix), in the white blank box in the filter:

This will filter and show only the Sale and Pick and mix collection in the report.