Hi,
I am trying to retrieve the ID of the active user in the form (and not the logged on user => $user->id) in a SQL query (dynamic cascade)
SELECT a.id AS value, a.title AS text
FROM #__usergroups AS a
JOIN #__user_usergroup_map AS b ON a.id = b.group_id
WHERE a.parent_id = 11 AND b.user_id = $user->id
$config["pk"] can not be used => Create content dynamiclly using code
then I get it in my request or have to go through a beforeStore ?
Thank you for your ideas :)
Sorry, but this is not clear, how does active user differ from logged in user? User logins are bound to sessions and you can only have one active user per session/app (one for front and one for back end).
Thanks for your feedback.
I work on a form managing data of different individuals (joomla users). When editing a form, I have 2 users: the user who is logged on the current Joomla session and the user (or the user's record) that is being modified. I am trying to retrieve the ID of the user being modified in my sql request.
If you are accessing users from some list than you have article id in the url, you can use $uri->get to get that value from url, than you only need to join #__cck_core table on this id as it hold both, id and pk for each record.
it works with $uri->getValue('id'), thank you :-)