How to retrieve pointer data (related objects) in a query at server code?

[Ricardo Amaral]

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?

[Serhii Kulibaba]

Hello Ricardo,

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

[Ricardo Amaral]

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"]

[Serhii Kulibaba]

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

[Ricardo Amaral]

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!