Databesejoin multiselect in detais view issue

[k0d1]

If we have many lalues selected in Databesejoin multiselect in detais view so after a couple of records I see "unknown label". Here (OECD fields of science) we see also sorting issue.

[LIST]
[*]3.3. Health sciences
[*]3.2. Clinical medicine
[*]3.1. Basic medicine
[*]3. Medical and Health sciences
[*]2.9. Industrial biotechnology
[*]4. Agricultural sciences
[*]3.5. Other medical sciences
[*]3.4. Medical biotechnology
[*]2.6. Medical engineering
[*]2.5. Materials engineering
[*]2.4. Chemical engineering
[*]2.3. Mechanical engineering
[*]2.2. Electrical engineering, Electronic engineering, Information engineering
[*]2.11. Other engineering and technologies
[*]2.10 Nano-technology
[*]2.1. Civil engineering
[*]2. Engineering and technology
[*]1.7. Other natural sciences
[*]1.6. Biological sciences
[*]1.5. Earth and related environmental sciences
[*]1.4. Chemical sciences
[*]1.3. Physical sciences
[*]1.2. Computer and information sciences
[*]1.1. Mathematics
[*]1. Natural Sciences
[*]5.7. Social and economic geography
[*]5.6. Political science
[*]5.5. Law
[*]5.4. Soci
[*]unknown label
[*]unknown label
[*]unknown label
[*]unknown label
[*]unknown label
[*]unknown label
[*]unknown label
[*]unknown label
[*]unknown label
[*]unknown label
[*]unknown label
[*]unknown label
[/LIST]

 

[troester]

"unknown label" is shown if your have multi select values stored in the DB and the label for this value doesn't exist (e.g. after deleting entries in your dbjoin list).

Sorting: what are your "order by" settings?