It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,884
×12,011

question asked: Nov 06 '13, 12:08 p.m.
question was seen: 3,779 times
last updated: Nov 12 '13, 1:56 p.m.

Related questions

Is it possible to query on a custom attribute?

0
adam krumholz (1●1●1) | asked Nov 06 '13, 12:08 p.m.

I am currently building a set of queries using the RTC REST API.  Below is the query that is giving me trouble.  I have added carriage returns for readability.

If i remove the mediumStringExtensions from the filter portion of the query data is returned and the product application structure is returned.

e.g.

<mediumStringExtensions>

<key>com.ak.adt2.workitem.attribute.productapplication</key>

<helperId>_TTqPsSzYEeMzHuEstN_GtQ</helperId>

<value>Reporting system V1</value>

<numericValue>0.0</numericValue>

</mediumStringExtensions>

 

When I add the filter mediumKeyExtensions to the query I get an error. Is it possible to query on a custom attribute that is used to populate a dropdown combo box?  Is this a syntax issue?

 

 

https://adam.kaye.com/ccm/rpt/repository/workitem?fields=workitem/workItem

               [

                              modified > 2013-10-24T10:10:53.000-0500

and

               mediumStringExtensions[key="com.ak.adt2.workitem.attribute.productapplication"]/Value = "Reporting System V1"

               ]/

               (

                              id|

                              creationDate|

                              mediumStringExtensions[key="com.ak.adt2.workitem.attribute.defecttype" or

                              key="com.ak.adt2.workitem.attribute.productapplication"]|mediumStringExtensions/*

               )

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Brian Fleming (1.6k●1●19●28) | answered Nov 07 '13, 4:07 p.m.
What is the error you are getting?  Based on the lack of response to:
https://jazz.net/forum/questions/104578/is-there-a-way-to-filter-a-reportable-rest-url-by-the-value-of-a-custom-attribute
and the discussion in 158711 I do not think its possible to filter a REST query by a custom attribute.
Comments
adam krumholz commented Nov 12 '13, 10:53 a.m.

I am getting the following error: 

Error 500: CRRED0122E: Illegal syntax in fields argument: ].
Brian Fleming commented Nov 12 '13, 1:56 p.m.

That error indicates your query is not structured properly, but its hard to tell what your original query was given the formatting above.  When I try this query:
https://<hostname>:<port>/<contextroot>/rpt/repository/workitem?fields=workitem/workItem[mediumStringExtensions/key="a"]/id

I get this error:
Error 500: CRRED0135E: Illegal filter.  The field &#39;workitem/mediumStringExtensions/key&#39; may not be used in a filter because it returns multiple values.

Your answer

Register or 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.