using SQL IN statement in Assure layout

Follow

JL Macatula

• June 22, 2020 20:24

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

 

0

• 

  Manoj Jha

  • June 24, 2020 09:39

  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.

   

  0

  Comment actions Permalink
• 

  JL Macatula

  • June 24, 2020 12:26

  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.   

  0

  Comment actions Permalink
• 

  JL Macatula

  • July 27, 2020 15:59

  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.   

  0

  Comment actions Permalink

Please sign in to leave a comment.