laguill
Follow
#2156 2024-07-25 04:58:24 Join
55
Home View
38m20s
Online time
  • 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:40

    Hi,
    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 ?