custom attributes of type Small String not displaying in JRS report
![]()
In our JRS reports, adding a column for an enumeration custom attribute works, displays the attribute value. But a column for a Small String custom attribute displays nothing. A comment on https://jazz.net/forum/questions/167078/is-it-true-that-jrs-reports-do-not-support-custom-attributes/167089 says "almost all of the simple (e.g., Boolean, String, Enumeration List) and complex (e.g. Contributor, Iteration, Project Area) types are supported" but other List types are not. So, what's wrong that our string attribute does not display?
Here's the generated SQL for a simple report that displays one work item. APARName is a custom attribute of type Small String.
SELECT DISTINCT T1.REFERENCE_ID,
T1.NAME AS URL1_title,
T1.URL AS URL1,
T2_1.LITERAL_NAME
FROM RIDW.VW_REQUEST T1
LEFT OUTER JOIN RICALM.VW_RQST_STRING_EXT T2
ON T2.REQUEST_ID=T1.REQUEST_ID AND T2.NAME='aparname'
LEFT OUTER JOIN RICALM.VW_RQST_ENUMERATION T2_1
ON T2_1.EXTERNAL_ID=T2.VAL AND T2_1.PROJECT_ID=T1.PROJECT_ID
WHERE T1.PROJECT_ID = 6 AND
( T1.REFERENCE_ID = '99575'
) AND
(T1.ISSOFTDELETED = 0)
|
Accepted answer
3 other answers
![]()
Thanks Lidija. I'm able to work around the problem by editing the SQL to remove the join with RICALM.VW_RQST_ENUMERATION for string custom attributes. Here's the edited SQL for the example above:
SELECT DISTINCT T1.REFERENCE_ID,
T1.NAME AS URL1_title,
T1.URL AS URL1,
T2.VAL AS APARNAME
FROM RIDW.VW_REQUEST T1
LEFT OUTER JOIN RICALM.VW_RQST_STRING_EXT T2
ON T2.REQUEST_ID=T1.REQUEST_ID AND T2.NAME='aparname'
WHERE ( T1.REFERENCE_ID = '99575'
) AND
(T1.ISSOFTDELETED = 0)
The join with the enumeration table is removed, and the query is changed to read T2.VAL instead of T2_1.LITERAL_NAME. The same fix works for reports that have multiple string custom attributes, removing the join with the enumeration table for each string attribute.
There seems to be a defect when using the SQL editor. Validating the query sometimes displays this error:
I can avoid that error by setting an alias for each column (e.g. T2.VAL AS APARNAME). This isn't simply a case of duplicate names (e.g. T2.VAL and T3.VAL), as the error happens when there are no such duplicates.
|
![]()
That is certainly a valid workaround Greg. As for the error you are getting in the manual editor, try clicking on Validate Query button first (right above the editor in the Advanced tab) and then on Save.
|
![]()
I ran into same issue with JRS 5.0.2.
I tried setting up Aliases for all columns as well as validating the query, but it still does not work.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
Greg, what version of JRS are you on?
Version: 5.0.2