I have to search some data using JAVA API. I can do the same using X_PACK Sql query. Same needs to be done through JAVA API. I have searched a lot but didn't find the reult.
My Sql Query is like:
select map.serviceName as name, count(map.serviceName) as noOfTimesApiUsed, avg(map.executionTimeInSeconds) as averageTime from auditlogs where map.orgId = 'XXXXX' group by map.serviceName order by noOfTimesApiUsed desc
Please help to change the query in JAVA code.