Show warning icon on condition

[vaskoZGU]

Hello,

Could you help me with the following case?
I am using a MySQL query as a data provider, which compares two values and returns either "Equal" or "Not Equal."

In the attached image above, I would like to know how to ensure that the icon above the table only appears when the result for any row in the table is "Not Equal."
I attempted to set a condition for the Icon component, but the only binding option available is "Selected Rows."

Using the above condition do the job but only when the rows are selected. Is there an option to invert the default row selection i.e. all selected?

Thank you for your assistance!

[vaskoZGU]

Here’s how I resolved my problem, which may be helpful for others facing the same issue:

1. I created a MySQL recurring event to perform the calculation and save the results in a separate table.

2. In BB, I created a MySQL query to check this table with the following command:

   SELECT DISTINCT(comparison_result) FROM bb_sum_compare_stgrad WHERE comparison_result = 'Not Equal!';

3. I added an "Interval" element that triggers the following 3 actions every 60 seconds:

   • Execute the query from step 2.
   • Perform a conditional action.
   • Show a notification if the condition is met.

In the conditional action, I used the following JavaScript script:

return $("Action 1.Query result")?.data?.[0]?.["Not Equal"];

This approach triggers a warning notification if the comparison_result column has the value "Not Equal"!