It's all about the answers!

Ask a question

How to use Date range in RTC Expressions for Automation


Jazzuser user (488) | asked May 09 '17, 6:50 a.m.

Hello All,

I have a usecase wherein we need to use the RTC expressions and query all the workitems whose resolution date is in the range of start date and end dates.

I have found this : https://rsjazz.wordpress.com/2012/11/19/using-expressions-for-automation/
https://jazz.net/wiki/bin/view/Main/QueryDevGuide

However in the sample code the Term has Operator.AND and Operator.OR:

Term typeinProjectArea= new Term(Term.Operator.AND);
typeinProjectArea.add(inProjectArea
);
typeinProjectArea.add(isType
);

Is there any way I can get Something like "BETWEEN" ? So that I can pass this start and end dates to the expression.

Or is there any way that for the attribute "resolution date", I can use a "between" operator ?

Request your assistance.

Thanks

Accepted answer


permanent link
Ralph Schoon (55.5k23642) | answered May 09 '17, 7:06 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

You should be able to use content assist. e.g. point the cursor before the AND and press CTRL+SPACE. Then you should see something like this (provided you followed my suggestions to set up the SDK and plain Java):






 

Jazzuser user selected this answer as the correct answer

Your answer


Register or to post your answer.