I am trying to run a query with some output statistics to determine a count of the numbers of copies I have of each item based on the 'Call_Number' this seems to work okay but it only returns the count and the call number, not the rest of the attributes for each item. Here is a simple example of what I am looking to do:
Title: sheet1, Date: 1900, Call Number: 1234
Title: sheet1, Date: 1900, Call Number: 1234
Title: sheet1, Date: 1900, Call Number: 1234
In this case, there are 3 versions of an identical record. I would like it to show in the query, 1 record, the number of copies, and all of the attributes. For example it would return:
Title: sheet1, Date: 1900, Call Number: 1234, Copies: 3
Here are the outputstatistics I am using. Any help would be appreciated!
[{
"statisticType": "count",
"onStatisticField": "Call_Number",
"outStatisticFieldName": "Copies"
}]