[Leenomeedo]

Firstly I appreciate the support I found in this Fourm thank you to all who help and support me.
I followed the post here viewtopic.php?t=709602
viewtopic.php?t=709602
Not solved my problem
1- I have external database and connected to my process in dynaform I have id and name I just want when type the ID the name automatically fill .
2- I create the trigger bellow
$db='5095676575b30905c0bec46079475259';
$id=@@id;
$name=@@name;
$sql="SELECT BRANCH_CODE FROM CUSTOMERS WHERE ID_NO = @@id";
@@name = executeQuery($sql, $db);
put the trigger after Dynafourm
3- I test out the forum nothing happened
4- I repeated the same scenario but using PM database locally its working
What my mistake?

[amosbatto]

Have you tried using a Dependent Field query like this?
SELECT BRANCH_CODE, BRANCH_CODE FROM CUSTOMERS WHERE ID_NO = @@id
It is much easier than using a trigger.

If you really want to use a trigger, then your code should be something like this:

Code: Select all

@@name = '';
$db='5095676575b30905c0bec46079475259';
$id=@@id;
$sql="SELECT BRANCH_CODE FROM CUSTOMERS WHERE ID_NO = '$id'";
$aResult = executeQuery($sql, $db);
if (!empty($aResult)) {
    @@name = $aResult[1]['BRANCH_CODE'];
}

This will only work if this trigger is fired before the Dynaform. If you want @@id to be set by the same dynaform where you display the @@name, then you will have to use PMFRedirectToStep() to return to the Dynaform. See this example of redirection in triggers:
http://wiki.processmaker.com/3.0/Submit ... n_triggers

[Leenomeedo]

Yes I have used it but it was not working. I ts working when I used internal Database in Mysql DB (DM).

Have you tried using a Dependent Field query like this?
SELECT BRANCH_CODE, BRANCH_CODE FROM CUSTOMERS WHERE ID_NO = @@id
It is much easier than using a trigger.

If you really want to use a trigger, then your code should be something like this:

Code: Select all

@@name = '';
$db='5095676575b30905c0bec46079475259';
$id=@@id;
$sql="SELECT BRANCH_CODE FROM CUSTOMERS WHERE ID_NO = '$id'";
$aResult = executeQuery($sql, $db);
if (!empty($aResult)) {
    @@name = $aResult[1]['BRANCH_CODE'];
}

This will only work if this trigger is fired before the Dynaform. If you want @@id to be set by the same dynaform where you display the @@name, then you will have to use PMFRedirectToStep() to return to the Dynaform. See this example of redirection in triggers:
http://wiki.processmaker.com/3.0/Submit ... n_triggers

[amosbatto]

Have you tried it without the dependent field relationship?
SELECT BRANCH_CODE, BRANCH_CODE FROM CUSTOMERS
If it doesn't work that way, then your database connection is bad or your field names are wrong.

[Leenomeedo]

I double checked and created a new MYSQL database and connected to processmaker then by using dependent fileds i typed (SELECT BRANCH_NAME FROM CUSTOMERS WHERE BRANCH_CODE=@id) I am relay confused find snapshot attached

Have you tried using a Dependent Field query like this?
SELECT BRANCH_CODE, BRANCH_CODE FROM CUSTOMERS WHERE ID_NO = @@id
It is much easier than using a trigger.

If you really want to use a trigger, then your code should be something like this:

Code: Select all

@@name = '';
$db='5095676575b30905c0bec46079475259';
$id=@@id;
$sql="SELECT BRANCH_CODE FROM CUSTOMERS WHERE ID_NO = '$id'";
$aResult = executeQuery($sql, $db);
if (!empty($aResult)) {
    @@name = $aResult[1]['BRANCH_CODE'];
}

This will only work if this trigger is fired before the Dynaform. If you want @@id to be set by the same dynaform where you display the @@name, then you will have to use PMFRedirectToStep() to return to the Dynaform. See this example of redirection in triggers:
http://wiki.processmaker.com/3.0/Submit ... n_triggers

[amosbatto]

The only think I see is that your BRANCH_CODE field is an integer, so your query should be:
SELECT BRANCH_NAME FROM CUSTOMERS WHERE BRANCH_CODE=@#id

Check whether the ID of the field is spelled "id" and the field has a variable named "id".

Have you tried it without the dependent field relationship?
SELECT BRANCH_CODE, BRANCH_CODE FROM CUSTOMERS

Can you answer this question?

[Leenomeedo]

Great You are exactly right its working now I appreciate your help thank you

The only think I see is that your BRANCH_CODE field is an integer, so your query should be:
SELECT BRANCH_NAME FROM CUSTOMERS WHERE BRANCH_CODE=@#id

Check whether the ID of the field is spelled "id" and the field has a variable named "id".

Have you tried it without the dependent field relationship?
SELECT BRANCH_CODE, BRANCH_CODE FROM CUSTOMERS

Can you answer this question?