Since London Upgrade, Error message"Business rules that modify queries cannot be created for out-of- scope tables" when creating "before query" Business Rule on custom table

[Simon Ciglia]

Hi folks :-),

Updated today our Production Instance to London

We wanted to create a new "before query" business rule on "u_process_task" table.
But we received the error message "Business rules that modify queries cannot be created for out-of- scope tables"

Is this a new restriction with London?
Why is the table out-of-scope?

[Alberto Consonn · Accepted solution]

Hi,

This is what is saying the official documentation:

You can create business rules on tables in the same scope and on tables that allow configuration records from another application scope.

• You cannot create any other types of business rules on tables in a different scope.

Probably the "u_process_task" table is a custom table that extends the Task table and it has been created in a different scope.

More info here: Business rules in scoped applications

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto

[Simon Ciglia]

Thank you :-), but the table is in Global scope...so i dont understand the error message...

[ajeetkumarchaub]

Recently I also faced the same issue while creating the before query business rule on cmdb_ci table.

What I noticed that system prevents me to create a before query business rule even if I was in same scope as table. Looks like since business rule does not exist actually in the system as it is a new business rule,, system is not able to identify the scope of business rule for this validation. I saved business rule first after clearing out "query" checkbox. Once it is saved in the system, I was able to re check the query flag.

Thanks,

Ajeet