Category Archives: Sugar

Manually Removing Module Loader Packages

Posted on August 15, 2017 by Janaki in Sugar / 0 Comment(s)

Use the following steps to remove the reference to the package in the Sugar file system: Navigate to the ./upload/upgrades/module/ directory. Create a new directory titled “disabled”. Move the files […]

Custom Entrypoint

Posted on August 7, 2017 by Janaki in Sugar / 0 Comment(s)

Create an entrypoint fine anywhere in custom folder(file can be located anywhere you choose). Let say the file is: ./custom/customEntryPoint.php

<?php
    if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
    echo "Hello World!";

<?php

if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');

echo "Hello World!";

Next, we will need to create our extension in […]

Sugar CRM DBManagerFactory

Posted on July 27, 2017 by Janaki in Sugar / 0 Comment(s)

Querying The Database:

$sql = "SELECT id FROM accounts WHERE deleted = 0";
$result = $GLOBALS['db']->query($sql);
while($row = $GLOBALS['db']->fetchByAssoc($result) )
{
    //Use $row['id'] to grab the id fields value
    $id = $row['id'];
}

$sql = "SELECT id FROM accounts WHERE deleted = 0";

$result = $GLOBALS['db']->query($sql);

while($row = $GLOBALS['db']->fetchByAssoc($result) )

{

//Use $row['id'] to grab the id fields value

$id = $row['id'];

}

Retrieving a Single Result

$sql = "SELECT name FROM accounts WHERE id = '{$id}'";
$name = $GLOBALS['db']->getOne($sql);

1 2	$sql = "SELECT name FROM accounts WHERE id = '{$id}'"; $name = $GLOBALS['db']->getOne($sql);

Limiting Results To limit the results of a query, you can add a limit to the SQL string or use the […]

Sugar BeanFactory

Posted on July 19, 2017 by Janaki in Sugar / 0 Comment(s)

The BeanFactory class, located in ./data/BeanFactory.php, is used for loading an instance of a SugarBean. This class should be used any time you are creating or retrieving bean objects. It […]