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

Fix query to get Template documents

    XMLWordPrintable

    Details

    • Release Notes Summary:
      The query to return mapped templates uses a selective criterion.
    • Backlog priority:
      500
    • Sprint:
      nxsupport 11.1.3, nxsupport 11.1.4, nxsupport 11.1.5, nxsupport 11.1.6

      Description

      The query used by TemplateMappingFetcher is

       select * from Document where tmpl:forcedTypes/* <> 'none'

      With VCS, this query only returns documents which contain the documenttemplate schema, so using from Document does not have an impact.

      With MongoDB, this query returns all documents having as criteria the fact that the document type must have the documenttemplate schema.

      A workaround solution is to force the type of documents which will be returned with a query like

       select * from TemplateSource where tmpl:forcedTypes/* <> 'none'

      where TemplateSource is the only document type which uses the schema documenttemplate by default

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 hour, 40 minutes
                  1h 40m