Question in product: FileNet 5.5.7 CPE.

Can you please help with the ACCE Query or API to directly get the actual count of documents group by certain metadata and filter by search criteria. Currently, we are only able to implement this by running a query that list all the docs that matches the search criteria and then use API to get the count. Instead we are looking for a kind of reporting query to just give the count of docs based on search criteria and group by. For example, like below.

Select count(1), DocumentType from Document group by DocumentType.

We need to call this query from the application for Dashboard feature.

------------------------------
Mohan Chandran
------------------------------

To get the actual count of documents group by certain metadata and filter by search criteria using ACCE API, you can use the "Aggregate Query" endpoint. The Aggregate Query endpoint allows you to run aggregate queries against your content and returns the result as an aggregation of the data.

------------------------------
noah Jeffr
------------------------------

Original Message:
Sent: Mon February 06, 2023 02:00 PM
From: Mohan Chandran
Subject: Dashboard Query - Count of docs group by metadata.

Question in product: FileNet 5.5.7 CPE.

Can you please help with the ACCE Query or API to directly get the actual count of documents group by certain metadata and filter by search criteria. Currently, we are only able to implement this by running a query that list all the docs that matches the search criteria and then use API to get the count. Instead we are looking for a kind of reporting query to just give the count of docs based on search criteria and group by. For example, like below.

Select count(1), DocumentType from Document group by DocumentType.

We need to call this query from the application for Dashboard feature.

------------------------------
Mohan Chandran
------------------------------

Thanks for your reply. Can you please share some example or tech note for Aggregate Query endpoint. Is it possible to use Aggregate Query thru API from application apart from ACCE?

------------------------------
Mohan Chandran
------------------------------

Original Message:
Sent: Sun April 02, 2023 01:55 AM
From: noah Jeffr
Subject: Dashboard Query - Count of docs group by metadata.

To get the actual count of documents group by certain metadata and filter by search criteria using ACCE API, you can use the "Aggregate Query" endpoint. The Aggregate Query endpoint allows you to run aggregate queries against your content and returns the result as an aggregation of the data.

------------------------------
noah Jeffr

Original Message:
Sent: Mon February 06, 2023 02:00 PM
From: Mohan Chandran
Subject: Dashboard Query - Count of docs group by metadata.

Question in product: FileNet 5.5.7 CPE.

Can you please help with the ACCE Query or API to directly get the actual count of documents group by certain metadata and filter by search criteria. Currently, we are only able to implement this by running a query that list all the docs that matches the search criteria and then use API to get the count. Instead we are looking for a kind of reporting query to just give the count of docs based on search criteria and group by. For example, like below.

Select count(1), DocumentType from Document group by DocumentType.

We need to call this query from the application for Dashboard feature.

------------------------------
Mohan Chandran
------------------------------

Based on the documentation, I see Aggregate function is available only for Background Seach query? please let me know if this is feasible thru API from application.

------------------------------
Mohan Chandran
------------------------------

Original Message:
Sent: Mon April 03, 2023 10:13 AM
From: Mohan Chandran
Subject: Dashboard Query - Count of docs group by metadata.

Thanks for your reply. Can you please share some example or tech note for Aggregate Query endpoint. Is it possible to use Aggregate Query thru API from application apart from ACCE?

------------------------------
Mohan Chandran

Original Message:
Sent: Sun April 02, 2023 01:55 AM
From: noah Jeffr
Subject: Dashboard Query - Count of docs group by metadata.

To get the actual count of documents group by certain metadata and filter by search criteria using ACCE API, you can use the "Aggregate Query" endpoint. The Aggregate Query endpoint allows you to run aggregate queries against your content and returns the result as an aggregation of the data.

------------------------------
noah Jeffr

Original Message:
Sent: Mon February 06, 2023 02:00 PM
From: Mohan Chandran
Subject: Dashboard Query - Count of docs group by metadata.

Question in product: FileNet 5.5.7 CPE.

Can you please help with the ACCE Query or API to directly get the actual count of documents group by certain metadata and filter by search criteria. Currently, we are only able to implement this by running a query that list all the docs that matches the search criteria and then use API to get the count. Instead we are looking for a kind of reporting query to just give the count of docs based on search criteria and group by. For example, like below.

Select count(1), DocumentType from Document group by DocumentType.

We need to call this query from the application for Dashboard feature.

------------------------------
Mohan Chandran
------------------------------