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

Enable TaskServiceImpl.getTaskInstances query alternative

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.8.0-HF18, 5.9.5
    • Fix Version/s: 6.0
    • Component/s: Elasticsearch, Workflow

      Description

      The getTaskInstances uses an hard coded NXQL query that sometime does not scale.
      Using a page provider will enable to override the query, so we can use Elasticsearch if available to query tasks.

      The NXQL query is

      SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND ecm:currentLifeCycleState NOT IN ('ended', 'cancelled') AND 
  ecm:isProxy = 0 AND (nt:targetDocumentId = ? OR nt:targetDocumentsIds IN (?))

        Attachments

          Issue Links

          depends on

          Improvement - An improvement or enhancement to an existing feature or task. NXP-14947 Allow unrestricted queries on document page providers

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          is required by

          Clean up - NXP-17534 Clean up task pageprovider NXQL

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4 hours
                  4h
                  Remaining:
                  Remaining Estimate - 4 hours
                  4h
                  Logged:
                  Time Spent - Not Specified
                  Not Specified