Currently in the form when it loads should check to see if there are any freight

sudhirp804 over 10 years ago

Currently in the form when it loads should check to see if there are any freight options already there and show them (as it does now) then when the user submits the form the existing freight rows in the DB should either be updated or deleted and overwritten. Could anyone let me know in how I can use the Query Database smart service and what query I should write so that existing freight row should be updated or deleted and overwritten. This query we have used earlier and in this case it deleted the existing freight detail (DELETE FROM prmprojectfreight WHERE projectid = ac!projectId and amount>0)

What we need instead of deleting the existing frieght it should be updated or deleted and overwritten in DB.
...

workflow.docx

Discussion posts and replies are publicly visible

Parents

0 Michael Chirlin
Appian Employee
over 10 years ago

Is this a SAIL form? What does the user interface look like?

It may be a matter of saving the ids of the lines that were deleted and using the Delete from Data Store Entities Smart Service to remove them from the database. The updated and new lines should be written to the database using the Write to Data Store Entity Smart Service.

forum.appian.com/.../Write_to_Data_Store_Entity_Smart_Service.html
forum.appian.com/.../Delete_from_Data_Store_Entities_Smart_Service.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Michael Chirlin
Appian Employee
over 10 years ago

Is this a SAIL form? What does the user interface look like?

It may be a matter of saving the ids of the lines that were deleted and using the Delete from Data Store Entities Smart Service to remove them from the database. The updated and new lines should be written to the database using the Write to Data Store Entity Smart Service.

forum.appian.com/.../Write_to_Data_Store_Entity_Smart_Service.html
forum.appian.com/.../Delete_from_Data_Store_Entities_Smart_Service.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data