List behavior changed with github update

[Saumier]

Joomla 2.5.4 Fab 3.0.6

I updated to github Fabrik-fabrik-3.0.5-366-g8ba19a4.zip. The last github update prior to the latest one was about 2-3 weeks ago. Prior to the last update, the list in question worked as I expected.

I have a parent list (users)
One child (profile) is left-joined to users 1 to 1
Another list (payments) is left-joined to users 1 to many

Prior to latest github update, all users displayed in list with profile data and any payments. This is the way I think it should work.

After github update, only users with payments display in list. This is not good.

 

[cheesegrits]

Do you have "merge rows" selected for the list joins?

I think we introduced an issue with that a week or so ago, I've been trying to track down.

If so, can you turn off 'merge rows', and see if all your records start showing?

-- hugh

 

[Fred04]

this issue looks similar to the one I described a few weeks ago in this thread:

Missing records in list with joins

Please confirm if you also use the 'merge row' or 'merge row and reduce data'

 

[Saumier]

Merge rows was on, I changed it to Each row separately and all records do display.

 

[cheesegrits]

I'm working on this one.

I may have to just roll back the change Rob made to the main query creation, which was a fix for searching on joined data, and work on that stuff in a separate branch of the code.

-- hugh

 

[cheesegrits]

Rob is working on this one as I type. Hopefully should have a fix by the time you read this.

-- hugh

 

[rob]

this should be fixed now it github, could people update to test please?

 

[Fred04]

looks ok to me, I see all me records
thank you Rob for fixing it

 

[cheesegrits]

Looks good for me too. Both "merge rows" and "merge rows and reduce data" modes are working as expected.

-- hugh

 

[Saumier]

Merge rows and merge and reduce data both work now after github Fabrik-fabrik-3.0.5-474-g8b2ec8d.zip.

I sure hate to be the fly in the soup, but after this github install, if I do an edit to a record, one field (label = testrecord) is being cleared that was set to a 0 or 1. I do a pre-filter on this field to display the membership list. This has always worked until now. What broke the pre-filter was the testrecord field being cleared.

A better explanation:
user tbl; key = id
profile tbl; key = pid; left join to user tbl id to pid
(testrecord is an element in profile tbl)
payment tbl; key = rid; left join to user tbl id to rid

I have a list where I can select a record to edit, I changed the email address in the user tbl, save, and testrecord element in profile tbl is cleared.