Chat now with support
Chat with Support

Foglight 6.1.0 - Web Component Guide

Introducing the Web Component Framework The Web Component Framework Configuring Views and Context Queries Functions Bindings Additional Components

Filter Results Based on Top N

The Filter Results Based on Top N property lets you restrict the results of a query. You can restrict the results to the first N or, conversely, exclude only the first N. For example, you may only want all but the first five items of the results from the query. This function is enabled by selecting the Filter results based on top N? check box.

The Value of N must be a number. You can set this using one of two options:

Specific Value, where you enter a number greater than 0.
From Parameter, where you can select a Required Parameter from the drop-down list and use the value.

The Results to Include lets you restrict the results using one of two options:

Only the Top N, where only the first N results are returned.
Everything except the Top N, where everything except the first N results are returned.

Selecting Everything except the top N may be useful in conjunction with an aggregation operation where you use one query to get an average of the top N, and you want to use another query to get an average of the rest of the data that are not in the top N.

You would almost always use Order By when you use Filter Results Based on Top N. Otherwise you would not know in which order the results would occur, and thus it would not be clear which results would be included in the top N.

Order By

Order By keys control the sorting of the data objects returned by the query.

You can create multiple keys. Order By sorts on the first key, then on the second key, and follows the sequence. Order By sorts only on a second key if the first key has data objects in which the values were identical. In this case Order By sorts the data objects containing those identical values based on the second key. This continues as further keys are specified.

There are three types of views that can use the query's sort order: drop-downs, row-oriented tables, and radio-buttons. As a result, sorting within a query is usually only needed when Filter Results Based on Top N is also used.

If you are sorting on a metric property, such as cpuUsage under Hosts, the algorithm automatically sorts on the metric's current/value property.

2
Select the Path from the drop-down tree.
3
Select ascending or descending.

Where

The Where property restricts which data objects are selected by the query, based on criteria such as property values in the data objects.

Comparison: Compare by Path, Specific value, or From Parameter with Path. Comparisons can be one of equals, not equals, is less than, is less than or equals, is greater than, is greater than or equals, like, matches or in.
Is Set: Choose a path to check if it is set.
Sub Type is: True if the sub type of the object is as specified.
And: Logical operator whose operands may be any of the types in this list
Or: Logical operator whose operands may be any of the types in this list
Not: Logical operator whose operands may be any of the types in this list

Conditional Types

You can configure the following different types of conditions.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating