36
Views
2
Comments
Database
Question

Hi All,


I have a database filedetails with entities filename, file content, code explanation, decision(reference to the static entity decision), comment. The database has data already stored with 17 rows having data for filename, file content, code explanation and in the next screen,we will display all the 17 rows in the table, we have to select the value for decision which is valid or invalid and give comment and store it in the database. How to do this implementation in outsystems . How to store the decision and comment for 17 records in the database from the next screen.

2023-10-21 19-42-11
Tousif Khan
Champion

Hello

Would you like to store all the 17 Rows with same decision and comment?

If yes then you can just add two inputs via Input you can select whether it is Valid or not and update the comment and save on a button click  and in logic loop through all the 17   records and save them,
If you want to add the decision & comment individually for each row, then you need to add a column in a table and add a save button to that column. After that you can write a logic on the save button, you need to pass the current row data by adding an input param to that button.
And save the data  by its crud opperations

I am attaching a sample that might help you

Sample - App
Thanks
Tousif Khan

SamplePOCApp.oml
2025-11-25 13-20-12
Tamirys Silva Barina

Hi @Lincy Thomson 

To achieve this, you could create a screen displaying a list of all 17 records. Upon selecting a record, redirect the user to a detailed form. This form should include all relevant fields, along with a checkbox for the decision field (a Boolean value indicating validity) and a text area for comments. When the user submits the form, the isValid field should be set to true if the checkbox is checked, and false otherwise. The updated record, including the new isValid and comment values, should then be saved to the database. Call the create or update action to update the respective record in the table.

Kind regards,

Tami




Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.