Left / Inner Join with multiple

15 views
Skip to first unread message

Proximate

unread,
Dec 1, 2020, 2:04:22 AM12/1/20
to Joomla Component Builder
Hi at all
For a project i need to load all items that are relatied to a group. The Initial view / get is the getgroup get. Here i have a field called users where all related users are linked to. The field itself is a default Multiple selection that stores its data as '{"0":"3","1":"2"}', so now before i can join those values i need them to be decoded. So i need a "json_decode($data->users,1)" that the inner join is working - when i am not doing this the Join is not working because the function JCB creates for joining awaits an array (which is correct) but i cannot see how i am able to bring my data into the correct format...

anyone have an idea about this? 

kind regards
Marco

((ewe))yn

unread,
Dec 19, 2020, 4:47:10 PM12/19/20
to Joomla Component Builder, Proximate

We are moving to GitHub Discussions. We will keep this open to give access to old issues, resolved. But please continue conversations on the new github discussions area ;)
Reply all
Reply to author
Forward
0 new messages