How to use "oslc.where" to get filtered resutlset on the fly

Answer

Prerequisite:

• OSLCLinks package 1.2 should have been applied to the ClearQuest Schema and to the Record Type for which you want to use "oslc_cm.query".
  
  Review the Information Center Procedure to apply OSLCLinks Package for more details.
  
  
• You will need RESTClient here to illustrate the use of "oslc.where" parameter.
  
  Download the RESTClient plug-in from RESTClient, a debugger for RESTful web services.

• Check if the RESTClient is installed on your machine
  
  Click Tools > RESTClient in Firefox browser
  
  

1. Open the RESTClient as follows: Click Tools > RESTClient in Firefox browser.
   This should open a new Firefox window.
   
   
2. Click Headers > Custom Headers
   This will open a new window for a Request Header.
   
   
3. Provide the Name as OSLC-Core-Version and Value as 2.0
   
   
4. Set Method to GET in the browser
   
   
5. Type the following in the URL text box:
   
   http:///cqweb/oslc/repo//db//simpleQuery/?oslc.where=cq:State="Submitted"
   Example 1:
   
   http://LocalHost/cqweb/oslc/repo/Connection1/db/SAMPL/simpleQuery/16777…"Submitted"
   
   This URL will return all the records of Record Type Defect (DB ID for Defect Record Type is = 16777224) where State is "Submitted".
   
   
   Example 2:
   
   http://LocalHost/cqweb/oslc/repo/Connection1/db/SAMPL/simpleQuery/16777…"Submitted" and cq:Severity="High"
   
   This URL will return all the records of Record Type Defect (DB ID for Defect Record Type is = 16777224) where State is "Submitted" And "Severity" is "High".