Where Clause Tab
AdminStudio 2022 | 23.0 | Application Manager | ACE Rule Properties Dialog Box
Edition:Application Manager is included with AdminStudio Professional and Enterprise Editions.
From the Where Clause tab, you can edit the 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 when you created this ACE, you must have also selected 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 records from two tables that have a installation directory of C:\ProgramFiles, then you would specify Directory as the Join column. To change the Join Column, select a different column name from the list.
To continue editing ACE Properties, click the General Information, Additional Information, or Custom Options tabs. To save your edits and close this dialog box, click OK.
Tip:To improve query performance, enclose table names in square brackets ([]).
See Also