MarkLogic - JavaScript node.js Client API - QueryBuilder - Join between collections -
say have 2 collections this:
// city collection <city> <id>1</id> <name>tulsa</name> <stateid>1></stateid> </city> // state collection <state> <id>1</id> <name>oklahoma</name> </state>
now want return list of cities state name instead of stateid. how can join efficiently, using node.js client api , query builder?
an efficient join can't performed using node.js api. best way approach this, if possible, denormalize content documents contain information need query or return.
<city> <id>1</id> <name>tulsa</name> <stateid>1></stateid> <state-name>oklahoma</state-name> </city>
Comments
Post a Comment