Grist workspace as subfolder in /docker/grist/persist/docs/as-workspace-name

Grist Feedback
4

Ah, I see. No, neither team names nor workspace names map onto directories on disk. They can both be retrieved from the database though. For example this query:

$ sqlite3 --json landing.db "select docs.id as docId, workspaces.name as workspace, orgs.name as team from docs \
  left join workspaces on workspaces.id = docs.workspace_id \
left join orgs on orgs.id = workspaces.org_id"

will report workspace names and team site names for all documents, which could then be soft-linked into directories as you wish by a small script:

[{"docId":"sample_1","workspace":"Horizon","team":"NASA"},
 {"docId":"sample_2","workspace":"Horizon","team":"NASA"},
 {"docId":"sample_8","workspace":"Trees","team":"Primately"},
 {"docId":"sample_12","workspace":"Deep","team":"Abyss"},
 {"docId":"sample_20","workspace":"Tailor Made","team":"Shiny"},
 ...]
1 Like