Skip to main content

Folks,

I've just gone to use a "Sorter" trasnformer to sort some data in a mapinfo table for processing. However upon opening the attribute selector the list of available columns is presented in alphabetical order. In many instances this would be great, but in this particular instance it's a true pain.

I presume the Sorter works much like other query\\sorts where the logic is

sort by "this" then by "this" then by "this" etc.

In the case of my table I want to sort in the order of the columns as presented in the table. The issue is they are rather generic in name and the order isn't obvious in the naming even though regular, their order in the table does not follow this convention.

In the image below the id is followed by start_equipment_id. There are additional columns but this gives you a good idea.

Ironiclly I see the "sorted" check box which seems to imply that the default is "table structure order" but this is how the data is being presented. Have I got something wrong or is this a known issue with Mapinfo readers?

I think the attributes are always listed as an ordered listed, even if you do not use a sorter.

If you want to change the order your attributes are displayed, you can set these manually in your reader or an attribute manager?


andyew , let me be clear about the functionality of the Storter transformer. It does not sort your attributes in a certain way. Is sorts the features in a alphabetical/numerical order. This just changes the order of the features. It has nothing to do with changing the order of how your attributes are written. Does that make sense?


andyew , let me be clear about the functionality of the Storter transformer. It does not sort your attributes in a certain way. Is sorts the features in a alphabetical/numerical order. This just changes the order of the features. It has nothing to do with changing the order of how your attributes are written. Does that make sense?

@jneujens thanks for continuing to offer assistance. I see referring to the "Sorter" transformer has confused my question. Just for clarification here is the Attribute page for an AttributeFilter. Again the attributes are listed in alpha-order and the "sorted" checkbox seems to be inert. So my question remains, should this list of attributes be presented in table order and then "sorted" should the user wish or is this default "alpha-sorted" a bug?

 


andyew , let me be clear about the functionality of the Storter transformer. It does not sort your attributes in a certain way. Is sorts the features in a alphabetical/numerical order. This just changes the order of the features. It has nothing to do with changing the order of how your attributes are written. Does that make sense?

andyew , aaah that makes sense! For me, it is exactly the same. The attributes are actually alwas ordered. If I click on the 'sorted' checkbox, nothing really changes.

 

 

Is this a bug? Well that depends on the initial intentions of the developer, but it is definitely weird that there is a checkbox 'sorted' while the attributes are already sorted. I think you should contact someone from Safe. 🙂

 

 


andyew , aaah that makes sense! For me, it is exactly the same. The attributes are actually alwas ordered. If I click on the 'sorted' checkbox, nothing really changes.

 

 

Is this a bug? Well that depends on the initial intentions of the developer, but it is definitely weird that there is a checkbox 'sorted' while the attributes are already sorted. I think you should contact someone from Safe. 🙂

 

 

Thanks @jneujens for validating my observations. I've contacted Safe to see what the deal is.

 


Reply