It's all about the answers!

Ask a question

Using jfs:query service to list WorkItems


Jan Roman (11) | asked Aug 31 '10, 9:15 a.m.
Hi,
As a first step I would like to list all work items from my RTC instance or just from one dashboard.

I follow this instruction http://jazz.net/wiki/bin/view/Main/JFSIndexStoreQueryAPI and after sending query:
SELECT DISTINCT $url WHERE { $url a <http://jazz.net/xmlns/wi/defects#WorkItem> }

I get empty results like:
<?xml version="1.0" encoding="UTF-8"?>

<feed xmlns="http://www.w3.org/2005/Atom">
<title>Query Results</title>
<updated>2010-08-31T12:40:34.807Z</updated>
<link rel="self" href="/jazz/query?query=SELECT+DISTINCT+%3Furl+WHERE+%7B+%3Furl+a+%3Chttp%3A%2F%2Fjazz.net%2Fxmlns%2Fwi%2Fdefects%23WorkItem%3E+%7D&size=100" type="application/atom+xml;type=feed" />
<generator>Jazz Resource Services</generator>
</feed>



I find that my work item is of type https://myserver.com/jazz/oslc/types/_DWGZAFd-Ed--ca_5H1S1Yg/task . Here is example work item got using api.
<?xml version="1.0" encoding="UTF-8"?>

<oslc_cm:ChangeRequest xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#" xmlns:oslc_disc="http://open-services.net/xmlns/discovery/1.0/" xmlns:dc="http://purl.org/dc/terms/" xmlns:opensearch="http://a9.com/-/spec/opensearch/1.1/" xmlns:oslc_cm="http://open-services.net/xmlns/cm/1.0/" xmlns:jp="http://jazz.net/xmlns/prod/jazz/process/1.0/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:oslc_qm="http://open-services.net/xmlns/qm/1.0/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:calm="http://jazz.net/xmlns/prod/jazz/calm/1.0/" xmlns:rtc_cm="http://jazz.net/xmlns/prod/jazz/rtc/cm/1.0/" xmlns:jd="http://jazz.net/xmlns/prod/jazz/discovery/1.0/" xmlns:oslc_rm="http://open-services.net/xmlns/rm/1.0/">
<rtc_cm:modifiedBy rdf:resource="https://myserver.com/jazz/oslc/users/_pdGw0Vd0Ed--ca_5H1S1Yg"/>
<dc:subject/>
<dc:modified>2010-08-30T15:27:22.584Z</dc:modified>
<rtc_cm:filedAgainst rdf:resource="https://myserver.com/jazz/resource/itemOid/com.ibm.team.workitem.Category/_j2woQI8rEd-ICI-YiPRgPw"/>
<rtc_cm:projectArea rdf:resource="https://myserver.com/jazz/oslc/projectareas/_DWGZAFd-Ed--ca_5H1S1Yg"/>
<rtc_cm:estimate/>
<oslc_cm:priority rdf:resource="https://myserver.com/jazz/oslc/enumerations/_DWGZAFd-Ed--ca_5H1S1Yg/priority/priority.literal.l1"/>
<rtc_cm:due/>
<dc:creator rdf:resource="https://myserver.com/jazz/oslc/users/__cYgAJ5LEd-cKvzrTmUMMQ"/>
<rtc_cm:startDate/>
<rtc_cm:correctedEstimate/>
<rtc_cm:timeSpent/>
<rtc_cm:plannedFor/>
<dc:created>2010-08-24T14:25:02.402Z</dc:created>
<rtc_cm:resolved/>
<rtc_cm:resolvedBy rdf:resource="https://myserver.com/jazz/oslc/users/_YNh4MOlsEdq4xpiOKg5hvA"/>
<rtc_cm:state rdf:resource="https://myserver.com/jazz/oslc/workflows/_DWGZAFd-Ed--ca_5H1S1Yg/states/bugzillaWorkflow/2"/>
<rtc_cm:ownedBy rdf:resource="https://myserver.com/jazz/oslc/users/__cYgAJ5LEd-cKvzrTmUMMQ"/>
<dc:title>ClearCase and RTC integration</dc:title>
<dc:description>Integrate ClearCase with RTC.<br/>Implement check in trigger for automatically making association between Task and check in.</dc:description>
<dc:type rdf:resource="https://myserver.com/jazz/oslc/types/_DWGZAFd-Ed--ca_5H1S1Yg/task"/>
<rtc_cm:resolution/>
<rtc_cm:foundIn/>
<oslc_cm:severity rdf:resource="https://myserver.com/jazz/oslc/enumerations/_DWGZAFd-Ed--ca_5H1S1Yg/severity/severity.literal.l4"/>
<dc:identifier>3304</dc:identifier>
<rtc_cm:subscribers oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:subscribers"/>
<rtc_cm:comments oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:comments"/>
<rtc_cm:teamArea rdf:resource="https://myserver.com/jazz/oslc/teamareas/_qtNJMH30Ed-xlPYRcuGZBw"/>
<rtc_cm:com.ibm.team.connector.ccbridge.common.act2wi.s oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:com.ibm.team.connector.ccbridge.common.act2wi.s"/>
<rtc_cm:com.ibm.team.build.linktype.includedWorkItems.com.ibm.team.build.common.link.includedInBuilds oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:com.ibm.team.build.linktype.includedWorkItems.com.ibm.team.build.common.link.includedInBuilds"/>
<rtc_cm:com.ibm.team.connector.ccbridge.common.ver2wi.s oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:com.ibm.team.connector.ccbridge.common.ver2wi.s"/>
<calm:blocksTestExecutionRecord oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/calm:blocksTestExecutionRecord"/>
<rtc_cm:com.ibm.team.workitem.linktype.textualReference.textuallyReferenced oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:com.ibm.team.workitem.linktype.textualReference.textuallyReferenced"/>
<calm:implementsRequirement oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/calm:implementsRequirement"/>
<calm:testedByTestCase oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/calm:testedByTestCase"/>
<rtc_cm:com.ibm.team.workitem.linktype.attachment.attachment oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:com.ibm.team.workitem.linktype.attachment.attachment"/>
<rtc_cm:com.ibm.team.workitem.linktype.relatedartifact.relatedArtifact oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:com.ibm.team.workitem.linktype.relatedartifact.relatedArtifact"/>
<rtc_cm:com.ibm.team.build.linktype.reportedWorkItems.com.ibm.team.build.common.link.reportedAgainstBuilds oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:com.ibm.team.build.linktype.reportedWorkItems.com.ibm.team.build.common.link.reportedAgainstBuilds"/>
<rtc_cm:com.ibm.team.workitem.linktype.relatedworkitem.related oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:com.ibm.team.workitem.linktype.relatedworkitem.related"/>
<rtc_cm:com.ibm.team.scm.svn.linkType.workItem.s oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:com.ibm.team.scm.svn.linkType.workItem.s"/>
<oslc_cm:relatedChangeManagement oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/oslc_cm:relatedChangeManagement"/>
<rtc_cm:com.ibm.team.workitem.linktype.copiedworkitem.copies oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:com.ibm.team.workitem.linktype.copiedworkitem.copies"/>
<rtc_cm:com.ibm.team.workitem.linktype.copiedworkitem.copiedFrom oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:com.ibm.team.workitem.linktype.copiedworkitem.copiedFrom"/>
<rtc_cm:com.ibm.team.workitem.linktype.blocksworkitem.blocks oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:com.ibm.team.workitem.linktype.blocksworkitem.blocks"/>
<rtc_cm:com.ibm.team.workitem.linktype.blocksworkitem.dependsOn oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:com.ibm.team.workitem.linktype.blocksworkitem.dependsOn"/>
<rtc_cm:com.ibm.team.workitem.linktype.duplicateworkitem.duplicates oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:com.ibm.team.workitem.linktype.duplicateworkitem.duplicates"/>
<rtc_cm:com.ibm.team.workitem.linktype.duplicateworkitem.duplicateOf oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:com.ibm.team.workitem.linktype.duplicateworkitem.duplicateOf"/>
<rtc_cm:com.ibm.team.filesystem.workitems.change_set.com.ibm.team.scm.ChangeSet oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:com.ibm.team.filesystem.workitems.change_set.com.ibm.team.scm.ChangeSet"/>
<calm:affectsExecutionResult oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/calm:affectsExecutionResult"/>
<rtc_cm:com.ibm.team.workitem.linktype.parentworkitem.parent oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:com.ibm.team.workitem.linktype.parentworkitem.parent"/>
<rtc_cm:com.ibm.team.workitem.linktype.parentworkitem.children oslc_cm:collref="https://myserver.com/jazz/oslc/workitems/3304/rtc_cm:com.ibm.team.workitem.linktype.parentworkitem.children"/>
</oslc_cm:ChangeRequest>


after modyfiing query to:
SELECT DISTINCT $url WHERE { $url a <https://myserver.com/jazz/oslc/types/_DWGZAFd-Ed--ca_5H1S1Yg/task> }
I am still getting empty results.


I also tried this query (from manual):
PREFIX dc: <http://purl.org/dc/elements/1.1/>

SELECT ?title ?description ?parent
WHERE {
?url dc:title ?title;
dc:description ?description;
dc:isPartOf ?parent .
}

But gets empty results as well.

As long as i know I am not able to use simpleQuery becouse in my https://myserver.com/jazz/rootservices there is no section oslc_cm:simpleQuery

On Jazz site help -> About Rational Team Concert I have those versions listed:
Jazz Foundation - Jazz Team Server: 1.0.0.2 iFix 3
Rational Team Concert: 2.0.0.2 iFix 3

Any input will be appreciated.

Be the first one to answer this question!


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.