Skip to main content
July 25, 2022
Question

Is there a possible way to add rownum column in readonly grid?

  • July 25, 2022
  • 7 replies
  • 0 views

Hello,

Is there a possible way to add rownum column in readonly grid?

If possible, it would be appreciated if you could attach an example for reference.

Thank you.

    7 replies

    July 25, 2022

    Hey please find the attached code. You can use fv!identifier for the same.

     

    a!localVariables(
      local!data: {
        { a: 1, b: 2, c: 3 },
        { a: 4, b: 5, c: 6 },
        { a: 7, b: 8, c: 9 },
        { a: 10, b: 11, c: 12 },
        { a: 13, b: 14, c: 15 }
      },
      a!gridField(
        data: local!data,
        columns: {
          a!gridColumn(value: fv!identifier),
          a!gridColumn(label: "A", value: fv!row.a),
          a!gridColumn(label: "B", value: fv!row.a),
          a!gridColumn(label: "C", value: fv!row.a)
        }
      )
    )

    stefanhelzle0001
    Brainy
    July 25, 2022

    When you fetch the data from DB, fv!identifier will contain the values from the primary key column.

    You could generate a list of number using the enumerate() function and use this as the value of a gridColumn. You might have to consider paging and create this list of numbers with a dynamic offset based on the paging info.

    But before diving into this, what is your use case?

    August 3, 2022

    That's right, fv!identifier retrieves the value of the primary key column, so not suite for rownum use.

     I'm using read-only grid with record type as its data source.

    I want to know more about generating a list of number using the enumerate() function, could you provide any example code for it?

    Thank you. Always wish the best for you.