PHP SugarQuery_Builder_Where::addRaw Examples

Example #1

File: FilterApi.php Project: jglaine/sugar761-ent

 /**
  * Add a Following Filter
  * @param SugarQuery $q
  * @param SugarQuery_Builder_Where $where
  * @param $filter
  */
 protected static function addFollowFilter(SugarQuery $q, SugarQuery_Builder_Where $where, $filter, $joinType = 'LEFT')
 {
     $field = 'following';
     $q->select($field);
     if (isset($q->from->field_defs[$field]['link'])) {
         $link = $q->from->field_defs[$field]['link'];
         if (isset($q->joinLinkToKey[$link])) {
             $alias = $q->joinLinkToKey[$link];
             $where->addRaw("{$alias}.id IS NOT NULL");
         }
     }
 }