Broadridge Financial Solutions
Last activity: 11 Sep 2021 8:08 EDT
Write Custom SQL Query
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.