How to count the number of records in a table?

[pranita-24]

Hi 
You can try this
var gr = new GlideRecord('incident');
gr.query();
gs.info(gr.getRowCount());

[Ankur Bawiskar]

@kishorchika 

You can easily get answer to your question by doing a google search.

It will save a lot of time and effort.

[Bhuvan]

@kishorchika 

There are many options to get the number of records in a table. You can use Glide Record with getRowCount() or use Glide Query with count(). You can also use addQuery or addEncodedQuery or where conditions to filter the data and get the count details.

https://www.servicenow.com/docs/bundle/zurich-api-reference/page/app-store/dev_portal/API_reference/...

https://www.servicenow.com/docs/bundle/zurich-it-business-management/page/product/project-workspace/...

As per community guidelines, you can accept more than one answer as accepted solution. If my response helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[aneta_koleva]

hi Kishorchika.

My answe is totallin from within UI Builder.

Easiest way is to add an Aggregation Query data resource: 

You can specify the table you are interested in: 

and in the Output you will get the count