We need a way to filter a reference field on a template for Standard Change control...

[Community Alums]

We have over a million CI's and only about 7,000 of them need Change Controls to be submitted.

On the Change form we have the Configuration Item reference field filtered to show only those CI's needed.

However, when we create a new Standard Change, the template that we use to apply the field content has a Configuration Item reference field that shows all 1 million CI's.

How can we filter this?

I have tried Dictionary Overrides and nothing seems to work.

[Allen Andreas]

Hi,

Please see this solution which uses a query business rule to accomplish it in this specific scenario: https://community.servicenow.com/community?id=community_question&sys_id=dc2c0365db9cdbc01dcaf3231f96...

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Community Alums]

Allen,

Thank you for your response!

I will give it a try and let you know.

If it works for me then I will mark as correct your answer.\

-Cory

[Allen Andreas]

Hi Cory,

Great, thanks. This was from a few weeks ago.

Let me know if you need any other assistance.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Community Alums]

Hello Allen,

We tried the BR you suggested, however this BR had to be turned off in our instances due to the excessive logging in our log table.

Would you happen to know if there is a way to prevent the logging?

- Cory