Choose your inspector and lookup basis. You may select multiple lookups to increase your detail of data. To focus your results, proceed to Search and enter search criteria for each lookup basis.
Inspectors
ui-btn
No records found
lookup basis
Enter your search criteria per selected basis. This must be an exact search term or you can use * as a wildcard (*searchterm*). Then proceed to Columns or click Launch API.
No search fields available. If you wish to add search fields, please select one or more basis fields.
Choose a pre-configured metric collection or all columns. From available columns, select the columns of metrics you wish to return and drag or move them into selected columns. Selecting none returns a default set. You can move your selected columns up or down with the arrows. Then proceed to filters or click Launch to run the API in your browser.
Choose the columns you wish to filter on. All AND rules must meet criteria in order to return records. Proceed to Format or click Launch API.
Select Column
=
and
Choose your Sort Column and Sort Order. For numeric columns, consider using the descending sort for the largest numbers first. Select Rating to include metric units or color and alert ratings. Then click Output or Launch API.
Sort Column
Select Column
Sort Order
Select Sort Order
Sort Rating
Select Rating
Select the row limit to be returned and the output method. When building and test launching your API query, the Json output will show valuable metadata which can help with debugging. If using CSV output, set this option at the end. CSV with HTML content will write to the screen vs. a file. Proceed to Date or click Launch API.
Select a predefined date range (last X) and time constraint (ie 9:00 to 17:00 hrs) or enter a custom date range start and end time. When finished click Launch API.
Tapping the "Reset Cache" button below will clear your existing cache objects following system refreshes. Once cache is refreshed, enhanced performance will enable the screen to load quickly moving forward.
Reset Queries
Tapping the "Clear Queries" button below will remove any existing queries that have been defined. This can be helpful in deleting existing queries as a group.