CA PPM: Attribute Availability Rate of Resource Object is not displayed in a portlet. Also, Unable to filter on attribute Availability Rate

Document ID : KB000071376
Last Modified Date : 10/08/2018
Show Technical Document Details
Issue:
Attribute 'Availability Rate' is displayed in the Resources list, but it is not displayed in a Portlet based on Resource Object.
Also, Unable to filter on attribute "Availability Rate" in the Resources list and in the Portlet based on Resource Object.


Steps to Reproduce:
Preconditions: resources with different Availability Rates.
1.Login to clarity.
2.Go to the Resources list.
3. Click on Configure and add column Availabilty Rate.  Add Availability Rate to the Filter section
4. Save and Return
5. Click on Show All
Observe that values of Availabiltiy Rate are displayed
6. In the Filter, input values on Availability Rate (ex: 8)
 
Expected Result: 
Display only entries with Availibility Rate = 8
Actual Result: 
Display entries with all results

7. Create a custom portlet, type grid, based on Resource Object.
8. Add column Availabilty Rate. Add Availability Rate to the Filter section
9. Put the portlet in the overview page or any page
10. Click on Show All. Observe that values of Availabiltiy Rate

Actual Result: 
values of Availabiltiy Rate are not displayed
Expected Result: 
values of Availabiltiy Rate should be displayed

11. In the Filter, input values on Availability Rate (ex: 8)
 
Expected Result: 
Display only entries with Availibility Rate = 8
Actual Result: 
Display entries with all result and values in column Availabiltiy Rate are not displayed
Cause:
Caused by DE33594 and DE39173
 
Resolution:
DE33594: Won't fix. The 'Availability Rate' being a virtual attribute without read expression, it is not possible to filter on this field.

DE39173: By Design. 
The customer is using the wrong data provider.  Instead of the 'Resource' data provider, they should be using the 'Resource Availability' one. The Availability Rate is special because it is computed based on the Resource Calendars.  Therefore, a specific data provider has been developed to provide the Availability Rate.