GETTING THE DATA FROM THE USER WITH DEPARTMENT KEY

Discussion about developing the ProcessMaker application and suggestions for improving it

Moderator: amosbatto

Madz7104
Posts: 3
Joined: Mon Apr 10, 2017 1:52 am
Country: Saudi Arabia

GETTING THE DATA FROM THE USER WITH DEPARTMENT KEY

Unread postby Madz7104 » Tue Jul 04, 2017 9:35 am

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 688 times

amosbatto
Posts: 5322
Joined: Mon Jun 22, 2009 10:28 am
Country: Bolivia
Location: La Paz

Re: GETTING THE DATA FROM THE USER WITH DEPARTMENT KEY

Unread postby amosbatto » Tue Jul 04, 2017 3:05 pm

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 [email protected]@selectDepartment

See: http://wiki.processmaker.com/3.1/Dependent_Fields
Amos B. Batto ♦ ProcessMaker Technical Documentation Writer & Forum Manager ♦ Cofounder of ILLA (http://www.illa-a.org)

jackluter
Posts: 3
Joined: Wed Jun 14, 2017 4:01 am
Country: India
Contact:

Re: GETTING THE DATA FROM THE USER WITH DEPARTMENT KEY

Unread postby jackluter » Mon Sep 18, 2017 7:10 am

userDetailsManager.getStringProperty(user, "position");


Return to “Development of the ProcessMaker application”

Who is online

Users browsing this forum: No registered users and 1 guest