In the documentation, I see:
The instance variables (instance.vars.xxx) are comparable to global variables. They are shared by all activities.
What are the options for the XXX part? A user is using /@hora .. but I don't see hora as a column of xtk:workflow. That XXX part should be only one of the columns of xtk:workflow, right?
SubMinutes( GetDate() , $(instance/vars/@hora) * 30) // Removing the And condition fixes the workflow.
Also, according to documentation, in oder to use it you have to define it first in an JS activity, and the
But the query activity doesn't have anything defined and the JS "Data" activity,,, doesn't define anything.
The error log is:
07/25/2024 11:49:56 AM b0-42d7-8ff1-b55cfdeb4fcf') AND (P0.tsCreated = SubMinutes(GetDate() , '' * 30))) AND ((P0.iPipelineEventId > 0 OR P0.iPipelineEventId < 0))' could not be executed.
07/25/2024 11:49:56 AM WDB-200001 SQL statement 'INSERT INTO wkf94388735_81019_1 (mData,sCodinternocomputacionalhash,sRUBRO,tsCreated,iId) SELECT DISTINCT P0.mData, NULL, NULL, P0.tsCreated, P0.iPipelineEventId FROM AcxPipelineEvent P0 WHERE ((P0.sTriggerType = E'a80c22d9-97
07/25/2024 11:49:56 AM PGS-220000 PostgreSQL error: ERROR: invalid input syntax for type integer: "" LINE 1: ...4fcf') AND (P0.tsCreated = SubMinutes(GetDate() , '' * 30)))... ^ .
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Hi @god_prophet,
The xxx part in instance.vars.xxx isn't at all a collumn of xtk:workflow.
You should declare it before using it on the workflow.
Exemple of declaring it on a js code activity :
After executing the workflow you can see the variables on the Properties on the workflow here :
To use the variables in other activities of the workflow, please check this documentation Variables
Br,
I don't even see DeliveryIN as a column of xtk:workflow
Views
Replies
Total Likes
Hi @god_prophet
I am pretty sure you wont be able to see the instance variables as part of the columns as such. They sort of exist in the global context of the workflow execution. It is also correct that the instance variables should be defined somewhere in the workflow.
The error looks like either a typing error where the name of the variable is incorrect or a data type error. Would be helpful to see the expression where the variable is used as well as where it is defined in the workflow
For reference, here is a image example of how to use it:
Views
Replies
Total Likes
Hi @god_prophet,
The xxx part in instance.vars.xxx isn't at all a collumn of xtk:workflow.
You should declare it before using it on the workflow.
Exemple of declaring it on a js code activity :
After executing the workflow you can see the variables on the Properties on the workflow here :
To use the variables in other activities of the workflow, please check this documentation Variables
Br,
Hi @Amine_Abedour Thank you.
So, would you say event variables (vars.xxx) and instance variables (instance.vars.xxx) should be place in an JS activity?
While Taks events inside the activity from where you want to use it? So Task events should be place in the Advance tab of a Query activity or...
...in "Properties > Variables" of a delivery?
Views
Replies
Total Likes