How can I count total requests via rule

Which IIQ version are you inquiring about?

Version 8.3

Share all details related to your problem, including any error messages you may have received.

Hi team, by using which API i can count Reqtuest.
Reqtuest Details
Total no. of successfully completed requests.
Total no. of failed requests.
Total no. of requests with approval pending.

Hi @amanKsingh,

There is no OOTB rest API to achieve this use-case. However you can do it via Query Filters. If you need help let me know.

Also please take a look on this solution, one community member has given Plugin.

Let me know if it does not solve your ask.

Thanks

@amanKsingh
You can do it using

  1. Query options and Filter - as mentioned by @ashutosh08
  2. You can directly query the DB
Connection con = context.getJdbcConnection();
//Write the query
String sql = "<Query to fetch the required details from spt_identity_request table>"
//logic to execute the query
  1. HQL queries (similar to sql)

If you are able to build QueryOptions which will filter for Requests you want you can just execute context.countObjects(IdentityRequest.class,qo) where qo is you QueryOption with Filter.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.