Question

3
Replies
82
Views
AmitK211 Member since 2014 25 posts
Cognizant Technology Solutions
Posted: September 27, 2019
Last activity: September 27, 2019
Closed

Most Active developer

Hi can you please suggest a simplest way to get the most active developer .

I am joining Data-rule-summary with Rule-History and getting number of actions grouped by developer. Now i have to apply a MAX on counts and then find which all operators' count matches max count. How we achieve it using report definitions.

I am trying to do a equivalent of below sql query using report definition and subreports.

with TEMP as (select V.pxUpdateOperator operator,count(H.pzINskey) CountUpdate from mnprule.pr4_rule_vw V, MNPDATA.pr4_history_rule H where V.pzinskey=H.PXHISTORYFORREFERENCE
and V.pxupdatedatetime is not null
and V.pxupdatedatetime > sysdate -7
and V.pyclassname is not null
group by V.pxUpdateOperator)

select * from TEMP where CountUpdate = (select Max (TEMP.CountUpdate) from TEMP)

Reporting
Moderation Team has archived post
Share this page LinkedIn