I’ve tried to and a new filter a cs.search in code studio the line that start /* spw mod…
its doesnt error which is a good start but it doesnt work either! What i want it to do is exclude any records that dont have a value of person_created_by_system which is a relation to another object? So if its a relation rather than comparing it to an empty string do i need to do something like is not null? but how do i do that?
var a = cs.search({
'base_object_id':'obj_person',
'selects': \['person_firstname','person_surname_person','person_address_from_any_source_stamped','person_email','person_ID'\],
'filters': \[{'field_path':'person_mobile','value':mob,'comparator':'equal_to'},
{'field_path': 'person_ID','value': page_id,'comparator': 'not_equal_to','logical_operator': 'AND'},
/\*spw mod\*/{'field_path': 'person_created_by_system','value': '','comparator': 'equal_to','logical_operator': 'AND'},
\],
'return': 'data'
});