Jazz Register Log in
Jazz Forum Welcome to the Jazz Community Forum

Welcome to the Jazz Community Forum

Connect and collaborate with IBM Engineering experts and users

How to use Date range in RTC Expressions for Automation

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

0 votes


Accepted answer

Permanent link

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

1 vote

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 10,996
× 6,141
× 458

Question asked: May 09 '17, 6:50 a.m.

Question was seen: 3,118 times

Last updated: May 09 '17, 7:06 a.m.

Confirmation Cancel Confirm