CRM_Case_BAO_Query

class CRM_Case_BAO_Query extends CRM_Core_BAO_Query

Methods

static 
addCustomFormFields(CRM_Core_Form $form, array $extends)

No description

from CRM_Core_BAO_Query
string
qill()

Getter for the qill object.

static 
searchAction($row, int $id)

Possibly unnecessary function.

from CRM_Core_BAO_Query
static 
tableNames($tables)

No description

static array
getFields(bool $excludeActivityFields = FALSE)

Get fields.

static 
select(CRM_Contact_BAO_Query $query)

Build select for Case.

static 
where(CRM_Contact_BAO_Query $query)

Given a list of conditions in query generate the required where clause.

static 
whereClauseSingle(array $values, CRM_Contact_BAO_Query $query)

Where clause for a single field.

static string
from(string $name, string $mode, string $side)

Build from clause.

static array|null
defaultReturnProperties($mode, bool $includeCustomFields = TRUE)

No description

static array|null
extraReturnProperties(string $mode)

This includes any extra fields that might need for export etc.

static 
buildSearchForm(CRM_Core_Form $form)

Add all the elements shared between case search and advanced search.

static bool|array
formRule(array $fields, array $files, CRM_Core_Form $form)

Custom form rules.

Details

in CRM_Core_BAO_Query at line 41
static addCustomFormFields(CRM_Core_Form $form, array $extends)

Parameters

CRM_Core_Form $form
array $extends

at line 583
string qill()

Getter for the qill object.

Return Value

string

in CRM_Core_BAO_Query at line 76
static searchAction($row, int $id)

Possibly unnecessary function.

Parameters

$row
int $id

at line 664
static tableNames($tables)

Parameters

$tables

at line 42
static array getFields(bool $excludeActivityFields = FALSE)

Get fields.

Parameters

bool $excludeActivityFields

Return Value

array

at line 58
static select(CRM_Contact_BAO_Query $query)

Build select for Case.

Parameters

CRM_Contact_BAO_Query $query

at line 222
static where(CRM_Contact_BAO_Query $query)

Given a list of conditions in query generate the required where clause.

Parameters

CRM_Contact_BAO_Query $query

at line 262
static whereClauseSingle(array $values, CRM_Contact_BAO_Query $query)

Where clause for a single field.

CRM-17120 adds a test that checks the Qill on some of these parameters. However, I couldn't find a way, other than via test, to access the case_activity options in the code below and invalid sql was returned. Perhaps the options are just legacy?

Also, CRM-17120 locks in the Qill - but it probably is not quite right as I see 'Activity Type = Scheduled' (rather than activity status).

See CRM_Case_BAO_QueryTest for more.

Parameters

array $values
CRM_Contact_BAO_Query $query

at line 511
static string from(string $name, string $mode, string $side)

Build from clause.

Parameters

string $name
string $mode
string $side

Return Value

string

at line 593
static array|null defaultReturnProperties($mode, bool $includeCustomFields = TRUE)

Parameters

$mode
bool $includeCustomFields

Return Value

array|null

at line 642
static array|null extraReturnProperties(string $mode)

This includes any extra fields that might need for export etc.

Parameters

string $mode

Return Value

array|null

at line 679
static buildSearchForm(CRM_Core_Form $form)

Add all the elements shared between case search and advanced search.

Parameters

CRM_Core_Form $form

at line 733
static bool|array formRule(array $fields, array $files, CRM_Core_Form $form)

Custom form rules.

Parameters

array $fields
array $files
CRM_Core_Form $form

Return Value

bool|array