Questions and discussion about using ProcessMaker 2: user interface, running cases and functionality
Forum rules: Please search to see if a question has already been asked before posting. Please don't ask the same question in multiple forums.
By amform
#793525
HI,
Sorry for the dull question.
But since I migrated to the new version of PM 2.5 from 1.6, some of the stuff that was working smooth before now there not working properly.
So in this case I have a dynaform where a populate a textbox from a trigger(before load dynaform) that works fine, however I have a text box that have a SQL query that doesnt work, and depends on the first text box. For example:
field one @@text1, (populate by a php trigger).Works
field two @@text2, that is populate buy a sql like this one:
SELECT NAME FROM database1 WHERE LASTNAME = @@text1.
My question why is not working if it was working fine before?
if I put a string in there the query will work but with the variable @@text1 doesn't.
Thanks for the help
Regards
Attachments
SQL_dynaform.PNG
SQL_dynaform.PNG (12.73 KiB) Viewed 3660 times
User avatar
By amosbatto
#793526
You have to go to the properties of your text1 field and under the "Dependent Fields" property, select your second textbox to indicate that it is a dependent field. Then you SQL query should work.

Get an instant solution to move emails to MBOX for[…]

Most Demanding OST to PST Converter

The most demanding OST to PST Converter is TrijaT[…]

Betvisa clone scripts are pre-built software solut[…]

A Bet365 Clone Script is essentially a ready-made […]