[Solved] Sorting joined repeated group item in form view

[jolle]

Hello,

I have 2 lists: courses and participants
I have added a joined repeated group to participants with a dbjoin-element on courses since they select can select several courses on registration.

The participants list is sorted by the course title.
The participants list is grouped by the course title and the groups sorted by registration date.
The course title is a concat value from course number and course title.

When editing (form view) a participant with its courses it is important to keep the entry order of the courses.
But they are influenced by the sort criteria of the list.

How can I display the joined repeated data keep in the order they were entered and keep the list sorted?

BR,
J?rn
Fabrik 3.0.9, Joomla 2.5.27

 

[jolle]

Ok, I found a workaround.

I duplicated the participants list (copy) to participants_two.
I changed the sorting of participants_two to sort by the id of the joined repeated group.
The joined repeated group is stored in a mapping table between participants and courses and has its own id. Entries in this table are created in the order of entry in the frontend.

At last I changed the edit link of list participants to use the form participants_two.
Custom edit link:
index.php?option=com_fabrik&view=form&formid=20&rowid={rowid}

That did the trick since this form relies on sorting of participants_two.

I would have preferred a way to define sorting for the form in the form's options.

BR,
J?rn