Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-4147

VCS: allow queries about tags using NXQL

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.7.1
    • Component/s: Core VCS
    • Impact type:
      API added
    • Upgrade notes:
      Hide

      Examples from the doc:

      SELECT * FROM Document WHERE ecm:tag = 'tag1'
      SELECT * FROM Document WHERE ecm:tag IN ('tag1', 'tag2') – documents with either tag
      SELECT * FROM Document WHERE ecm:tag/* = 'tag1' AND ecm:tag/* = 'tag2' – documents with both tags
      SELECT ecm:tag FROM Document WHERE dc:title = 'something' – with queryAndFetch
      SELECT ecm:tag FROM Document WHERE ecm:tag LIKE 'abc%' – with queryAndFetch
      SELECT ecm:tag/*1 FROM Document WHERE ecm:tag/*1 LIKE 'abc%' AND ecm:tag/*2 = 'tag1'
      SELECT ecm:tag FROM Document WHERE ecm:tag LIKE 'abc%' AND ecm:tag/* = 'tag1' – simpler version of above

      Show
      Examples from the doc: SELECT * FROM Document WHERE ecm:tag = 'tag1' SELECT * FROM Document WHERE ecm:tag IN ('tag1', 'tag2') – documents with either tag SELECT * FROM Document WHERE ecm:tag/* = 'tag1' AND ecm:tag/* = 'tag2' – documents with both tags SELECT ecm:tag FROM Document WHERE dc:title = 'something' – with queryAndFetch SELECT ecm:tag FROM Document WHERE ecm:tag LIKE 'abc%' – with queryAndFetch SELECT ecm:tag/*1 FROM Document WHERE ecm:tag/*1 LIKE 'abc%' AND ecm:tag/*2 = 'tag1' SELECT ecm:tag FROM Document WHERE ecm:tag LIKE 'abc%' AND ecm:tag/* = 'tag1' – simpler version of above

      Description

      We need to retrieve and paginate documents that are referenced by the tag service.
      This can be achieved by extending NXQL for being able to evaluate expression like

      SELECT * from Document WHERE ecm:tag IN ('photo','movie');

      The first and critical need is to be able to evaluate expression using the equal operator

      SELECT * FROM Document WHERE ecm:tag = 'photo'

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                1 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 2 days
                  2d
                  Remaining:
                  Remaining Estimate - 2 days
                  2d
                  Logged:
                  Time Spent - Not Specified
                  Not Specified