Show data in widgets before entering values in inputs
- Juan Tomás Alonso Nieto (Deactivated)
- Borja Moro Moreno
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.
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.
Example without predefined values
query(from siem.logtrust.web.activity
where username = $Select0.value
group every - by username, method
select count())Example 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.
Example without predefined values
query(
from demo.ecommerce.data
where method = $Input0.value)Example with predefined values
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.
Â