CAllGroup::GetDropDownList

static function GetDropDownList($strSqlSearch="and ACTIVE='Y'", $strSqlOrder="ORDER BY C_SORT, NAME, ID")
{
	global $DB;
	$connection = BitrixMainApplication::getConnection();
	$helper = $connection->getSqlHelper();

	$strSql = "
		SELECT
			ID as REFERENCE_ID,
			" . $helper->getConcatFunction("NAME", "' ['", "ID", "']'") . " as REFERENCE
		FROM
			b_group
		WHERE
			1=1
		$strSqlSearch
		$strSqlOrder
		";
	$res = $DB->Query($strSql);

	return $res;
}