Enabling users to search a DBLookup using the description text

By default, users can only search for a value in a lookup using the element name. After enabling the description for a particular lookup, configure the lookup query to also enable users to search using the description text.

  1. In the desktop application, select Maintenance > System Administration > Maintenance Forms.
  2. Click Edit beside the maintenance form that contains your required DBLookup field.
  3. In the Form Fields section, locate your required field.
    Note: The field control is MobLookupUI. This UI should not be modified.
  4. Locate the Field Parameters column where the DBLookup query resides.
  5. Add the element description to the searchColumns property.
    For example, for the Department lookup, the initial query has searchColumns='DEPT_LOC_NAME'.

    To enable searching by the department description, modify the searchColumns property as follows:

    searchColumns='DEPT_LOC_NAME, DEPT_LOC DESC'
    Note: If users lack the security group permissions to see the descriptions, then the query should not be modified to enable searching by the description text. Otherwise, users may get search results that match descriptions that are not visible to them.
  6. Click Save.