How to create Index to find null values of fields(myField:null)?

Help
1

I have order collection with many fields. When I run allOrders index(list of all orders) with some fields I get following result.

2021_03_04_0nz_Kleki
2021_03_04_0nz_Kleki1506×669 49.8 KB

Now I want to find how many orders are there with null value of myField, so I am creating index

CreateIndex({
   name: "findbyMyField",
   source: Collection("Order"),
     terms: [
    { field: ["data", "myField"]}
    ]
    })

but above index doesnot return any data when called by

q.Paginate(q.Match(q.Index("findbyMyField"), null))

How to get documents with null values of given field?

2

Use Index binding.