Skip to main content
S
SathishkumarC1-Visitor
1-Visitor
August 9, 2020
Solved

How to reorder fields in InfoTable

  • August 9, 2020
  • 2 replies
  • 2406 views

Hi,

 

I am trying to convert infotable data into JSON. The fields order available in InfoTable is not same in JSON string.

How to reorder the fields in InfoTable? Fields not follow the infotable order in JSON. How to resolve this?

 

My Infotable:

InfoTable.png

 

Converrted JSON:

{"rows":[{"Description":"Demo","AddedOn":1596949613100,"AddedBy":"Administrator","TemplateFile":"Report.xlsx","Template":"Report Demo"}],"dataShape":{"fieldDefinitions":{"Description":{"name":"Description","aspects":{"isPrimaryKey":false},"description":"","baseType":"STRING","ordinal":2},"AddedOn":{"name":"AddedOn","aspects":{"isPrimaryKey":false},"description":"","baseType":"DATETIME","ordinal":4},"AddedBy":{"name":"AddedBy","aspects":{"isPrimaryKey":false},"description":"","baseType":"STRING","ordinal":5},"TemplateFile":{"name":"TemplateFile","aspects":{"isPrimaryKey":false},"description":"","baseType":"STRING","ordinal":3},"Template":{"name":"Template","aspects":{"isPrimaryKey":true},"description":"","baseType":"STRING","ordinal":1}}}}
 
 
Best answer by SathishkumarC

Thanks for the response.

 

I got a solution with ordinal of the fields.

 

Regards,

Sathishkumar C.

2 replies

V
vinakumar12-Amethyst
12-Amethyst
August 10, 2020

Hi,

 

You can sort the infotable using sort() function as below:

result.Sort({ name: "Name", ascending: true });

S
SathishkumarC1-VisitorAuthorAnswer
1-Visitor
August 10, 2020

Thanks for the response.

 

I got a solution with ordinal of the fields.

 

Regards,

Sathishkumar C.

    Terms & ConditionsAccessibility statement