Retrieve data

General
1

Retrieve data

Greetings, I would like to know which is the best form of retrieving data from different tables but related to one especific objectId.

For example, In my table “Publication” I have a relation with car (it’s another table), which also have some media and the media has their own attributes. What I’d like to do is by creating a query or a service retrieve all the information related to one car, and thats include their media and media attribute.

I’m kind of lost in this topic I’ve created the database in backendless by following this model but I don’t know how to achived this.

Any help will be more than welcome. Thanks.

ask.png
ask.png693×609 33.7 KB

2

Hi Fender,

You can query a car by its objectId and specify the relations you want to retrieve in the same request, using either “loadRelations” to specify exact relations or “relationDepth” to specify how many levels of relations you want to retrieve. Please refer to the documentation on this very same topic, it also has a sample code: https://backendless.com/documentation/data/android/data_relations_retrieve.htm