Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to filter by Date using Xporter

David Meharg April 30, 2019

I'm trying to do a bulk export of all issues within a specific date range.  Interestingly, I don't see any examples of that filter type in the Xporter samples.  Any guidance what that would look like?  The current template, without a filter, reports that the results will exceed the 5000 max.  So, it looks as if I'll need to pull the data in chunks.

1 answer

1 accepted

0 votes
Answer accepted
Jimmy Van (GLiNTECH)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 30, 2019

Hi David,

Where are you exporting from? From a JQL search? If so, you can restrict by your JQL query, so try something like:

created > 2017-01-01 AND created < 2017-06-30

 and update your JQL appropriately so you don't hit the limits. Alternatively, you can filter in the Xporter template itself.

Let us know how you go

David Meharg April 30, 2019

As I'm brand new to Xporter, I found that the filter can be done at the View level in JIRA.  I've done that successfully.  I was originally thinking that I would need to apply the filter at the template level, and it seemed strange that there was no instruction on how to export all Issues between a date range.  Oh, well.  Just needed a bit more time under my belt.  It appears that the Xporter will export whatever the results are in the JIRA filter that you are viewing.

Like Jimmy Van (GLiNTECH) likes this
Jimmy Van (GLiNTECH)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 2, 2019

Glad to hear you sorted it out.

Alyssa Priddy
Contributor
June 18, 2020

I need to do this on the template side - I am creating a Word Doc template separated by due date: Past Due, Coming Due, etc. and I cannot figure out how to code it properly. I have: 

&{for issues|filter=%{'${Issue Type}'.equals(‘Key Decision’) && '${Status}'!=(‘Done') && '${DueDate}'<=(‘0d’)}}

#{if (%{${BulkIssueIndex} == 0})}

 

But it is not working.

Suggest an answer

Log in or Sign up to answer