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> |
2 answers
David Honey (1.8k●1●7)
| answered Apr 02 '19, 9:25 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Have you tried including "oslc:archived=false" to your query?
|
Geoffrey Clemm (30.1k●3●30●35)
| answered Apr 02 '19, 11:50 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER The "delete" for a work item should be destructive, so that no remnant of that work item exists in the repository for retrieval in any fashion, including by a query. If you have deleted a work item, and it is still accessible via a query, then that is a bug that should be reported. |
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.
Comments
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.
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.