[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]