RadNet Query Builder Search User Guide
Welcome to the RadNet Query Builder Search User Guide. This tool allows users to report on any data element, and is primarily geared toward the experienced user.
General Instructions
The RadNet Query Builder searches for data elements using the user's table and column selections and other search criteria.
Follow these five basic steps to search data elements:
- Choose a Subject Area
- Choose a Table/Select Tables to Join
- Select Fields
- View Data
- Enter search criteria and organize output data
The data in this database is classified by the subject area. Each subject area contains a data table, with each data table containing information related to the subject area. You may select only one subject area at a time. A brief description appears for each subject area name to help you determine which data to retrieve.
Click a subject area of your choice. You can search for this with the Search title/description filter. This selection will automatically bring you to Select table(s) to join.
STEP 2: Choose a Table/Select Tables to Join
You may select up to 3 additional tables or go directly to the next step by clicking on the Get Fields button. These tables will change depending on which subject you chose in Step 1 above.
If you need to modify the output of data in this step, click the Choose a Subject Area header. Otherwise, click one or more tables of your choice. You can search for this with the Search title/description filter. After making table selections, click the Get Fields button to go to Step 3 Select Fields.
You may select one or more columns based on your table selections. These columns, which will be used for your output, will change depending on which tables you chose to join in Step 2 above. If you need to modify the output of data in this step, click the Select table(s) to join header.
To select the columns for each table, which will be used for your output, click on the table name on the left side of the page, where the currently selected table will be in blue font. Then click on the column name’s box. You can search for this with the Search title/description filter. Click the Select All button to choose all the available columns for the selected table. Click a column’s box again to deselect for output, or click the Clear Selection button to remove all column selections. Repeat this process for each table for your output. After you have selected one or more desired columns, click on the Get Data button to view data. You will need to select at least one column from the table chosen in Step 1 for the Get Data button to become available.
The data based on the selected subject, their optional joined tables, and their fields display on the page. Sort the data by clicking the column headers. If you need to modify the output of data in this step, click the Select Fields header. Refer to the Step 5 section below for data viewing options.
STEP 5: Enter search criteria and organize output data
To create a search criteria for each column header, first select the table from the Choose Table dropdown list, then click the Add Search Criteria button. In the pop-up window, choose one column header. Then choose one operator and enter an applicable value for that operator. Finally, click the Add button to create the search criteria. Repeat as needed for each column.
If you choose an operator more than once for a column, only the latest entry will be considered. Click the Remove button to delete a filter for a column.
Once you finish entering the column’s search criteria for the data output, click the Apply Filter button. The data output refreshes with your applied criteria. You may modify any column filter by clicking the pencil icon that appears above the data table.
Click the Reorder Columns button to open a pop-up that lists the data tables. Click the dropdown arrow to see a list of the columns in each table. Click and drag the column names in the order you want the columns to appear from left to right. You can reorder columns within each table, while the tables remain in the same left-to-right order. Once you finish, click the Apply button. The data output refreshes with your applied layout.
To view all or modify the display of columns in the data table in a pop-up list, first select the table from the Choose Table dropdown list, then click the View Fields button. In the pop-up, you may search for the columns with the Search title/description filter. Click the column’s checkbox to add the column to or remove the column from the data table. Click the upright arrow next to the checkbox to view the column’s metadata description. Click the Export Field Metadata button to export all selected data columns’ metadata descriptions into a spreadsheet.
After selecting or deselecting the columns to display in the data output, click the Update Fields button. The data output refreshes with your applied columns added or removed.
Click the Save Query button to save the search query for future use. The generated URL can be used to view and share these results. Copy the generated Query URL to the clipboard. Afterward, click the X or the Close button to exit the pop-up screen.
At the bottom-left of the page, to export the data output, select the file format from the dropdown field (options include CSV, Excel, JSON, XML) and click the Export button.