Dynamic index query for null

83 views
Skip to first unread message

Scott Mackay

unread,
Jun 20, 2012, 2:39:15 PM6/20/12
to rav...@googlegroups.com
Wondering if it's possible to use the dynamic index query in the studio to return documents where a field is null

Item { "Id": "Items/1", "MyField": null }
Item { "Id": "Items/1", "MyField": 123 } 


The Query syntax

MyField: null

does not return anything and I haven't managed to get a range to work yet?

Thanks
Scott.


Oren Eini (Ayende Rahien)

unread,
Jun 20, 2012, 3:22:16 PM6/20/12
to rav...@googlegroups.com
MyField:[[NULL_VALUE]]

Would return that 

Scott Mackay

unread,
Jun 20, 2012, 3:29:25 PM6/20/12
to rav...@googlegroups.com
Perfect, Thanks Oren.


On Wednesday, 20 June 2012 20:22:16 UTC+1, Oren Eini wrote:
MyField:[[NULL_VALUE]]

Would return that 
Reply all
Reply to author
Forward
0 new messages