None of my tags are being connected to get order data

I am trying to create a flow to get all orders from my sales force into a google sheet. Each salesperson has their own tag but every time I run the report, I get condition was false. I just created a new tag “test” to use and that came up negative as well.

Here is the query I am using:

created_at:<=‘{{ scheduledAt }}’ AND created_at:>‘{{ scheduledAt | date_minus: “1 week” }}’ AND channel:web AND tag:‘Test’

Thanks!

1 Like

@David-MedSpas

It looks like your query might be missing some elements or have a syntax issue. Try adjusting your query to ensure proper tag usage and correct syntax:

created_at:<=‘{{ scheduledAt }}’ AND created_at:>‘{{ scheduledAt | date_minus: “1 week” }}’ AND channel:web AND tag:Test

Make sure that “Test” matches exactly with the tags used in Salesforce and that tags are properly formatted. If issues persist, double-check the Salesforce tag settings and consult the documentation for any additional query requirements.

What I usually do is copy that query line and paste it into a log action. Then in the flow run you can see the exact query that it’s using and you can paste that into a graphql client to troubleshoot. Nothing looks off to me in that query but usually if you copy paste the exact thing into graphql you can figure out what the issue is.