Appear in the Data browser, and in the Data tab when using Create dashboard and Create report as the starting point for exploring contained data.
Select the UI Query box to mark the query as a UI Query. UI queries (and their execution results) are listed in the Data browser and the Data tab when using Create dashboard and Create report. They provide a way to organize the data presented in those locations.
The Hide Root check box is only enabled if UI Query is selected. If selected, when the results of the UI query are shown in the Data Browser or the Data tab using Create dashboard or Create report, the first item in the results list is hidden. If the query results list does not contain one item, then this option is ignored. This is useful when you know that the results of the query will always return one item and you want to save users having to expand the node corresponding to the one item in order to see its children. For example, if you have a query that returns the root of a data source, hiding that root is useful so that users can more easily get to the data that is really of interest.
If you have a Dashboard Designer or a Cartridge Developer role, you can see the entire data structure in Dashboards > Configuration > Data > Management Server > All Data.
By default, queries are accessible from the module in which they are defined. If a query is marked as Public, it can be accessed from any module. For more information, see .