Create a WHERE clause - HxGN SDx - Update 64 - Administration & Configuration

You can create a WHERE clause in the Table Properties pane for one or more columns. The WHERE clause is used to extract only those records that meet a specified criterion.

1. In the Tables pane, select a table.

2. In the Table Properties pane, click Create WHERE Clause in the Where column for the appropriate table properties.

3. In the Generate Where Clause dialog box, select the appropriate option to create a WHERE clause.

   • Filter by value - Select this option to retrieve records matching a string.

   • Filter by tables - Select this option to retrieve columns matching the criterion.

4. Click OK.