Repeat Group in JOIN table

[germanoalves]

I have 2 tables:

- table A of users

- table B of products intended for each user of table A

In table B, the output form has a repeater group.

I need to make a general listing to know which items are available for each user.
When doing a "LEFT JOIN" of the table generated by the repeater group, it doesn't return any data.

I already did a LEFT JOIN of the non-repeating items and it worked.

How do I handle this repeater group data in a JOIN?

Thanks!

 

[lousyfool]

Sounds like http://fabrikar.com/forums/index.php?wiki/list-joins/#adding-a-join

 

[germanoalves]

Hi @lousyfool !

I managed to partially solve the problem. :/

I've tried in every way the configurations of the "JOIN" tab and I didn't have the final result I need.

See that in the "product name" column only the name of the products appears, but without the same being repeated in the entries of the 'mother' table.





Table "mother"


even activating the "Repeatable" option in the "JOIN" tab, the product names are not repeated.

Is there anything else I can adjust in the settings of this list so that the quantity and name of each product appears, line by line?

Thanks!

 

[troester]

This all is in list view?
What are your settings in Joins/"Display mode"?
How do you sort your list?

Depending on what you want you may need a custom list template. Or you may want to go with related date instead of displaying it directly in the list view.


Your screenshot of your mother table doesn't look like a standard Fabrik list view.
Is it a custom one? Or did you group the list?

 

[germanoalves]

Hi @troester !

My configuration in table "JOIN":



I grouped the list because it was the only way that came closest to the reality I need. But still, the data didn't get 'linked' correctly.


apparently so I'll have to create a customizable layout, right?

 

[troester]

Try with

Display mode = merge rows (not "and reduce...")

Set correct list ordering
1st order by = some unique field of your main table (e.g. id)
2nd order by = the element of your "mother" table you did the "group by" on
3rd order by = Nome Produto

 

[germanoalves]

It worked @troester !

Thanks! ^^