relational operators not supported?
Posted on 2005-04-20
Guys, I have a big problem.
I have written an application which I am to demostrate to the company out our annual conference tomorrow afternoon.
I have created a local replica on my laptop to demonstrate with as the conference center will not have sufficient connectivity with out HO.
As part of the demonstration I will be showcasing the search functions of Notes. When using the server copy and index, I am able to search for docs if the contents of a number field exceeds a therotical value, however my local copy will not behave the same. I have created a local replica and local full text index, but now search function doesn't recognise the field is a number field, i.e. it wont give me usual options (is equal to, greater than etc etc) instead just offers text feild options (contains, does not contain)
Also using a previous saved (shared) search which uses this number field to find a value greater than x, notes reports the error "relational operators not supported in text fields"
What have I done wrong? is this something that cannot be done with a local replica's index?
Any help would be great, even if it is bad news. What a bombshell the night before my presentation!!!!