jFiles SaveFile sorting by a key

Hi all,

I’m using jFiles to export a TPS file to JSON. This process is sequential. I’m wondering if it’s possible to do this by a key. Add a line somewhere in the code like SET(PRE:MyKey,PRE:MyKey)
Suggestions are welcome.
The reason for this is that the recipient requests it.

Regards, Henk

Depending on the number of rows, it might be simplest to fill an intermediate queue that then goes to JSON. You can sort that queue however you want before export.

Create a VIEW on the table and set the Prop:Order for the view before using jfiles to export it.

3 Likes