I’m using ML8. I have a bunch of json documents in the database. Some documents have a certain property “summaryData”, something like:
{
...(other stuff)...
summaryData: {
count: 100,
total: 10000,
summaryDate: (date value)
}
}
However, not all documents have this property. I’d like to construct an SJS query to retrieve those documents that don’t have this property defined. If it was SQL, I guess the equivalent would be something like “WHERE summaryData IS NULL”
I wasn’t sure what to search for in the docs. Any advise would be helpful.