Finding a Business Rule based on its message

September 26, 2017

If you receive a business rule notification message, but you’re unsure as to exactly which business rule it came from, there’s a few ways to find the originating rule.

Notification Message

For example, lets say that you received the following notification:

How do I find which business rule caused this notification to be sent?

There’s actually a few options here.

1. Dovetail Agent – Query Business Rule Actions

Using Dovetail Agent, create a query for Business Rule Actions

And filter for Message Contains something happened

This will show you a list of rules that contain that string in the message.

Clicking one of the results will take you to the Business Rule itself.

2. Dovetail Agent – from the History

If you know the work item (Case, Subcase, etc.) that the notification pertains to, then you can also check the History for that item.

Make sure the History is set to Show Details. You can then see the Rules that fired.

Clicking on the rule will take you to the Business Rule page for that rule.

Then you can see the details of that rule, including the message.

You may have to view a few of the rules on that case before you find the right one, but at least your surface area for rules to check have been reduced greatly.

3. BOLT

Using the Business Rule page in BOLT, filter for Message contains something happened.

This will show you a list of rules that contain that string in the message.

And from there, you  can click on the rule name to see details of the rule.

BOLT is freely available at https://github.com/DovetailSoftware/bolt

4. SQL

You can also use direct SQL to query for the data.

The following query will give you the names of the business rules based on a notification message.

select * from table_com_tmplte where objid in 
(
  select escal_act2com_tmplte 
  from table_com_tmplte  
  where action like '%something happened%'
  and type = 2
)

From there, you can view the business rule itself in whatever app you use for managing business rules (Dovetail Agent, Dovetail Admin, Clarify Client, etc.)

Using SQL is my least favorite way of accomplishing this task, but it is an option.

Summary

Locating a business rule based on its message is one of those sys admin tasks that pops up on occasion – and with just the Clarify Client, it was a challenge.

Now, with some smarter tools, and a bit of know-how, this becomes an easy task.

Rock on.

Dig This?

Sign up to get information like this delivered right to your inbox.

Sign up for the Dovetail Newsletter