$join_parent_rel
The $join_parent_rel function allows you to search for an entity based on its field values as well as its relationship to a parent entity. This is especially helpful when you want to find all children of a particular entity that meet certain criteria.
Example: Find all contacts (char type ID = 2) on a Deal record (record ID = 1234) with a Party ID = 15
{
"query":{
"$join_parent_rel":[
{
"$and":[
{
"$eq":[
"parentchartypeid",
4
]
},
{
"$eq":[
"parentrecordid",
1234
]
},
{
"$eq":[
"childchartypeid",
2
]
},
{
"$eq":[
"relind",
15
]
}
]
}
]
},
"start":0,
"rows":25,
"sortOrders":[
"title_sort asc"
]
}
Last updated
Was this helpful?