What are the variables of an instance? | Community
Skip to main content
G
god_prophet
Level 6
July 25, 2024
Solved

What are the variables of an instance?

  • July 25, 2024
  • 3 replies
  • 1183 views

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)))... ^ .


This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Amine_Abedour

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,

 

 

3 replies

G
god_prophetAuthor
Level 6
July 25, 2024

I don't even see DeliveryIN as a column of xtk:workflow

S
SorenDP
Level 4
July 26, 2024

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: 

 

 



Amine_Abedour
Community Advisor
Amine_AbedourCommunity AdvisorAccepted solution
Community Advisor
July 26, 2024

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,

 

 

Amine ABEDOUR
    G
    god_prophetAuthor
    Level 6
    July 26, 2024

    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?

     




    Terms & ConditionsAccessibility statement

    Loading footer...