AnsweredAssumed Answered

SQL statement to retrieve the availability field of a resource

Question asked by JoostBreggeman76041091 on Dec 13, 2015
Latest reply on Dec 13, 2015 by urmas

Hello,

 

I am looking for the query that is required to retrieve the value that is called "Availability" located on the Resource object. It's a calculated field but I like to pull it in a portlet that allows us to get a simple overview of All resources and their default availability. so, something like this. In the end I want to calculate the FTE per person

 

Resource (Jan Jansen) - 8.0 hrs availability.

 

thanks

 

Joost

Outcomes