Display data from database view into interface

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

Parents
  • 0
    Certified Senior Developer

    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

    }

    )

    }

    )

    )

  • 0
    Certified Senior Developer
    in reply to saurabhrajnala

    Hi , try to use for code the "insert code" functionality. You can find it below your comment box at the dropdown "Insert" it makes it waaaaay easier to read for others.

    Hi Shubhamy,
    sarabhrajnala explained one way of a lot of different ways. Can you tell us more about your target? What do you want to archieve? Reporting?
    Editing of specific data entity (line)( Then we are in the record context)
    Do you want to call data in a process the most structured way? 
    Do you want to show data all at once or one by one?
    and so on 
    A lot of factors can be considered here. Can you elaborate your target :)?

Reply
  • 0
    Certified Senior Developer
    in reply to saurabhrajnala

    Hi , try to use for code the "insert code" functionality. You can find it below your comment box at the dropdown "Insert" it makes it waaaaay easier to read for others.

    Hi Shubhamy,
    sarabhrajnala explained one way of a lot of different ways. Can you tell us more about your target? What do you want to archieve? Reporting?
    Editing of specific data entity (line)( Then we are in the record context)
    Do you want to call data in a process the most structured way? 
    Do you want to show data all at once or one by one?
    and so on 
    A lot of factors can be considered here. Can you elaborate your target :)?

Children
No Data