Hi All,

I want to add a new column for the Assigned to User Pop-Up window.

We have the column list
Name | UserName | Group | <here i want new column named: Account Name>

i have added a account_id and account_name in the users table. Account name is available for every users but i just to fetch account name for the corresponding user.

i am confused here how can i fetch account_name from the users table.

actually in the modules/Users/metadata/popupdefs.php is having this code

$popupMeta = array(
'moduleMain' => 'User',
'varName' => 'USER',
'orderBy' => 'user_name',
'whereClauses' => array(
'first_name' => 'users.first_name',
'last_name' => 'users.last_name',
'user_name' => 'users.user_name',
'is_group' => 'users.is_group'
),
'whereStatement'=> " users.status = 'Active'",
'searchInputs' => array(
'first_name',
'last_name',
'user_name',
'is_group'
),
);

please tell how can i fetch account name using this query

Thanks,
Chetan