-
SQL querry to get date and time of creation of a document
2024-07-30 22:25@Wetoria I tried also by using the sql command you provided but nothing is displaying I only have error 'Search content block does not exist'
here is what I have in my template{{ SELECT created, updated from blocks where id = '.action{.id}';}}
I tried something else with by creating a database with the properties key with the document and then 2 columns with created time and updated time
But I could not find a way do to do it in a template
Any Idea ? -
SQL querry to get date and time of creation of a document
2024-07-28 21:40Hi,
Thanks for your reply.
Indeed I would like a query in the document that refresh itself automaticaly.
Can I get the document id only with a template function or is the there variable I can use in the query ?Where can I get the document id ?