Skip to content

Retrieval with Relation Depth

The Data Service API supports a mechanism for loading related objects without identifying each by its name. Instead, the API includes a parameter which specifies the "depth" of the relations to include into the response. Consider the following diagram:

relation-depth

The diagram shows a hierarchy for class structure - the Order class has two relations: with OrderItem and Customer classes. Each in turn has a relation to the Manufacturer and Address classes. When an instance or a collection of Order objects is retrieved from Backendless, the API may include a parameter specifying the depth of relations to include into the response. If the relation depth is 1, then all related instances of OrderItem and Customer will be included into each Order object. If the relation depth is 2, then not only OrderItem and Customer instances will be included, but the corresponding Manufacturer and Address objects as well.

Important

Loading relations with relation depth retrieves only a partial set of the related objects (default size of the retrieved related collection is 10). To load additional related objects, use the Relation Paging API .

API methods supporting relations depth

For the methods which accept the DataQueryBuilder argument, the relation depth must be set using the SetRelationDepth method on the query builder object:SwiftSDK.framework

Blocking API

Dictionary<String, Object> Backendless.Data.Of( "TABLE-NAME" ).FindById( string id, int relationsDepth );
Dictionary<String, Object> Backendless.Data.Of( "TABLE-NAME" ).FindById( string id, 
                                                                            IList<string> relations, 
                                                                            int relationsDepth );

// Set the relation depth on the QueryBuilder instance using the SetRelationDepth method
Dictionary<String, Object> Backendless.Data.Of( "TABLE-NAME" ).FindFirst( DataQueryBuilder queryBuilder );
Dictionary<String, Object> Backendless.Data.Of( "TABLE-NAME" ).FindLast( DataQueryBuilder queryBuilder );
IList<Dictionary<String, Object>> Backendless.Data.Of( "TABLE-NAME" ).Find( DataQueryBuilder queryBuilder );
Task<T> Backendless.Data.Of<T>().FindByIdAsync( string id, int relationsDepth );
Task<T> Backendless.Data.Of<T>().FindByIdAsync( string id, 
                                                      IList<string> relations, 
                                                      int relationsDepth );

// Set the relation depth on the QueryBuilder instance using the SetRelationDepth method
Task<T> Backendless.Data.Of<T>().FindFirstAsync( DataQueryBuilder queryBuilder );
Task<T> Backendless.Data.Of<T>().FindLastAsync( DataQueryBuilder queryBuilder );
Task<IList<T>> Backendless.Data.Of<T>().FindAsync( DataQueryBuilder queryBuilder );

Non-Blocking API

Dictionary<String, Object> Backendless.Data.Of( "TABLE-NAME" ) FindById( string id, int relationsDepth );
Dictionary<String, Object> Backendless.Data.Of( "TABLE-NAME" ) FindById( string id, 
                                                                            IList<string> relations, 
                                                                            int relationsDepth );

// Set the relation depth on the QueryBuilder instance using the SetRelationDepth method
Dictionary<String, Object> Backendless.Data.Of( "TABLE-NAME" ).FindFirst( DataQueryBuilder queryBuilder );
Dictionary<String, Object> Backendless.Data.Of( "TABLE-NAME" ) FindLast( DataQueryBuilder queryBuilder );
Dictionary<String, Object> Backendless.Data.Of( "TABLE-NAME" ) Find( DataQueryBuilder queryBuilder );

Prepare LoadRelationsQueryBuilder:

var loadRelationsQueryBuilder = LoadRelationsQueryBuilder<BackendlessUser>.Create();
loadRelationsQueryBuilder.SetRelationName( "friends" );
Blocking call:
String parentObjectId = ""; // removed for brevity
var friends = Backendless.Data.Of<Person>().LoadRelations( parentObjectId, 
                                                           loadRelationsQueryBuilder );
foreach( var friend in friends )
  System.Console.WriteLine( friend.Email );
Non-blocking call:
String parentObjectId = ""; // removed for brevity
var task = Backendless.Data.Of<Person>().LoadRelationsAsync( parentObjectId, 
                                                                loadRelationsQueryBuilder );
task.Wait();
var friends = task.Result;

foreach( var friend in friends )
  System.Console.WriteLine( friend.Email );

Example

var queryBuilder = DataQueryBuilder.Create();
queryBuilder.SetRelationsDepth( 2 );
var invoices = Backendless.Data.Of( "Invoices" ).Find( queryBuilder );

Codeless Reference

Suppose you have set up the hierarchy with the following structure described further:

Data tables hierarchy:

  1. employees - general information about employees.

  2. uniqueSkills - the names of the skills

  3. marketValue - the market value for each skill.

Consider the parent data table called employees.As you probably noticed, the skills column has a relation to the uniqueSkills data table
data_single_step_retrieval_1

The uniqueSkills data table presented below has a relation to another data table called marketValue, all relations leading to this table are referenced in the value column.

data_relations_depth_retrieval_1

The last related data table called marketValue has the following structure:

data_relations_depth_retrieval_2

Every data table described above is related/linked to each other forming an hierarchy.

Before proceeding to the example, let's examine the relation of the parent object called 'Alex Lincoln' that is stored in the employees data table. As you can see, the parent object has only one  relation to the child object.

data_relations_depth_retrieval_5

The example below retrieves all related objects in the hierarchy for the 'Alex Lincoln' parent object. Notice how the parent object is retrieved using the where clause condition: to obtain a specific object you must reference one of the desired columns such as "name" and the exact value in the where clause property; in this case, it is "name = 'Alex Lincoln'".

Furthermore, you have to specify the name of the column containing the relation, in the context of this example it is "skills".

The relations depth property is set to 2, indicating that the third data table is the last in the query.

data_relations_depth_retrieval_3

Important

For a detailed description of all input parameters see the Basic Object Retrieval topic of this guide.

After the Codeless logic runs, the operation returns the parent object 'Alex Lincoln' and all underlying related records from all data tables described above:

data_relations_depth_retrieval_4