By touhamm - Fri Aug 26, 2016 5:35 am
- Fri Aug 26, 2016 5:35 am
#786396
Hi everybody!
I have been trying to mass advance cases (+300) to the next task in the process. It works more or less. But the more I want to electing about choosing the cases, the more things get hacky, especially because we use LDAP.
Probably the right solution in our case is to use plain SQL to manipulate the cases and probably a bit of PHP if cases forms need manipulation.
Here is our scenario:
A user complains he can't manage his inbox because it is flooded with 480 case while he only works on less than 100. He needs to advance, or simply get rid of the rest. How should we determine the unnecessary cases? Easy! They originate from a particular process, they have been assigned from a certain person, and have a case variable set to a determined value.
Easy to do in theory, but while on practice, this causes me many problems:
Thank you in advance.
I have been trying to mass advance cases (+300) to the next task in the process. It works more or less. But the more I want to electing about choosing the cases, the more things get hacky, especially because we use LDAP.
Probably the right solution in our case is to use plain SQL to manipulate the cases and probably a bit of PHP if cases forms need manipulation.
Here is our scenario:
A user complains he can't manage his inbox because it is flooded with 480 case while he only works on less than 100. He needs to advance, or simply get rid of the rest. How should we determine the unnecessary cases? Easy! They originate from a particular process, they have been assigned from a certain person, and have a case variable set to a determined value.
Easy to do in theory, but while on practice, this causes me many problems:
-
[*] I cannot proceed to route the cases as an admin because LDAP
[*] How do query I for cases both based on database columns and case variables?
[*] The operation takes too much time and, past PHP execution timeout, the batch hangs out, may corrupt some cases and another batch is needed.
Thank you in advance.
Last edited by touhamm on Tue Sep 06, 2016 4:46 am, edited 1 time in total.