Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RRC OSLC Query with dc:created field.

Hi All,

I am building a DOT NET C# Application using REST Services from RRC Using OSLC.
I was able to retrieve the all the requirement count for a particular project area but when I tried to get the count of the requirement count rolling 5 months I was unable to do so.

This what i am trying to do. I got the query base URL,
This is how it looks :-
https://accenture.com:9443/rm/views?oslc.query=true&projectURL=https://accenture.com:9443/jts/process/project-areas/_GLa0wkcjEeGhRrxQpZF
When i use this URL all the requirement are displayed from this particular project areas.

But when i tried to apply a filter using OSLC no result is displaying.
Here the filter URL.
https://accenture.com:9443/rm/views?oslc.query=true&projectURL=https://accenture.com:9443/jts/process/project-areas/_GLa0wkcjEeGhRrxQpZF&oslc.prefix=dc=<http>&oslc.where=dc:modified=" 2012-01-25T07:22:08.818Z"

If i try to filter it with some other element the correct result is displaying
https://accenture.com:9443/rm/views?oslc.query=true&projectURL=https://accenture.com:9443/jts/process/project-areas/_GLa0wkcjEeGhRrxQpZF&oslc.prefix=dc=<http>&oslc.where=dc:identifier=771
For the above URL the result is displayed.

The particular XML-RDF for requirement is
<xml><rdf>
<oslc_rm>
<dc>
<rdf>
<dc>This is the RQM Requirement 1</dc>
<oslc>
<oslc>
<dc>771</dc>
<dc>RQM Requirement 1</dc>
<rm_property>
<dc>2012-01-25T07:22:08.818Z</dc>
<dc>2012-01-25T07:22:08.818Z</dc>
<dc>
</oslc_rm>
</rdf>

The problem I believe is the rdf:datatype used, I have tried many P&C but none returns me the desired result.
I guess i am not using the right format to query the datetime.

Any insights will be greatly appreciated.

Akki

0 votes



3 answers

Permanent link
Hi All,

...

But when i tried to apply a filter using OSLC no result is displaying.
Here the filter URL.
https://accenture.com:9443/rm/views?oslc.query=true&projectURL=https://accenture.com:9443/jts/process/project-areas/_GLa0wkcjEeGhRrxQpZF&oslc.prefix=dc=<http>&oslc.where=dc:modified=" 2012-01-25T07:22:08.818Z"

...
The problem I believe is the rdf:datatype used, I have tried many P&C but none returns me the desired result.
I guess i am not using the right format to query the datetime.


Yes, the problem is the timestamp type....here's the right clause to use (note the punctuation and encoding, it's needed):

&oslc.prefix=dcterms=http://purl.org/dc/terms/&oslc.where=dcterms:modified>"2011-12-07T04:11:01.165Z"%5E%5Exsd%3AdateTime

Yes

1 vote

Comments

Thanks. your post helped me a lot.

Interesting that DOORS DWA doesn't need this timestamp type... 


Permanent link
I was unable to upload the right XML for the requirement as the editor is stripping out the attributes etc.
So i uploaded it as an image.

Here is a link for the image of XML of requirement.
http://i41.tinypic.com/35n67bp.jpg

http://i41.tinypic.com/35n67bp.jpg

0 votes


Permanent link
Hi All,

...

But when i tried to apply a filter using OSLC no result is displaying.
Here the filter URL.
https://accenture.com:9443/rm/views?oslc.query=true&projectURL=https://accenture.com:9443/jts/process/project-areas/_GLa0wkcjEeGhRrxQpZF&oslc.prefix=dc=<http>&oslc.where=dc:modified=" 2012-01-25T07:22:08.818Z"

...
The problem I believe is the rdf:datatype used, I have tried many P&C but none returns me the desired result.
I guess i am not using the right format to query the datetime.


Yes, the problem is the timestamp type....here's the right clause to use (note the punctuation and encoding, it's needed):

&oslc.prefix=dcterms=http://purl.org/dc/terms/&oslc.where=dcterms:modified>"2011-12-07T04:11:01.165Z"%5E%5Exsd%3AdateTime

Yes

Hi Andy Berner,

Thanks a lot for your reply, I finally got it working.

Regards
Akshansh Khare

0 votes

Your answer

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

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Feb 02 '12, 8:10 a.m.

Question was seen: 7,440 times

Last updated: Nov 23 '14, 10:54 a.m.

Confirmation Cancel Confirm