4 Replies Latest reply on May 19, 2017 10:31 AM by user1069

    Create SQL command to filter records

    jcgapps

      I need an example of selecting records using a SQL query with WHERE clause.

       

      The where clause can be dynamic depending on the user criteria entry.

      For example, the user can select CATEGORY criteria three times so I can have this string:

       

      WHERE CATEGORY IN ('DRESS','PRINT','GENERIC')

       

      Thanks.