Uploaded image for project: 'OASIS Content Management Interoperability Services (CMIS) TC'
  1. OASIS Content Management Interoperability Services (CMIS) TC
  2. CMIS-729

Add new Wildcard section in Query

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Applied
    • Affects Version/s: V1.1
    • Fix Version/s: V1.1
    • Component/s: Domain Model
    • Labels:
      None
    • Proposal:
      Hide

      Wildcards

      Wildcards can substitute for one or more characters when searching for objects in a CMIS relational view.

      These wildcards can be used with the LIKE predicate.

      % A substitute for zero or more characters
      _ A substitute for exactly one character

      These wildcards can be used with the CONTAINS predicate function.

      • A substitute for zero or more characters
        ? A substitute for exactly one character
      Show
      Wildcards Wildcards can substitute for one or more characters when searching for objects in a CMIS relational view. These wildcards can be used with the LIKE predicate. % A substitute for zero or more characters _ A substitute for exactly one character These wildcards can be used with the CONTAINS predicate function. A substitute for zero or more characters ? A substitute for exactly one character
    • Resolution:
      Hide

      Proposal is accepted 28 Nov 2011. Only * and ? are used in CONTAINS, and only % and _ are used in LIKE.

      Show
      Proposal is accepted 28 Nov 2011. Only * and ? are used in CONTAINS, and only % and _ are used in LIKE.

      Description

      Is it time to revisit the wildcard support in Query V1.1, for both LIKE predicate and CONTAINS predicate?

      The Query section in the V1.0 spec does not describe the wildcard support. It only hinted at the support in the 2.1.12.3 Escaping section, that % and _ need to be escaped.

      And there is no mention of the wildcard support in text search CONTAINS. This may be a source of confusion because some databases use % and _, while others use * and ? for text search wildcards.

      We should consider adding a new wildcard section, to clarify our wildcard characters. Here is an example. We can modify the wording if we decide to use % and _ for both LIKE and CONTAINS. However, if we decide to use * and ? for text search, then we also need to open another CMIS Jira issue to update the Escaping section.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jane.doong Jane Doong
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: