This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a workflow that queries finance data. For data that is 6 months old or younger, I want to get the line item detail. For data that is older, I don't need that much detail. To make this work, I am performing 2 queries, and then unioning the data together. I am using dynamic input to build the query.
As you can see in my workflow below, I start with a datetime input. Then, I calculate 6 months backward. Then I calculate the month end for whatever that date is. That month end date is what I want to feed into the dynamic input.
HEre is the query used as the template.I have circled the bits that I want to replace.
When, I have only one modification setup here, it works, but the data is wrong because it only modifies one of my where clauses. When I add in a second modification, I get an error that says the replacement context "2019-10-31" does not exist in the template. It does exist.
Does anyone know why I can't modify both of the where clauses? Also, I have confirmed that the query used as the template is correct and works.