Difficulty retrieving dates in dashboard
I am using the following query to try to retrieve dates of defect status changes in Mercury Dashboard:
SELECT A.AU_TIME as value
FROM AUDIT_LOG A, BUG B, AUDIT_PROPERTIES C
where B.BG_Bug_ID = A.AU_Entity_ID
and A.AU_ACTION_ID = C.AP_ACTION_ID
and A.AU_ENTITY_TYPE = 'BUG'
and B.BG_BUG_ID = '13'
and C.AP_Field_Name = 'BG_STATUS'
and C.AP_NEW_VALUE IN ('New', 'Closed')
It retrieves the date / timestamp correctly when i run the SQL in the QC site Admin, but when I try to execute this as a KPI in dashboard I receive the following error:
Kpi 107 data source contains value '2006-05-10 00:00:00' of incorrect type :
I believe that I need to define an entity to handle this return data, but the admin guide does not help much when i comes to actually creating the entity.
Can anyone help me with how this might be done?
Re: Difficulty retrieving dates in dashboard
I guess the reason why it doesn't work is because the KPI output can only be a int or float. The select query has the output column of date type so the KPI engine may not understand that.
try converting the output date/time column to int or add another column to display like count(*)..you can try this and check..
please update your findings..