CODEWITHSUNDEEP
syntaxlotus-domino
Markus
Markus

Reputation: 291

Domino Designer query: numeric operation

When submitting a query via NotesDatabase.FTSearch I get the error message:

Notes Error: Query is not understandable 
(FIELD Form="Contact" AND ( FIELD CUSTOMER_ID <> 1)) (262)

The same query with an equals performs normal (same with <= and >=):
(FIELD Form="Contact" AND ( FIELD CUSTOMER_ID = 1))
Therefore I think there is an error on the "not equal" operator.

The documentation explains various operators on numeric values except the "not equals" operation. Even worse it states, that

You cannot put NOT after the math symbols =, <, >, <=, or >=; and before a date or number

So whats the proper way to do it? <> and != didn't work.

Thanks for your help!

Upvotes: 1

Views: 195

Answers (1)

Panu Haaramo
Panu Haaramo

Reputation: 2932

This works at least for text fields:

![CUSTOMER_ID]=1

Giive it a try, I'm not sure about numeric. If it does not work you can do this:

[CUSTOMER_ID]>1 OR [CUSTOMER_ID]<1

Simon's suggestion might work also (without the first underscore).

Upvotes: 3

Related Questions