Попробую описать неописуемое повседневными человеческими словами :)
В хелпе есть описание метода GetList для результатов форм. Мне нужно вытаскивать результаты фильтруя их по ответу типа DropDown. Каким это образом делается?
[CODE]
if(CModule::IncludeModule("form"))
{
// ID веб-формы
$FORM_ID = 8;
// фильтр по полям результата
$arFilter = array(
"TIMESTAMP_1" => date("d").".".(date("m")-1).".".date("Y"), // изменен "с"
"TIMESTAMP_2" => date("d.m.Y"), // изменен "до"
);
// фильтр по вопросам
$arFields = array();
$arFields[0] = array(
"SID" => "[COLOR=red]SIMPLE_QUESTION_277[/COLOR]",
"PARAMETER_NAME" => "ANSWER_VALUE",
"VALUE" => 644
);
$arFilter["FIELDS"] = $arFields;
// выберем первые 10 результатов
$rsResults = CFormResult::GetList($FORM_ID,
($by="s_timestamp"),
($order="desc"),
$arFilter,
$is_filtered,
"Y",
10);
while ($arResult = $rsResults->Fetch())
{
echo "<pre>"; print_r($arResult); echo "</pre>";
}
}
[/CODE]
Причем:
[CODE]
[[COLOR=red]SIMPLE_QUESTION_277[/COLOR]] => Array
(
[0] => Array
(
[ID] => 644
[FIELD_ID] => 172
[QUESTION_ID] => 172
[TIMESTAMP_X] => 18.02.2008 15:07:53
[MESSAGE] => Москва
[VALUE] =>
[FIELD_TYPE] => dropdown
[FIELD_WIDTH] => 0
[FIELD_HEIGHT] => 0
[FIELD_PARAM] => selected
[C_SORT] => 10
[ACTIVE] => Y
)
[1] => Array
(
[ID] => 645
[FIELD_ID] => 172
[QUESTION_ID] => 172
[TIMESTAMP_X] => 18.02.2008 15:07:53
[MESSAGE] => Саратов
[VALUE] =>
[FIELD_TYPE] => dropdown
[FIELD_WIDTH] => 0
[FIELD_HEIGHT] => 0
[FIELD_PARAM] =>
[C_SORT] => 20
[ACTIVE] => Y
)
[2] => Array
(
[ID] => 646
[FIELD_ID] => 172
[QUESTION_ID] => 172
[TIMESTAMP_X] => 18.02.2008 15:07:53
[MESSAGE] => Липецк
[VALUE] =>
[FIELD_TYPE] => dropdown
[FIELD_WIDTH] => 0
[FIELD_HEIGHT] => 0
[FIELD_PARAM] =>
[C_SORT] => 30
[ACTIVE] => Y
)
)
[/CODE]