Setting up DBLookup filters for timesheet edits

You can configure the mobility timesheet to use filters on DBLookups (database lookups). Filtering lookups is useful to present only a relevant subset of selections to the user, based on a prior selection. For example, for users making edits of work details or premiums, you can filter the values in the Department lookup based on what is selected in the Team lookup.

To set up a DBLookup filter for timesheet edits:

  1. Identify the field that is used to filter the DBLookup. This is the master input field.
    In our example, the Team lookup is the master input field.
  2. Identify the DBLookup being filtered. This is the slave input field.
    In our example, the Department lookup is the slave input field.
  3. Modify the SQL expression of the DBLookup being filtered. The SQL expression links the master input field with a slave input field to extract the data you want to display in the filtered DBLookup.
    In our example, we will modify the SQL expression of the Department lookup to show only the active departments with the currently selected team.