One of our users was looking for a quick way to generate a list of
approximately 14 Accounts. Because these Accounts to not have an attribute
value in common that no other Accounts have, he created an Advanced Find with
one select for each Account on the Account name (a navchar attribute) using
the Contains option with a portion of the name as the value. He then
selected each row and when he clicked on Group Or, the first select statement
disappeared. And it did not apply the OR to the remaining statements. Each
successive clidk on the Group Or removed the select statement at the top of
the list. I was able to reproduce this and it appears the limit for this
type of search is 5 selects. Any one else experience this? Is this by
design? Thanks.

I'm not sure about the limit, but you can select multiple accounts if
you use the equals clause, i.e.

Account Equals ABC Co., DEF Co.,
GHI Co.


Try that and you may not need so many OR clauses

- Scott
www.easiintl.com


WK Carlon wrote:

Hi Scott,

Thanks for the suggestion. My expeirence is that Advanced Find in v3.0 does
not support the comma seperated values when using the equals on a navchar
attribute.

Wanda

"Scott Moore: JourneyTEAM - EASI" wrote:

Wanda,

You would not actually be inserting the commas.

You would simply select the customer id field, then set the criteria to
equals to, then select the customers you want through the lookup that
is provided. You can select multiple customers via this lookup.

- Scott
www.easiintl.com


WK Carlon wrote:

Hi Scott,
I understand what you are saying about selecting multiples when the
attribute is a lookup or a picklist. The attribute in my example is neither
of these, it is a navchar type attribute, so there is not option to lookup
values.
Regards,
Wanda
--
WKC
Greater Twin Cities United Way
Minneapolis, MN


"Scott Moore: JourneyTEAM - EASI" wrote:

I went back and read your original post, but I'm still not sure that I
understand what you're trying to accomplish. Is there a value (or are
you specifying a value) in the "Account Name" to create a custom list
(or advanced find view) of accounts?

If so, why not just add a field on the account form for something like
account category (or whatever these 14 accounts have in common) and
then perform a select on that value in the advanced find query builder.

i.e.

Select Account Category Equal To Category XYZ


I would say that 14 or so clauses created in a fashion like

Account Name like BBB
or
Account Name like CCC
or
Account Name like DDD

is an inefficient way of trying to classify similiar accounts when you
have the option to so easily add a field that could provide the common
classification that you need. Let me know if I am way off on this.

Thanks,
Scott



WK Carlon wrote: