When looking at the offering screen, where are the numbers for 'Requests' and 'Subscriptions' coming from on the first screen?

Version 1

    Details

    Questions about the Request offering screen and the numbers presented.


     
    When looking at the offering screen, where are the numbers for 'Requests' and 'Subscriptions' coming from on the first screen?

     


    Resolution

     

    'Subscriptions' is just the count of items linked between ServiceReqTemplate and ServiceReqSubscription, using the relationships between ServiceReqTemplate and ServiceReqSubscription.

    Requests comes from the field UsageCount.

    select 
      ST.Name
    , ST.UsageCount as [Requests]
    , count(ST.Name) as [Subscriptions]
    from ServiceReqTemplate ST
    Inner join ServiceReqSubscription SR 
    on ST.Recid = SR.SvcReqTmplLink_RecId
    Group by ST.Name, ST.Usagecount
    Order by ST.Name