Multiple Join

[Fred04]

quick question: does Fabrik support the following type of database structure:

TableA 1:N TableB
TableB 1:N TableC

With Table A,B and C having database join elements?
I'm asking because I have a hard time to display the right records in my details view.

 

[pkjoshi]

All kinds of joins is possible in Fabrik. You place an example here exactly what you want to display and how you are trying to achieve it. At Fabrik there are many nice guys including the moderators who are ready to help.

 

[Ajyamal]

hi,

Are u going to show one view which is including all element ?

 

[Fred04]

it seems my database was completely messed up, it created SQL error about element not assigned to the right list. I reset everything and recreated a simple test scenario.

The structure is the following and it works well so far except some cosmetics issues:

list1 1:1 list2
list1 1:N list3

In the list view we have information from list1 and list2

problems:
- the way product2 (databasejoin) is displayed is not the same as info2
- how can I really merge all the data in the list view?
- in the form, the date element does not read what is in the database

Here is the website: Test site

 

[pkjoshi]

if you have created the joins in the list, there is an option under heading display mode - where you can select merge rows.

 

[Fred04]

the option 'merge row' is active... but does not really work on all elements..

 

[Fred04]

any idea on these issues?
here is the test site: Test Site