Is there a possibility to return different Business Rule error message based on different matching condition?
I am doing a SQL Lookup in which, following conditions are checked,
- user should exist for type A user => error message: user does not exist for type A
- user should not exist for type B user => error message: user exists for type B
I can easily implement it using 2 rules inside Business Rule component.
But I want to reduce 2 lookups done to SQL Server by combining these conditions. While condition combining is possible, how can I give out different messages?
Is it possible, or is there a better way of doing it?
Please note, data in table is huge, so cache and cahe lookup is not feasible.