Custom querys???

[ezcurrax]

What file or function i have to modify to make a custom search using my own fields???
i need to do in the module contacts .. in the pop-up that appeairs in campaigns...
thanks...

[kenshiro]

Maybe Enhanced Search fulfill your needs.

Take a look at this thread for more details.

[ToniFatec]

Hi,
In a code-level perspective you can re-use SugarCRM Framework own method to get access the database and then use your own query to check/updat/do whatever you want.
The following is a hypothetical example to be put inside the class of a module.

     $personalQuery = "SELECT accounts.id, accounts.name FROM accounts
WHERE accounts.id ='$this->specialId'";
        $personalResult = $this->db->query($personalQuery,true," Error filling in additional detail fields: ");
        $personalRow = $this->db->fetchByAssoc($personalResult);
 
        if($personalRow != null) {
            $otherField = $personalRow['id'];
        } 
  

[ezcurrax]

if i wanna to make query on a pop - up for contacts.... wich class i have to modify ??

pop - updefs.php??

i think this won `t work

have u got any idea ?

the pop - up is when click on campaigns , select target list , and then click on select contacs ,


a lot of thanks......

[ezcurrax]

other question....

how we launch this custom query????

is there any way to do this by clicking on a button or something else???

thanks