Loading...

XML

Word

Printable

Details

Type: Bug
Resolution: Fixed
Priority: Major
Fix Version/s: COmanage Registry 3.2.4 (Oyster Pearl MR4)
Affects Version/s: COmanage Registry 3.2.3 (Oyster Pearl MR3)
Component/s: Registry
Labels:
- CMF-GRN

Description

Under the user's menu we get a list of the available OrgIdentities linked to the user for the CO the user chose. If we link and unlink an OrgIdentity multiple times then we will have a list of the same OrgIdentity or Identifier, etc. The reason for this seems to be the changelog behavior.

The buggy code is in



      $this->loadModel('CoOrgIdentityLink');
      $this->loadModel('OrgIdentity');
 
      $args = array();
      $args['joins'][0]['table'] = 'co_org_identity_links';
      $args['joins'][0]['alias'] = 'CoOrgIdentityLink';
      $args['joins'][0]['type'] = 'INNER';
      $args['joins'][0]['conditions'][0] = 'OrgIdentity.id=CoOrgIdentityLink.org_identity_id';
      $args['joins'][1]['table'] = 'identifiers';
      $args['joins'][1]['alias'] = 'Identifier';
      $args['joins'][1]['type'] = 'INNER';
      $args['joins'][1]['conditions'][0] = 'OrgIdentity.id=Identifier.org_identity_id';
      $args['conditions']['CoOrgIdentityLink.co_person_id'] = $userId;
      $args['conditions']['Identifier.status'] = StatusEnum::Active;
      $args['conditions']['Identifier.login'] = true;
 
      $userOrgIDs = $this->CoOrgIdentityLink->OrgIdentity->find('all', $args);

Tested on the develop branch

Attachments

Issue Links

is related to

CO-1879 EmailAddress table not available in query response

Resolved

Activity

People

Assignee:: Benn Oshrin (internet2.edu)

Reporter:: Ioannis Eythymios Igoumenos

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 06/Dec/19 10:42 AM

Updated:: 11/Mar/20 8:26 AM

Resolved:: 19/Feb/20 2:16 PM

app/Controller/AppController.php
Show all
1215	$this->loadModel('CoOrgIdentityLink');
1216	$this->loadModel('OrgIdentity');
1217
1218	$args = array();
1219	$args['joins'][0]['table'] = 'co_org_identity_links';
1220	$args['joins'][0]['alias'] = 'CoOrgIdentityLink';
1221	$args['joins'][0]['type'] = 'INNER';
1222	$args['joins'][0]['conditions'][0] = 'OrgIdentity.id=CoOrgIdentityLink.org_identity_id';
1223	$args['joins'][1]['table'] = 'identifiers';
1224	$args['joins'][1]['alias'] = 'Identifier';
1225	$args['joins'][1]['type'] = 'INNER';
1226	$args['joins'][1]['conditions'][0] = 'OrgIdentity.id=Identifier.org_identity_id';
1227	$args['conditions']['CoOrgIdentityLink.co_person_id'] = $userId;
1228	$args['conditions']['Identifier.status'] = StatusEnum::Active;
1229	$args['conditions']['Identifier.login'] = true;
1230
1231	$userOrgIDs = $this->CoOrgIdentityLink->OrgIdentity->find('all', $args);