4

We experience a sorting issue in our SDL Tridion 2011 SP1 implementation. Our CM uses numbers to sort structure groups but Tridion sorts first letters and then numbers. We use Oracle 11g. What we found is that there is one environment lcmAcc that behaves the correct way. Means that it sorts first numbers and then letters. After testing and connecting different DB's (all Oracle 11g) we concluded that is not a DB issue but a setting on the Server. Whatever DB we connect with the lcmAcc (windows server) environment behaves as we want. Could it be a Tridion configuration setting that does the job or the Oracle client installed there? Can anybody give us a tip? As I see the question was asked a year ago. Quirijn did you figured it out?

Improve this question
3
  • 1
    to my knowledge it is a Oracle Client setting (thought actaully it could also be a server setting), but I don't know any details of it.
    – Bart Koopman
    Commented Jan 29, 2015 at 13:49
  • 2
    Check the collation sequence settings on your databases.
    – Dominic Cronin
    Commented Jan 29, 2015 at 22:06
  • That's an Oracle setting right, Dom? Would NLS_Sort be on the right path?
    – Alvin Reyes
    Commented Jan 31, 2015 at 18:28

2 Answers 2

Reset to default
4

Sort order on Oracle is determined by the NLS_SORT parameter on the Oracle Client. Perform the steps below to set NLS_SORT to BINARY, or choose a NLS_LANG setting that includes binary.

according to some oracle docs

So ensure these are the same across all installed oracle clients used to connect to Tridion databases.

Improve this answer
3

As a temporary measure you could implement a Data List Extender, take a look at the docs:

Data Extender Example

All you'll have to do is re-sort the xml nodes by the Title attribute using .Net. This way you ensure you see the sorting like you want (regardless of the database) and even you can then use this mechanism to apply more rules when sorting.

Improve this answer
1
  • Thanks but we try not to add extra complexity to the system. Implementing that will be executed in every GetList() response that happens in the system. There should be a setting that does this as one environment works as requested? I guess is something with the Oracle 11g client installation. Anybody that knows how???
    – Alexandros Bakaros
    Commented Jan 29, 2015 at 15:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.