How to refresh Data Grid when list type Lookup List and lookup source is SQL with variable filtering

Comments

4 comments

  • Avatar
    Gowrisankar

    Hello Juho-Matti Jaaskelainen,

    Yes, you can retrigger the datagrid lookup source using executeLookup helper JavaScript function. Please refer below link to know about the usage. This helper function should be executed on change of ${SelectPlant} variable. I hope this helps.

    https://documentation.agilepoint.com/8000/appbuilder/cloudjsExecuteLookup.html

     

    0
    Comment actions Permalink
  • Avatar
    Juho-Matti Jaaskelainen

    Thank you guiding to the helper. I managed to executeLookup but was not able to bound the results back to the grid so to see updated result. Is there a helper also for this or how this could be achieved?

    Best regards,

    Juho-Matti

    0
    Comment actions Permalink
  • Avatar
    Gowrisankar

    Hello Juho-Matti Jaaskelainen,

    executeLookup helper function will execute the lookup and provides the response in a callback function only. it will not bind the data to the control. So we need to send the response to the control where we want to bind the response using setFieldValue helper method. Please refer below screenshot of the sample code snippet for your use case. I hope this helps for your requirement.

    0
    Comment actions Permalink
  • Avatar
    Juho-Matti Jaaskelainen

    This works perfectly. Thank you very much for your help.

    Br.

    Juho-Matti

    0
    Comment actions Permalink

Please sign in to leave a comment.