[marcosfpa]

I have a strange problem:

Script tasks with triggers with external executeQuery do not work. I have script tasks with a trigger that connects with an external database and it doesn't work outside an esuary task like a step before or after a dynaform for example. Here's a piece of the trigger:

$ db = "5762336645d2a0ff2cf1439019917712";
$ sql = "SELECT TYPE CALL AS IDCHAMED, MONTH, YEAR, USERID, USER, COUNT (*) AS QTY FROM U_CALLSWEB WHERE MES = '$ mes' AND YEAR =' $ year 'AND SITUATION =' CLOSED 'AND TYPE CALL =' 6 - PERSONAL VISIT 'GROUP BY TIPOCHAMADO, MONTH, YEAR, USERID, USER ORDER BY USERID ASC ";
$ res = executeQuery ($ sql, $ db);

The strange thing is that this same trigger works normal on a user task as a step, and doesn't work on a script task ...

What can it be? Is it about permissions? User login?

Using PM V3.3.10.

[programerboy]

Hi,

Please check your trigger again:

Code: Select all

$mes = 'YOUR_MES';
$year = 'YOUR_YEAR';
$db = "5762336645d2a0ff2cf1439019917712";
$sql = "
	SELECT TYPE CALL AS IDCHAMED, MONTH, YEAR, USERID, USER, COUNT(*) AS QTY 
	FROM U_CALLSWEB 
	WHERE MES = '$mes' AND YEAR ='$year' AND SITUATION = 'CLOSED' AND 
	TYPE CALL ='6 - PERSONAL VISIT'
	GROUP BY TIPOCHAMADO, MONTH, YEAR, USERID, USER 
	ORDER BY USERID ASC
";
$res = executeQuery($sql, $db);

If you have error with script task, you can set your trigger on your main task on after routing event.

https://pmlearning.info
Thanks

[marcosfpa]

The $ mes and $ year variables exist in my trigger, I just didn't copy here in the post, so that's not it ...
Is this script task right after an intermediate time event, any more ideas?

[marcosfpa]

Could it be related to cron? Permissions in cron?

[marcosfpa]

Help!

[Nikakhtar]

hi,
i have the same problem as you've posted...do you have found the answer??
i know that the resason is that executeQuery is for pmFunctions class and i have tried to include pmFunctions in my external script but still it can not fined executeQuery() in pm from external script...
i will appreciate your help...

[marcosfpa]

Still no answer. I still have the problem ...

[Nikakhtar]

https://forum.processmaker.com/viewtopic.php?f=44&t=737122
the latest post on this topic is the solution, and you can use it to call external script contained executeQuery usages from a trigger...
but my problem is that when I want to run the same external script from another place, not in triggers (i mean when you want to run the external script from another external script not from triggers) I have another error which throws from pmFunctions class on executeQuery() function which says :

PHP Fatal error: Uncaught Error: Call to undefined function config() in C:\Bitnami\processmaker-3.3.2-0\apps\processmaker\htdocs\workflow\engine\classes\class.pmFunctions.php:244

[dhanapal]

The post is very useful to me, thanks for more information shares with me.

[Nikakhtar]

u r welcome...