Kuali Rice Development
  1. Kuali Rice Development
  2. KULRICE-5694

Under some circumstances lookups can return the same row multiple times

    Details

    • Type: Improvement Improvement
    • Status: Closed Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.0.0-b1, 2.0
    • Component/s: Development
    • Security Level: Public (Public: Anyone can view)
    • Labels:
      None
    • Similar issues:
      KULRICE-8391Screen to edit multiple parameters at the same time
      KULRICE-7265Multi-Value Lookup return selected not posting
      KULRICE-3175When performing inquiries the system returns data elements that can in turn be inquired upon. In some screens this leads to a circular inquiry situation.
      KULRICE-7734Multiple select of Lookup does not return selection
      KULRICE-12934Some classes are duplicated multiple times over if they are added during the lifecycle
      KULRICE-6616under certain circumstances two propositions are in edit mode
      KULRICE-7178When editing a role, the app allows you to add the same user multiple times in the assignee section.
      KULRICE-3704KEW needs some caching within the same request
      KULRICE-1980Fix "Multiple services with same endpoint url" errors
      KULRICE-6873After searching once same results are returned from document type lookup
    • Application Requirement:
      KFS
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required

      Description

      We discovered this with the person lookup in our IU environment (IU JIRA EN-2227). In our case we were seeing cases where the lookup was returning multiple identical rows in lookup search results for people who had multiple jobs. The problem isn't particular to this lookup or situation though and can apparently happen in other cases where we're joining to secondary records.

      IU is developing code to fix this problem across all lookups and would like to contribute it back for RICE 2.0.

        Issue Links

          Activity

          Hide
          Eric Westfall added a comment -

          As per our discussion this morning, we should add filtering based on principal id after the search, so that only one row per principal id is returned from the person search.

          Show
          Eric Westfall added a comment - As per our discussion this morning, we should add filtering based on principal id after the search, so that only one row per principal id is returned from the person search.
          Hide
          James Smith added a comment -

          Added Heather and myself as watchers.

          Show
          James Smith added a comment - Added Heather and myself as watchers.
          Hide
          Shannon Hess added a comment -

          Fix for this has been contributed back to 2.0

          Show
          Shannon Hess added a comment - Fix for this has been contributed back to 2.0
          Hide
          James Smith added a comment -

          Thank you!

          Show
          James Smith added a comment - Thank you!
          Hide
          Rice-CI User (Inactive) added a comment -

          Integrated in rice-trunk-nightly #231 (See http://ci.rice.kuali.org/job/rice-trunk-nightly/231/)
          KULRICE-5694 : prevent duplicate rows from being returned for the person inquiry (In this case, duplicate meaning same entityId, principalId, and principalNm). This allows for multiple rows to be returned if an entityID has more then one principal name or more than one principal ID.

          Show
          Rice-CI User (Inactive) added a comment - Integrated in rice-trunk-nightly #231 (See http://ci.rice.kuali.org/job/rice-trunk-nightly/231/ ) KULRICE-5694 : prevent duplicate rows from being returned for the person inquiry (In this case, duplicate meaning same entityId, principalId, and principalNm). This allows for multiple rows to be returned if an entityID has more then one principal name or more than one principal ID.

            People

            • Assignee:
              Shannon Hess
              Reporter:
              Damon Dorsey
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Structure Helper Panel