I need to add a custom WHERE in the indexes of a dashboard, the where must be WHERE xxx in (‘aaaa’,‘bbbb’)
how can I do it? IS NOT POSSIBILE!
Try adding by writing in the WHERE clause: xxx in (’[vc_lista_values_csv]’).
vc_lista_values_csv will be an input parameter variable in case they are not fixed.
Otherwise you can write the values separated by commas: xxx in (‘aaaa’,‘bbbb’).
You can also add it to the flight with sc_select_where (add) macro.
sc_select_where add work in dashboards index? the documentation does not indicate that they work in dashboards