Dropdown display value

[tripar]

I have modified some of the display values of the default dropdown.
When I view my fields in phpmyadmin or a reporting program, it is the old value that is displaying.

For example, I changed "Proposal/Price Quote" to "Quoted", but when I pull the field opportunities.sales_stage, it is "Proposal/Price Quote" that shows up.

So where is my new display value stored? I can't seam to find the table for it.

Eric.

[sacramentojoe]

I have modified some of the display values of the default dropdown.
When I view my fields in phpmyadmin or a reporting program, it is the old value that is displaying.

For example, I changed "Proposal/Price Quote" to "Quoted", but when I pull the field opportunities.sales_stage, it is "Proposal/Price Quote" that shows up.

So where is my new display value stored? I can't seam to find the table for it.

Eric.

The value being saved in the database is the KEY, which is the value on the left of the Drop down that you can't change.

[tripar]

The value being saved in the database is the KEY, which is the value on the left of the Drop down that you can't change.

Are you saying that the display value that we are changing is not stored in the database. If so, how does sugar know what to display?

[cywolf]

It looks up the translated value of the stored key on the fly so that multiple interface languages can be supported. Your custom option lists are defined in custom/include/language/ in case you want to see what the mapping looks like.