We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.
Our Support systems migrated on Saturday, May 21. We'll automatically forward you to the new location for this content.

using SQL IN statement in Assure layout

Comments

3 comments

  • Avatar
    Manoj Jha

    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
  • Avatar
    JL Macatula

    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
  • Avatar
    JL Macatula

    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.