Cascading Checkbox in "double" repeat group

[lori19]

Hi there!

J5.1.4, F4.2
Here's my setup: I have a table for projects and subproject whereby the subproject are a repeated group within the projects (as one project can have several subproject).

Then I have a second table with beneficiaries who are attributed to projects. Again, as there may be beneficiaries belonging tio several projects, this section is set up as a repeated group. The project field is a database join element linking to project table, the subproject field is a CDD configured as a checkbox list depending on the project field.

Data input etc works fine, however, the pagination in the beneficiaries list is broken. The first page loads fine but when Iwant to move from one page to another I get an empty result. System Debug on shows no errors, system debug off make no difference, no javascript issues in the console. The CDD element has standard settings, no advanced or frontend etc. functionality. I noticed that Fabrik created a beneficiary's-xy_repeat_repeat-subprojects table to store the data from the checkboxes.

Any suggestions?

Kindly,
Lorenz

 

[troester]

Not sure if Fabrik does pagination 'correctly' at all with repeat groups and joins display set to merge rows.
Maybe it's counting/computing for display mode ="each row separately".
Not on my PC, I can't test.

 

[lori19]

No hurry
So far, repeated groups are displayed fine in my list views, neatly in a column, even with a little cell border around.
But you gave me the idea to check for the "Merge row" setting in the involved lists: They actually show all "Merge rows" as intended. However, the beneficiaries_xy-repeat_repeat is not displayed anywhere in these setting. I even made a new list-clone for beneficiaries_xy_repeat and set this one to "Merge row" - no effect.
When I unpublished the subproject element the pagination behaviour is normal again.

 

[lori19]

Update

Found a work around: Thinking that the paginations features is basically a filtering procedure I deactivated the filtering options for my beneficiaries_xy-repeat_repeat_subproject.subproject element -> the pagination is back to normal.
Maybe an indication for where the issue lies?

Thanks for helping me think!

Kindly,
Lorenz