Getting the value names from query activity to javascript node | Community
Skip to main content
New Participant
June 5, 2020
Solved

Getting the value names from query activity to javascript node

  • June 5, 2020
  • 1 reply
  • 2611 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_
_Manoj_Kumar_Accepted solution
New Participant
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     Find me on LinkedIn