I want to get the work items resolved on specific date and time using RTC query.
Hello,
I want to fetch the ALM workitems resolved on a specific date and time using RTC query.
But when I am querying, I am getting the query result only based on the Date value. Time is ignored.
Kindly provide your insights on fetching ALM workitems resolved on a specific date and time using RTC query.
Please find below sample code snippet used for querying.
java.sql.Timestamp timestampTill = new java.sql.Timestamp(calendar.getTime().getTime());
IQueryableAttribute resolutionDateAttribute = QueryableAttributes.getFactory(IWorkItem.ITEM_TYPE)
.findAttribute(projectArea, IWorkItem.RESOLUTION_DATE_PROPERTY, iauditableCommon, progressMonitor);
Expression resDateTillExp = new AttributeExpression(resolutionDateAttribute, AttributeOperation.BEFORE, timestampTill);
Term queryTerm = new Term(Term.Operator.AND);
queryTerm.add(resDateTillExp);
queryResult = queryClient.getResolvedExpressionResults(projectArea, queryTerm, IWorkItem.FULL_PROFILE);
Please let me know if there is any other ways we can fetch the workitems based on Date and time value.
Term queryTerm = new Term(Term.Operator.AND);
queryTerm.add(resDateTillExp);
queryResult = queryClient.getResolvedExpressionResults(projectArea, queryTerm, IWorkItem.FULL_PROFILE);
Please let me know if there is any other ways we can fetch the workitems based on Date and time value.
Thanks in advance,
Sneha Bhaskar
Sneha Bhaskar