1 Reply Latest reply: May 14, 2014 7:03 AM by Rudolf Linder RSS

    Facing Problem in script with Record filtering

    Gyanaranjan Tripathy


      Hi,

      I have a requirement to fetch data from DB with multiple condition.I need the records with Flag='Y' and 'N' as well and for Flag=N, only Max(MD_DATE) is required.

       

      1) I need to Fetch FIRST_NAME, LAST_NAME, CITY, ZIP_CODE, CUSTOMER_ID, MANUAL_FLAG, DB_ACTIVE_FLAG

      from the DB WHERE (DB_ACTIVE_FLAG='Y' OR  DB_ACTIVE_FLAG='N') AND MANUAL_FLAG='Y' (Max(MD_DATE);

       

      Could anyone help me on this?

       

      Thanks in advance.