Hello,
I need to update the data of multiple rows. For example, there are multiple records with requested status and I want to change them into submitted. There is an editable grid from where the status is changed which is used by Admin. The record view is used by the user.
What I think: To make something when admin clicks on submit the status value update the record with the updated status automatically.
Note: Value of status is already submitted, but it hasn't changed the record from requested to submitted in the record. I do not have access to Database.
I am new to Appian. If you find anything missing kindly reply.
Thanks
Discussion posts and replies are publicly visible
https://docs.appian.com/suite/help/21.2/recipe-use-the-write-to-data-store-entity-smart-service-function-on-an-interface.html
This example may be useful to you!
Hi gayathris0003
The example you refer to in that the complete data is getting published. What I seek only to update status values in the record.
Hi ,
If you're looking to update the records for a specific set of columns, then this may be useful
docs.appian.com/.../Query_Database_Smart_Service.html
Hi Selvakumar Kumarasamy,
I do not have access to the Database. Can I have a different approach? Maybe using the action on record and updating all rows for a particular column. Is possible?
Hi atula0005,
You don't need database access to develop this method. You already know the table name & the column names right (or it can be fetched from CDT XSD), based on them you can develop queries and use them in this smart service.
Note: The reason for insisting to do this operation at the database level is that in the future if your application has more records, then doing the operations inside the database will be much more efficient than bringing the data into Appian & manipulating it.
The main question I have in reading this post is what is actually being stored in your record. Are you storing the plain text of "Requested" for the status or are you storing an ID that refers to your reference table (which I assume is displayed on the left)?
If it's the latter, you shouldn't need to make any updates. If you change the data in the reference table using your action on the left, then all the places where you use this reference data will be updated automatically. In general this is the preferred approach to ensure that you only need to update the data in one place.
If you actually have the values stored as plan text in your records, then it's a little bit harder to update the results. The question is - do you just need to update this as a one time change or do you anticipate needing to make other changes in the future? If it's only a one time change, I'd actually recommend making the change directly in the database using a SQL statement like
"UPDATE <table_name> SET status = 'Submitted' WHERE status = 'Requested'
If you don't do this it's going to be a lot more complex - you'll need to create a process that queries the data, updates the value for that column, and then writes the data back to the database. In my opinion, it's not worth the effort to create a process if you're just doing a one time update.