How I can customize query in view.popup in SugarCRM

Question

I am are using SugarCRM 6.7, I wanna customize the listview query in popup. I need a custom query when I open the Accounts popup in Cases module.

I was created a file in \custom\modules\Accounts\views\view.popup.php

if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');

class CustomViewPopup extends ViewPopup{

    function CustomViewPopup(){

        parent::ViewPopup();
    }

}

But I need change the initial query, I tried to use $this->where = "whereCondition" equal in view.list.php but with no success.

How I can, change the initial query in view.popup? Thank you

Answer 1

This is a way to customize the sql queries inside the popup( view.popup.php ) in SugarCRM.

Create a file called view.popup.php in \custom\modules\< module >\views with this:

if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');

class CustomAccountsViewPopup extends ViewPopup{

    public function listViewProcess(){

        parent::listViewProcess();

        $this->params['custom_select'] = " CUSTOM SELEC";
        $this->params['custom_from'] = "CUSTOM FROM";
        $this->where .= " CUSTOM WHERE CONDITION";
    }

    function CustomAccountsViewPopup(){

        parent::ViewPopup();
    }

    function preDisplay(){
        parent::preDisplay();       

    }
}