find data in calculated fields

Classic Servoy
1

I have the following method:

//selectInterimBillMatters[maBillingInterim]
var month = sysprefs.interimbillmonth
controller.find();
matterstatus = “Open”;
billingperiods = “%” + month + “%”;
aboveminimum = “Yes”
controller.search( ) ;

aboveminimum field is a calculated field:

var answer = “No”
if ( matter_to_timeexpense_unbilled.sumfeeexpense >= matter_to_client.clminbillamt )
{
answer = “Yes”
}
return answer;

The calculation is correct for all records.
When I run the method aboveminimum appears to be ignored - when I debug, the search criteria field is never updated with “Yes”
Am I missing something? can you search for a record based on a calculated field?

2

Dennis,

You can only search on stored calculations (where there is a field in the database with the same name as the calculation).

3

airmark:
Thanks for your reply. I tried that before and was not able to get it to work - THEN, after reading your reply, I remembered that merely defining a field as a stored calculation is not enough for it to work - so I looped through all the records in the table, THEN it finally worked. Thanks again!