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 3661 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.

The market for cryptocurrencies is demonstrating a[…]

What's SAP FICO?

Embarking on a dissertation can be one of the most[…]

Hello. For rental housing, there are software solu[…]

Experience heightened pleasure with Cenforce 100 M[…]