Need search form help. Frustrated!

HCL Domino Domino Forum
1

I am building a search form to look for rental properties that meet the criteria.

This query works because RENT is a numeric field: http://www.coolrenthouses.com/members/osu9400/crh.nsf/(search)/?SearchView&Query=([rent]<=1500)

However, this one SHOULD work, but it does not. I receive the error that Relational operators are not supported in text fields. BEDROOMS is NOT a text field – it is numeric! Why am I getting this error?

http://www.coolrenthouses.com/members/osu9400/crh.nsf/(search)/?SearchView&Query=([bedrooms]>=1)

I checked the document properties via the Notes client and BEDROOMS is a numeric field and contains a value. In reality, BEDROOMS is a computed numeric field with the formula @TextToNumber(bedrooms_edit) – I have even tried switching it to an editable numeric field with the same formula, but the results were the same.

bedrooms_edit is used for input only and is hidden in read mode. Likewise, bedroooms is hidden in edit mode.

Feel free to check out the input form using these credentials:

user: “romeo the dog”

pass: “passpass”

http://www.coolrenthouses.com/members/osu9400/crh.nsf/property?OpenForm&Login

So why do I receive this error?

Thanks!

2

Subject: Need search form help. Frustrated!

I “solved” the problem, if yuo can call it that.

I had to remove all instances of the BEDROOMS field form the form, agents, and views. I then discarded the FT index.

I replaced all instances of BEDROOMS with BEDROOMS_READ.

I guess Domino didn’t realize I wanted BEDROOMS to be a numeric field.

Check out now.

3

Subject: RE: Need search form help. Frustrated!

I’ve just had this problem as well - but with a date field. At one time in the form’s life the field “orderDate” was a text field. I converted every instance of orderDate into a date/time value but when doing the search using:

…?searchView&query=([orderDate]>=12/12/2003)&…

I got the same “Relational operators are not supported in text fields”.

After loosing my temper a few times I finally gave in. I created a new date/time field called “dateOrdered” on the form and copied the data in the orderDate field into it (unchanged!). Then I removed the old field and changed the search to look at the new field.

It worked. No need to discard the FT index though.