Custom ListView only working for admin user

[chrislynch8]

HI,

I have a custom list view for Accounts that I use to filter Global team records out of list view. This is the code I have but it is only working for the admin user. When any other user log into the CRM no Accounts appear. Can someone tell me what is wrong

 <?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 
require_once('include/MVC/View/views/view.list.php');
 
class AccountsViewList extends ViewList{
     function AccountsViewList()
     {
         parent::ViewList();
     }
     
     /*
      * Override listViewProcess with addition to where clause to exclude project templates
      */
    function listViewProcess()
    {
        $this->processSearchForm();
                
 
        // RETRIEVE ACCOUNTS WHERE THE TEAM IS NOT GLOBAL
        if ($this->where != "")
            $this->where .= ' and team_id != 1 ';
        else
            $this->where .= 'team_id != 1';
 
        
        $this->lv->searchColumns = $this->searchForm->searchColumns;
        
        if(!$this->headers)
            return;
            
        if(empty($_REQUEST['search_form_only']) || $_REQUEST['search_form_only'] == false)
        {
            $this->lv->setup($this->seed, 'include/ListView/ListViewGeneric.tpl', $this->where, $this->params);
            $savedSearchName = empty($_REQUEST['saved_search_select_name']) ? '' : (' - ' . $_REQUEST['saved_search_select_name']);
            echo get_form_header($GLOBALS['mod_strings']['LBL_LIST_FORM_TITLE'] . $savedSearchName, '', false);
            echo $this->lv->display();
        }
    }
 
}
 
?>  

Rdgs
Chris

[andopes]

Probably it is generating a sql query error.

Edit the file include/ListView/ListViewData.php and add this line:

 echo "<LI>$main_query</LI>"; 
  

just after the line

 $main_query = $ret_array['select'] . $params['custom_select'] . $ret_array['from'] . $params['custom_from'] . $ret_array['where'] . $params['custom_where'] . $ret_array['order_by'] . $params['custom_order_by']; 
  

Try again, you will see the sql query on screen.
Execute it at your phpMyAdmin, let us know both sql query and error provided by phpMyAdmin

Cheers

[chrislynch8]

Hi thanks for the info.

the error I get in the query is

CODE]Column 'team_id' in where clause is ambiguous[/CODE]

For the admin user I am getting a different query then for a normal user.

This is the part of the query for a normal user

FROM accounts 
INNER JOIN team_memberships team_memberships ON accounts.team_id = team_memberships.team_id 
AND team_memberships.user_id = 'a19ff192-49a6-102c-8082-001d0911a977' 
AND team_memberships.deleted=0 
LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c 
LEFT JOIN teams jt0 ON jt0.id= accounts.team_id 
AND jt0.deleted=0 
AND jt0.deleted=0 
WHERE (team_id !=1) AND accounts.deleted=0 ORDER BY team_name DESC

This is the same part that is created by admin

FROM accounts 
LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c 
LEFT JOIN teams jt0 ON jt0.id= accounts.team_id 
AND jt0.deleted=0 
AND jt0.deleted=0 
WHERE (team_id != 1) 
AND accounts.deleted=0 
ORDER BY team_name DESC

How do I fix whatever is going wrong here?

*******************************
UPDATE
******************************
Where I have team_id I need that to be accounts.team_id so I gues I have to change it in my list.view.php
********************************

[chrislynch8]

Hi,

Thanks for teh help André - that is working perfectly now.

I know this is the wrong thread but I am still having trouble with the DevToolKit as per my posts in the Help forums yesterday.

Rgds
Chris

[kuske]

If I would like to filter by the team_id of accounts I would write

         // RETRIEVE ACCOUNTS WHERE THE TEAM IS NOT GLOBAL 
        if ($this->where != "") 
            $this->where .= ' and accounts.team_id != 1 '; 
        else 
            $this->where .= 'accounts.team_id != 1'; 
  

[chrislynch8]

If I would like to filter by the team_id of accounts I would write

         // RETRIEVE ACCOUNTS WHERE THE TEAM IS NOT GLOBAL 
        if ($this->where != "") 
            $this->where .= ' and accounts.team_id != 1 '; 
        else 
            $this->where .= 'accounts.team_id != 1'; 
  

Thats perfect, had it done by time I say this post.

Rgds
Chris

[chrislynch8]

Quick question relating to this.

THe above change works great in the ListView, but how do I acheive the same thing in the listview that appears for accounts in the Popup box when selecting an Account for a Meeting. I need a custom view.popup.php but what does it have to contain to work.

Rgds
Chris

[chrislynch8]

Anyone know what I can put in to add extra Where Clauses to the ListView that appears in the popup windows

Rgds
Chris

[naveen2k7]

Hi,

Iam using sugarcrm CE 5.5, Iam working on same custom list view. so i have added the code as per your post.

 function listViewProcess(){
        $this->processSearchForm();
        
    
            global $current_user; // grab the $current_user object
        
            $acl_role_obj = new ACLRole();
        
            $user_roles = $acl_role_obj->getUserRoles($current_user->id);
                
        if(in_array("SUPERVISOR",$user_roles)){
        
        if ($this->where != "")
        {
            $this->where .= ' and leads.validdata != "1"';
            
            }
        else {
        
            $this->where .= 'leads.validdata != "0"'; 
            }
            
             } 
  

and its working fine in list view.

Now i want to add the same for dashlet listview for the leads module. Can u help me out for which file i have to modify??

Thanks in Advance,
Naveen

[cheq326]

anyone has a solution for this?