1 Reply Latest reply on Jul 17, 2018 12:36 AM by rhaa

    Reporting from Parameters on a Service Request?

    dsyee Rookie

      Is there any way to generate reports based on the selections in the Parameters of a Service Request?

       

      For example, I have a request offering with 3 options, A, B & C. I want to generate a report to see how many people requested option A in the past month.

        • 1. Re: Reporting from Parameters on a Service Request?
          rhaa Apprentice

          sure, it's all about the SQL Statement.

          Here is what you need:

           

           

          select count(*) as Amount, srp.ParameterDisplayValue from ServiceReqParam srp

          left join servicereq sr  on srp.ParentLink_RecID = sr.RecId

          left join ServiceReqTemplate srt on sr.SvcReqTmplLink_RecID = srt.RecId

          where srt.name = 'installhardwareap' -- name of your request offering

          and srp.ParameterName = 'combo_3' -- name of parameter of your "option"

          group by srp.ParameterDisplayValue

           

           

           

          Here is the Result I get:

           

          In my example this Shows how often a 12" or 15" Notebook ist ordered in offering "installhardwareap".

           

          edit: just add some date filters in where clause to get the amount only for a specific time (for example last month as you wrote)