LookupInfo Element

When a user selects a field as a Filter in a query, it is often useful to select from a list of options or to search for a specific record. For example, it is easier to select "Mr." from a list of titles than try to remember whether to enter it as "Mr" or "Mister."

This functionality is enabled on a query view spec by the LookupInfo element within a specific Output field. LookupInfo fields can use simple data lists, code tables, search lists, or translation lists to provide lists of options.

  • Simple data lists require the GUID of an existing simple data list. This is set using the SimpleDataListID option. The simple data lists is then used to display the list of possible values in a drop-down list when selecting the field as a filter.

  • Code tables require the name of the actual table that stores the code table values. They also include an option to include entries that are marked as inactive.

  • Search lists allow you to bring up a search screen to look for the appropriate record. This is typically used when the field refers to the ID of a record such a specific constituent or payment record. To use a search list, you need to set the SearchListID equal to the GUID of an existing search list. You can use the View XML option in Catalog Browser to see the ID of a search list.

  • Translation lists provide the ability to specify a set list of possible options when selecting the field as a filter in Query. This is recommended for small lists of options that are not likely to change.