What JQL to search for all issues that are NOT in the board of a Team-Managed Project

[Carlo Alberto Hung]

In my scenario, I'd like to move issues from a Team-Managed project to a Company-Managed one.

Within the Team-Managed one, the "backlog" feature is on, and there are issues which are in the "backlog" status, as well as in the "in progress" status that are sitting in the board and some of them that are in the same status that are sitting outside the board.

Something like this:

<BOARD>

ISSUE-01 (Backlog)

ISSUE-02 (In Progress)

<BACKLOG)

ISSUE-03 (Backlog)

ISSUE-04 (In Progress)

Obviously ISSUE-03 and ISSUE-04 won't show in the board, however, if I search for them through JQL (e.g. status = Backlog AND project = MYPROJ), they show both the issues.

Now, if I move the issues as they are, all the "backlog" issues will go within the same column and I will lose the information about what issues where selected and which where not.

In the new project (Company-Managed) I would use two different statuses, as well as I can see that if I am using a Scrum template, they have a "sprint" field that differentiate between issue in the boards or issues outside the board.

What JQL can I use to query for only the issues of that project that are NOT in the board?

[Pawel Niewiadomski · Accepted solution]

Well, if you get HTTP/404 during import I guess the URL-s you produced are wrong.

Looking at the concat you used I guess attachment_files.disk_filename is relative to the installation directory of Redmine which may be totally different than the URL Redmine is available at.

What you need to produce is a correct URL that you can use in your browser to reach the file.

[Bob Swift]

You might consider using addAttachment from JIRA Command Line Interface

[julian bankston]

Ok. I have over 1800 attachments and they have subfolders as well. For example redmine.localdomain/200, redmine.localdomain/50, redmine.localdomain/700 etc. Would it be more efficient to just create a SQL script which imports all required fields into the fileattachment table in the Jira database? I can then set the file location and move the attachments over. Thanks.

[Nic Brough -Adaptavist-]

Don't do it with SQL, there's all sorts of hassle and risks around doing it that way. I'd highly recommend either correcting your paths as Pawel suggests, or using the CLI as Bob said.

[julian bankston]

Thanks guys. I appreciate the quick responses.