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.
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.
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.
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. |
The system does not currently stop a User from saving a Query with the exact same name as an existing Saved query.
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.
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.