IF MISSING Index not updating

SQL++
, ,
1

Hi
I have got the below index created to find count documents where versionId is missing, however even after the documents are updated with value of versionId the number of documents returned are same.
Can someone help me out where I am doing this incorrectly?
CREATE INDEX idx_01
ON promotions(entity.endDateTime)
PARTITION BY HASH(aggregateId)
WHERE _class IN [‘XXXX’,‘YYYY’]
AND versionId IS MISSING using GSI with {‘num_replica’:1,‘num_partition’:6};

Query:

SELECT count(*) FROM promotions WHERE
_class IN [‘XXXX’, ‘YYYY’]
AND versionId IS MISSING AND entity.endDateTime>NOW_MILLIS()

Regards,
Venkat

2

Use 6.5.1 Known issue with Partition and Partial index 6.0.x

3

It worked thanks. But it’s working for all of our indexes, except this one.