In order to implement this feature, we need to think about how to include notes in CSV.

My idea:
|_. # |_. Tracker |_. Status |_. Priority |_. Subject |_. Assignee |_. Updated |_. Note-# |_. Notes |
| 3 | Bug | New | Normal | Private issue on public project | | 09/08/2020 01:40 PM | | |
| 3 | | | | | | | 1 | test1 |
| 3 | | | | | | | 2 | test2 |
| 3 | | | | | | | 3 | * test3
* test4|
| 2 | Bug | New | Low | Subproject issue two | | 09/01/2020 11:27 AM | | |
| 1 | Bug | New | Low | Cannot print recipes |User name| 09/02/2020 11:27 AM | | |
| 1 | | | | | | | 1 |The quick brown fox jumps over the lazy dog |
| 1 | | | | | | | 2 | Some notes with Redmine links: #2, r2. |

I've added a column called Note- # to make note sorting work.
For a issue with the same id: 3, there are 4 lines with 1 line of ticket information + 3 lines of notes.
--------------------------------------------------------------------------------
Mizuki ISHIKAWA wrote:
> In order to implement this feature, we need to think about how to include notes in CSV.
>
> My idea:
> |_. # |_. Tracker |_. Status |_. Priority |_. Subject |_. Assignee |_. Updated |_. Note-# |_. Notes |
> | 3 | Bug | New | Normal | Private issue on public project | | 09/08/2020 01:40 PM | | |
> | 3 | | | | | | | 1 | test1 |

I think an additional column that represents the user who wrote the note (stored as @journals.user_id@) is necessary.
--------------------------------------------------------------------------------
Go MAEDA wrote:
> I think an additional column that represents the user who wrote the note (stored as @journals.user_id@) is necessary.

And it is better to have @journals.created_on@ and @journals.private_notes@.
--------------------------------------------------------------------------------
I have created a draft patch for people to try out this feature. I have not written any tests.
If you output CSV from issues list and check "All notes" checkbox, notes related information will be added to CSV.
"All notes" checkbox is available only for CSV output.
!{width: 300px; border: 1px solid #ccc}screenshot.2021-09-02-13.59.56.png!

Feedback is very welcome!
--------------------------------------------------------------------------------
I'm attaching a patch that improves draft.patch.
Once this feature is implemented, it will be possible to easily retrieve note information without using the API.
--------------------------------------------------------------------------------
I attached is a sample csv that outputs the issues and journal notes created by @rake db:fixtures@.
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------