RTC Rest API: Filter workitems by specific Extension parameter
I'm trying to filter workitems by specific values in specific extension key, but all I get is the error message:
Error 500: Illegal filter. The field 'workitem/allExtensions/key' may not be used in a filter because it returns multiple values.
Here the URL I have:
https://example.com/ccm/rpt/repository/workitem?fields=workitem/workItem[projectArea/itemId=_Xpc-8HlGEeOY04eYDyuMzc and (state/id='state.s1' or state/id='state.s2' or state/id='state.s4' or state/id='state.s5' or state/id='state.s6' or state/id='state.s8' or state/id='state.s9' or state/id='state.s10') and (allExtensions/key='mode03' and allExtensions/displayValue='Default Value')]/(id|projectArea|category/name|state/(id|name)|creator/name|owner/name|resolver/name|summary|resolutionDate|creationDate|dueDate|duration|timeSpent|description|allExtensions/(key|type|displayName|displayValue))
I'm working with RTC 6.0.4