Hello,
I want to show some Jomsocial custom fields on a form.
The query looks like: "SELECT (value) FROM # __community_fields_values WHERE field_id = {$ fieldID} && user_id = {$ userId}";
Where fieldID and userId are the variables.
With the userId no problem, because I can filter the user via the WHERE clause of DB Record Loader action.
But do not know how filter out one record for each form field.
What field type should I use on the form to add the variable fieldID?
Is there any way to do this?
I want to show some Jomsocial custom fields on a form.
The query looks like: "SELECT (value) FROM # __community_fields_values WHERE field_id = {$ fieldID} && user_id = {$ userId}";
Where fieldID and userId are the variables.
With the userId no problem, because I can filter the user via the WHERE clause of DB Record Loader action.
But do not know how filter out one record for each form field.
What field type should I use on the form to add the variable fieldID?
Is there any way to do this?
Hi edurichard,
Sorry but there's something important missing from your post - when I read it I can't make sense of it. The obvious answer is - anything that returns the correct value of $fieldID.
Bob
Sorry but there's something important missing from your post - when I read it I can't make sense of it. The obvious answer is - anything that returns the correct value of $fieldID.
Bob
Sorry, but I found the solution!
Thanks!
Thanks!
This topic is locked and no more replies can be posted.
