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
------------------------------
Original Message:
Sent: 01-20-2020 01:10 AM
From: Sasikala Nelli
Subject: sql query for approved,submitted timesheets which are posted
Hi ,
can someone help me with the query to validate the approved, submitted timesheets which are posted.
thank in advance.
sasi