I'm trying to work out a way to dynamically sort a portal. For example, I display a list of invoices showing invoice number, customer, date, status. I want to be able to sort by any of the fields at the click of a button through the same portal and on the same layout.
My best option would seem to be to build a value list and sort by this, you can then set the ale list to be the sorted order of the selected field using SQL and hey presto. That should work a treat in a single user environment as you just put the value list items into a field and build your value list from that (although I've not done it so it might not work ;-)
But when you want to do this in a multi user environment your sort order will en raked up by envying else who is viewing the same layout. Global fields won't work as they aren't indexed and so can't build a value list. You could set up a table to hold all these value lists by user by layout, but thats quite long winded.
Anyone else had any brain storms on this one?