Filter reference field

Jens_Lehmann · February 13, 2019, 2:59pm

Hi Squidex Support,

I have a schema with reference field and would like to filter for entries with specific id and entries which have no reference set. Is there a way to do this?

Best regards,
Jens Lehmann

Sebastian · February 13, 2019, 3:08pm

Sure, you can do it with

Filter by id

`$filter=data/myReference/iv eq ‘123’

and no refes

$filter=empty(data/myReference/iv) // Coming tomorrow

Jens_Lehmann · February 13, 2019, 3:13pm

I get the following error: An unknown function with name ‘empty’ was found. This may also be a function import or a key lookup on a navigation property, which is not allowed.

$filter=empty(data/myReference/iv) // Coming tomorrow
-> Tomorrow this is available?

Best regards,
Jens Lehmann

Sebastian · February 13, 2019, 3:14pm

Yes, it is already implemented but not deployed yet. I will deploy it tomorrow around 1pm probably.

Jens_Lehmann · February 14, 2019, 3:03pm

Hi Sebastian, is this function already deployed? Best regards, Jens Lehmann

Sebastian · February 14, 2019, 3:14pm

Not yet, I had an unplanned Meeting.

Sebastian · February 15, 2019, 8:55am

Sorry, I had a problem with the build server yesterday. It is deployed now.