I have one form in that i have to store data into 4 CDTS .Project ,projectteaam,milestone,milestonetask,
={{entity:pv!DSR_Project, data:{pv!DSR_Project.projectname,pv!DSR_Project.roleid,pv!DSR_Project.clientid,pv!DSR_Project.estimatedbudget,pv!DSR_Project.projectstartdate,pv!DSR_Project.projectenddate,pv!DSR_Project.description}},{entity:pv!DSR_ProjectTeam, data:{pv!DSR_ProjectTeam.projectid,pv!DSR_ProjectTeam.employeeid,pv!DSR_ProjectTeam.startdate,pv!DSR_ProjectTeam.enddate,pv!DSR_ProjectTeam.description}},{entity:pv!DSR_MileStone, data:{pv!DSR_MileStone.projectid,pv!DSR_MileStone.milestonename,pv!DSR_MileStone.startdate,pv!DSR_MileStone.baseline,pv!DSR_MileStone.forcast,pv!DSR_MileStone.actual,pv!DSR_MileStone.estamount,pv!DSR_MileStone.actualamount,pv!DSR_MileStone.comments,pv!DSR_MileStone.paymentrecieveddate}},{entity:pv!DSR_MileStoneTask, data:{pv!DSR_MileStoneTask.milestoneid,pv!DSR_MileStoneTask.taskname,pv!DSR_MileStoneTask.taskhour}}}
can any one help me out of this .I need to store data in multiple data store entities.since im unable to store
Discussion posts and replies are publicly visible
You might want to create a constant for each entity and use in place of process variable. Also you do not need to mention each field in data just a process variable with right data type (CDT) will write the data to entity.
{ { entity: cons!DSR_PROJECT_ENTITY, data: pv!DSR_Project }, { entity: cons!DSR_PROJECTTEAM_ENTITY, data: pv!DSR_ProjectTeam }, { entity: cons!DSR_MILESTONE_ENTITY, data: pv!DSR_MileStone }, { entity: cons!DSR_MILESTONETASK_ENTITY, data: pv!DSR_MileStoneTask }}
Hi gangadharr0001
You can follow the below structure for writing to multiple data store entity. Your pv should be of cdt type where you can store all the individual field data.{
{entity:cons!ENTITY_PROJECT,data:pv!Project},
{entity:cons!ENTITY_PROJECT_TEAM,data:pv!projectteaam},
{entity:cons!ENTITY_MILESTONE,data:pv!milestone},
{entity:cons!ENTITY_MILESTONE_TASK,data:pv!milestonetask}
}Documentation: https://docs.appian.com/suite/help/20.3/Write_to_Multiple_Data_Store_Entities_Smart_Service.html#example-inputs
Vadivelan and rickyc0001 ,
As per you guys suggestion i did but in variables value showing no value .Please look at images
Your data PV's will need to be populated with data beforehand for this to work. You'll need to troubleshoot your SAIL form and/or the configuration in which your form is passing data back to the process.
Verified SAIL form ,process model executing fine but its not updating process variables .only saving data in project entity remaining entities storing null values .and also projectteam,milestone ,milestonetask is child tables of project .Can you give suggestion on this
Please provide some further details (screenshots etc) of your user input task's Data Inputs tab as well as the Form configuration. Those are the things we need to see to verify whether it'd be expected to work.
Per your screenshot above it looks as if your DSR_Project PV is populating with some valid data. We can't tell much about the others based on what you've provided so far.
As per your request user input data and user input form.Please look t once
Thanks
mike schmitt
Can you give me suggestion on above post
Please find below post regarding above issue
Just to confirm - you showed the project variable in your screenshot of the user input task, and it appears that one is saving data to your process correctly. Are you doing the same thing (using a saveInto in the inputs of your user input task) for the other variables?
Also, is it possible that your form isn't saving the data correctly? If you go to the interface and submit the form from Interface Designer, do you see the rule inputs populated with data you expect?