Clarity PPM

Expand all | Collapse all

sql query for approved,submitted timesheets which are posted

Jump to Best Answer
  • 1.  sql query for approved,submitted timesheets which are posted

    Posted 01-20-2020 01:11 AM
    ​​Hi ,
    can someone help me with the query to validate the approved, submitted timesheets which are posted.
    thank in advance.
    sasi


  • 2.  RE: sql query for approved,submitted timesheets which are posted
    Best Answer

    Posted 01-20-2020 02:19 AM
    Hi Sasikala

    Something to start with and you can change the where condition based on your need

     select r.full_name, tp.prstart
    from srm_resources r, prtimeperiod tp,
    prtimesheet ts left join prtimeentry te
    on ts.prid = te.prtimesheetid
    where r.id = ts.prresourceid
    and ts.prtimeperiodid = tp.prid
    and ts.prstatus = 1-- submitted
    and tp.prisopen <> 0
    group by r.full_name, tp.prstart

    Also you can refer to the ER diagram for clarity http://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm-on-premise/15-7-1/reference/clarity-ppm-entity-relationship-diagrams-erd.html

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------



  • 3.  RE: sql query for approved,submitted timesheets which are posted

    Posted 01-20-2020 03:19 AM
    thank you Suman.


  • 4.  RE: sql query for approved,submitted timesheets which are posted

    Posted 01-21-2020 08:41 AM
    Just want to note that only approved timesheets should be posted.
    Posted timesheets have prtimesheet.prstatus=4