How to get Enumeration Value for an RTC Attribute in RPE
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
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
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.