Details about this thread
  • State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 6 replies
  • Answers 1 answer
  • Subscribers 313 subscribers
  • Views 1986 views
  • Users 0 members are here
Related content from around SugarClub

Change Data Type

John Kitsmiller

I made a mistake years ago, that just came up.

We use two fields, the competitor an Account uses, and then what competitive software we converted them from.

It seems I created one as a DropDown instead of a MultiSelect, as it should have been.

We have tons of data in the Converted From now.

Is there any way to convert this to a MultiSelect now, without losing all the data in that field across Accounts?

Parents
  • 0

    Yes, it is possible, send to Sugar Support 2 queries:

    1. Query to update the respective fields_meta_data from enum to multienum
    2. Query to massp update all existing data, like UPDATE table SET field = CONCAT("^", field, "^")

    Query 2 must be executed after confirming that the target field has been converted properly. It requires QRR after running query 1, I would do that twice to make sure!

    André Lopes
    Lampada Global
    Skype: andre.lampada
Reply
  • 0

    Yes, it is possible, send to Sugar Support 2 queries:

    1. Query to update the respective fields_meta_data from enum to multienum
    2. Query to massp update all existing data, like UPDATE table SET field = CONCAT("^", field, "^")

    Query 2 must be executed after confirming that the target field has been converted properly. It requires QRR after running query 1, I would do that twice to make sure!

    André Lopes
    Lampada Global
    Skype: andre.lampada
Children