Hi All
I am attempting to create filters to segment my database. For me it makes sense to use the first letter of Name. i.e. Contacts starting with A, B, C, etc, along with a tag. It seems thought that I get records in multiple filters because it returns contacts that FIRST OR LAST name begin with that letter of the Alphabet. E.g. Doctor Hoffman Will appear in both the D filter and the W filter where I only want him to appear once. I am using this filter for instance:
[['category_id', '=', 'UK Import'], ['name', '=like', 'C']]
What am I doing wrong? Why is it looking in both the First and Last name and not just the first letter of the name field?
Hope someone can help
Thanks