Spectrum Spatial (SSA/LIM)

Expand all | Collapse all

Info Template - Sorting Results

  • 1.  Info Template - Sorting Results

    Posted 05-27-2019 02:00
    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
    ------------------------------


  • 2.  RE: Info Template - Sorting Results

    Pitney Bowes
    Posted 06-05-2019 00:55
    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
    ------------------------------



  • 3.  RE: Info Template - Sorting Results

    Posted 06-05-2019 17:49
    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
    ------------------------------



  • 4.  RE: Info Template - Sorting Results

    Pitney Bowes
    Posted 06-07-2019 03:15
    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
    ------------------------------



  • 5.  RE: Info Template - Sorting Results

    Posted 06-07-2019 09:41
    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
    ------------------------------



  • 6.  RE: Info Template - Sorting Results

    Pitney Bowes
    Posted 06-10-2019 21:05
      |   view attached
    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
    ------------------------------



  • 7.  RE: Info Template - Sorting Results

    Posted 06-11-2019 22:29
    Edited by Tim Warfe 06-11-2019 22:30
      |   view attached
    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 Mishra

    Regards



    ------------------------------
    Tim Warfe
    GIS Officer
    MOORABOOL SHIRE COUNCIL
    ------------------------------



  • 8.  RE: Info Template - Sorting Results

    Pitney Bowes
    Posted 06-11-2019 22:39
    Wonderful!! You are welcome, Tim :)
    Thanks for sharing it with community as well.

    ------------------------------
    Ruchi Mishra
    Pitney Bowes Australia Pty Ltd
    Melbourne
    ------------------------------



  • 9.  RE: Info Template - Sorting Results

    Moderator
    Posted 06-12-2019 00:38
    Hi Tim and Ruchi,

    Discussions like these are bringing new learnings for everyone. Thanks for sharing!


    ------------------------------
    Nalin Mathur
    Pitney Bowes Software India PVT. Ltd
    Noida
    ------------------------------



  • 10.  RE: Info Template - Sorting Results

    Posted 06-13-2019 19:35
    Thank you @Nalin Mathur

    ------------------------------
    Tim Warfe
    GIS Officer
    MOORABOOL SHIRE COUNCIL
    ------------------------------