Page Comparison

Overview

Table conditions permit you to limit the data returned from a specific table. For example you may wish to limit your query of a sales table to specific Product transactions rather than allowing a user to query all data in the table.

...

1. Begin creating a condition as outlined earlier
2. Tick the Dynamic option when creating a condition, you will now notice different options available:
   
3. You will need to create a set of codes for each possible value to be used, much the same way you would create an Org Ref Code, by clicking on the Create Dynamic Filter Code link.
   
4. You will now need to create a record for each unique code available, in this example, we create a record for each possible currency we have data for. The first value should be the Code, or the value found in the database table. The second value should be a Description, which is what users will see when they can select their preferred option. The third value can be used to provide a custom sort order, sometimes used to ensure the most commonly selected values are listed at the top to save time.
   
5. This is what your list of codes will look like complete. Click Save & Close to complete.
   
6. You will now need to select your code from the Dynamic Filter Codes list, and select a default value from the list (this is used as the default if the user has not selected a preferred value in their profile). Save.
   
7. Your condition will now display like the one shown here
   

Defining a User's Value for a Dynamic Condition

...

To remove or clear the conditions from a table select the table properties and click the Clear link. This will remove all the conditions associated for that table.