aware_support wroteFor instances when you have a referenced BO attribute and you are trying to filter based on EITHER OR criteria a Process wouldn't work.
Still don't understand. Filter where? Why can't you use built-in filters that allow you to specify AND/OR etc?
A highly artificial example (you would do it differently in real life but I can't remember a real life issue atm)
Consider:
BO ORDER with
Order.Status of 'In Progress' OR 'Delivered' and a
Order.PaidStatus of 'Outstanding' OR 'Paid'
Order.psHandledBy is a reference to Employees
Employees.Department = 'Order Processing' OR 'Credit Control'
If you're in the process of delivering the order then the Order.psHandledBy should only allow Employees in Order Processing to be shown, but if the order has been delivered and is still outstanding you want the Order.psHandledBy field to show only Credit Control staff:
So the value of Order.psHandledBy should be filtered by:
IF Order.Status='In Progress' AND Order.PaidStatus='Outstanding' THEN FIND Employees WHERE Employees.Department='Order Processing' ELSE
IF Order.Status='Delivered' AND Order.PaidStatus='Outstanding' THEN FIND Employees WHERE Employees.Department='Credit Control'
The only way to achieve that is by duplicating the form and determining which form to show based on the Status and PaidStatus fields. This creates unnecessary redundancy if everything else on the form is identical except that filter.
You could probably build a stored procedure but then you are fragmenting the development across the application development environment and the database, which introduces fragility to the system if fields ever get renamed. You are also creating a barrier to use for non SQL/technical users, which seems to be counter to the AwareIM ethos.
An alternative would be to return the SQL editor for queries, which would keep the application within the development environment. Is there a technical limitation to Eclipse that prevents this?
