
Queries 77
Creating a Query in vFoglight
• Derived from
Note For more information about these functions, see “View Commands in the Definitions Area”
on page 105. For more information about configuring queries, see “Query Definition
Settings” on page 77.
Query Definition Settings
This section provides the details of the definition settings for a query. Unlike views a
query definition does not have separate tabs for different groups of settings. All the
settings are on a single page.
Name
This is a required field. You cannot create a new query with the same name as another
query in the same module. A warning icon ( ) is displayed if this happens. Move your
mouse over the icon and a tooltip displays the problem.
Root Query
Check this box to mark the query as a Root Query. Root queries (and their execution
results) are listed in the Data browser and the Data tab of a Portal or a Report Builder.
They provide a way to organize the data presented in those locations.
Relevant and Allowed Roles may be set on Query Definitions as well as on Views.
These roles are taken into account when filtering Root Queries by role, as is done in the
data browser, a portal or a report builder. For more information, see “Relevant Roles
and Allowed Roles” on page 78.
Hide Root
The Hide Root checkbox is only enabled if Root Query is checked. If checked, when the
results of the root query are shown in the Data Browser or the Data tab of a Portal or
Report Builder, the first item in the results list will be 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.
Kommentare zu diesen Handbüchern