{
"target": "ENTITY",
"conditions": [
{
"type": "or",
"conditions": [
{
"type": "and",
"conditions": [
{
"type": "hasFieldWithValue",
"field": "status",
"value": "active",
"operator": "EQUALS"
}
]
}
]
}
],
"joins": [
{
"schemaId": "contacts",
"field": "realEstateAgent",
"fetch": [
"identifier",
"firstName",
"lastName"
],
"outer": false,
"conditions": [
{
"type": "HASFIELDWITHVALUE",
"joinField": [
"realEstateAgent",
"firstName"
],
"value": "${CURRENT_USER.firstname}",
"applyToJoinedElements": false
},
{
"type": "HASFIELDWITHVALUE",
"joinField": [
"realEstateAgent",
"lastName"
],
"value": "${CURRENT_USER.lastname}",
"applyToJoinedElements": false
}
]
}
]
}