[Vuyisanani]

Good day

Can someone help me to populate a data in a dyanform field.
I have a variable named external_ref with the following query below:
SELECT DISTINCT EXTERNAL_REF, EXTERNAL_REF FROM `PMT_OUTLET` WHERE EXTERNAL_REF = @@external_ref
PMT_OUTLET is the table in the database and has all the variables and gets the data from the CSV file with headings exactly matching the variables.

Thank you in advance.

Best regards
Vuyisanani

[amosbatto]

For some reason ProcessMaker has problems with ` (back ticks).
Try it this way:
SELECT DISTINCT EXTERNAL_REF, EXTERNAL_REF FROM PMT_OUTLET WHERE EXTERNAL_REF = @@external_ref

[Vuyisanani]

Hi @amosbatto

Thank you so much, it all worked Just fine.

Thank you once again.

Best Regards
Vuyisanani