Advanced Query / Customization

The Advanced Query / Customization page is used to access customization records from either the FDB Standard table, the VA Custom tables, or both at the once. This allows you to research existing records, make customizations, or export data.

Accessing the Advanced Query/Customization Page

The Advanced Query / Customization page can is accessed in one of two ways.

Click the Advanced Query/Customization tab on the navigation bar near the top of the page. This will open a blank query.

ALT Text

Click a link from one of the summary tables displayed on the Home tab. This will generate a query appropriate to the context of the link that was clicked. In the example below, a query displaying criteria to display the unassigned Drug-Drug Interaction records will be produced.

Build A Query Panel

Example Unassigned Drug-Drug Interaction Query (Unassigned)

After values are selected for those two fields, additional fields appear in which the user can create their Query.

Fields A drop-down list of the fields available to be queried against for the Concept selected
Filter A drop-down list of the filters that can be used in the Query
Value A blank field into which the user inserts the particular value they are searching for/by
And/Or If the user is creating a query searching for one set of criteria AND an additional set of criteria, the user will utilize the 'And' option. After selecting 'And' an additional row of 'Field', 'Filter' and 'Value' will be displayed to be filled out. If the user is creating a query searching for one set of criteria OR another set of criteria, the user will utilize the 'Or' option.
Query button The user clicks this to run the written query.
'Include Historical records' checkbox The user checks/selects this box to include records in the Query results that are considered historical versions of active records. No action can be taken on them, they can only be viewed.
'Clear Query' button The user clicks this if they want to totally remove the Query they have written above.
'Save Query' button The user clicks this if they want to save the Query they have written above.
'Query Name' The user enters a name for the Query they have written above, and want to save.

Query Specifics

  1. If searching by a date value, the only acceptable format to search by is YYYY-MM-DD
  2. The only FILTER values that can be used when searching for date values are:

Run a Saved Query Panel

The system does not currently stop a User from saving a Query with the exact same name as an existing Saved query.

'VA Table Results' and 'FDB Table Results' Panels

Export Button

Each Table Results panel has its own ‘Export’ button. Clicking this button in a panel will extract only the records from within that panel into an Excel format. The user can Open or Save the exported information and can also cancel out of the export action.

Sorting

In both of the Table Results sections, the default sort order is by the ‘Action Date’ value, from newest to oldest. This puts the VA Customizations that have been updated most recently at the top of the returned list. The results in the tables can be re-ordered by clicking on any Column Header. One click on a text field sorts the data in alphabetical order (A to Z), a second click sorts them in reverse alphabetical order (Z to A). One click on a numeric field sorts the data smallest to largest, a second click sorts them largest to smallest.