Reporting on flagged field in knowledge management

[mohammedunwala]

Hi All,

We have a requirement to report flagged article to service desk at the end of every business day. Another requirement is to check and send the email only if there are articles that were flagged that day.

Proposed solution:

I was thinking of creating a custom date field called "Flagged date" on the knowledge table and update that date to current whenever an article is flagged. Then create a scheduled report with conditions 'Article Flagged = True' and 'Flagged Date = today' and run that report every night so that the system sends the list of articles flagged (if any) on that day to service desk.

My question to you all developers is this the right solution for this type of requirement? or is there a better, easier solution?

Also, I am new to scripting so not sure how will i set the custom field to update when the article is flagged?

Any help would be greatly appreciated.

Thanks,

Mohammed

[Mike Allen]

If you look in sys_history_line, you can see when an article was flagged:

[mohammedunwala]

Hi Mike,

Can i create a scheduled report on the sys_history_line field? Remember the requirement is to send the service desk a list of all the article flagged that day.

Thanks,

Mohammed

[Mike Allen]

I would create a notification email script that queries sys_history_line, finds all the articles that were flagged that day, compiles it in a regular html table, and put that notification script in an email notification that is triggered by an event.   Then, have a schedule that fires the event every night.

[mohammedunwala]

Hi Mike,

Is it possible for you to help me with the script? would really appreciate that.

Thanks,

Mohammed