-
New Commercial Services Section
We have now opened a commercial services section here on the forum for registered users. If you have a Fabrik project that you wish to have someone work on for you, post it under Help Wanted. If you are an application developer and wish to earn some money helping others, post your details under Fabrik Application Developers.
Both of these are unmoderated. It will be up to both parties to work out the details and come to an agreement.
-
Joomla 5.1
For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
SOLVED: Possible bug in joined lists
- Thread starter dimoss
- Start date
- Status
dimoss
Well-Known Member
Hi
I saw another post which describes the same problem in:
http://www.fabrikar.com/forums/inde...elationship-deletes-linked-data-on-save.39533
I saw another post which describes the same problem in:
http://www.fabrikar.com/forums/inde...elationship-deletes-linked-data-on-save.39533
cheesegrits
Support Gopher
Can you give us exact details of your set up?
Preferably with screenshots of the join settings, and information on which elements are the PK's on each table.
Also, let us know if you have any pre-filters on the list, and if so, what they are.
-- hugh
Preferably with screenshots of the join settings, and information on which elements are the PK's on each table.
Also, let us know if you have any pre-filters on the list, and if so, what they are.
-- hugh
dimoss
Well-Known Member
Hi Cheesegrits
2 lists joined.
One list is the core Joomla users tables which is left joined to another fabrik created list from jos_users.username (is unique) to fab_dinamologio.am (is unique).
There are 3 simple prefilters in the list which don't affect anything. Even if I remove these prefilters the problem remains.
The PK in the jos_users table is the 'id'.
You can see the screenshots:
Thanks.
2 lists joined.
One list is the core Joomla users tables which is left joined to another fabrik created list from jos_users.username (is unique) to fab_dinamologio.am (is unique).
There are 3 simple prefilters in the list which don't affect anything. Even if I remove these prefilters the problem remains.
The PK in the jos_users table is the 'id'.
You can see the screenshots:
Thanks.
dimoss
Well-Known Member
Hi again
I changed the PK in the jos_users list and instead of jos_users.id I put it the 'jos_users.username' and it seems that was the solution.
But I wonder why is that? Is that mean that the FROM field in the join settings has to be the same with the PK value in the list settings?
Thanks.
I changed the PK in the jos_users list and instead of jos_users.id I put it the 'jos_users.username' and it seems that was the solution.
But I wonder why is that? Is that mean that the FROM field in the join settings has to be the same with the PK value in the list settings?
Thanks.
cheesegrits
Support Gopher
One end of any join in Fabrik has to be the PK of the table. One of those restrictions we'll try and lift one day, but the code grew over years, with the assumption that it would always be an FK -> PK join, and changing that at this point would be, to put it mildly, tough. So really, I doubt it'll ever get changed in 3.x.
Obviously for repeat joins, the "child" has to have the FK, pointing to the PK on the parent.
For one-to-one joins, it can be either way. FK on parent pointing to PK on child, or vice versa.
-- hugh
Obviously for repeat joins, the "child" has to have the FK, pointing to the PK on the parent.
For one-to-one joins, it can be either way. FK on parent pointing to PK on child, or vice versa.
-- hugh
- Status