MapInfo Pro

Hi everyone,

I'm refining the aesthetics of a layout I'm creating, which involves printing over 700 maps using Site Mapper. I use <COL#> references along with the $mb{SMGetColumnValue()} function to pull in data. Although I can generate the layout with the minimum required data, I'm facing an issue: the indexing table (support data) isn't displaying the columns in the specific order I need (aim - acending order).

To address this, I created a read-only view in PostgreSQL that positions the essential data in the first column, hoping that MapInfo would sort by this column after applying a filter. Unfortunately, this hasn't worked as expected.

I'm looking for suggestions or alternative approaches to reorder the column values in descending order. Additionally, if there are other areas I might be overlooking-such as pre-sorting the data within the SQL query or different configuration options in MapInfo-I would appreciate any insights.

Thanks 

Hi Duane

if I understand you correctly you want to sort your data not only by the selected Site ID column but by a second column for the records your want to show as attributes on the layout. Is the right?

Site Mapper does by default only sort and group by the Site ID column. I think your request requires a modification to Site Mapper

Peter

Hi everyone,

I'm refining the aesthetics of a layout I'm creating, which involves printing over 700 maps using Site Mapper. I use <COL#> references along with the $mb{SMGetColumnValue()} function to pull in data. Although I can generate the layout with the minimum required data, I'm facing an issue: the indexing table (support data) isn't displaying the columns in the specific order I need (aim - acending order).

To address this, I created a read-only view in PostgreSQL that positions the essential data in the first column, hoping that MapInfo would sort by this column after applying a filter. Unfortunately, this hasn't worked as expected.

I'm looking for suggestions or alternative approaches to reorder the column values in descending order. Additionally, if there are other areas I might be overlooking-such as pre-sorting the data within the SQL query or different configuration options in MapInfo-I would appreciate any insights.

Thanks 

Hi Peter,

That's correct. If that's not possible, I have another question-when using MapInfo's table functionality to filter a column and return 100 records, is the result ordered in a specific way?

I appreciate your help.

Best regards,

Hi Duane

if I understand you correctly you want to sort your data not only by the selected Site ID column but by a second column for the records your want to show as attributes on the layout. Is the right?

Site Mapper does by default only sort and group by the Site ID column. I think your request requires a modification to Site Mapper

Peter

Hi everyone,

I'm refining the aesthetics of a layout I'm creating, which involves printing over 700 maps using Site Mapper. I use <COL#> references along with the $mb{SMGetColumnValue()} function to pull in data. Although I can generate the layout with the minimum required data, I'm facing an issue: the indexing table (support data) isn't displaying the columns in the specific order I need (aim - acending order).

To address this, I created a read-only view in PostgreSQL that positions the essential data in the first column, hoping that MapInfo would sort by this column after applying a filter. Unfortunately, this hasn't worked as expected.

I'm looking for suggestions or alternative approaches to reorder the column values in descending order. Additionally, if there are other areas I might be overlooking-such as pre-sorting the data within the SQL query or different configuration options in MapInfo-I would appreciate any insights.

Thanks 

Hey Duane

If no Order By is specified, the data would typically be returned in the way it's fetched from the table. What that means can be hard to tell as an index can play a role here and "mess up" the order.

As for Site Mapper, I'd say it would be relatively easy to add an Order By Column option to the dialog allowing you and other users to control the sort order of the queries.

Hi Peter,

That's correct. If that's not possible, I have another question-when using MapInfo's table functionality to filter a column and return 100 records, is the result ordered in a specific way?

I appreciate your help.

Best regards,

Hi Duane

if I understand you correctly you want to sort your data not only by the selected Site ID column but by a second column for the records your want to show as attributes on the layout. Is the right?

Site Mapper does by default only sort and group by the Site ID column. I think your request requires a modification to Site Mapper

Peter

Hi everyone,

I'm refining the aesthetics of a layout I'm creating, which involves printing over 700 maps using Site Mapper. I use <COL#> references along with the $mb{SMGetColumnValue()} function to pull in data. Although I can generate the layout with the minimum required data, I'm facing an issue: the indexing table (support data) isn't displaying the columns in the specific order I need (aim - acending order).

To address this, I created a read-only view in PostgreSQL that positions the essential data in the first column, hoping that MapInfo would sort by this column after applying a filter. Unfortunately, this hasn't worked as expected.

