You need to sign in to do that
Don't have an account?
BillF
Excluding id's with blank data
I am using an OR clause to filter my data. I need to put in two values along with a way to exclude blank values. My query says SFDC field <> to Value1, Value2. How do I add a third value to that statement and have the query filter out blanks also? I have tried using, " ", Null and just a space. So far no luck.
Figured it:
It requires the same field twice.
SFDC Field <>
SFDC Field <> value1,value2
Whoops that didn't work - it looks like it put an and between the two exlucdes :(
This should work:
SFDC Field <> ,value1, value2
OR
SFDC Field <>
SFDC Field <> value1,value2
then add filter logic so it reads: 1 or 2 (instead of the default 1 and 2, as you mentioned in your later post)
I tried this option:
SFDC Field <> ,value1, value2
and it does not see the null value.
SFDC Field <>
SFDC Field <> value1,value2
I'm sure this would work, but I can't see where to change the AND to an OR in the Query. I just see the values list out in columns in Excel?
My bad, I only now see you posted this question specifically for Excel Connector. My response is only applicable to Reports within Salesforce.com.
You said you had tried using " ", did you try ""?
I just tested by sandwiching the null in the middle with two commas and it worked that way. I didn't try putting it at start of end.
e.g. value1,,value3