-hidden- asked

Middle Initials

We have an issue where we have two people who have the same first and last name.  And we have two tools in Infocapture that use the User List dropdown.  This makes it difficult to tell the difference between the two guys with the same name.  Anyone else have this issue?  If so, how do you handle it?  

 

For anyone having this issue with an infocapture form, I have a solution.  Below is the code for a plugin that will retrieve the department for any person that you select in a User List dropdown.  I just implemented this on one of our forms and it works beautifully.  Just replace $db_host, $db_user, $db_pass, $db_name, $sym & $sym2 with your information and it will at least give those using the form a way to know the difference between 2 or more people with the same name.

 

require_once('../common/core.php');
require_once('../common/connect.php');
require_once('../common/sessioncheck.php');

 

class ICPluginSpot extends ICPluginBase 
{
    
    public function ModifyData() {
        $db_host = 'yourserver'; 
        $db_user = 'youruserid';
        $db_pass = 'yourpassword';
        $db_name = 'yourdb';

        try {
            $db = \Claromentis\Core\DAL\DBFactory::GetInstance('mssql', $db_host, $db_user, $db_pass, $db_name);
        } catch (Exception $ex)
        {
            die($ex->getMessage());
}    
        $sym="empl_award";
        $sym2="group";
        $sar=$this->GetIssueFieldValue($sym);
        
        $query=new Query("Select txtval from metadata_simple where object_id=".$sar." and name='Department'");
        $res = $db->query($query);
        $row = $res->fetchArray();
        $dpt=$row['txtval'];
        $this->SetIssueFieldValue($sym2,$dpt);
    }
}

Asked on: 26 August 2016

infocapture, intranet

0 Likes
Share

[Discuss]

photo
{{ comment.user.is_me ? cc.translations.my_comment : comment.user.name }} {{ comment.user.is_me ? cc.translations.my_comment : comment.user.name }} {{comment.user.name}} [wrote]...
[Reply] [Like] [Unlike]  {{comment.like_count}} [person] [people] [liked this] [Edit] [Delete] {{ comment.timestamp.date_str }}

[Loading...]
Search Knowledge Base
Recent Questions
-hidden- asked...
Events showing on regular Calendar?

1 comments • Friday, 5 January 2018

-hidden- asked...
Anchor tags?

2 comments • Friday, 20 October 2017

-hidden- asked...
E-Learning Reminders ?

1 comments • Sunday, 8 October 2017

-hidden- asked...
Infocapture - Set Expiration Dates

1 comments • Thursday, 31 August 2017