Create Custom Fields Based on SQL Queries (On-Premises only)

Applies to QAComplete 14.3, last modified on February 19, 2024

On-Premises clients may create a new combo box and fill it with the information from the another table in the QAComplete database.

For example, you may create a field on the Defects screen that returns a list of your security administrators. To do this:

  1. On the Defects screen, select  Tools >  Manage Custom Fields.

  2. On the Custom Fields screen, specify the name for the new field (for example, Our Administrators).

  3. Select the Choice List (Based on SQL) type for the new field.

  4. In the newly appeared SQL Statement edit box, enter the SQL query to retrieve the information about administrators from the list of users in the Persons table.

    Custom drop-down list

    Click the image to enlarge it.

  5. Click Submit Changes.

After that, the new combo box will appear on the Create Defect and Edit Defect forms. Its value will also appear on the Defects screen. It will list users that have the Security Admin check box selected.

Tip: You may have to select this field for display in the Choose Fields dialog. To call the dialog, select Choose Fields in the Tools (Actions) menu.
The custom drop-down list

Click the image to enlarge it.

See Also

Custom Fields

Highlight search results