Process Model

Hi said0002,

Hope this might be helpful,

1.  Create a Query rule , Query the table and get the data , while querying the data base table make sure that you give the "batchSize" of the "pagingInfo"  as "1" so that it will return only one row of data , user index function so that the output will in the form of "data" but not a DataSubset

2. Take a rule input to filter the data  (take a filed that is unique in the Database table so that u can fetch details for that particular row in database,  for example  :  "id" and the data type as Number (Integer), here consider the Id as the primary key of the Database table )

3. User a query filter and filter the data (for example  : "id" , test the query by passing the "id" in the rule input, if the "id" exits you can see the data, as we have taken the batchSize as "1" we would get only row of data )

4. Create a Process model , create process variables (like id, the CDT and other variables) that are required

5. Take a Script task , in the output of the DATA , create a new custom output and call the above Query rule and pass the process variable to the query rule input (for example  : pv!id , where id is a process variable)

6. Store the output of the query in a process variable (the data type of the process variable should be the same as the output of the query ,if you are using a CDT, then is data type of the process variable should be the same)

7. Create an Interface , a rule input (same data type as used in the process model like if you are using a CDT , create a rule input with the data type as CDT) in the interface and use all the components to display the data ( like if you have a "Name" filed you can use a text field to display the data , so that you can edit it  and like wise for the rest of the fields)

8. Call the above created Interface in the User Input Task of the process model and rule inputs of the Interface will be mapped with the same data type process variable, pass the variable ( the same variable that you have used for storing the query output ) to the value of the interface and save the same in the saveInto

9. A write to Data Store Entity smart service after the User Input Task and pass all the necessary data input and output of the node (write to Data Store Entity)

10 . The row in the database will be Altered with the updated data

NOTE :

1. You should pass value to the process variable that you are using to filter the Query (for example : "id", we have pass a value to the field "id" so the I can fetch the data from the query )

2. Use Activity Chaining where ever necessary

Below is a reference Image of the Process Model

Hi said0002,

Hope this might be helpful,

1.  Create a Query rule , Query the table and get the data , while querying the data base table make sure that you give the "batchSize" of the "pagingInfo"  as "1" so that it will return only one row of data , user index function so that the output will in the form of "data" but not a DataSubset

2. Take a rule input to filter the data  (take a filed that is unique in the Database table so that u can fetch details for that particular row in database,  for example  :  "id" and the data type as Number (Integer), here consider the Id as the primary key of the Database table )

3. User a query filter and filter the data (for example  : "id" , test the query by passing the "id" in the rule input, if the "id" exits you can see the data, as we have taken the batchSize as "1" we would get only row of data )

4. Create a Process model , create process variables (like id, the CDT and other variables) that are required

5. Take a Script task , in the output of the DATA , create a new custom output and call the above Query rule and pass the process variable to the query rule input (for example  : pv!id , where id is a process variable)

6. Store the output of the query in a process variable (the data type of the process variable should be the same as the output of the query ,if you are using a CDT, then is data type of the process variable should be the same)

7. Create an Interface , a rule input (same data type as used in the process model like if you are using a CDT , create a rule input with the data type as CDT) in the interface and use all the components to display the data ( like if you have a "Name" filed you can use a text field to display the data , so that you can edit it  and like wise for the rest of the fields)

8. Call the above created Interface in the User Input Task of the process model and rule inputs of the Interface will be mapped with the same data type process variable, pass the variable ( the same variable that you have used for storing the query output ) to the value of the interface and save the same in the saveInto

9. A write to Data Store Entity smart service after the User Input Task and pass all the necessary data input and output of the node (write to Data Store Entity)

10 . The row in the database will be Altered with the updated data

NOTE :

1. You should pass value to the process variable that you are using to filter the Query (for example : "id", we have pass a value to the field "id" so the I can fetch the data from the query )

2. Use Activity Chaining where ever necessary

Below is a reference Image of the Process Model