- Tue May 21, 2019 3:07 am
#824524
I created a process to simply record my queries to a processmaker table. In the process I have one dynaform with two questions. The first question is a dropdown box to query all the user UID's. I would then select a user UID and the next question queries the user email based on the UID selected. The SQL query for question 1 is given below:
SELECT USR_UID FROM USERS ORDER BY USR_UID DESC
The query for the second question is given below:
SELECT USR_UID, USR_EMAIL FROM USERS WHERE USR_UID = @@user_uid ORDER BY USR_EMAIL ASC
My Problem is that the first query doesnt return any results. Any assistance would be great.
SELECT USR_UID FROM USERS ORDER BY USR_UID DESC
The query for the second question is given below:
SELECT USR_UID, USR_EMAIL FROM USERS WHERE USR_UID = @@user_uid ORDER BY USR_EMAIL ASC
My Problem is that the first query doesnt return any results. Any assistance would be great.
Attachments
Test.PNG (10.01 KiB) Viewed 4016 times