Sort Editable Grid By Column Values

This is possible to do via workarounds like Drew mentions, but there's a reason the editable grid isn't inherently sortable by column - when the data within is actually editable, then trying to change the sort (while pending edits are in place, etc) is just a nightmare.  Therefore I strongly recommend against this.  If you need sorting, use read-only.  If you need editable, then sort the data at the start in a manner that will be suitable until editing is completed.

Hi,

I want to sort the display order column in the editable grid and is this the way it should be done?

How do I know if its working?

a!localVariables(
  local!QRSuppliers: a!queryEntity(
    entity: cons!BC_SUPPLIER_DSE,
    query: a!query(
      selection: a!querySelection(
        columns: {
          a!queryColumn(field: "supplierId"),
          a!queryColumn(field: "description"),
          a!queryColumn(field: "displayOrder"),
          a!queryColumn(field: "createdDate"),
          a!queryColumn(field: "createdBy"),
          a!queryColumn(field: "modifiedDate"),
          a!queryColumn(field: "modifiedBy"),
          
        }
      ),
      pagingInfo: a!pagingInfo(
        startIndex: 1, 
        batchSize: - 1,
        sort: a!sortInfo(field: "displayOrder", ascending: true)
      )
    ),
    fetchTotalCount: true
  ).data,

Thanks

You should be able to just run that query by itself and verify whether it comes out ordered the way you want.

• • supplierId1(Number (Integer))
  • description"Lockheed Martin"(Text)
  • displayOrder5(Number (Integer))
  • Dictionary
  • supplierId3(Number (Integer))
  • description"Office Mart"(Text)
  • displayOrder8(Number (Integer))
  • Dictionary
  • supplierId2(Number (Integer))
  • description"Dell"(Text)
  • displayOrder15(Number (Integer))
    

It's working. 

Thanks

• • supplierId1(Number (Integer))
  • description"Lockheed Martin"(Text)
  • displayOrder5(Number (Integer))
  • Dictionary
  • supplierId3(Number (Integer))
  • description"Office Mart"(Text)
  • displayOrder8(Number (Integer))
  • Dictionary
  • supplierId2(Number (Integer))
  • description"Dell"(Text)
  • displayOrder15(Number (Integer))
    

It's working. 

Thanks