[Libreoffice-bugs] [Bug 105039] "Analyze SQL command" help should probably refer to "Filter" and "Sort" form properties, rather than "Content list box" property.

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105039

Xisco Faulí  changed:

   What|Removed |Added

 Status|ASSIGNED|NEW
   Assignee|kelem...@ubuntu.com |libreoffice-b...@lists.free
   ||desktop.org

--- Comment #6 from Xisco Faulí  ---
Dear developer,
This bug has been in ASSIGNED status for more than 3 months without any
activity. Resetting it to NEW.
Please assigned it back to yourself if you're still working on this.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105039] "Analyze SQL command" help should probably refer to "Filter" and "Sort" form properties, rather than "Content list box" property.

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105039

Xisco Faulí  changed:

   What|Removed |Added

 CC||xiscofa...@libreoffice.org
   Assignee|libreoffice-b...@lists.free |kelem...@ubuntu.com
   |desktop.org |
 QA Contact|kelem...@ubuntu.com |

--- Comment #5 from Xisco Faulí  ---
Adjusting Assignee...

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105039] "Analyze SQL command" help should probably refer to "Filter" and "Sort" form properties, rather than "Content list box" property.

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105039

--- Comment #4 from Howard Johnson  ---
Hi again,

I remember how baffled I was when I first encountered this stuff in early
Access versions many years ago. It is the first big thing that is quite
different in Base from say, a spreadsheet.  So I feel it is very important to
help the new user quickly understand this data setup, as being so fundamental
to using forms and subforms.  I want more people to use Base.  So I want it to
be easier to use.  

I suppose there are three ways that this all could be more clear:


1) First, I think the name `Analyze SQL command` could be more to the point. 
Is it possible to rename it to `Enable Filter and Sort`?  (BTW. MS Access calls
this same feature `Enable Filter`.)  I would think this would be the first,
best way to improve overall clarity.


2) But failing that, is there some way to produce a hover mode flyout help
message explaining this property better, i.e. saying that what it actually does
is: enable the Filter and Sort properties?


3) Or failing even that, there might be better F1 help.  See my specific
suggestions below.  Also I think the F1 help needs usage examples.  I suggest
you give a few examples for each and every one of these parameters.  I think
people learn much more quickly from examples than from explanations.


Here is what I suggest for help verbiage:




---
Content type

To select the data your form will operate on, select a `Content type` and then
specify a related `Content`.  Later you can also possibly specify a Filter
criteria and/or Sort specification.  Content types:

Table/View - To read or write to a Table or View, set `Content type` to `Table`
and `Content` to a table or view's name.

Query - To read or write to a query, set `Content type` to `Query` and
`Content` to a query's name.

SQL - To read or write to a data set described by a SQL statement, set `Content
type` to `SQL` and `Content` to the actual SQL code to specify the data set.

Examples:
Content type Table
ContentPayroll

Content type Query
Content Payroll query

Content type SQL
Content ( SELECT FirstName, LastName FROM Payroll )


Notes:

* If you wish to create or write records, any table needs to be writeable, and
any query or SQL needs to be updatability.

* Each Form and SubForm has it's own independent (but possibly overlapping)
data set.  A SubForm's data set is often linked to its parent's form with
special criteria which filter a subset of the SubForm's data.

* See also: `Filter` and `Sort`

* If using a SubForm see also:  `Link Master Fields`, and `Link Slave Fields`. 
These engage additional selection criteria dependent on the parent's form.




---
Content

See Content type above.




---
Filter


(Note: at the moment I'm not seeing any help for Filter when I click F1 on it)


Enter any criteria desired to limit the data read via Content Type and Content.
 Format of this criteria is the same as for a SQL WHERE statement. 

This is only one of two possible filter stages, the other one being a subform
link that produces it's own, additional data filtering so that a subform can
respond to what is selected in a master form.

Example:

FilterFirstName='Fred'


See also: `Content type` and SubForm linking via `Link master fields`, and
`Link slave fields`.




---
Sort

"Specifies the conditions to sort ..." etc.  (Good enough I think, but pls add
a usage example:).

Example:

SortFirstName, LastName DESC





---
Thanks guys!

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105039] "Analyze SQL command" help should probably refer to "Filter" and "Sort" form properties, rather than "Content list box" property.

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105039

Gabor Kelemen  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED
 QA Contact||kelem...@ubuntu.com

--- Comment #3 from Gabor Kelemen  ---
I played a bit with this dialog:

The ... button next to the "Content" list box is not activated when "Analyze
SQL command" is set to Yes (or even to No).
Instead the "Content type" needs to be set to "SQL command" for that.
Setting "Analyze SQL command" to No makes the Filter and Sort field inactive,
this could be mentioned in the help of this command.

Also the text for "Content type" ends with this "not exactly true" sentence:
"You can then enter the statement for the SQL query or the subform directly in
the List content box on the Control properties Data tab page." - as in, there
is no "List content box", this should be "Content list box" too.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105039] "Analyze SQL command" help should probably refer to "Filter" and "Sort" form properties, rather than "Content list box" property.

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105039

Gabor Kelemen  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

--- Comment #2 from Gabor Kelemen  ---
That should be the "Content" listbox, above "Analyze SQL command".

At the very least a bit of emphasis could be added :).

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105039] "Analyze SQL command" help should probably refer to "Filter" and "Sort" form properties, rather than "Content list box" property.

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105039

--- Comment #1 from Howard Johnson  ---
Created attachment 130083
  --> https://bugs.documentfoundation.org/attachment.cgi?id=130083=edit
Form properties dialog

Here's where the F1 help is clicked, and the Form Properties it relates to.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs