This guide is essential for users looking to enhance their dashboard’s filtering capabilities with custom SQL support.
Use case:
Adding LHS (Left-Hand Side) and RHS (Right-Hand Side) custom SQL allows dynamic filtering.
For example, you can search for product names dynamically by applying transformations in theWHERE
clause using the{{global_selected_values}}
variable.
{{global_selected_values}}
in the “Apply on” sectionCONCAT()
, LOWER()
, and UPPER()
in Custom RHS SQL using {{global_selected_values}}
{{global_selected_values}}
dynamically fetches the corresponding values, regardless of case sensitivity or type casting.