For the SQL experts:
I would like to realize an editorial plan on a page. We are keeping drafts of blog posts in certain spaces. I need to have a list or table with all blog posts of one or multiple of these spaces with following details
- title
- create date
- create user
all this could be done easily with macros, I know. But for the planning page I need to have a comment or note field or addition to each line which can be modified using the Confluence editor. When I try with macros I see no chance achieving this. Also inline comments are not working in macros providing the info above.
I was hoping this could be possible using SQL in any way. I also have the PocketQuery Plugin available for use. This way I can display any Query result on a page with a macro - but how can I add some kind of editable field per item?
Is this even possible? Thanks :)
