I am getting the following error while creating a portlet:
Value list must not contain "" ids: .prefsFormTree.prefTree.Tests__Test_Steps__single_ select_.defaultValue
The query works fine in the KPI, but not while creating a portlet. The Mercury forums has a couple posts on this problem but no solutions (other than removing the fields your trying to select). There is nothing under Mercury KB that I found. Any help appreciated.
The Data Source is the KPI query you create. The query is:
select ?Tests.Test_Name?, ?Tests.Scripting_Status?, ?Tests.Status?, ?Tests.Execution_Status?, ?Tests.Test_Execution_Date?, count(*)
group by ?Tests.Test_Name?, ?Tests.Scripting_Status?, ?Tests.Status?, ?Tests.Execution_Status?, ?Tests.Test_Execution_Date?
Its failing on the Test_Execution_Date field. I created the Test_Execution_Date entity which maps to the TS_VTS field in the TEST table. If I remove this field it works fine in both the query & portlet. I'm confused as to why it would work with the query, but fail in the GUI portlet portion of the dashboard?
I have the same trouble. But no solution at all.
I have tried using real field names (BG_USER_18) or not (?Defects.ProjectName?).
Testing Kpis give me results, but not able to create a any portlet based on this KPis [img]/images/graemlins/frown.gif[/img]
Does someone has any idea ?