Details about this thread
  • State Not Answered
  • Replies 7 replies
  • Subscribers 314 subscribers
  • Views 540 views
  • Users 0 members are here
Related content from around SugarClub

Remove tags from multiple contacts

Jan-Frederic Buss

We would like to be able to quickly remove a tag from a group of contacts. Does anybody have any ideas how you can do this? We tried with the mass update, but there is unfortunately no possibility to remove data.

Parents
  • 0

      ,

      has a great answer for you, but it does require code.


    If you are On-Site, feeling adventurous, and you know your tag_id, you could hazard a DB update, but know that this will bypass any bean logic.

    update
tag_bean_rel
set deleted = 1,
date_modified = utc_timestamp()
where bean_module = 'Contacts'
and tag_id = 'c29334c8-4a11-11eb-98f2-001a4a160206'
and deleted = 0

    (the tag_id in the example is obviously made up and would have to be replaced with your tag id)

    I believe that for Cloud customers you could ask Support to execute SQL commands for you, which may be an option for you.

    FrancescaS

Reply
  • 0

      ,

      has a great answer for you, but it does require code.


    If you are On-Site, feeling adventurous, and you know your tag_id, you could hazard a DB update, but know that this will bypass any bean logic.

    update
tag_bean_rel
set deleted = 1,
date_modified = utc_timestamp()
where bean_module = 'Contacts'
and tag_id = 'c29334c8-4a11-11eb-98f2-001a4a160206'
and deleted = 0

    (the tag_id in the example is obviously made up and would have to be replaced with your tag id)

    I believe that for Cloud customers you could ask Support to execute SQL commands for you, which may be an option for you.

    FrancescaS

Children