Oracle Transactional Business Intelligence

Embedding filters without converting to SQL

Received Response
91
Views
3
Comments

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):

Tagged:

Answers

  • Nathan CCC
    Nathan CCC ✭✭✭✭✭

    Yes. Select the AND to toggle to OR.


  • 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

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