Search for a calculated number attribute

paddo2002

I have a number attribute that is calculated by a rule. It just counts up each time a record is created.

I have a query that searches for either the title or this number attribute that asks at run time. The title search works, but if I use the number, I get an http Error 500 and a lot of java garbage, which means nothing to me. Is it possible to do this sort of search?

Regards

christopherb

PM,
Re-produce the error and post the text.

Christopher

paddo2002

This is the error I am having. All help appreciated.

Cheers
Patrick

paddo2002

Woops Let me try that again

aware_support

Could you please send your bsv file to support@awareim.com with the description of the steps required to reproduce the problem?

paddo2002

Sure,
Where would I find the BSV file? I use a Macintosh if that is any help?

Also to reproduce the problem. I have a query that is activated from the admin menu and there are 2 OR criteria. One is number the other is title. If you put a number in the number field, I get this error. If I use the title field it works...

Regards
Patrick

christopherb

PM,
Start configuration tool > Right click on the business space > Export >Save

That will create your bsv. Then you can email that as an attachment to support.

Good luck
Christopher

paddo2002

I have sent the BSV through to awaresupport. Hope it helps

Cheers
PM

aware_support

Yes, this is a bug. When using Derby database you cannot search for numbers using CONTAINS statement. Please replace the CONTAINS statement in your query for a number attribute with equality operator to search for the entire number.