Reportable Rest API to return only 2 specific custom fields

Pallavi Deore (38●1●27) | asked Jun 13 '22, 8:42 a.m.
edited Jun 13 '22, 8:45 a.m.

Hello All,

We need to fetch 2 custom fields from ibm rtc so I tried to access that using belows urls:

https://localhost:9443/ccm/rpt/repository/workitem?fields=workitem/workItem[id=12460]/(id|summary|type/name|(allExtensions[key=%27Test1%27]/(displayName|displayValue|itemValue/))|(allExtensions[key=%27Test2%27]/(displayName|displayValue|itemValue/)))

Above url return only Test2 custom field

and

https://localhost:9443/ccm/rpt/repository/workitem?fields=workitem/workItem[id=12460]/(id|summary|type/name|allExtensions/(displayName|displayValue|itemValue/*))

Above url returns all custom fields.

But How to get only 2 custom fields using reportable api.

Thanks and Regards

Pallavi Deore

Comments

Ralph Schoon commented Jun 13 '22, 10:01 a.m.

FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

I would try to change the filter in the allExtensions or even in the results e.g. something along the lines of

[key='Test1' or key='Test2']

e.g.

Check the examples at the bottom for how the selection/filters work.

Accepted answer

permanent link

Subramanya Prasad Pilar (4.6k●1●4) | answered Jun 13 '22, 2:43 p.m.

You can use or in the filter to include more than one custom attribute.

You can use the following:

https://<server>:9443/ccm/rpt/repository/workitem?fields=workitem/workItem[id=12460]/(id|summary|type/name|allExtensions[key='Test1' or key='Test2']/(key|displayName|displayValue|itemValue))

Alternately, you can use

https://<server>:9443/ccm/rpt/repository/workitem/workItem/id/12460?fields=workitem/workItem/(id|summary|type/name|allExtensions[key='Test1' or key='Test2']/(key|displayName|displayValue|itemValue))

Pallavi Deore selected this answer as the correct answer

It's all about the answers!

Related questions

Reportable Rest API to return only 2 specific custom fields

Accepted answer

Your answer