Hello Everyone,
I would like to display data from database view into interface without using grid. Can anyone please help me how to achieve this, the displayed must be editable as well.
Thank You.
Discussion posts and replies are publicly visible
You could display the data in box layout where each box could hold the data of one row of the view. Inside the box you could have these view columns as editable text field, dropdown field or any field of your choice.
Consider the below example code:
a!localVariables(
local!data: *Query the view*,
a!forEach(
items: local!data,
expression: {
a!boxLayout(
label: fv!item.labelField,
contents: {
a!textField(
label: *field name*,
value: fv!item.field
),
//All the fields you want for that row
}
)
@saurabhrajnala: Thank you for your reply. How can the user update the fields and save into database if using box layout.
thanks for the tip.
shubhamy0001 you can create fields such as textField, dropdownField and so on for all the columns of your view's row and edit the data there and save into the table that is used in the view since views aren't editable. In my above reply you can notice the textField inside the box layout's contents in the code snippet. You can hold values of your DB entity in that field and manipulate the data over there.