db join filter current user

[prophoto]

Updated. Now to say this again.....I have the dbjoin working fine (/calendar/new-calendar-item.html) and it is filtering properly after acl changes BUT other functions are screwed up after I had to remove managers and superadmins from the registered group. I put the Registered access level back the way it belongs and created a new one that only has registered group selected. Bottom line the db join is working fine, but this is only 50% done.

Whole story:
1. calendar list has a db join & should lookup title field in guide list - done
2. registered users should only be able to choose only THEIR guide listing - done
3. admins should be able to choose ANY guide listing in this same db join field - done
4. on the CALENDAR RECORD DETAILS page this dbjoin should display the GUIDE TITLE from the selected record with A LINK to the DETAILS page of the GUIDE LISTING the TITLE belongs to

 

[prophoto]

bump, data has already been filled out you responded in another thread

 

[cheesegrits]

As mentioned on another thread, the login details in your My Sites do not work:

"Username and password do not match or you do not have an account yet."

I'm copying and pasting the password directly from your sites info.

-- hugh

 

[prophoto]

bump, info has been updated and is working.

 

[prophoto]

bump

 

[prophoto]

I tested it twice the other day.

 

[prophoto]

bump

 

[prophoto]

4th bump!!!!!

 

[rob]

this should be fixed with this commit https://github.com/Fabrik/fabrik/commits/joomla3
The bug was that as the dbjoin is rendered as a multi-select list, we were building the details link with the x-ref lists id, where as it should be the final target table's record id.

 

[prophoto]

Just updated from git, working fine except for multiple url issue, starting a new thread for that bug. Thanks.

 

[prophoto]

For some reason (might have been me screwing it up) this stopped working on the list view page but is fine on the details page...

 

[prophoto]

bump

 

[rob]

ah yes it was never coded to work in the list view, I've had a go at fixing that here:
https://github.com/Fabrik/fabrik/commit/ed18bbd6bda72819de16190e7012d179208f3a13
Also it should fix the URL's when viewing them in the administration pages

 

[prophoto]

That helps, now if we can get it to use the proper sef url it would be perfect.

 

[prophoto]

bump