+3HI 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?
Thanks in advance,
Kamra
Best answer by Tarf
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.
+8Hi @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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.