We have an adobe form designed which picks the data from the backend. In one specific case, a table comprising of different headers with different data, including date is being called.
My pdf simply displays the data, the way it is stored in the backend. But now I want to display the data, sorting by its date mentioned. Is it possible for the pdf to read the content of the data and display it based on the sorting defined on the layout end?
I did come across the 'controls' option for the table(under context) and tried adding the field name for sorting based on ascending/descending. But unfortunately, whenever I tried to enter the field name as 'date', it gives me an error saying "component does not exist". I have tried for other fields too, but the same message. This message comes irrespective of the check box for 'already sorted' property.
What could be the reason for this?
In the code initialisation of the interface, I heard that there can be a sort mechanism being coded. Is this alternative possible in my case?
Please provide your valuable inputs.