Calculate Records from Related List to Add to Field on Incident Table

[Zo2]

Hi All,

I am trying to "Calculate records from a related List to add to field on the incident table".

I imagine it would be a client script as i would need for it to update onLoad and onChange.

Im not too sure how i would write the script but think I should use the GlideAggregate function.

Your help/guidance is much appreciated

[Ankur Bawiskar]

Hi,

So it should give same row count when it runs in display business rule

Can you share what type of business rule you have written?

It should be display business rule

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Zo2]

Please business rule details below.

[Ankur Bawiskar]

Hi,

you want to populate value on incident field; so you need to have the display business rule on incident table

since the client script is also on incident table

change the business rule table to incident and check once

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Zo2]

Thanks Ankur....im now seeing the row count but it shows the same count (16) on all incidents, even if there is no calls related to the incident. Do you think its the encoded query causing the issue.

Appreciate all your help so far.

Kind regards

[Ankur Bawiskar]

Hi,

That's because you are just querying with the call_type and u_related_incident fields

Does the u_related_incident store the incident number?

The query doesn't take into account the current incident record

Do you want to show the count of calls from new_call table where the caller in incident is same as the caller in new_call table?

If yes then have this query

var gr = new GlideRecord('new_call');

gr.addEncodedQuery('call_type=incident^u_related_incident!=NULL');

gr.addQuery('caller',current.caller_id);

gr.query();

var rowCount = gr.getRowCount();

g_scratchpad.rowCount = rowCount;

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur