How to get Enumeration Value for an RTC Attribute in RPE

Ben Sharples (81●22●53) | 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

Most liked answers ↓|Newest answers|Oldest answers

permanent link

Subramanya Prasad Pilar (4.6k●1●4) | 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.

It's all about the answers!

Related questions

How to get Enumeration Value for an RTC Attribute in RPE

One answer

Your answer