locked
AND in Select RRS feed

  • Question

  • User1118242308 posted

    Any help much appreciated. How can I select so records are returned that have all Codes ie C007B and C037 and C050 and H016

    Using CR11

    {EP_VisitNumber.EPVIS_DateOfCollection} = {?Period} and
    {CT_TestSet.CTTS_Code} like ["C007B", "C037", "C050", "H016"]

    Monday, March 6, 2017 4:25 AM

All replies

  • User281315223 posted

    Generally, in SQL you can accomplish this via the IN keyword :

    WHERE {EP_VisitNumber.EPVIS_DateOfCollection} = {?Period} 
      AND {CT_TestSet.CTTS_Code} IN ["C007B", "C037", "C050", "H016"]

    This will return all records that have ANY of those specific conditions (i.e. CTTS_Code = "C007B" OR CTTS_Code = "C050", etc.)

    Friday, March 10, 2017 4:38 PM