Querying Lotus Notes 1

[alexlc]

I have just beeb able to connect to out Notes databases this week. I am trying to filter results with Select Expert & Record Selection formula ofr "does not start with" - if I use "and" between each expression I get no results, if I use "or" nothing is filtered. Where am I going wrong as this how I would usually query Access or SQL?!
Any help is much appreciated.
Alex

 

[alexlc]

Oops - should mention that I am using Crystal v9 & connecting throug an ODBC connection, not Native driver.
Cheers

 

[synapsevampire]

Perhaps you could post what you were trying?

OR should be the proper predicate in most situations, depending upon how you wrote it and the intent.

Another way to use does not start with would be:

(
not(left({table.field},2) in ["HI","OR"])
)


Or you might use:

(
not({table.field} like "HI*")
)
and
(
not({table.field} like "IN*")
)

Anyway, you'd be better served to post examples than a text description.

-k

 

[alexlc]

Cheers for that - I'll give it a go tomorrow - this is the record selection formula entered. Sorry if it's bit vague ,I've not asked for help on forums before.

not ({Location.ApexSalesCode} startswith "1133")or
not ({Location.ApexSalesCode} startswith "1111")and
{Location.LocationCategory}<> "Homecare

 

[synapsevampire]

Try:

(
not(left({Location.ApexSalesCode},4) in ["1133","1111"])
)
and
(
{Location.LocationCategory}<> "Homecare"
)

-k

 

[alexlc]

Thank ever so - that worked perfectly.