Skip to main content
R
Ramaswami
Level 4
June 5, 2020
Solved

Getting the value names from query activity to javascript node

  • June 5, 2020
  • 1 reply
  • 2614 views

Hi Team, 

 

i have a query activity and i need to get the values of query into javascript variables. 

 

 

This is my workflow : 

 

i need to get the event date values that is 1st may and 32st may to javascrpt variables like 

 

vars.fromDate = vars.Getfromquery

 

    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 Manoj_Kumar

    Hello @ramaswami ,

    For this use case, Instead of directly hardcoding the date in query activity you can use a javascript activity in the start to initialize the variables.

    Like This:

     

    Then you can call these variables in the query activity like this:

     

     

    and then finally call the same variable in the second javascript activity to get the values like this:

     

     

    And this is how the complete workflow will look like:

     

     

    Let me know if that helps

     

    1 reply

    Manoj_Kumar
    Community Advisor
    Manoj_KumarCommunity AdvisorAccepted solution
    Community Advisor
    June 5, 2020

    Hello @ramaswami ,

    For this use case, Instead of directly hardcoding the date in query activity you can use a javascript activity in the start to initialize the variables.

    Like This:

     

    Then you can call these variables in the query activity like this:

     

     

    and then finally call the same variable in the second javascript activity to get the values like this:

     

     

    And this is how the complete workflow will look like:

     

     

    Let me know if that helps

     

    Manoj  | https://themartech.pro
      Terms & ConditionsAccessibility statement

      Loading footer...