AnsweredAssumed Answered

Sugarcrm 7 Multi-select keys display wrong characters in database

Question asked by Gaelle Fernandez on Apr 8, 2016
Latest reply on Apr 11, 2016 by Ben Selby

Hello fellow sugarers !


I have a big weird issue with multiple choice dropdowns, the keys in the database are encapsulated within "^" characters

In admin, via the Studio, i create a new Multi choice Dropdown field under Accounts module, called list_test_c

Here are the key and the values i've set :


choiceoneChoice One
choicetwoChoice Two
choicethreeChoice Three
choicefourChoice Four

Every thing is well displayed under studio.

So, this is well displayed under the account's record view, and i can select one or more choices for list_test_c.

For Record n°1, i've selected Choice One and Choice Two, so in my database, under accounts_cstm's field list_test_c, i assume i will see choiceone,choicetwo.

And for Record n°2, because i've selected only Choice Three, in my database, i will certainly see choicethree.


won't i ?


But Sugar decided not to do that. So in my database i have :

Record n° 1 => ^choiceone^,^choicetwo^

Record n°2 => ^choicethree^

Yes, the "^" caracter is added at the beginning and ending of each key.


Is that even normal ? It does that only for multi select fields, but not for normal dropdowns.

Do you have any clue on that matter ?


Thanks a lot.