Get row count of related records

[Priya75]

Hi All, 

I have a field on the form as test. i want to populate this field on the basis of a related list, so i have a related list of business service which shows the records from cbdb_ci_service tables.i want to count of services related to that particular task and update that field. 

[Servicenow Use4]

Hello Priya,

By what I understood from your requirement, apart from the 'test' field, you have a reference field 'Business Service' on the from that fetches data from cmdb_ci_service table. Now my question is: is the data being retrieved in the reference field dynamic? what is the condition? 

In your statement "i want to count of services related to that particular task", what task are we talking about?

Kindly clarify.

Counting the number of services can be done easily via script once we know the condition that filters data.

Thanks!

[Priya75]

Hi ,

I have a certificate task form, in this the business services(cmdb_ci_services)is the related list record.i have a field on the certificate task form as test. i want to populate this field, for that i want to count all the service record in business service related list.

for eg:- for each task created there are 2,3 services are there in the related list record. this i have to calculate and populate in test field