Update:- (Solved)
I managed to get the sorting results I was after.
1. Create a view table. (Using the original table for the layer as the source) (Use Column alias [Select "xx" as "xyz 123"] to rename column names as you go)
2. I called the new view table the same as the source table with the suffix "_Ordered" to differentiate from the two tables.
3. Change the reference table for the layer in question to the newly created view table resource (So the Spectrum layer uses that new table as a reference when the data is shown in the info panel in order)
In the screenshot attached I wanted to display the selected records from newest to oldest so I ordered desc by the MSSQL created rowID "MI_PRINX".
If you have any further questions on how this was achieved, please let me know.
PS: Thanks for your help
@Ruchi MishraRegards
------------------------------
Tim Warfe
GIS Officer
MOORABOOL SHIRE COUNCIL
------------------------------
Original Message:
Sent: 06-10-2019 21:04
From: Ruchi Mishra
Subject: Info Template - Sorting Results
Hi Tim,
Nice idea! you should be able to get the columns sorted using MISQL "order by" while creating view.
I have also attached a screenshot showing how the records can be sorted in ascending or descending order in runtime if it helps.
Thanks,
------------------------------
Ruchi Mishra
Pitney Bowes Australia Pty Ltd
Melbourne
Original Message:
Sent: 06-07-2019 09:41
From: Tim Warfe
Subject: Info Template - Sorting Results
Hi Ruchi, sorry I can't see an option to do that.
By default would be ideal. Can you please send me a screenshot of the manual option you are talking about and I'll see if I can locate it in the meantime.
Just an idea, would creating a custom view query of the data, with an order clause, maybe help??
Thanks
Tim
------------------------------
Tim Warfe
GIS Officer
MOORABOOL SHIRE COUNCIL
Original Message:
Sent: 06-07-2019 03:15
From: Ruchi Mishra
Subject: Info Template - Sorting Results
Thanks Tim!
Wondering you must have tried the sorting option in the info panel (near the Column name)? Would that help?
Or would you like to get the columns sorted by default?
Thanks,
------------------------------
Ruchi Mishra
Pitney Bowes Australia Pty Ltd
Melbourne
Original Message:
Sent: 06-05-2019 17:49
From: Tim Warfe
Subject: Info Template - Sorting Results
Hi Ruchi,
Yes, that is the ideal scenario.
For example, I currently create a MapInfo layer of properties with EDMS records. 1 property Polygon per document record.
In the info pane, when the polygon/s are selected it would be great to have them show as Date Received in Desc order. At the moment the dates are all over the place when the object/s selected.
I hope this makes sense.
Tim
------------------------------
Tim Warfe
GIS Officer
MOORABOOL SHIRE COUNCIL
Original Message:
Sent: 06-05-2019 00:55
From: Ruchi Mishra
Subject: Info Template - Sorting Results
Hi Tim,
Would you like to sort the results by re-ordering the columns or the records in ascending or descending order?
Thanks,
------------------------------
Ruchi Mishra
Pitney Bowes Australia Pty Ltd
Melbourne
Original Message:
Sent: 05-27-2019 02:00
From: Tim Warfe
Subject: Info Template - Sorting Results
Hi guys,
Is there a way to sort the order of which multiple results in the same table are displayed within the info panel when selected. Eg. Date or ID order, etc... ??
Thank you
Tim
------------------------------
Tim Warfe
GIS Officer
MOORABOOL SHIRE COUNCIL
------------------------------