Formula: Nested filters in lookup functions #3422
Description
Supporting a nested where clause for formula lookup functions. The where item format is the same as for API requests.
Affected functions:
record\findOnerecord\findManyrecord\findRelatedOnerecord\findRelatedManyrecord\existsrecord\countentity\countRelatedentity\sumRelated
Example:
$where = object\create();
$where['type'] = 'or';
$where['value'] = list(
(
$it = object\create();
$it['type'] = 'equals';
$it['attribute'] = 'name';
$it['value'] = 'A1';
$it;
),
(
$it = object\create();
$it['type'] = 'equals';
$it['attribute'] = 'name';
$it['value'] = 'A2';
$it;
)
);
$output = record\findMany('Account', 2, null, null, $where);