1 2 Previous Next 15 Replies Latest reply on Jun 18, 2015 10:03 AM by rrrichie

    Help needed for sql statement

    Lizhe

      I have the following sql statement and cannot figure out why it's not working. Attachment are the tests I performed in data view with my solution. Please help. Thanks.

       

      Let( s="SELECT Distinct targetName FROM TPR_TargetPTResult WHERE \"_fk_PanelId\" =? AND targetId IN (?) ORDER BY targetId";

      ExecuteSQL ( s ; ";" ; "¶" ; 4; Substitute(RES_Res::_fk_links;"¶"; ",")))

        1 2 Previous Next