datagrid filters foreign keys problem
Wed, 03/16/2011 - 14:59
please help me
i have want to filter qdatagrid from foreignkey listfilter, looking from the example advance filtering.. problem is grid filtering dropdown not working
i have 2 tables
---------
tuser
=========
id
name
groupid
---------
tusergroup
=========
id
group
Qdatagrid column code
//Group - filtered
$groupCol = new QDataGridColumn('Group', '<?= $_ITEM->Group ?>', 'Width=90');
$groupCol->OrderByClause = QQ::OrderBy(QQN::TUsers()->GroupId);
$groupCol->ReverseOrderByClause = QQ::OrderBy(QQN::TUsers()->Group, false);
$groupCol->FilterType = QFilterType::ListFilter;
$objgroup = TUsergroups::LoadAll();
foreach ($objgroup as $objG)
$groupCol->FilterAddListItem($objG->Group, QQ::Equal(QQN::TUsers()->GroupId,$objG->Id));
$this->dtgTUserses->AddColumn($groupCol);
filter event from dropdown not working, how to fix it.. please help me.. thanks b4
help please.. up.. up..
HI,
you must add a QChangeEvent to your list so that when you choose an item it will update the datagrid.
hi thx for your answer, there's any example for that ?
QChangeEvent for QFilterType::ListFilter ?
i not find it at advanced_filtering example..
anyone help ...