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



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.