I created a dashboard with 4 text inputs and added in the end next query:
where like(credentials, "%$credentials$%") OR like(host, "%$host$%") OR like(okato, "%$okato$%") OR where like(command, "%$command$%")
So I need to exclude empty fields from the query. How do I make it? I need it because, if I have at least one empty, the search returns everything. I want to use every part of like, only if, the input for field has value.