I am using the Query Data activity to query a table with the parameters for a specific academic year and userID. (2021 - 2022 would be denoted ad 2122) (Parameter examples: "2122", "123")
When i check the "resultsfound" token in workflow for this activity, the value is "true" even when a record does not exist in the table. The token should have the value "false"
If I query the table directly through SQL, no records are returned. This is correct.
This is messing up my entire workflow because the token is getting the wrong value.
I have triple checked to make sure that the parameters and table being used are correct for both the activity and sql statements.
Any tips?