Bug 113965 - View/Edit Table, Query, Form & Report's Date created, last edited, and comments
Summary: View/Edit Table, Query, Form & Report's Date created, last edited, and comments
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Base-UX
  Show dependency treegraph
Reported: 2017-11-21 07:27 UTC by Howard Johnson
Modified: 2019-03-15 16:42 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Example of Form properties UI (72.83 KB, image/png)
2019-03-15 16:42 UTC, Drew Jensen

Note You need to log in before you can comment on or make changes to this bug.
Description Howard Johnson 2017-11-21 07:27:31 UTC
This is for the Table, Query, Form, and Report indexes where you select which thing to open or edit.

For example, for each Base Form I think it would be very helpful to show the Form creation and last edited date to the right of a form (or by hovering over it), and also to have an area that can contain a comment to possibly say what the form is, or how it should be used, etc.  

Also the list of forms in this case should be sortable by these dates, in addition to name.
Comment 1 Buovjaga 2017-11-21 09:38:15 UTC
Alex, Robert: any insight into how this could be expressed in the UI?
The report kind of has multiple ideas, but fit into a single element, so maybe it can be kept in one piece.
Comment 2 Alex Thurgood 2017-11-23 14:42:35 UTC
I feel that this would be a worthwhile enhancement, but unfortunately am not able to help out with coding.

The comment about the form description or the way to use the form could appear as a tooltip. I believe that this is currently possible when a form is already opened and the HELP property is filled in (or is it the URL property ?). Anyway, I believe that this functionality exists at a "form open" level. Perhaps it would be possible to take the comment inserted at the form level and display it here with a right mouse button click ?

As regards the creation date, modification date, etc properies, the old template manager had a toggle view switch that allowed you to display this information, or at least part of it. It was housed in a window that showed a preview of the template. As Forms within ODB files are ODF documents, it should be possible to achieve the same thing here with toggle switch in the right hand window instead of displaying a preview of the Form (currently there is a drop down menu that allows the user to choose either "None" or "Document". Perhaps a "Properties" entry could be added here that the user could toggle to.
Comment 3 Drew Jensen 2019-03-15 16:42:19 UTC
Created attachment 150005 [details]
Example of Form properties UI

The Base UI has a place holder 'Document Information' for Form and Report items.
Presently this does not support generated dates (created, last updated, etc) but does include string properties (title, subject, comments, etc) from the Form or Report document. 

So UI wise it would perhaps make the most sense to use that existing framework and extend it to include the generated date information and expand it to include Table/View/Query Definition items also. 

The attached screen shot shows the properties displayed for a Form. (ps, you can't add properties to a form or report until it has been saved //might save you the time I just wasted to figure that out again ;-)