[DiegoSandoval]

Hi Team,

I have this issue, two dropdowns in a grid one dropdown value depend on the other, but I have an issue to do this. I am using the following query.

Code: Select all

SELECT USR_UID, USR_USERNAME 
FROM wf_workflow.GROUPWF 
WHERE GRP_TITLE = [u]'@#Job'[/u];

The grid name is 'Verification' and the dropdowns are 'Job' and the affected value is 'Verificator'.

If I use this query with a constant value it doesn't have any issue. How I need to set this variable.

I appreciate your help

Regards

[amosbatto]

You can use this SQL query in your second dropdown:
SELECT U.USR_UID, CONCAT(U.USR_FIRSTNAME, ' ', U.USR_LASTNAME)
FROM USERS U JOIN GROUP_USER GU ON GU.USR_UID=U.USR_UID WHERE GU.GRP_UID=@@selectGroup

Here is an example Dynaform:

select users in grid.json

(2.52 KiB) Downloaded 228 times