Can anyone think of a way to get a summary count o...
# generald
Dylan Fields
11/20/2023, 5:17 PMCan anyone think of a way to get a summary count of records by custom record? NS told us we have 2.2M custom records (less than 400 unique custom record types), so I was curious to see (quickly) how many of each.
e
eblackey
11/20/2023, 5:40 PMI would create a Suitelet that queried for all Custom Record types:
eblackey
11/20/2023, 5:40 PMselect scriptid from CustomRecordType;
eblackey
11/20/2023, 5:41 PMAnd then loop through and do a "select count(*)" on each and then display results in a table.
3 Views