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

Moderators: ArturoRobles, ArturoRobles

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.
By flattante
Hi all,
i've a problem with some open cases not visible under advanced search section.

Inside the database the situation is this:
    table [b]APP_DELEGATION[/b], field [b]DEL_THREAD_STATUS[/b]=[b]CLOSED[/b] table [b]APPLICATION[/b], field [b]APP_STATUS[/b]=[b]TO_DO[/b] for the last (and all others) DEL_INDEX
I think that there is an issue inside the process that set the case in closed status when, in the reality it is not completed.

Can anyone help me to resolve this annoying problem?

If the task in the case has already been completed, then APP_DELEGATION.DEL_THREAD_STATUS='CLOSED' in the database. There should be at least one task in the case whose APP_DELEGATION.DEL_THREAD_STATUS='OPEN' in the database if the case isn't paused, canceled or completed. Are you not seeing that? If not, then post your process so we can look at it .

At any rate you should be able to use Advanced Search to find cases which have tasks which are already closed. You probably have to give Process Permissions to the user in order to see the case under Advanced Search.
Thanks for you reply,
the advanced search works fine for the other cases (there is not a permission issue) but the cases with this problem are visible only accessing it by direct address (<address>/cases/opencase/<case uid>).

I'm sure that those cases are not in pause, cancelled or completed but they are in progress. In fact, trying to set the field DEL_THREAD_STATUS to OPEN, they come back visible and the user can interact with them.

I really don't know how I can solve this issue. At the moment the only 'solution' is to set the field DEL_THREAD_STATUS to OPEN, but periodically I have to extract all the cases 'blocked'.

I've attached the process to analyze it.

Thank you so much
(425.78 KiB) Downloaded 93 times
I tried to run a case, but there was too much missing data for me to get through the process, so I couldn't reproduce your problem. Tell me exactly which tasks get closed, which you have to set to "OPEN". You should alway have one open task in your process until you finish the case.

The 500 Internal Server Error is the general catch[…]

Really very nice blog information for this one and[…]

This is a long, lengthy and cumbersome process. T[…]

Great read for when on the road. The book provides[…]