Unable to query @refresh metadata

[ItsRobbAllen]

I am trying to set up a subscription that refreshes on a schedule (weekly, monthly, etc).

The subscription is
from "GeneratePaymentRequests" as req where req.@metadata.@refresh == null

What I expect is the refresh deletes the metadata, my generation runs, sets a new refresh tag for the next time it should run, and life goes on.

However, I absolutely cannot query @refresh.

Currently, all the payment request documents do NOT have a refresh tag, but the above query returns 0 results.

If I switch it to
from "GeneratePaymentRequests" as req where req.@metadata.@refresh != null

It returns ALL the requests even though NONE of them have that metadata.

Am I doing something wrong here?

Edit: I am using 5.4.2 and this behavior happens in my local Raven instance (running in Docker) as well as all of our Cloud instances

[ayende]

You need to quote the fields:

from "GeneratePaymentRequests" as req where req.'@metadata'.'@refresh' == null

But your scenario is that you are checking the value of a field that isn't there, you need to use exists():

from "GeneratePaymentRequests" as req where exists(req.'@metadata'.'@refresh')

[ItsRobbAllen]

The single quotes seem to work better, but I need to find documents that DO NOT have a refresh tag.

from "GeneratePaymentRequests" as req where NOT exists(req.'@metadata'.'@refresh') doesn't work, but from "GeneratePaymentRequests" as req where true AND NOT exists(req.'@metadata'.'@refresh') does :/

[ayende]

Yes, the later option is the right way to handle this