Set Relation using condition¶
API request replaces related objects with the ones identified in the API call. Child objects are referenced implicitly - through "whereClause" defining the condition for object selection.
Backendless.Data.of( "TABLE-NAME" ).setRelation(
parentObject,
relationColumnName,
whereClause )
.then( function( count ) {
})
.catch( function( error ) {
});
Backendless.Data.of( ClassFunctionRef ).setRelation(
parentObject,
relationColumnName,
whereClause )
.then( function( count ) {
})
.catch( function( error ) {
});
where:
Argument | Description |
---|---|
TABLE-NAME |
Name of the table where the parent object is stored. |
ClassFunctionRef |
Reference to a JS function/class identifying the table. Name of the table must match the name of the function. |
parentObject |
The object which will be assigned related children for relatedColumnName . When this argument is a plain JS object(for the "Untyped Objects" approach), it must contain the "objectId" property. |
relationColumnName |
Name of the column identifying the relation. Objects from the childrenArray array will be set as related for the column in parentObject . The column name may optionally include table name separated by the colon character (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 set as the related objects for the parent object. |
Return Value¶
Number of child objects set into the relation.
Example¶
The following request creates a relation between a Person
object and all objects in the Users
table which 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 set in the relation. The relation column is created if it does not exist. This is done because the column name argument contains the child table qualifier, defined as ":Users:n"
right after the column name.
var parentObject = { objectId:"41230622-DC4D-204F-FF5A-F893A0324800" };
Backendless.Data.of( "Person" ).setRelation( parentObject,
"users:Users:n",
"name = \"Joe\" or name = \"Frank\"" )
.then( function( count ) {
console.log( "relation has been set" );
})
.catch( function( error ) {
console.log( "server reported an error - " + error.message );
});
function Person {
// define Person class properties here
}
var personObject = // personObject retrieval is out of scope in this example
Backendless.Data.of( Person ).setRelation( parentObject,
"users:Users:n",
"name = \"Joe\" or name = \"Frank\"" )
.then( function( count ) {
console.log( "relation has been set" );
})
.catch( function( error ) {
console.log( "server reported an error - " + error.message );
});