You can use native filters with all of the supported data
sources. Native filters, which are interpreted by the Reporting Data
Services Adapters, allow you to enter filters in the data source format.
The native filter is processed by the Reporting Data Services Adapters
rather than by Rational® Publishing Engine,
so the use of native filters improves Rational Publishing Engine performance.
Before you begin
If you are integrating
Rational Publishing Engine with
a product that does not support Reportable REST data sources, the
entire data set is fetched and cannot be filtered. To verify that
your product does support Reportable REST data sources, you can test
the filter condition in the native data source before using it in
Rational Publishing Engine.
Review
the Reportable Rest v1 document for more information
about defining Reportable REST v1 services requirements.
About this task
Native filters are supported by Reportable REST data sources,
which enable the filtering, sorting, and selective support of properties.
The native filter requests a set of data from the data source, and
then filters and refines the data for output from a Rational Publishing Engine template.
You are not required to create filters in the product the data came
from unless you would like to test the filters for accuracy, but you
can create filters exclusively for use in Rational Publishing Engine templates
from within Rational Publishing Engine.
In
previous releases of Rational Publishing Engine,
you could only define filters that were static. You had to know what
the filters were when you designed the template and they could not
be changed at run time.
Native filters apply to any data source,
but the syntax is specific to each data source.
For more information about syntax, refer to the documentation
for that data source.
Procedure
- In Document Studio, select the template element that contains
the query that is to be filtered.
- In the Properties view, select the Data tab.
- In the Filter field, click the ellipsis.
- In the Native Filter tab, expand Variables.
Note: Variables used in filters can be modified before the first
query on that data source is used.
- Select a variable to filter on.
- Enter the syntax ${} to define your
query to be filtered. For example, you can filter by
a product name. Multiple product teams can use this template and specify
a product name in the document specification at run time.
cq:Product{cq:Product"${productName}"
Note: - Custom attributes cannot be used in native filters.
- If you rename a variable,
the name is not updated in a script expression or native filter and
creates a reference error. When you rename a variable, ensure that
you revise the name in the script expressions and native filters as
well.
- To extract Rational DOORS data,
use the DXL script as native filter condition. To extract REST data,
use the XPath filter condition.
- Click OK.