MXQL Data Lookup
On the MXQL Data Lookup screen, you can query the data collected by WhaTap directly with MXQL (the WhaTap data query language). Use it to extract data in a form the default screens do not provide, or to check collected values directly.
You can find the MXQL syntax and functions in the MXQL Guide.
How to use
-
In the Time selector, choose the time range to query (for example, the last 1 day).
-
In the MXQL Editor, enter the query to run. For example, specify a category and tag in the form
CATEGORY db_real_counter TAGLOAD SELECTto load data. -
In the Row Count field, choose the number of rows to fetch at once (for example, Up to 100 lines).
-
After setting the options, run the search to display the results. Click the Explore Metrics button to explore the metric data as well.