SQL++ - Assembling and loading user profiles

When a player loads his gameworld the client application needs to load the data from all the collections. This can be accomplished by running a single N1QL query. The query on the right assembles the blobs from all three collections for a user with key "zid-jungle-0001".

If you notice the game-data attribute has a hyphen in its name, and when used in the query it needs to be escaped with a backtick character, `game-data`.

To run this example, click the button in the top right corner of the code editor.

Code Editor

Output