# How to find all published notes?

**URL:** <https://discourse.joplinapp.org/t/how-to-find-all-published-notes/47481>\
**Category:** Features\
**Created:** [5 October 2025 16:16 UTC](https://discourse.joplinapp.org/t/how-to-find-all-published-notes/47481 "2025-10-05T16:16:40Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![antonio-slog](https://avatars.discourse-cdn.com/v4/letter/a/f6c823/32.png) [@antonio-slog](https://discourse.joplinapp.org/u/antonio-slog)\
**Post date:** [5 October 2025 16:16 UTC](https://discourse.joplinapp.org/t/how-to-find-all-published-notes/47481/1 "2025-10-05T16:16:40Z")

</div>

Hello all,  
Is there a way to find all published notes in one shot? It would be fine to have a menu item (published notes) somewhere on the desktop /mobile app.  
TIA  
Tony

---

<div class="post-metadata">

**Author:** ![\_vg](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/_vg/32/27067_2.png) [@\_vg](https://discourse.joplinapp.org/u/_vg)\
**Post date:** [5 October 2025 17:21 UTC](https://discourse.joplinapp.org/t/how-to-find-all-published-notes/47481/2 "2025-10-05T17:21:09Z")

</div>

You can query the SQLite Database (Recommended for Full List): Joplin stores data in a local SQLite database, and published notes have `is_shared = 1` in the `notes` table. This is a quick SQL query—no extra tools needed.

1. 
  - **Locate the Database** :

  - **Run the Query** :  
Use any SQLite tool (e.g., DB Browser for SQLite—free download) or command line (`sqlite3 database.sqlite` if you have SQLite installed).

Thanks grok for this.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex028/uploads/cozic/original/3X/1/c/1c948e33314e232a0927789508474d8624f4270b.png) [@system](https://discourse.joplinapp.org/u/system)\
**Post date:** [30 September 2026 17:22 UTC](https://discourse.joplinapp.org/t/how-to-find-all-published-notes/47481/3 "2026-09-30T17:22:02Z")

</div>

This topic was automatically closed 360 days after the last reply. New replies are no longer allowed.