Adding a query to a panel
- Juan Tomás Alonso Nieto (Unlicensed)
- Sarah Bigault (Deactivated)
When you add a query to a panel item, you embed a link to the query and, if it's a live query, a table that contains selected live data from the query. Below is an example of a live query table in a panel.
Before you begin
Before you begin this procedure, you should confirm that the query that you want to add is marked as a favorite. To do so, go to Data Search. In the Finder tab, make sure that the query is included in the Favorite Queries list. If it's not included, you will need to locate the query and mark it as a favorite.
Add a query to a panel
Once you have confirmed that the query is marked as a favorite, you can add it to a panel item.
Go to Panels, select your panel from the drop-down list, then click
in the toolbar to open the panel in edit mode.Click to select the item, then click the green magnifying glass icon that appears above the highlighted object. The Queries list appears.
Click the Assign button for the query you want to link to the item.
If the selected query does not group events, it is added to the panel as a static query.
If the selected query does group events, another Queries window opens listing the available columns. You can choose to add this kind of query as either a static or a live query.
Static queries
Static queries simply add links to the panel that lead to the queries. They do not embed live data. When you add a query that does not group events, it is automatically added as a static query. However, if the query does group events, you will be able to choose between static and live in the Queries window. If you choose static, you can ignore the Hide Column selection and just click Add as a Static Query.
Just as you can customize the appearance of items and connections in a panel, you can edit the appearance of a static query. Click to select the query symbol and edit the setting as needed. You can modify the text label, size, and font family and color.
Live queries
Live queries add tables containing live query data to the panel.
If you choose this, select the Hide Column checkboxes for the columns you do not want to include in the table. For integer values, including counts and averages, you can select the Hide Column checkbox to simply include the values. Or you can select the Show Scale checkbox to define a range of normal, expected values. This is used to color-code the cells in the table based on where values fall with respect to the defined range. For example, values that fall above the maximum of the normal range will be shaded red.
Once you have selected columns and defined any value ranges, click Add as a Live Query.
While you cannot modify the appearance of a live query table, you can edit the fields included in the table and value ranges. In edit mode, click the query table to select it, then click the cogwheel in the upper-right corner of the table. This reopens the Queries configuration window where you can make your changes and click Update.
