Search for a calculated number attribute

paddo2002 · Post by **paddo2002** » Wed Dec 26, 2007 12:15 pm

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

PM

christopherb · Post by **christopherb** » Wed Dec 26, 2007 6:24 pm

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

Christopher

paddo2002 · Post by **paddo2002** » Thu Dec 27, 2007 10:56 am

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

<a href="http://s42.photobucket.com/albums/e339/ ... cture1.png" target="_blank"><img src="http://i42.photobucket.com/albums/e339/ ... cture1.png" border="0" alt="Photobucket"></a>

Cheers
Patrick

paddo2002 · Post by **paddo2002** » Thu Dec 27, 2007 10:59 am

Woops Let me try that again

aware_support · Post by **aware_support** » Thu Dec 27, 2007 11:32 am

Could you please send your bsv file to [email protected] with the description of the steps required to reproduce the problem?

paddo2002 · Post by **paddo2002** » Thu Dec 27, 2007 11:51 am

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 · Post by **christopherb** » Thu Dec 27, 2007 6:13 pm

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 · Post by **paddo2002** » Sat Dec 29, 2007 4:11 am

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

Cheers
PM

aware_support · Post by **aware_support** » Sat Dec 29, 2007 5:55 am

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.