I am new to Yii and need some advice. I have two tables - project & rates. Rates table has a project_id field. In rates admin view I am displaying a "value" field from project table:
array( 'name' => 'projectvalue', 'type' => 'raw', 'value' => 'CHtml::encode($data->project->value). ),
and it displays fine. My problem is when I try to filter by entering >=15000 it returns no entries. It does work if I enter 15000 (without any operator). It appears that it is seeing this column as text values and not numeric. Am I missing something simple or should I use a different approach?
In model I have:
and in search I have included:
$criteria->with='project'; $criteria->addSearchCondition("project.value",$this->projectvalue); $criteria->compare('project.value',$this->projectvalue);
Any help would be greatly appreciated. Thakks in advance.