RRC OSLC Query with dc:created field.
![](http://jazz.net/_images/myphoto/bbe13abc4ddae50d70d0dba093600964.jpg)
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
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
![](http://jazz.net/_images/myphoto/bbe13abc4ddae50d70d0dba093600964.jpg)
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
![](http://jazz.net/_images/myphoto/bbe13abc4ddae50d70d0dba093600964.jpg)
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
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://jazz.net/_images/myphoto/bbe13abc4ddae50d70d0dba093600964.jpg)
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