OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office message

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