-
Type: Bug
-
Status: Resolved
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: 9.2
-
Fix Version/s: 9.3
-
Component/s: Core MongoDB
-
Backlog priority:700
-
Sprint:nxcore 9.3.10
-
Story Points:5
When searching for multi-valued complex properties using NXQL (in JSF UI Search tab), the resulting MongoDB query is not returning the expected results.
Steps to reproduce:
- Create data model with each field in the complex field being a multi-valued string.
Example: Complex Multi-Valued Field: Vehicle. Sub Fields: Make & Year - both multi-valued string fields - One document has 2 vehicles - 1st: 2008, Chevy; 2nd: 2010, Ford
- Example NXQL Search (should not return document above):
`SELECT * FROM HotlineArchive WHERE ecm:path STARTSWITH '/default-domain/vehicleTestHotlineArchiveContainer' AND (vehicleList:vehicles/*1/make/* = 'Ford' OR vehicleList:vehicles/*1/make/* IS NULL) AND (vehicleList:vehicles/*1/year/* = '2008' OR vehicleList:vehicles/*1/year/* IS NULL)"`
- Translated Mongo search (returns document - not desired):
`{ "$and" : [ { "ecm:primaryType" : "HotlineArchive"} , { "ecm:ancestorIds" : "427b9e7d-226c-4ae2-8e31-cb320756d709"} , { "$or" : [ { "vehicleList:vehicles.make" : "Ford"} , { "vehicleList:vehicles.make" : null }]} , { "$or" : [ { "vehicleList:vehicles.year" : "2008"} , { "vehicleList:vehicles.year" : null }]}]}`
- is required by
-
NXP-23823 Fix ecm:tag queries on DBS
- Resolved