Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

Widgets linked to an input (both the input and select type) do not automatically show data before you enter or select a value in the corresponding input. However, you can make it happen by adding a specific syntax to the widget query.

Show a specific value

This is possible with both types of inputs, as well as any of the operations accepted in the use of inputs (see them in this article).

In the widget query, adding this pattern (|"specific value") right after the input reference (InputID.value) will make the widget show a specific value of your choice before entering or selecting one in the input.

When using the $ or $* operators, the input reference and the predefined value reference must be enclosed within brackets after the operator.

...|"specific value"

InputID.value|"specific value"

$(InputID.value|"specific value")

$*(InputID.value|"specific value")

For example, the query on the left is used to call the username value from Select0 and can be transformed into the query on the right to show the username value john@devo.com before you select one.

Without predefined values

query(from siem.logtrust.web.activity
where username = $Select0.value
group every - by username, method
select count())

With predefined values

query(from siem.logtrust.web.activity
where username = $(Select0.value|"john@devo.com")
group every - by username, method
select count())

Show all possible values

This is possible with both types of inputs, however, it is only possible with operations to filter data.

In the widget query, adding the following pattern after the where operator will make the widget show all possible values of the filtered field for the query and time range specified. This is helpful to show all data before start filtering for a more holistic view of each filtering criteria in contrast to the total.

...isempty(InputID.value) or... → where isempty(InputID.value) or field = $InputID.value

For example, the query on the left is used to call the method value from Input0 and can be transformed into the query on the right to show all the available method values before you enter one.

Without predefined values

query(
from demo.ecommerce.data
where method = $Input0.value)

With predefined values

query(
from demo.ecommerce.data
where isempty($Input0.value) or method = $Input0.value)

Multiple selection in select inputs

When using select inputs and enabling the multiple selection option, the syntax must be adjusted as explained in the article Case-specific adjustments. Otherwise, you will get an error and your widget will not display data.

  • No labels