Where Clause Panel

AdminStudio 2022 | 23.0 | Application Manager | Rules Wizard

Edition:Application Manager is included with AdminStudio Professional and Enterprise Editions.

From the Where Clause panel, you must define a valid Where clause for the ACE. If you do not know how to build a Where clause, you can click the Build Expressions button to launch the Expression Builder dialog box. You can also click Test to validate the Where clause syntax.

If you selected Custom - Source and Target Packages on the Additional Information panel, you must also select a Join Column—a table column in the Application Catalog database that has a matching value for both the Source and Target packages. Rows in each of the packages that have a matching value in the Join Column are selected and those rows are checked against the Source and Target Packages. For example, if you wanted to evaluate Source and Target packages that write files to the same directory, you might specify Directory as the Join column.

Tip:To improve query performance, enclose table names in square brackets ([]).