[raja2704]

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]

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/Proces ... e_Database

If you can't figure it out, post your code and I will help you.

[raja2704]

Thanks for the information amosbatto.
I got the solution.

regards,
Rajamuthu

[raja2704]

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]

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?