sort column (disconnected web)

[agustinh2000]

Hi Guys,
I'm working on a disconnected web and I need to sort the data by one column in ascending order
(it's column with numbers I show in the screenshot below)

I set it up in the "sort" tab of that column but it doesn't work. Should I do it with jquery?
I'd greatly appreciate you help!
Thanks!
Agustin

[Bruce]

Hi Agustin,
I would need to see an example app to comment on what you are doing, or why it might not be working.
Could be any number of things...

cheers
Bruce

[agustinh2000]

Hi Bruce, thanks for your answer.
I can use the DisconnetedWeb example (attached below) to clarify my previous question. In this case, I'd want to sort (e.g in ascending order) the InvoiceNumber field which currently appears seemingly 'random' (2,1,3). I set it up in the "sort" tab but it doesn't seem to work. Am I missing something? Do you know what can I do to solve this?

Thanks much!
Agustin

[Bruce]

Hi Agustin,

I tried it out, and after fixing one issue in the example [1], I was able to get it running.
the Invoice.tps file you included was blank (maybe because of the bug?) - so I added some records, but it behaved itself.

[1] SyncInvoice procedure, Returns tab, InvoiceView,
Include Prefixes should be OFF

cheers
Bruce

[agustinh2000]

thanks Bruce.
it worked!!!

[agustinh2000]

Bruce, I was able to sort the column out, but it takes the data as string (see screenshot) rather than short (which is how it's defined in the dictionary). Do I need to set it up in the p_web.SetOption or there's any other way?

p_web.SetOption(loc:options,'orderBy','"' & lower('field_number') & '"')

Thanks!
Cheers,
Agustin

[Bruce]

an updated example of what you have so far, along with an invoice.tps file will probably be helpful in answering this.

Cheers
Bruce

[agustinh2000]

Thanks Bruce,
please find here the example. It does sort the column but as a string (1,10,2,3 etc) but it's defined as long.