Forum | Appery.io

I have a server code that query a collection. That collection has two pointers inside.

When I run the collection.query with my filter, I get back the collection data, but I don ́t receive the other fields from columns inside the pointer (I just receive the pointer tb name and pointer ID for that pointer).

Is that an additional parameters to include related objects (from those pointers) to return them at same query response?

Hello Ricardo,

Please set a list of collection for including to the parameter "include":
https://devcenter.appery.io/documenta...

Hi!

Seems I ́m doing something wrong on the syntax. Could you please take a look to ensure if it is correct?

var receiveObject = Collection.retrieveObject(dbId, "myTb1", id, include["myTb2"]);

I ́m receiving error " SyntaxError: Unexpected token" when I add include["myTb2"]

You are right, please use:
prevar receiveObject = Collection.retrieveObject(dbId, "myTb1", id, "myTb2"); /pre

instead of:
prevar receiveObject = Collection.retrieveObject(dbId, "myTb1", id, include["myTb2"]); /pre

parameter include should be a string

oh! Got that! In the example, myTb2 is the name of the column at myTb1 that has the pointer to the related object. Also below an example to retrieve more than one column/object:

pre
var receiveObject = Collection.retrieveObject(dbId, "myTb1", id, "ColumnThatHasThePointerToMyTb2, ColumnThatHasThePointerToMyTb3"); /pre

Thank you!