Page 1 of 1

What is APP_STATUS_ID for?

Posted: Wed Jul 11, 2018 12:44 pm
by higgledy
I am using a trigger to change the APP_STATUS to "TO_DO" after I create a new case via a REST call. I noticed in the APPLICATION table a column, APP_STATUS_ID. It looks like APP_STATUS_ID contains a '1' when the status is DRAFT and a '2' when the status is TO_DO. Is this correct? Where is APP_STATUS_ID used?
But my big question is why does the change status trigger also change the APP_STATUS_ID?

I am using PM 3.1.2, which APP_STATUS_ID is a new thing in PM 3.2.

Re: What is APP_STATUS_ID for?

Posted: Wed Jul 11, 2018 10:13 pm
by amosbatto
APP_STATUS_ID is for the status of the case:
DRAFT: 1
TO_DO: 2
COMPLETED: 3
CANCELLED: 4

Paused cases can have DRAFT or TO_DO status and you need to search in the APP_DELAY table for paused cases.

Re: What is APP_STATUS_ID for?

Posted: Thu Jul 12, 2018 10:14 am
by higgledy
OK thanks. That is what I thought. You will need to update your documentation where you talk about creating a case via REST. The change status php code only changes the APP_STATUS, it should probably also change the APP_STATUS_ID as well.

Re: What is APP_STATUS_ID for?

Posted: Thu Jul 12, 2018 9:03 pm
by amosbatto