Auto incremental number

[gjlando]

Hi,
I needed to create a new module similar to Cases.
I did it succesfully except for the following: the Cases module has a field called case_number which is automatically increased by the system (it is not required as an input for the user).
The new module I created, with the Issue template, has this field but it is not auto incremental, and I cannot find a type of field like that.
Could anyone help me please?
Thank you.
Gabriela.

[Angel]

The auto increment is accomplished at the database server level, not within Sugar.

See here for info on how to apply the feature to your column: http://dev.mysql.com/doc/refman/5.0/...increment.html

[andopes]

Hi, Gabriela.

Did you run the quick repair and rebuild?

[ToniFatec]

You can also "force" a normal int field to became autonumber as you want to, plus you can obligate it begins with any size and/or add other characters (only in case it is a varchar in database).

Because it is in a new module you can edit default Sugarbean->save() method by inheritance:

 function save($check_notify = FALSE) {
        $this->setOrder();
        parent::save();
    }
 
    function setOrder() {
        if ($this->id == ''){
            $query = "SELECT order_number FROM my_module_name ORDER BY order_number DESC";
            $result = $this->db->query($query,true,"");
            $row = $this->db->fetchByAssoc($result);
            if($row != ''){
                $this->order_number = ($row['order_number'] + 1);
            }
        }
    } 
  

[hagay2386]

Hi Gabriela,
I wish I would know the answer, but I don't.
You can visit us on:

http://www.elalmovers.com
http://www.elalmoving.com
Miami movers, movers in Miami