Report Builder: How can I define which column can be filtered in the widget? (RQM)
Hi
I created a query in Report Builder and want to define "where" by the filter on the widget itself. So I can use the report in dashboards and user can select their filters by their needs.
Is this possible and how?
For example this query, I want that the user can set the masterplan in the widget by filter:
SELECT DISTINCT TP.NAME AS URL2_title,
TP.REFERENCE_ID AS TestPlanId,
TP.URL AS URL2,
TMA.NAME
FROM RIDW.VW_TESTPLAN TMA
INNER JOIN RIDW.VW_TESTPLAN_TESTPLAN_HIERARCHY TH
ON (TMA.TESTPLAN_ID = TH.PARENT_TESTPLAN_ID)
INNER JOIN RIDW.VW_TESTPLAN TP
ON (TP.TESTPLAN_ID = TH.CHILD_TESTPLAN_ID)
WHERE TMA.PROJECT_ID = 1 --AND TMA.NAME = 'MasterPlan1'
AND TP.ISSOFTDELETED = 0 AND (TP.TESTPLAN_ID <> -1 AND TP.TESTPLAN_ID IS NOT NULL)
I can select these columns for filter url2_title, testplanid and url2, but "TMA.NAME" doesn't appear. Also if I use an As for TMA.Name, it's not in the filter.
Why I can not set the testplan name by filter?
Thanks for help,
Dani
*Edit
I've changed my select and replaced the name after Distinct with the TP.Reference_ID, afterwards I could select the TMA.Name in the widget filter.
Is there any bug with using the same property name in Select?