Follow
Time Off/PTO Reports

Reporting PTOs 

Users can review their and others' PTOs and Time offs via creating a User or Schedule type Reports in WF. The following Text Mode codes can return data about different types of non-working days available in Workfront. 

Textmode codes for Time off.

This code will show the non-working days as specified in the schedule: 

1. For a Schedule type Report

displayname=Non work dates (holidays)
listdelimiter=<br>
listmethod=nested(nonWorkDays).lists
textmode=true
type=iterate
valueexpression={nonWorkDate}
valueformat=HTML

 

 

2. For a User type Report 

displayname=Non work dates (holidays)
listdelimiter=<br>
listmethod=nested(schedule.nonWorkDays).lists
textmode=true
type=iterate
valueexpression={nonWorkDate}
valueformat=HTML

 

 

This code will show the non-working days as specified in the Time Offs page on the User's landing page.

3. For User type Report

listdelimiter=<br>
listmethod=nested(reservedTimes).lists
name=Reserved Times
textmode=true
type=iterate
valueexpression=CONCAT({startDate}," - ",{endDate})
valueformat=HTML

 

This code will alter the code above to only show the future non-working days as specified in the Time Offs page on the User's landing page.

4. For User type report - FUTURE Time off

valueformat=HTML
listdelimiter=<br>
textmode=true
valueexpression=IF({endDate}<$$TODAY,"",CONCAT({startDate}," - ",{endDate}," "))
type=iterate
listmethod=nested(reservedTimes).lists
displayname=Time Off

 

Here is also a textmode code that will give you the hours for the time off for users. 

valueformat=HTML
listdelimiter=<br>
textmode=true
valueexpression=IF({endDate}<$$TODAYe+1w,"",DIV(WORKMINUTESDIFF({endDate},{startDate}),60))
type=iterate
listmethod=nested(reservedTimes).lists
displayname=Vacation Hours