It's all about the answers!

Ask a question

RRC OSLC Query with dc:created field.


Akshansh Khare (5678) | asked Feb 02 '12, 8:10 a.m.
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

3 answers



permanent link
Andy Berner (61127) | answered Feb 20 '12, 11:05 p.m.
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

Comments
Moti Wertheimer commented Nov 23 '14, 10:54 a.m.
JAZZ DEVELOPER

Thanks. your post helped me a lot.

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


permanent link
Akshansh Khare (5678) | answered Feb 02 '12, 9:01 a.m.
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

permanent link
Akshansh Khare (5678) | answered Apr 11 '12, 10:39 a.m.
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

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.