Uploaded image for project: 'CloverDX'
  1. CloverDX
  2. CLO-9915

SalesforceReader subquery join type - left outer join

    XMLWordPrintable

    Details

    • Branch:
    • QA Testing:
      Graph automated test
    • QA Test Identification:
      SalesforceReader_relation_parentToChild_emptySubquery, SalesforceReader_relation_parentToChild_multipleSubqueries_firstEmpty, SalesforceReader_relation_parentToChild_multipleSubqueries_secondEmpty
    • Sprint:
      PRG Sprint 28, PRG Sprint 29

      Description

      Original description:
      Currently the SalesforceReader component performs inner join on subqueries, ie. if a subquery doesn't return any result for parent query the parent records are not returned. The component should allow selection of join type, e.g left outer join so in this case fields of the subquery would be filled with nulls.

      EDIT:
      We decided to change the join type with no configuration. The component will perform left outer join. The behavior should be well documented with examples. The change is backwards incompatible with 4.4.0-M2.

        Attachments

          Activity

            People

            • Assignee:
              salamonp Pavel Salamon
              Reporter:
              urbanj Jaroslav Urban
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: