Platform

Platform

A place for Apptio product users to learn, connect, share and grow together.

 View Only
Back to discussions
Expand all | Collapse all

How to use AND operator in row level security

  • 1.  How to use AND operator in row level security

    Posted Thu April 25, 2024 05:32 AM

    I have already implemented row level security in one of my projects, in which i am getting the attached error/warning while trying to use both OR and AND condition.

    Can someone help me to understand and help to resolve the issue?

    Regards

    Prasanna Ravindran


    #TBMStudio


  • 2.  RE: How to use AND operator in row level security

    Posted Thu April 25, 2024 07:11 AM
    Edited by Rene Norskov Tue November 05, 2024 05:35 PM

    It looks to be a warming about the order of operations in your filter statement.  Using parentheses is recommended when you are mixing AND and OR to make sure the clause is executing as expected. For example in this statement  X=1 OR X=2 AND Y=3 it is not entirely clear if the condition is met when X=1 regardless of Y value, as in X=1 OR (X=2 AND Y=3), or whether the condition is met for either X value, as in (X=1 OR X=2) AND Y=3


    Original Message


Related Content