query updating custom field

[dusker]

Hello,

i have a pretty complex situation down here.
in my opportunities module i have several custom fields, and one of them is a computed field (on a database level), so it shouldn't be updated with any query comming from sugar. is it possible to achieve this, because everytime i try to save an opportunity, it obviously tries to save custom fields as well and here's the problem:

12/10/08 15:28:31 [1380][1][FATAL] SQL Server error: The column "weighted_c" cannot be modified because it is either a computed column or is the result of a UNION operator.

So the best solution here would be to get sugar not to touch this field (and this field needs to be there because of reporting - lack of weighted value field), but i don't know where the queries are stored. Could anyone help out with this?

greetings
peter

[eggsurplus]

Peter,

We have a computed field as well in the Accounts module. What we did was rename the Account.php file to Accounts_sugar.php and renamed the class within that file to Accounts_sugar. We then created a new Account.php file with the following contents:

 <?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 
require_once('modules/Accounts/Account_sugar.php');
 
/** [IC] 20080711 PDB - Extend the Accounts class to modify the save and
                        retrieve functionality to look at the name_source
                        column instead of name. */
class Account extends Account_sugar {
 
    var $name_source;
 
    function Account() { 
        parent::Account_sugar();
    }
 
    function retrieve($id = -1, $encode=true) {
 
        $this->field_defs['name_source'] = $this->field_defs['name'];
        $this->field_defs['name_source']['name'] = 'name_source';
 
        parent::retrieve($id, $encode);
 
        $this->name = $this->name_source;
 
        return $this;
    }
 
    function save($check_notify = FALSE) {
 
        $this->field_defs['name_source'] = $this->field_defs['name'];
        $this->field_defs['name_source']['name'] = 'name_source';
        $this->name_source = $this->name;
        unset($this->field_defs['name']);
 
        return parent::save($check_notify);
    }
 
}
?>  

The name column is a computed column. Pretty much what we did was have a different column display the data on the screen (called name_source) so that name_source is saved and not name.

Hope that gives you some ideas.