Xata•6mo ago

Filter not working.

Hello, I am trying to filter with xata.createdAt for a date 2025-01-14T14:19:05.349804Z and it looks to be not working, tried with adding milliseconds too , and also tried with the date selector - dose not work, As seen in screenshot the date in the records in "xata.createdAt" column exists for which filter was applied but no records were found. Is there anything we could do to solve this ? or is this a bug ? Thanks

5 Replies

cmck•6mo ago

Hi there, thanks for reaching out. Can you enable support access to your workspace so I can test this behaviour? I'll take a look and see what's going on. Hi Fanatic, did you enable support access? Please feel free to DM me your workspace ID so we can take a look.

FanaticXOP•6mo ago

Hi sorry didn't check your reply, I have enabled the support access. kindly check.

cmck•6mo ago

No problem, can you please share your workspace ID? I'm afraid I can't find the workspace for the support view without it. You may also need to disable support access and re-enable it to re-send the invite. Apologies for the delay.

FanaticXOP•5mo ago

I have shared it, please check DM

alihammad•2mo ago

same error I don't know how, but it worked now. I updated the cli and client sdk. and this code works:

...
.filter({
          xata_updatedat: {
            $gt: dayjs().subtract(1,                   "minute").toDate(),
          },
        })
...

...
.filter({
          xata_updatedat: {
            $gt: dayjs().subtract(1,                   "minute").toDate(),
          },
        })
...

Gaming

Programming

Filter not working.

Did you find this page helpful?