We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

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.