MapThat – Sorting Data Tables

By David Crowther

Question:

Is it possible to auto sort the records in the MapThat Data Table?

Answer:

Yes, MapThat allows you to auto sort the results in any Data Table in either ascending or descending order. You can sort numeric, dates and textual values.

For information on how to configure a Layers Information Bubble and Data table to show the correct data types please refer to this FAQ - https://www.cadlinecommunity.co.uk/hc/en-us/articles/360000377998-MapThat-How-do-you-configure-the-Information-Bubbles-to-Show-Date-Fields-

Having specified the correct values in the Column Type and Column Data Type fields within the LAYER_ATTREDIT table, you can now use the ATTR_SORT_DIRECTION field in that table to choose which field to order your records on.

For example in the Liverpool Planning Applications layer we can order the result records using the AREA field by specifying either ASC (for ascending) or DESC (for descending).

The above configuration would then show the Liverpool Planning Applications in their Ascending order based on their size (Area).

We can also order the result records using the Date Updated field by specifying either ASC (for ascending) or DESC (for descending).

The above configuration would then show the Liverpool Planning Applications in Descending order based on their last Updated Date.

Finally, we can order the result records using a Textual field (e.g. the Location value) by specifying either ASC (for ascending) or DESC (for descending).

The above configuration would then show the Liverpool Planning Applications in Ascending alphabetical order based on their Location.

Please note – only 1 field should be set as ASC or DESC at any one time. If multiple fields are chosen then the Data Table will not auto sort as expected.