AnsweredAssumed Answered

Help needed for sql statement

Question asked by Lizhe on Jun 18, 2015
Latest reply on Jun 18, 2015 by rrrichie

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;"¶"; ",")))

Attachments

Outcomes