Documentum REST 7.3- Using OR operator in AQL

I am using AQL (Documentum REST 7.3) to do an xplore search against the repository.

With the below AQL send as an input to the search service (POST), I get 9 results –

{ "all-versions": false, "include-hidden-objects": false, "types": [ "my_type" ], "columns": [ "object_name", "r_creation_date", "r_creator_name" ], "sorts": [ { "property": "object_name", "ascending": true } ], "repositories": [ "corp" ], "expression-set": { "expression-type": "expression-set", "operator": "AND", "expressions": [ { "expression-type": "fulltext", "value": "opentext", "fuzzy": false } ] }}

If I were to AND another attribute (email_from) in the AQL, the result count reduces to 1.

{ "all-versions": false, "include-hidden-objects": false, "types": [ "my_type" ], "columns": [ "object_name", "r_creation_date", "r_creator_name" ], "sorts": [ { "property": "object_name", "ascending": false } ], "repositories": [ "corp" ], "expression-set": { "expression-type": "expression-set", "operator": "AND", "expressions": [ { "expression-type": "fulltext", "value": "opentext", "fuzzy": false }, { "expression-type": "expression-set", "operator": "AND", "expressions": [ { "expression-type": "property", "name": "email_from", "operator": "CONTAINS", "value": "abc", "exact-match": false, "repeating": false, "case-sensitive": false, "fuzzy": false } ] } ] }}

So far, everything is as expected. However, instead of AND-ing the additional attribute (email_from), if I were to do an OR, the result count still remains 1.

 "all-versions": false, "include-hidden-objects": false, "types": [ "my_type" ], "columns": [ "object_name", "r_creation_date", "r_creator_name" ], "sorts": [ { "property": "object_name", "ascending": false } ], "repositories": [ "corp" ], "expression-set": { "expression-type": "expression-set", "operator": "AND", "expressions": [ { "expression-type": "fulltext", "value": "opentext", "fuzzy": false }, { "expression-type": "expression-set", "operator": "OR", "expressions": [ { "expression-type": "property", "name": "email_from", "operator": "CONTAINS", "value": "abc", "exact-match": false, "repeating": false, "case-sensitive": false, "fuzzy": false } ] } ] }}

Shouldn’t the result count be 9 or more, since in this AQL my query is to get the documents where either ‘fulltext’ is ‘opentext’ OR ’email_from’ property is ‘abc’? So, the result count shouldn’t be less than the result when querying for ‘fulltext’ as ‘opentext’.

Is AQL not being generated correctly on this scenario?

Related:

Leave a Reply