It's all about the answers!

Ask a question

How to get Enumeration Value for an RTC Attribute in RPE


Ben Sharples (811647) | asked Dec 10 '15, 5:25 a.m.
I see to be having problems extracting enumerated values for my RTC attributes in my RPE Template.

Template snippet below:

My URI for the template is a filter on a specific Workitem ID so is of the form:
https://greygloom.outer.stellar.local:9443/ccm/rpt/repository/workitem?fields=workitem/workItem[id=3289]/*/*/*/*/*

The filter on workitem/workItem/allExtensions is: key == RTC Attribute ID
The filter on workitem/projectArea/enumerations/literals is: workitem/workItem/allExtensions/smallStringValue_value == workitem/projectArea/enumerations/literals/id

I am getting a positive return against query $121 and $128 but $129 returns nothing.

One answer



permanent link
Subramanya Prasad Pilar (4.5k14) | answered Dec 10 '15, 6:39 a.m.
edited Dec 10 '15, 6:44 a.m.
Are you using Native Filter or Scripted Filter? What is the URL you provide while configuring data source? (You can only set https://greygloom.outer.stellar.local:9443/ccm/rpt/repository/workitem/workItem/id/3289 and need not append fields filtering since RPE does it automatically).

Do you see the output if only key == RTC Attribute ID filter is used?

You can also create a Special Attribute and use it in the template.


If you can share the template, I can check why it is not working.

Comments
Ben Sharples commented Dec 11 '15, 2:14 p.m.

Its not letting me paste the screen shot of my RPE file, or up-load the image file currently.
I'll describe in detail my containers and the queries on them.

Container 1:
Query: workitem/workITem/allExtensions
Scripted Filter on the container is: key == "applicable_variant", where 'key' is from allExtensions and 'applicable_variant' is the ID of my RTC custom enumerated attribute

Container 2: Child of container 1
Query: workiten/workITem/allExtensions/smallStringValue
Data Assigment: Debug - Test, where Debug is a variable I have created in RTC to check data is being returned from the query

Container 3: Child of container 2
Query: workitem/projectArea/enumerations/literals
Data Assignment: Debug2 - Test2

Container 4: Child of container 3
Query: workitem/projectArea/enumerations/literals/name
Scripted filter on the container: _value = id, where '_value' is from smallStringValue and 'id' is from enumerations/literals
Data Assignment 1: Debug 3 - Test3
Data Assignment 2: RTC_ApplicableVariant - workitem/projectArea/enumerations/literals/name/_value.

Your answer


Register or to post your answer.