WEBVTT

00:00:01.033 --> 00:00:07.799
Welcome to this ACE Reports video,
Adding Nested Filters.

00:00:07.800 --> 00:00:14.200
This video will demonstrate how to
Add Nested Filters for Reports.

00:00:14.300 --> 00:00:20.066
Adding Nested Filters allows complex
filtering in a query statement.

00:00:20.066 --> 00:00:26.499
They create a complex filter by adding
multiple levels of logical statements.

00:00:26.500 --> 00:00:32.166
The two nested filter operators
are AND and OR.

00:00:32.400 --> 00:00:38.666
The AND operator requires results to match
all the filter objects and constrains the

00:00:38.666 --> 00:00:40.599
data in the query.

00:00:40.600 --> 00:00:47.200
The OR operator returns results that match
any of the filter objects and allows for

00:00:47.200 --> 00:00:50.833
expansion of the results.

00:00:50.833 --> 00:00:56.399
Please note that as items are dragged into
the report table, it is very important to

00:00:56.400 --> 00:01:02.966
pay attention to the tooltip that displays
the action and location for the data object.

00:01:03.566 --> 00:01:05.866
Open a Report.

00:01:05.866 --> 00:01:09.232
Select Design mode.

00:01:09.233 --> 00:01:16.299
In Design mode, in the Query tab,
select the Edit icon.

00:01:16.300 --> 00:01:19.033
The Query Panel displays.

00:01:19.033 --> 00:01:22.666
Select the Nested Filter icon.

00:01:22.666 --> 00:01:27.132
If necessary, drag and drop object(s)
to the Query Filters area.

00:01:30.733 --> 00:01:34.033
Select the Nested Filter icon.

00:01:34.033 --> 00:01:38.366
The OR operator displays in Query Filters.

00:01:38.366 --> 00:01:43.732
Please note that the OR operator is added
below the query filter object that is

00:01:43.733 --> 00:01:48.433
currently selected when you select the
Nested Filter icon.

00:01:48.433 --> 00:01:56.766
If necessary, double-click the OR
operator to display an AND operator.

00:01:56.766 --> 00:02:01.099
Drag and drop objects to the right of the
nested filter operator.

00:02:07.066 --> 00:02:15.099
Please note that you can also move
objects up or down by using the icons.

00:02:15.100 --> 00:02:21.133
You can remove objects by using the
Remove All icon

00:02:21.133 --> 00:02:25.599
or the icon of an
individual object.

00:02:25.600 --> 00:02:30.166
Select the Apply and Close button.

00:02:30.166 --> 00:02:32.699
The Query Panel closes

00:02:32.700 --> 00:02:38.266
This concludes our demonstration of how
to Add Nested Filters for Reports.

00:02:38.266 --> 00:02:47.066
If you have any questions,
email acetraining@cbp.dhs.gov.