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 Send Private Message
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 Send Private Message
Posts: 477
Veteran Member
2/11/2019 4:19 PM
Can't you just run a DME query on HRHISTORY?
agersh
Veteran Member Send Private Message
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.