How to find all published notes?

Features
1

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

2

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.

    • Locate the Database:

      • Windows: %APPDATA%\Joplin\database.sqlite
      • macOS: ~/Library/Application Support/Joplin/database.sqlite
      • Linux: ~/.config/joplin-desktop/database.sqlite

    • 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).

      SELECT id, title, notebook_id, updated_time, is_shared
FROM notes
WHERE is_shared = 1
ORDER BY updated_time DESC;
      • This lists all published notes with their ID, title, parent notebook ID, and last updated time.

Thanks grok for this.

1 Like