Yes no longer delegative query if we are using "0" in place of false.
Also, from past experience, there will be no answer until the US wakes up.
There is no one on here supporting from Microsoft unless it within US waking hours.
"[myTable]" is under 500 rows, so it is ok until the issue is fixed
All our businesss critical apps are broken where we have a delegated filter to Azure SQL.
Please fix this ASAP!
As a temporary fix I've added the full table to a collection and then applied filters to this.
This involves a bit of code change thought so not suitable for all.
Ours needs to be filtered into a collection, as the master tables are too big. Not much I can do and we have around 30 PAs...
We have the same issue, can't use the workround without changing all our Apps, so everyone gone home for an early Christmas except me while we find out if there will be a solution - not making me feel very festive ......
Does anyone have any update? I have raised a ticket with MS but silence...
Just copying @Mr-Dang-MSFT on this important issue.
This issue should be mitigated. We fixed some configuration changes in Sql connector. Please try again and let us know if the issue persists.
Checked 2 apps so far and looks to be fixed.