Kammasood
Forms Fledgling

Query list with Created column

Jump to solution

HI Everyone, 

I am working on a simple site workflow where I am trying to use query list action to bring back all Work Order number that are null and created date is in the past 7 days but if i try to use Work Order number is null, it bring back results but as soon as i introduce Created column it brings back nothing. I am using date calculator field to calculate date.  

 

please advise?

 

Kammasood_0-1619914546736.png

 

Kammasood_1-1619914605534.png

Kammasood_3-1619914794528.png

 

Thanks in advance,

Kamra

Kammasood_2-1619914732071.png

 

 

Tags (2)
0 Kudos
Reply
2 Replies
Tarf
Design Canvas Artiste

Re: Query list with Created column

Jump to solution

Hi @Kammasood,

 

to me this looks all good. Have you tried running your workflow?

When you test your queries, variables are shown as {WorkflowVariable:YourVarName}. These are replaced with the value of the variable when the workflow is executed. For testing purpose you can replace {WorkflowVariable:...} in the Run Now Menu with actual values.
Since the first condition is hardcoded (Column WO No. is empty) you can test this in without problems. 

I´d suggest running the workflow once and let it send you an email with the result of the query.

View solution in original post

0 Kudos
Reply
Kammasood
Forms Fledgling

Re: Query list with Created column

Jump to solution
Great stuff mate. it worked when i actually run it.
0 Kudos
Reply