using SQL IN statement in Assure layout
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
-
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.
Please sign in to leave a comment.
Comments
3 comments