Show only contacts with emails

Yahoo Archive
1
Add a filter where TableName.EMailAddress <> (CompOp) (IsConst is checked)
and leave the constant field blank. Your query for the Customer table would
look like this:



for each Customer where ( Customer.EMailAddress <> '') no-lock .



Katharine Barry
Aspacia Systems Inc
866-566-9600
<http://www.aspacia.com> www.aspacia.com




From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
emverbeke
Sent: Thursday, June 25, 2009 3:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] show only contacts with emails








Does anyone know how to apply a filter for only records with email addresses
in a BAQ? Thank you.

Emily





[Non-text portions of this message have been removed]
2
Does anyone know how to apply a filter for only records with email addresses in a BAQ? Thank you.

Emily
3
Hi Emily,

You would be better applying a filter in a Dashboard. There, you would filter where ...

EMail <> Constant: NullValue

Let me know if you need a little more clarification.

Cheers,


CHRIS




________________________________
From: emverbeke <emverbeke@...>
To: vantage@yahoogroups.com
Sent: Thursday, 25 June, 2009 11:45:11
Subject: [Vantage] show only contacts with emails





Does anyone know how to apply a filter for only records with email addresses in a BAQ? Thank you.

Emily







[Non-text portions of this message have been removed]
4
If you want it in a BAQ, you could have a filter setup in the phrase
Custcnt.EMailAddress <> Custcnt.ShortChar10

Assuming you are not using Custcnt.ShortChar10 and it would be null then.

Bruce

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
emverbeke
Sent: Thursday, June 25, 2009 5:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] show only contacts with emails

Does anyone know how to apply a filter for only records with email addresses
in a BAQ? Thank you.

Emily



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]