CCheckListResult::GetList

static function GetList($arOrder = array(), $arFilter = array())
{
	global $DB;

	$arSqlWhereStr = '';
	if (is_array($arFilter) && !empty($arFilter))
	{
		$arSqlWhere = array();
		$arSqlFields = array("ID", "REPORT", "HIDDEN", "SENDED_TO_BITRIX");
		foreach($arFilter as $key => $value)
		{
			if (in_array($key, $arSqlFields))
			{
				$arSqlWhere[] = $key."='".$DB->ForSql($value)."'";
			}
		}
		$arSqlWhereStr = GetFilterSqlSearch($arSqlWhere);
	}

	$strSql = "SELECT * FROM b_checklist";
	if ($arSqlWhereStr <> '')
	{
		$strSql.= " WHERE ".$arSqlWhereStr;
	}
	$strSql.= " ORDER BY ID desc";
	$arResult = $DB->Query($strSql, false, "FILE: ".__FILE__."
 LINE: ".__LINE__);

	return $arResult;
}