Setting up DBLookup filters with a single primary input field

To set up a DBLookup filter with a single primary input field:

  1. Locate the secondary DBLookup you want to filter.
  2. Click the Turn ON config mode icon.
  3. Click the orange diamond icon beside the field you want to filter to open the Field UI Configuration window.
    Sometimes there are Field Parameters already set in the Field UI Configuration window. In that case, evaluate the existing parameters. You may want to replace them with the DBLookup filter, or you may want to append the filter to the existing parameters.
  4. Specify the appropriate SQL statement in the Field Parameters field. For example:
    sourceType=SQL
    source='SELECT DISTINCT JOB.JOB_ID, JOB_NAME, JOB_DESC, 
    MYPROJ_NAME AS PROJECT FROM JOB, DEPT_PROJ_JOB WHERE 
    DEPT_PROJ_JOB.JOB_ID=JOB.JOB_ID'
    primaryInputFields=[FIELDS3X]
    primaryDataFields=[PROJECT]
    multipleRowPrimarySecondary=true

    See SQL expression.

  5. Click Save.
The filter configuration is now set. If the settings have not taken effect, you can clear the system cache. For more information on how to do that, see Unloading the cache.