Is there a way to filter a reportable REST URL by the value of a custom attribute?

Brian Fleming (1.6k●1●19●28) | asked Mar 02 '13, 2:42 p.m.

workitem/workItem[stringExtensions/value="foo"]/id results in "Error 500: CRRED0135E: Illegal filter. The field 'workitem/stringExtensions/value' may not be used in a filter because it returns multiple values."

Based on the discussion in 158711 I suspect the answer is no.

I'm trying to create a document in RPE and I only want to include workitems that have a specific value set for a custom attribute. Does anyone know of another approach I could take?

2 answers

Most liked answers|Newest answers|Oldest answers ↑

permanent link

Brian Fleming (1.6k●1●19●28) | answered Mar 08 '13, 4:30 p.m.

I did not find any way to do this via REST, so used a Condition Script Expression (key == "bar" && value == "foo") in a nested query (under a workitem/workitem/stringExtensions query) within RPE to filter work items by a custom attribute key/value.

permanent link

Antoine LELEU (50●1●27●28) | answered Jun 12 '13, 7:09 a.m.

Hi Brian,

I very interested by this Post.
I 'm not sure to understand the syntaxe of the query. Please, can you write an example of this type of query.

Thanks,

Antoine

Comments

Brian Fleming commented Jun 12 '13, 11:04 a.m.

In RPE, you would create a query with a scripted filter (these are RPE terms and not REST API terms). In my example it looks like this:

It's all about the answers!

Related questions

Is there a way to filter a reportable REST URL by the value of a custom attribute?

2 answers

Your answer