Add Relation with condition¶
This API request adds related objects to the existing collection. Child objects to add to the relation are defined through a whereClause condition.
Blocking API¶
int result = Backendless.Data.Of( "TABLE-NAME" ).AddRelation(
Dictionary<string, object> parentObject,
string relationColumnName,
string whereClause );
int result = Backendless.Data.Of<E>().AddRelation(
E parentObject,
string relationColumnName,
string whereClause );
Non-Blocking API¶
Backendless.Data.Of( "TABLE-NAME" ).AddRelation(
Dictionary<string, object> parentObject,
string relationColumnName,
string whereClause,
AsyncCallback<int> callback );
Backendless.Data.Of<E>().AddRelation(
E parentObject,
string relationColumnName,
string whereClause,
AsyncCallback;<int> callback );
where:
Argument | Description |
---|---|
TABLE-NAME |
Name of the table where the parent object is stored. |
E |
parent's object .NET class. The class name identifies the table where the parent object is stored. |
parentObject |
The object which will be assigned related children for relatedColumnName . When this argument is an instance of System.Collections.Generic.Dictionary (for the dictionary-based approach), it must contain the "objectId" property. |
relationColumnName |
Name of the column identifying the relation. Objects from the children collection will be added as related for the column in parentObject . The column name may optionally include table name separated by the colon character as well as cardinality which determines the type of relationship (one to one or one to many) (see the note below): |
Important
If the column does not exist in the parent table at the time when the API is called, the value of the "relationColumnName
" argument must include the name of the child table separated by colon and the cardinality notation. The cardinality is expressed as ":1
" for one-to-one relations and ":n
" for one-to-many relations. For example, the value of "myOrder:Order:1
" will create a one-to-one relation column "myOrder
" in the parent table. The column will point to the Order
child table. Likewise, the value of "myOrder:Order:n
" will create a one-to-many relation column "myOrder
" pointing to the Order
table.
Argument | Description |
---|---|
whereClause |
a where clause condition identifying objects in the child table which will be added as related objects to the parent object. |
callback |
a responder object which will receive a callback when the related objects have been added or if an error occurs. Applies to the non-blocking method only. |
Return Value¶
Number of child objects added to the relation. The blocking call receives the return value through a callback executed on the AsyncCallback
object.
Example¶
The following request adds objects from the Users
table to a related property/column the Person
object. Child objects added to the relation must match the provided query. The query is specified in the whereClause
argument:
name='Joe' or name = 'Frank'.
As a result of the operation, all User objects where the name
property is either Joe
or Frank
will be added to the relation. The relation column is created if it does not exist. This is done because the column contains the child table qualifier, defined as ":Users" right after the column name.
Dictionary<string, object> parentObject = new Dictionary<string, object>();
parentObject[ "objectId" ] = "41230622-DC4D-204F-FF5A-F893A0324800";
AsyncCallback<int> addRelationCallback = new AsyncCallback<int>(
childrenSet =>
{
System.Console.WriteLine( "Number of child objects added in the relation " + childrenSet );
},
error =>
{
System.Console.WriteLine( "Server returned an error " + error.Message );
} );
Backendless.Data.Of( "Person" ).AddRelation( parentObject,
"users:Users:n",
"name = \"Joe\" or name = \"Frank\"",
addRelationCallback );
Person personObject = // personObject retrieval is out of scope in this example
AsyncCallback<int> addRelationCallback = new AsyncCallback<int>(
childrenSet =>
{
System.Console.WriteLine( "Number of child objects added in the relation " + childrenSet );
},
error =>
{
System.Console.WriteLine( "Server returned an error " + error.Message );
} );
Backendless.Data.Of<Person>().AddRelation( personObject,
"users:Users:n",
"name = \"Joe\" or name = \"Frank\"",
addRelationCallback );