WEBVTT

00:00:02.033 --> 00:00:07.966
Welcome to this ACE Reports video,
Modifying Query Filters.

00:00:07.966 --> 00:00:13.199
This video will demonstrate how to
Modify Query Filters.

00:00:13.200 --> 00:00:18.666
Use Query Filters to limit and focus the
data results for a report.

00:00:18.666 --> 00:00:24.899
Query filters are the set of criteria the
data must match for it to be retrieved

00:00:24.900 --> 00:00:27.233
from the data warehouse.

00:00:27.233 --> 00:00:33.333
Create custom filters by adding data
objects from the Universe outline to the

00:00:33.333 --> 00:00:40.299
Query Filters panel and customizing the
operator, values, and filter type.

00:00:40.300 --> 00:00:47.366
Any object in the Universe outline can be
included as either a result object or

00:00:47.366 --> 00:00:49.366
a query filter.

00:00:49.366 --> 00:00:54.499
Please note that Objects from multiple
universes can be included in the same

00:00:54.500 --> 00:00:57.966
report using the Add Query feature.

00:00:57.966 --> 00:01:04.099
This is an advanced concept not
covered in this video.

00:01:04.100 --> 00:01:05.533
Open a Report.

00:01:06.400 --> 00:01:08.633
Select Design mode.

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

00:01:20.700 --> 00:01:23.666
The Query Panel displays.

00:01:23.666 --> 00:01:30.532
In the universe outline menu, expand the
folder(s) to display available object(s).

00:01:30.533 --> 00:01:36.366
Please note that you can also search for
an object by typing text in the Type here

00:01:36.366 --> 00:01:41.966
to filter the tree field and selecting
the magnifying glass button.

00:01:44.866 --> 00:01:49.966
Drag and drop a data object from the
universe outline menu pane to the

00:01:49.966 --> 00:01:52.066
Query Filters pane.

00:01:52.066 --> 00:01:57.966
Please note that you can select multiple
objects by pressing the CTRL key while

00:01:57.966 --> 00:02:00.332
selecting objects.

00:02:00.333 --> 00:02:05.999
Continue to add data objects to the
Query Filters pane as needed.

00:02:06.000 --> 00:02:09.166
In Query Filters, as necessary:

00:02:09.166 --> 00:02:12.732
In the operator drop-down,
select an operator.

00:02:14.900 --> 00:02:21.300
Select the Click to Define filter type
button and choose an operand filter type.

00:02:21.300 --> 00:02:27.700
If Constant is selected as an operand
filter type, in the Type a constant field,

00:02:27.700 --> 00:02:30.500
type any required data.

00:02:30.500 --> 00:02:37.033
If Object from this query is selected as
an operand filter type, select an object

00:02:37.033 --> 00:02:39.599
in the Objects dialog box.

00:02:43.633 --> 00:02:46.266
Select Apply and Close.

00:02:50.533 --> 00:02:52.233
Save the report.

00:02:55.800 --> 00:02:58.300
Refresh the report.

00:03:09.066 --> 00:03:13.632
This concludes our demonstration of how
to Modify Query Filters.

00:03:13.633 --> 00:03:23.433
If you have any questions,
email acetraining@cbp.dhs.gov.