Discussion about developing the ProcessMaker application and suggestions for improving it

Moderator: ArturoRobles

#793649
Hi...

I am trying to to pull the data from the user table, but I need to specify the department, Ex. All employee at accounting department will be list in the dropdown control.

How can I do that.? Help.
Attachments
Capture.PNG
Capture.PNG (87.77 KiB) Viewed 4936 times
#793654
If your "Department" dropdown has the ID "selectDepartment" and is associated with a variable of the same name, then you can use use this SQL query in the "Department" dropdown:
SELECT CON_ID, CON_VALUE FROM CONTENT WHERE CON_CATEGORY='DEPO_TITLE' ORDER BY CON_VALUE
and this SQL query in the "Employee name" dropdown:
SELECT USR_UID, CONCAT(USR_FIRSTNAME, ' ', USR_LASTNAME) WHERE DEP_UID=@@selectDepartment

See: http://wiki.processmaker.com/3.1/Dependent_Fields
Golden Goose Sale that define

<P>Animal-print Super-Star sneakers with blu[…]

PMFSendMessage throwing error

Hello, Did you solve this issue? what was wrong? T[…]

I upgraded PM 3.3 to 3.5.7 recently. Previously, I[…]

For my video files question I discovered, that I c[…]