Prev
Next
Forums User Experience Lawson Design Studio

Run a SQL Query from a Lawson Form

 2 Replies
 1 Subscribed to this topic
 12 Subscribed to this forum
Sort:
Author
Messages
agersh
Veteran Member
Posts: 81
Veteran Member
2/11/2019 3:52 PM

    Using Design Studio once the HR11 form is displayed I would like to execute a custom Javascript function call that runs an SQL query to retrieve a value from the HRHISTORY table. Is this possible? What syntax would I use to run an SQL query from a for Lawson form, using Design Studio?

    Ragu Raghavan
    Veteran Member
    Posts: 476
    Veteran Member
    2/11/2019 4:19 PM
      Can't you just run a DME query on HRHISTORY?
      agersh
      Veteran Member
      Posts: 81
      Veteran Member
      2/11/2019 5:08 PM
        The SQL query that I am looking to run also includes a sub-Select statement within the main Select clause.