$notExists filter having weird behavior
I have a field called description and I wanted to filter out those rows with description as null. I use $notExists. It works for the most case but for some cases. One of the values which is being filtered as notExists true is attached in the text document. Please do let me know if more info is needed for this. Thanks
6 Replies
Hey Raveen, thanks for reaching out.
Can you enable support access to your database so I can try filtering the data and recreating the issue? https://support.xata.io/hc/en-us/articles/16775415603997-Allowing-Support-to-access-your-Workspace
If you have already enabled support access, please share your workspace slug privately via
[email protected]I have enabled the support access now
Thanks Raveen, I'll take a look
Hi @cmck , any luck on this ?
Hi Raveen, still trying to recreate the issue, will try again Monday and hopefully get to the bottom of it. Thanks for bearing with me.
Hey Raveen, still working on this, I can get the
$notExists filter to work well with the brands table but not with products. Still researching.Ok @cmck Thanks for the update, pls let me know once this is fixed. And Hope you are able to reproduce it now