[azalea]

Dear All,

I have a three step process as follows
Step 1 - A user initiates a new case.
Step 2 - A staff member reviews the case and can either make a decision or pass it on to an expert.
Step 3 - Once the decision has been made send an email to the first user.


As the case progresses through the process the various stages the @@FirstUser keeps changing.

On start of a new case I run the following in the start up trigger

Code: Select all

@@FirstUser = @@USER_LOGGED;
@@Data = executeQuery("SELECT APP_NUMBER FROM APPLICATION WHERE APP_UID = '" . @@APPLICATION . "'");
@@CaseNumber = @@Data[1]['APP_NUMBER'];

What am I doing wrong to be able to keep the first users details in the process?

Please help

[ashkufaraz]

For keep user detail permanently you must save data to table
http://www.wiki.processmaker.com/3.0/PM_Tables

[azalea]

thanks.

i could slap my self for this.

[amosbatto]

Hi Azalea,

As the case progresses through the process the various stages the @@FirstUser keeps changing.

That code example in the wiki is bad, because @@FirstUser will be changed every time the case returns to the first task. I have updated the documentation at http://wiki.processmaker.com/3.0/Tasks# ... Assignment to fix this.

You can use this trigger code to make sure that @@FirstUser is only set once in the case:

Code: Select all

if (!isset(@@FirstUser) or empty(@@FirstUser)) {
   @@FirstUser = @@USER_LOGGED;
   @@Data = executeQuery("SELECT APP_NUMBER FROM APPLICATION WHERE APP_UID = '" . @@APPLICATION . "'");
   @@CaseNumber = @@Data[1]['APP_NUMBER'];
}

[azalea]

Hi Amos,

Thanks for the update.