Help with business rule on kb use count population

[arundharmabe]

Hello All,

I have a custom table[u_xyz] and in that i have 3 fields[Year, Month & Total No. of Views]. The total number of views field should be populated from kb_use table count as per the year and month selection of u_xyz table. For Ex: 2023 and Dec is selected in the u_xyz table, it should populate the Total No. of Views for Dec 2023 from kb_use table. Kindly show some light on this. This is little urgent.

Kindly refer the attached screenshots for more info.

Regards,
Arun

[SanjivMeher]

You can create a scheduled job or a flow designer and do a GlideAggregate on the kb_use table to get the 'SUM' of the view count and the update the xyz table.

https://developer.servicenow.com/dev.do#!/reference/api/utah/server/no-namespace/c_GlideAggregateSco...

[Jayant_M]

Hi,

You can write on BR on your custom table and use GlideAggregate Count to fetch the the number of views by gliding for that year and month.

Mark my response helpful if it resolves your issue.