AnsweredAssumed Answered

Business Rule - Different Error messages in one rule?

Question asked by vshah01248 on Mar 27, 2017
Latest reply on Mar 27, 2017 by prashant.tiwari718253



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.