I am attaching a PDF of SQL queries that I think are useful for AtoM users. These are collected from my personal notes (from client projects or support requests, etc) and from reviewing those threads in the User Forum with the "SQL" and "FAQ" labels to see if anything useful shared there has not yet been added to the docs.
I simply haven't had time to set up a local docs contribution environment, format these notes in reST, and prep a PR. Nevertheless, I did try to make the notes as ready as possible to be added straight to the docs with minimal effort - hopefully making this a decent first / early issue for a new contributor if desired.
For Artefactual staff, here is a link to an internal editable copy.
Relevant version
Relevant pages
Issue description
I am attaching a PDF of SQL queries that I think are useful for AtoM users. These are collected from my personal notes (from client projects or support requests, etc) and from reviewing those threads in the User Forum with the "SQL" and "FAQ" labels to see if anything useful shared there has not yet been added to the docs.
I simply haven't had time to set up a local docs contribution environment, format these notes in reST, and prep a PR. Nevertheless, I did try to make the notes as ready as possible to be added straight to the docs with minimal effort - hopefully making this a decent first / early issue for a new contributor if desired.
For Artefactual staff, here is a link to an internal editable copy.
AtoM SQL queries for docs (2024-05-03).pdf