[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=21573#action_21573 ] Michael Brauer commented on OFFICE-2789: ---------------------------------------- The clue that even for form:command-type="query" or "table" a SQL statement is executed. We may amend the descriptions of the two values as follows: - query: the command contains the name of query. The form retrieves *the query* and executes *its SQL statement*. - table: the command contains a table name. The form *executes an SQL statement that* retrieves all of the data in the table. With that it becomes clear that there is always a SQL statement, and we may amend the form:filter description as follows: The form:filter attribute specifies a filter for the SQL clause determined by the form:command-type and form:comand attributes. If that SQL statement contains already a filter (WHERE clause), the filter specified by the attribute value is is conjunctively added to the existing filter. > 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: Forms > Affects Versions: ODF 1.2 CD 05 > Reporter: Patrick Durusau > 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]