I have a Data Type and configured with Data Page to store records. I created 5 columns in Data Page in which one column name is COUNT.
I have case type (name Test). In this test Case type I created to stages First Stage and second stage. I added an automation steps (change to a stage). so Based on when condition case instance also changing their stage. Means If I create a case instance , then case is going form first stage to second stage then same case is coming back from second stage to first stage based on when condition.
My requirement is once case is created for first time and case moved from first stage to second then in Data page count column One (1) should filled / saved / stored. if user selected condition for close the case in second stage then case should not go back to first stage but if user selected condition for change the stage then case is coming backing to first stage. same case when user again submitted for 2nd time for second stage then in count column value should increase from one (1) to two (2). Like wise same if case coming back for third time count should increase from two (2) to three (3).
My main concern about how count column value will increase from 1 to2 to 3 to 4, when case coming back to previous stage.
How can I achieve it ?? can I achieve it by writing custom SQL, if this is possible then guide me how can use it.
My concerns is not about change stages because I already achieved it.
***Edited by Moderator Marissa to change type from General to Product, update Product details and Platform Capability tags****
//if user selected condition for change the stage then case is coming backing to first stage.// whenever this condition is met, just increment the concern property, and case is in stage one, upon moving to next stage the updated count will be saved.
That I know. My mean of above question was how can I implement the count increment logic. Should I create Data Transform or Activity or Report Definition or any other approach. Which logic will be helpful for developing count increment ??