Modifying ACL server table queries

You can modify the WHERE and ORDER clauses for ACL server tables when you need to adjust the query for a table defined from an Oracle, IBM DB2, or SQL Server database using a database profile. This means that you can change the data retrieved for the ACL server table, without needing to redefine the table in the Data Definition Wizard.

To modify the query for a table:

  1. If the table you want to edit the query for is open, you must close it before you can edit the query. To close a table, right-click the table in the Overview tab in the Navigator and select Close Table.
  2. Right-click the table in the Overview tab in the Navigator and select Properties.
  3. In theTable Properties dialog box, click the Edit Query tab.
  4. Make any necessary changes in the WHERE clause and ORDER clause text boxes and click OK.

    The next time you open the table the modified query will be used to select and order data from the database table(s).



(C) 2015 ACL Services Ltd. All Rights Reserved.