Data Lookups and businesss rules

[poojithac]

Hi All,

I have got a requirement to set priority value based on Impact and Urgency for Problem table. I have implemented using data lookups. I am curious to know what happens if I write business rule for the same with few modifications? Will the business rule override the data lookup table values?

Thanks,

Poojitha

[Atul Kumar2]

Hi Poojitha,

As per my understanding, If i am understanding it correctly then it will depend on the condition on business rule is being fired.

Here is below things will matter the most.

1. When criteria(Before,after) since in the data lookup rule you can select on which it should populate to the field like (insert or update).

2. Order- If data look up table is storing the data in order 100 and your custom business rule is setting /changing the value in order 200 then it will override else it will not.

Hope this will make sense.

Regards,

Atul Kumar

[poojithac]

Thanks Atul. I got your point.

I will try doing that.

[poojithac]

Hi Atul,

I have tried 3 combinations:

1) I have created a BR with the same combinations as that of data lookup table values.And also I have added a message in order to see if the BR is executed or not. The result is that though the BR is executed, data lookup table values are saved.

2) I have changed the order of execution, still the data look table values overrides.

3) And I have tried deleting a combination in data lookup table and added that combo in BR and I found out that, as per BR, the value is saved.

As per my understanding, I would like to conclude that Data lookup table values overrides.

Thanks & Regards,

Poojitha

[Community Alums]

I know this is a bit old, but to offer some clarification:

The Data Lookup engine has two main functions. It displays the matching data on the form and it writes the matching data to the record after submission. Although it will display on a form in real time the value being looked up is NOT included in the insert or update.

Instead, after submission the data-lookup engine runs again and populates the information. It's run in the 'after engines' execution group, which is just before After Business Rules (Order =< 1000)

This has a couple implications.

1. No events can be used that require the data in the data lookup to be there if they run before this point. For example, you cannot populate the assigned_to field with data lookup and expect a notification set to send when the assigned_to field is not empty to work. This execution group runs each engine in no particular order, in practice the notification engine will almost always executive before the data lookup has finished.

2. It IS possible to modify values using a business rule, however it must be an AFTER business rule with an order equal to or greater than 1000.

3. Any BR set as a Before will not overwrite a data lookup, but can be used to ensure the data is there before other engines, like the notification engine, run.