Jump to Navigation
Home

Languages

  • English

Login

Search form

  • About us
  • Services
  • Tools
  • Resources
  • Download

Sugarcrm

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 - Sugarcrm

  • 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

  • Tools

    • Performance Monitor
    • Ops Center
    • MyEnv
    • SQL Formatter
    • Database Health Check
    • Performance Tuning Key
    • Consulting tools
    • MySQL Configuration

  • Resources

    • Blog
    • Forum
    • Presentations

  • Download

  • Recent content

Trademarks

RSS LinkedIn X / Twitter Xing Facebook Flickr Google+ twitter

MySQL, InnoDB and Oracle are registered trademarks of Oracle Corp. MariaDB is a trademark of Monty Program AB. 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.