Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How can I filter workitems in RPE based on more than one approval's title?

Questions
Tags
Users
Badges
Timothy Distel
(73●3●56) Aug 02 '19, 1:18 p.m.

 Hello, I am using CLM 6.0.6.


I want to return a subset of workitems from my RTC workitems data source. I tried using the native filter, but it seems to be a restriction as I got an error detailing an illegal filter because it returns more than one value. Therefore, I've moved to the RPE filter. I'm not very experienced with RPE filters, but I thought mine would work.

 

The subset of workitems I want: Workitems with EITHER (approval descriptor name "Title1" and cumulative state name "Rejected") OR (approval descriptor name "Title 2" and cumulative state name "Rejected")

 


Can anyone tell me what needs to change in my template/filter to apply this logic correctly? Any help is appreciated.

0 votes

2 answers
2,173 views
0 votes

Accepted answer

Permanent link
Subramanya Prasad Pilar
(4.6k●1●6) Aug 05 '19, 3:31 a.m.
Hi Timothy,

Can you try using cumulativeStateIdentifier instead of cumulativeStateName?
Note that some properties in RTC are not allowed/supported in filtering. For example, you cannot filter work items by the type name, but you can filter on type/id rather. Same with state/name or severity/name.
Timothy Distel selected this answer as the correct answer

0 votes

Comments
Timothy Distel
Aug 07 '19, 10:58 a.m.

Prasad,


I take this to mean that it is not supported currently; filtering work items in RPE by approvalDescriptor name, is this true? That instead I must use the approvalDescriptor ID which is not a UUID for the approvalDescriptor and only differentiates the order of approvals on the work item?

Also, is there some resource that documents what fields are available for things like filtering and what fields aren't? I looked in the REST API documentation for RTC, but couldn't find anything

Subramanya Prasad Pilar
Aug 07 '19, 2:33 p.m.
Yes. You can confirm this by trying the URL with filter in a browser. You should get
HTTP Status 500 - CRRED8022E: Non Queryable Field:

Unfortunately, there is no documentation aside from the wiki.


One other answer

Permanent link
Sean F
(1.3k●2●52●162) edited
Aug 03 '19, 10:39 a.m.
Hi Timothy,

Where is it getting the values for AprovalTitle1 and ApprovalTitle2? Are they external variables? If so have they been selected on the Variables tab?


Same questions for the variables cumulativeStateName and ApprovalState ?

Maybe try debugging it with hardwired strings before using the variables.

Also you don't need to repeat the cumulativeStateName = ApprovalState twice. You can just apply that condition once to make the expression simpler to debug, like this:-

cumulativeStateName == "Rejected" && (name == "Title1" || name == "Title2")


0 votes

Your answer

Register or log in to post 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,024

Question asked: Aug 02 '19, 1:18 p.m.

Question was seen: 2,173 times

Last updated: Aug 07 '19, 2:33 p.m.

Confirmation Cancel Confirm