Assure DQ

Is it possible to feed this SQL statement layout param (?) with ("ABC","XYZ","QWE")

where system_code in ?  

Tried to do a test layout, but it keeps putting double quotes around it. And I eventually get an error 

Error while compiling statement: FAILED: ParseException line 4:18 cannot recognize input near 'in' ''("ABC","XYZ","QWE")'' 'group' in expression specification

Attached files

SQL IN statement.pdf

Hi JL

Yes, you can use it.

In layout, write your query in SQL query editor with params(?) attribute , which layout is going to use on runtime.

Click on "Advanced SQL Query" tab,at the top , for params tab, add the appropriate parameter , like "CurrentLoadTime" or "LastLoadTime" depending on your requirement.

Then Use that param parameter in you capture control entity , at More->Manage Runtime fields.

Hi Manoj,

I haven't gone far in feeding runtime variable to it thru Control point because I cannot get it to work by just entering the variable manually when testing using "test layout" under layout. Would feeding from control point take out the double quotes? I don't know if you saw my attachment, I get an error on when testing thru "test layout" because Assure puts double quotes around it.   

Hi Infogix Support, 

Is this something that should work when doing test layouts? 

or do i need to test it out thru runtime variables by creating a CE/CP?     

Wasn't sure if the behavior is expected and by design.