It's all about the answers!

Ask a question

How to use Date range in RTC Expressions for Automation


Jazzuser user (68849) | 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 (63.1k33646) | 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.


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.