n1ql UNNEST query over couchbase lite

50 views
Skip to first unread message

djougue basso

unread,
Jun 14, 2018, 11:02:38 PM6/14/18
to Couchbase Mobile
hi,
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.
Reply all
Reply to author
Forward
0 new messages