- Wed Aug 24, 2016 8:43 am
#786389
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
Please help
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
What am I doing wrong to be able to keep the first users details in the process?@@FirstUser = @@USER_LOGGED;
@@Data = executeQuery("SELECT APP_NUMBER FROM APPLICATION WHERE APP_UID = '" . @@APPLICATION . "'");
@@CaseNumber = @@Data[1]['APP_NUMBER'];
Please help