Hi - we are trying to maintain 140+ business rules.
Each business rule contains a long "Subject contains" statement, containing multiple customer codes.
E.g. "Subject contains "BLAH" or "BLAH1" or "BLAH3" (up to 25 more) or "BLAH25""
We use these rules to detect client codes in email subjects, and route them to specific technicians.
The maintenance on these is currently untenable - we want to modify these rules directly in the database if possible.
I have found the RuleDefinition table, which contains the rule header information.
What I can't find is where the rest of the statement itself is stored.
We are hoping to learn what table(s) make up the Business Rule - e.g. the Subject contains "BLAH" or "BLAH" part of the query - so that we can directly edit the customer codes (the "BLAH" text portion).
We don't need to alter the Rule names, ID's, comments, "Subject Contains" or "Or" sections - just the string search data that each rule contains.