Add Extra Left Outer Join to dataset_logical_files View

XMLWordPrintable

    • Type: Feature
    • Resolution: Done
    • Priority: Standard
    • 2.1.12
    • Affects Version/s: 2.1.11
    • Component/s: None
    • None
    • 0.5
    • Sprint 163

      Problem:
      I was searching for datasets in our dataset_logical_files view that didn't actually have any files associated with them and due to the right inner join on logical_file_dataset_version_xref and logical_file there were no results being returned from our view.

      Acceptance Criteria:

      Make both the logical_file_dataset_version_xref and logical_file joins Left Outer Joins.
      Create appropriate change set.

              Assignee:
              Christy Grant
              Reporter:
              Nathan Hook
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: