Knowledge Valid to field change -URGENT

[PraneetaV]

Hi everyone,

I’m working on a requirement to build a dashboard that shows a monthly bifurcation of Knowledge Article updates:

1. Articles where content was modified

2. Articles where only the Valid To date was changed (no other field updates)

What I’ve done so far:

• Created a Metric Definition on the kb_knowledge table for the valid_to field

• Enabled Audit on the valid_to field

• Implemented a Business Rule to detect changes to valid_to

Issue:

• I do see audit records being generated in sys_audit

• However, the Metric Definition is not capturing any data in metric_instance

• Also, I only see options like Field value duration and Script calculation in Metric Type (no “Field value change” option)

My questions:

1. Is it expected that Metric Definitions won’t capture field changes in this case?

2. Is there a way to track field change counts using Metrics without “Field value change” type?

3. For my use case (distinguishing “only valid_to changed” vs “content modified”), is using a Business Rule + custom table the recommended approach?

Any guidance or best practices would be really helpful.

Thanks in advance!

[GlideFather]

Hi @PraneetaV,

could you possibly explain what do you mean "Implemented a Business Rule to detect changes to valid_to"?

Share what you tried to review it, saying "implemented business rule" is not enough.

Also, can you explain why is it important to know that a valid_to has changed?

Just an idea, maybe it can be done differently, business rule triggered when valid_to changes, it will fire an event and this event will be used for next processing. But i don't see the purpose of it to give oyu better suggestions, what is the benefit or business justification for that?