How to get the unassigned cases user list?

Questions and discussion about developing processes and programming in PHP, JavaScript, web services & REST API.

Moderator: amosbatto

Forum rules
Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.
raja2704
Posts: 4
Joined: Wed Aug 31, 2016 1:00 am
Country: India

How to get the unassigned cases user list?

Unread postby raja2704 » Tue Dec 12, 2017 2:42 am

Hi,

Requirement:
Input - user mail/user id.
Need to find the list of unassigned cases for the given user.

And also could you please share the db table name where the unassigned cases stored?

regards,
Raja

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

Re: How to get the unassigned cases user list?

Unread postby amosbatto » Tue Dec 12, 2017 10:59 pm

You can use the unassignedCaseList() web service in a trigger, but first you have to login as that user by looking up the hash of the user's password in the database. See:
http://wiki.processmaker.com/3.0/ProcessMaker_WSDL_Web_Services#Using_Hashed_Passwords_from_the_Database

If you can't figure it out, post your code and I will help you.
Amos B. Batto ♦ ProcessMaker Technical Documentation Writer & Forum Manager ♦ Cofounder of ILLA (http://www.illa-a.org)

raja2704
Posts: 4
Joined: Wed Aug 31, 2016 1:00 am
Country: India

Re: How to get the unassigned cases user list?

Unread postby raja2704 » Thu Dec 14, 2017 2:15 am

Thanks for the information amosbatto.
I got the solution.

regards,
Rajamuthu

raja2704
Posts: 4
Joined: Wed Aug 31, 2016 1:00 am
Country: India

Re: How to get the unassigned cases user list?

Unread postby raja2704 » Thu Jan 11, 2018 3:51 am

Hi amosbatto,

I am able to get the unassigned cases for the specific user. Its working fine.
But, only for some users there is a mismatch in the count of unassigned cases.
Do we have any restriction to list the unassigned cases?
i.e only if it self service assessment not with self service value based assignment. some thing like that.
waiting for your response.....

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

Re: How to get the unassigned cases user list?

Unread postby amosbatto » Thu Jan 11, 2018 10:14 pm

raja2704 wrote:I am able to get the unassigned cases for the specific user. Its working fine.
But, only for some users there is a mismatch in the count of unassigned cases.
Do we have any restriction to list the unassigned cases?
i.e only if it self service assessment not with self service value based assignment. some thing like that.
waiting for your response.....

I looked through the source code and this web service is using AppCacheView::getUnassigned() to get the list of unassigned cases. In the source code, both Self Service and Self Service Value Based Assignment case are returned. However, this code is old and I don't know if anyone has checked it for several years since most people are now using REST instead of web services. If not all the unassigned cases for a user are not being returned, can you determine which cases are not being returned?
Amos B. Batto ♦ ProcessMaker Technical Documentation Writer & Forum Manager ♦ Cofounder of ILLA (http://www.illa-a.org)


Return to “Developing processes & programming”

Who is online

Users browsing this forum: No registered users and 5 guests