i would like to perform the following request under couchbase lite java application.
"SELECT PersonnelParcours FROM `minesec-recensement`as PersonnelParcours UNNEST parcours AS parcoursItem where PersonnelParcours.type=\"personnel\" AND parcoursItem.posteActuel =true AND parcoursItem.structureId=$structureId";
my main problem is that i don't see any way to formulate such request including UNNEST statement. The only option that i see is to use QueryBuilder.select()... but it isn't possible to set UNNEST property within such request.
How can i proceed please.