Questions & Answers

[ck_accitio]

Hi all,

I tried to sort a language dependent table column within an FS_INDEX of DatasetDataAccessPlugin by query with ordercriteria including %lang%. My query sorts on language independent fields but not on fields like name_DE and name_EN.

Template:

<FS_INDEX name="tt_countries" useLanguages="no" viewMode="headers">
 <LANGINFOS>
  <LANGINFO lang="*" label="Countries"/>
 </LANGINFOS>
 <SOURCE name="DatasetDataAccessPlugin">
  <QUERY name="db.countries_sorted"/>
  <TEMPLATE uid="db.countries"/>
 </SOURCE>
</FS_INDEX>

 Query:

<QUERY entityType="countries">
 <ORDERCRITERIA attribute="name_%lang%"/>
</QUERY>

Is there any solution to sort by language dependent fields?

[ck_accitio]

One additional note: My sort query does in section templates but not in table templates with foreign key connection. Maybe this does matter.