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.
Adjust AND (default) or OR as you needed and try adding to the search field=*, in your case similar to:
credentials=* host=* okato=* command=* | where like(credentials, "%$credentials$%") OR like(host, "%$host$%") OR like(okato, "%$okato$%") OR where like(command, "%$command$%")