Query to show Technician leave details (MSSQL & PGSQL)

Query to show Technician leave details (MSSQL & PGSQL)

Tested in build PGSQL (14300) and MSSQL (14306)


select au.first_name "Technician", ltd.name "Leave type", longtodate(du.leavedate) "Leave date", ta.comments "Leave Comments" from techunavailability ta
left join aaauser au on au.user_id=ta.technicianid
left join leavetypedefinition ltd on ltd.leavetypeid=ta.leavetypeid
left join dateunavailability du on du.leaveid=ta.leaveid
where du.leavedate >= <from_thisquarter> and du.leavedate <= <to_thisquarter>
order by 1

                  New to ADSelfService Plus?