I'm trying to request all user models which have no e-mail addresses set, but this doesn't seem to work:
<?xml version="1.0" encoding="UTF-8"?>
This doesn't seem to work. I got the '<value />' by adding a filter in OneClick and looking in the custom/console/config/ directory of the oneclick server to look at the syntax - but this doesn't seem to work.
When I run this query, I still see entries with empty e-mail addresses appear in the list.
Is there a way to request 'if attribute *** is not set'? It seems simply using two single quotes next to each other doesn't work. I know on some attributes you can use regex and '^$' but this doesn't give you the option to use 'and regex does NOT match ***'.
Has anyone been able to sort this problem out?
Perhaps if not, I'll recommend it as a suggestion in an upcomming release!
You could always use this as a filter
Thanks, while that will work in this example, I'm specifically looking for a generic example - I have a few queries I need to run where the logic contains the 'where attribute *** is not set' clause. I was hoping there was a way to do this.
Frank, you create a Locator search for any attribute, and find models with null values just leaving the Attribute Value field blank.
I tried using the Locator search (this is where I usually test or work out what XML to use) but this doesn't always work (as in the example I provided). I think Gregory is correct, we just have to get clever and try to find other ways to query.