Shiv,
The problem is quite simple to solve. The first thing is to determine what
is empty. Mostly empty can be the non-existence of the element and second
an empty element. Simply just add an additional negated
cts.notQuery(cts.propertyValueQuery(...)). This will filter out empty dob
Hi,
How can I skip empty/null values as my dob property has empty ("") string
for some of the documents and below error is giving error XDMP-LEXVAL:
xs.date("") -- Invalid lexical value ""
Query:
cts.search(cts.andQuery([cts.jsonPropertyRangeQuery("dob", '>',