Hi Rob,

In the custom sorting options, you can specifiy more than one field like this:

created;ASC;Aangemaakt;DATE
modified;ASC;Gewijzigd;DATE

Effectively this means that first the sort is done by created and then by modified.
When you compare it to SQL, it's equivalent to ORDER BY created, modified

When there are article that have the exact same values for created and modified, the result is unpredictable.

Does this answer your question?

best,
Julien

Hi Julien,

Tanks for your reply but I think this is not correct. When entering values in the Custom ordering options this will generate links in the top of your view which give the visitor different options for ordering. It does not affect the default ordering and therefore you can not adjust the secondary ordering with this method.

When using a Custom ordering default there is a secondary ordering though, it just is not clear where it is defined. So when ordering on a date field, it is not clear to me what the secondary ordering does if the dates are the same.

For some reason there seems to be a ordering newest first when the dates are the same. The question here is, where is this set? Can I adjust that secondary ordering, and if so can I also set a secondary ordering based on F2C fields.

It would be very handy if there was a possibility to ad a secondary ordering in the default ordering field (just like you advised), but that does not seems to be possible at the moment. If this will never be possible it would be nice to know where to change the secondary ordering.

Greets,
Rob

Hello Julien,

That is exactly what I was looking for.

A suggestion for the future might be to create a secondary order option for the default custom ordering. For now I can mange it via your solution.

Thanks a lot!
Greets,
Rob