0 Replies Latest reply: Dec 9, 2015 4:35 AM by Sanket Khunte RSS

    Set Analysis : OR Conditions

    Sanket Khunte

      Hi there,

       

      Could you please let me know how can we handle below DB where clause in Set Analysis -:

       

      WHERE

          SC_START_DATE < V_END_DATE + 1 AND

         (

              SC_ENABLED_STATE = 1 OR

              (SC_LAST_CANCELLED_DATE IS NULL AND SC_ENABLED_STATE = 1) OR

               SC_LAST_CANCELLED_DATE <= SC_START_DATE OR

               SC_LAST_CANCELLED_DATE >= V_END_DATE + 1 OR

              (SC_LAST_CANCELLED_DATE IS NULL AND SC_ENABLED_STATE <> 1 AND SC_MODIFY_DATE >= V_END_DATE + 1)

          )

       

      V_END_DATE is input from user.


      Really appreciate your input on this.


      Thanks

      Sanket