Embedding filters without converting to SQL

Question

Summary:

Hello- Is there a way to embed a AND/OR statement into a filter without converting to SQL?

Content (required):

We are in need of a workaround that does not require us to convert a filtering condition into SQL. The filter needs to be and AND/ OR statement.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Anirban Basu-133546 · Answer

Yes in the filters pane you can change the operators as per your requirements.

Venkat Koduvayur-Oracle · Answer

Hi

Yes, it is possible. With out converting to sql means you mean selecting the option "Convert this filter to SQL"?

Yes by clicking the AND condition will change the filter to OR and we can keep adding nested OR filters as shown

Regards

Venkat

Nathan CCC · Answer

Yes. Select the AND to toggle to OR.