I'm looking for suggestions or alternative approaches to reorder the column values in descending order. Additionally, if there are other areas I might be overlooking-such as pre-sorting the data within the SQL query or different configuration options in MapInfo-I would appreciate any insights.

Thanks 

Hi Peter,

I really appreciate your attention to this. I believe this change would resolve the aesthetic issue. The right-hand side of my layout has many SMGetColumnValue rows (1-30). As you mentioned, there is no order by clause to neaten up the data (acending/ decending or alphabetically) - I do believe that it would sort it out.

Again - I appriciate your time.

Hey Duane

If no Order By is specified, the data would typically be returned in the way it's fetched from the table. What that means can be hard to tell as an index can play a role here and "mess up" the order.

As for Site Mapper, I'd say it would be relatively easy to add an Order By Column option to the dialog allowing you and other users to control the sort order of the queries.

Hi Peter,

That's correct. If that's not possible, I have another question-when using MapInfo's table functionality to filter a column and return 100 records, is the result ordered in a specific way?

I appreciate your help.

Best regards,

Hi Duane

if I understand you correctly you want to sort your data not only by the selected Site ID column but by a second column for the records your want to show as attributes on the layout. Is the right?

Site Mapper does by default only sort and group by the Site ID column. I think your request requires a modification to Site Mapper

Peter

Hi everyone,

I'm refining the aesthetics of a layout I'm creating, which involves printing over 700 maps using Site Mapper. I use <COL#> references along with the $mb{SMGetColumnValue()} function to pull in data. Although I can generate the layout with the minimum required data, I'm facing an issue: the indexing table (support data) isn't displaying the columns in the specific order I need (aim - acending order).

To address this, I created a read-only view in PostgreSQL that positions the essential data in the first column, hoping that MapInfo would sort by this column after applying a filter. Unfortunately, this hasn't worked as expected.

I'm looking for suggestions or alternative approaches to reorder the column values in descending order. Additionally, if there are other areas I might be overlooking-such as pre-sorting the data within the SQL query or different configuration options in MapInfo-I would appreciate any insights.

Thanks 

Hey Duane

I had a look into adding your improvement idea to Site Mapper.

I think I have found a way for now that doesn't mess too much with the comprehensive Setup dialog.

Next to the Site Column dropdown list, I have added a button that says Order.

When you click on this the Select Columns to Order By dialog pops up allowing you to specify up to five columns to use for the query each site that the tool runs through.

Hi Peter,

I really appreciate your attention to this. I believe this change would resolve the aesthetic issue. The right-hand side of my layout has many SMGetColumnValue rows (1-30). As you mentioned, there is no order by clause to neaten up the data (acending/ decending or alphabetically) - I do believe that it would sort it out.

Again - I appriciate your time.

Hey Duane

If no Order By is specified, the data would typically be returned in the way it's fetched from the table. What that means can be hard to tell as an index can play a role here and "mess up" the order.

As for Site Mapper, I'd say it would be relatively easy to add an Order By Column option to the dialog allowing you and other users to control the sort order of the queries.

Hi Peter,

That's correct. If that's not possible, I have another question-when using MapInfo's table functionality to filter a column and return 100 records, is the result ordered in a specific way?

I appreciate your help.

Best regards,

Hi Duane

if I understand you correctly you want to sort your data not only by the selected Site ID column but by a second column for the records your want to show as attributes on the layout. Is the right?

Site Mapper does by default only sort and group by the Site ID column. I think your request requires a modification to Site Mapper

Peter

Hi everyone,

I'm refining the aesthetics of a layout I'm creating, which involves printing over 700 maps using Site Mapper. I use <COL#> references along with the $mb{SMGetColumnValue()} function to pull in data. Although I can generate the layout with the minimum required data, I'm facing an issue: the indexing table (support data) isn't displaying the columns in the specific order I need (aim - acending order).

To address this, I created a read-only view in PostgreSQL that positions the essential data in the first column, hoping that MapInfo would sort by this column after applying a filter. Unfortunately, this hasn't worked as expected.

I'm looking for suggestions or alternative approaches to reorder the column values in descending order. Additionally, if there are other areas I might be overlooking-such as pre-sorting the data within the SQL query or different configuration options in MapInfo-I would appreciate any insights.

Thanks