marcq
Member
Hi,
I have created a Form with a databasejoin Element (checkbox layout) in order to list records from a repeated group table (gprh_fabrik_user_enrollment_repeat_choix_formation).
I'm trying now to display only the records that has been checked previously (databasejoin Element : gprh_fabrik_user_enrollment___choix_formation) when I'm editing the form.
I need to retrieve (display) only the records from the gprh_fabrik_user_enrollment_repeat_choix_formation .parent_id which are equal to the form Id (gprh_fabrik_user_enrollment___id).
I have read carefully the "Database join element" wiki and tried to add a where clause in the "Data - where" tab field, but I where unable to succeed. Example :
WHERE gprh_fabrik_user_enrollment_repeat_choix_formation.parent_id = {thistable}.id
id = 4 and I have two records with parent_id = 4 in the gprh_fabrik_user_enrollment_repeat_choix_formation table.
I'll get one record displayed, but I should get two, since two record has been checked previously.
Would appreciate if someone could explain me how to do it.
Thanks in advance,
Marc
I have created a Form with a databasejoin Element (checkbox layout) in order to list records from a repeated group table (gprh_fabrik_user_enrollment_repeat_choix_formation).
I'm trying now to display only the records that has been checked previously (databasejoin Element : gprh_fabrik_user_enrollment___choix_formation) when I'm editing the form.
I need to retrieve (display) only the records from the gprh_fabrik_user_enrollment_repeat_choix_formation .parent_id which are equal to the form Id (gprh_fabrik_user_enrollment___id).
I have read carefully the "Database join element" wiki and tried to add a where clause in the "Data - where" tab field, but I where unable to succeed. Example :
WHERE gprh_fabrik_user_enrollment_repeat_choix_formation.parent_id = {thistable}.id
id = 4 and I have two records with parent_id = 4 in the gprh_fabrik_user_enrollment_repeat_choix_formation table.
I'll get one record displayed, but I should get two, since two record has been checked previously.
Would appreciate if someone could explain me how to do it.
Thanks in advance,
Marc