OSLC query to fetch workitem that have not been soft deleted.
Hi,
We want to fetch WorkItems from RTC that have not been deleted from the UI and created between specific time interval.
Currently we are using the OSLC query: <o:p> </o:p>
This query fetches both types of WorkItems, valid and deleted ones. <o:p> </o:p>
Kindly let us know how to fetch only the valid, non-deleted WorkItems. <o:p> </o:p>
Thanks, <o:p> </o:p>
Sanjeet <o:p> </o:p>
Comments
Lawrence Smith
JAZZ DEVELOPER Mar 29 '19, 12:50 p.m.Can you clarify how the delete of the work items was performed? There is not a "soft delete" for work items so the items are removed from the repository when they are deleted using the user interface, which is enabled by permissions and JazzProjectAdmins or JazzAdmin repository role.
Sanjeet Pattnaik
Apr 01 '19, 4:51 a.m.The ISSOFTDELETED column is used to check the validity, here as the value is 0 only the non-deleted workitems are fetched. For example, in report builder we write:-
SELECT DISTINCT T1.PROJECT_NAME,T1.URL AS URL1, T1.REQUEST_TYPE FROM RIDW.VW_REQUEST T1 WHERE T1.PROJECT_ID=85 AND (T1.REQUEST_TYPE='ADT Task') AND T1.ISSOFTDELETED=0 AND (T1.REQUEST_ID <> -1 AND T1.REQUEST_ID IS NOT NULL
So, we wanted to know if the same SQL query can be converted to OSLC query.