Hi all,
I have got a requirement to create an audit table in the appian cloud DB.
I have an interface which i can select the select the tasks for users from a selectable Grid and assign those tasks for a particular user (one user can able multiple tasks).
So i haven to create a table and load those assignment data. Could you please guide me how can i achieve this.
example:
If a,b,c tasks are assigned to x
then our table should be
id taskid assignee active
1 a x 1
2 b x 1
3 c x 1
if x reassigned task b to y then our old transaction should go inactive.
Could you please suggest me the process model design with an dummy example
Thanks in advance
Discussion posts and replies are publicly visible
You may want to start by looking at the following:Create the table: https://docs.appian.com/suite/help/20.4/Custom_Data_Types.htmlWrite (insert/update) data to the table: https://docs.appian.com/suite/help/20.4/Write_to_Data_Store_Entity_Smart_Service.html
So, when the task is assigned write the DS. When the task is updated, using the PK, write the new data to the DS to update.Hope that gets you started!