How do I filter blank values or does not contain
I'm looking for records that are missing an email addres. I've tried "does not contain" the @ symbol and I get nothing. This used to work, but I haven't done it in a while and I don't know when it stopped. Am I missing something? is there another way to find records where the email field is blank?
0
-
Do the records that are missing an email address have a null value, blank value, or something else? 0 -
I guess I'd like to know how to handle both blanks and nulls, although in this case they are blank. 0 -
It probably depends on how you're going about finding the records that are missing an email address.
If you're using Query Task, then you can use a typical where clause such as "EmailField is null OR EmailField = ''". Then you could use the syntax resultFeatureSet.Features.Count() > 0 to see if the feature set create by the Query Task selected has any records in it.
If you're using an If activity (for example in a ForEach loop), then the syntax might be something like yourField is nothing OR yourField = "".0 -
I think we are talking about different things. I'm just using the Filter or Query buttons from the toolbar, not a workflow. "Is" is not an operation you can choose from. Choices are "contains", "does not contain", "starts with", "ends with", "=", and "!="
Further putting the work "null" in the search box will simply search for the string "null" and putting nothing in the box will return all records. A set of quotes or double quotes results in an error.0 -
BTW, i just upgraded to HTML viewer 2.11 and this is still broken. 0
Du måste logga in om du vill lämna en kommentar.
Kommentarer
5 kommentarer