Currently in my FM solution I have a table called orders. Each order has different status options.
Here is one status field
Estimate_Completion_Status:
'Complete' if Estimate_Completion_Date is valid
'Incomplete' if Estimate_Completion_Date is empty
For my estimate queue, I have a script that:
preforms a find based on the Estimate_Completion_ Status being 'Incomplete', then displaying a list of records.
In servoy I wanted to display this queue in a tab panel showing the number of records.
I know there are a few ways of accomplishing this one being that I create a field called 'Incomplete_Staus' that has the calculated value of 'Incomplete'. Create a self join relationship in the orders table:
Estimate_Completion_Status = Incomplete_Status
This would accomplish what I need. Would there be drawbacks from a self join relationship having to evaluate thousands of records, would this slow anything down?
Or could I accomplish this more efficeintly using a search method of some sort?
Thanks for any input.
Erich