Jump to Navigation
Home

Languages

  • English

Search form

  • About us
  • Services
  • Software
  • Resources
  • image

Suitecrm

SuiteCRM / SugarCRM Cheat Sheet

Tue, 2019-07-30 09:37 — Shinguz

Table of Contents

  • Unlink multiple records from Target List
  • Find Target Lists of Target/Prospect
  • List all email addresses of all accounts
  • Objects without Target List
  • Find PLP without Objects
  • Find Prospect List Entries per Prospect Type
  • Quick set-up on Ubuntu 18.04
  • Add targets from old target lists to new target list
  • Undelete accounts

Unlink multiple records from Target List

  1. Find id of record to unlink.
SQL> SET @uid = 'f232e8d0-9b82-20f7-7c35-5c1a5ce94e0a';
  1. Find entry in Target List table: …
tags: 
suitecrm
sugarcrm
crm
target
target_list
  • Read more about SuiteCRM / SugarCRM Cheat Sheet
Subscribe to RSS - Suitecrm

  • About us

    • News
    • About FromDual
    • Contact
    • Partner
    • References
    • Newsletter
    • Press

  • Services

    • Consulting
    • Support
      • MySQL
      • DB Development
    • Remote-DBA
    • Training
      • Training Modules
      • Class Schedule
      • for Developer
      • for Administrators
      • Galera Cluster

  • Software

    • Performance Monitor
    • Ops Center
    • Backup and Recovery Manager
    • MyEnv
    • Download

  • Resources

    • Blog
    • Presentations
    • SQL Formatter
    • Database Health Check
    • Performance Tuning Key
    • Consulting tools
    • MySQL Configuration

  • Download

  • Recent content

Trademarks

RSS LinkedIn X / Twitter Facebook Flickr Bluesky YouTube Mastodon Matrix PeerTube Codeberg twitter

MySQL, InnoDB and Oracle are registered trademarks of Oracle Corp. MariaDB®, the sea lion logo and MaxScale® are registered trademarks of MariaDB Corp. All other trademarks are property of their respective owners. Other product or company names mentioned may be trademarks or trade names of their respective owner.