[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Commented: (OFFICE-2789) 19.275 "The filteris conjunctively added..." ? How is "conjunctively added" different from"added?"
[ http://tools.oasis-open.org/issues/browse/OFFICE-2789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=20106#action_20106 ]
Patrick Durusau commented on OFFICE-2789:
-----------------------------------------
Andreas,
OK, well, its not the am but I have been thinking about this one. Not happy where I have come out.
Start with <form:form>, there are two relevant attributes:
19.253 form:apply-filter (this says whether or not to apply form:filter) - But its language is interesting:
"The form:apply-filter attribute specifies whether the filter clause specified by the form:filter attribute is applied to the SQL command constituting the form's result set. 19.275
The defined values for the form:apply-filter attribute are:
false: the filter clause specified by the form:filter attribute is not applied to the SQL command constituting the form's result set.
true: the filter clause specified by the form:filter attribute is applied to the SQL command constituting the form's result set."
OK, but an SQL command is *not* a result set. It can lead to a result set but it isn't a result set per se.
19.275 form:filter says (in full):
"The form:filter attribute specifies a filter. The filter is conjunctively added to any existing filter. The resulting filter forms a SQL "WHERE" clause, without the "WHERE" keyword.
The filter is only applied if the form:apply-filter attribute has the value true. 19.253.
Note: This allows OpenDocument consumers to toggle a filter on and off without loosing the content of the form:filter attribute."
I won't be a precise as Dennis but walk with me through this:
19.258 form:command - specifies a command to execute on a data source
19.259 form:command-type - command can be command (SQL), query, table
It looks like operation with form:apply-filter and form:filter depend upon SQL results but suspect it was meant to operate in the other two cases as well.
That is there is a "filter" (or query) if you like, to which the form:filter condition was applied/not applied to achieve the "toggling" described in the note.
Suggestions for what we need to define or say to straighten this out welcome!
> 19.275 "The filter is conjunctively added..." ? How is "conjunctively added" different from "added?"
> ----------------------------------------------------------------------------------------------------
>
> Key: OFFICE-2789
> URL: http://tools.oasis-open.org/issues/browse/OFFICE-2789
> Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
> Issue Type: Bug
> Components: Table
> Affects Versions: ODF 1.2 CD 05
> Reporter: Patrick Durusau
> Priority: Trivial
> Fix For: ODF 1.2 CD 06
>
>
> 19.275 "The filter is conjunctively added..." ? How is "conjunctively added" different from "added?"
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]