Does anybody know if it is possible to do an OR operation in a filter definition that we then use with filter_relate?
We have customised the Cases module, and we have a relate field with Contacts. We want to search the contacts, that are linked to the account we have picked on the Case. But also, add another contact record, all the time.
We currently have
$viewdefs['Contacts']['base']['filter']['basic']['filters'] = [
'id' => 'contactsForAccountForReportedBy',
'name' => 'LBL_FILTER_CONTACTS_FOR_ACCOUNT',
'filter_definition' => [
'$or' => [
'account_id' => '',
'id' => [
'$equals' => '1e40cf4a-615d-11e5-82a3-00155daa9e14'
'editable' => true,
'is_template' => true,
'default' => false,
But we get currently get this error:
Unknown field $in
The API request going into SugarCRM is this (Query String):
Anyone know if this is possible?