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?
