2 filter conditions for 1 column

I have a table that has datetime field and i want to filter it by interval from advanced search form.

i made in my module 2 variables to store the values from form




public $created_from;

public $created_till;



and in model search() i added 2 compare lines and commented out the original compare




$criteria->compare('t.sisfar_in_items_created_ts','>'.$this->created_from, true);

$criteria->compare('t.sisfar_in_items_created_ts','<'.$this->created_till, true);



When i try to use the new form fields they dont seem to give their values to $created_from and $created_till to be used in compare.

The filter itself seems to work since if i give $created_from and $created_till values in model contructor the table gets filtered corectly.

Any ideas what i am missing or doing wrong?

Full model code:




<?php

class SisfarInItems2 extends CActiveRecord

{

	public $sisfar_customers_name;

	public $created_from;

	public $created_till;

	

	function __construct() {

		//$this->created_from = '2012-06-06';

		//$this->created_till = date('Y-m-d');

		//print "In BaseClass constructor\n";

	}

	/**

	 * Returns the static model of the specified AR class.

	 * @return SisfarInItems2 the static model class

	 */

	public static function model($className=__CLASS__)

	{

		return parent::model($className);

	}


	/**

	 * @return string the associated database table name

	 */

	public function tableName()

	{

		return 'sisfar_in_items';

	}


	/**

	 * @return array validation rules for model attributes.

	 */

	public function rules()

	{

		// NOTE: you should only define rules for those attributes that

		// will receive user inputs.

		return array(

			array('sisfar_in_items_xml, sisfar_in_items_xml_after_pre_process, sisfar_in_items_received_xml_id, sisfar_in_items_mode, sisfar_in_items_created_by, sisfar_in_items_created_ts, sisfar_in_items_modified_by, sisfar_in_items_modified_ts', 'required'),

			array('sisfar_in_items_received_xml_id, sisfar_in_items_created_by, sisfar_in_items_modified_by', 'numerical', 'integerOnly'=>true),

			array('sisfar_in_items_ItemWeight', 'numerical'),

			array('sisfar_in_items_ips_mailitm_pid, sisfar_in_items_ItemId, sisfar_in_items_Content, sisfar_in_items_LocalId, sisfar_in_items_ClassCd, sisfar_in_items_AddService, sisfar_in_items_OrigCountryCd, sisfar_in_items_DestCountryCd, sisfar_in_items_PostalStatusCd, sisfar_in_items_Sender_Name, sisfar_in_items_Sender_Address, sisfar_in_items_Sender_City, sisfar_in_items_Sender_Postcode, sisfar_in_items_AdditionalData, sisfar_in_items_Sender_CountrySubEntity, sisfar_in_items_Sender_PhoneNo, sisfar_in_items_Sender_FaxNo, sisfar_in_items_Sender_Email, sisfar_in_items_Addressee_Name, sisfar_in_items_Addressee_Forename, sisfar_in_items_Addressee_Address, sisfar_in_items_Addressee_City, sisfar_in_items_Addressee_Postcode, sisfar_in_items_Addressee_CountrySubEntity, sisfar_in_items_Addressee_PhoneNo, sisfar_in_items_Addressee_Email, sisfar_in_items_ItemEvent_TNCd, sisfar_in_items_ItemEvent_Date, sisfar_in_items_ItemEvent_OfficeCd, sisfar_in_items_ItemEvent_UserFid, sisfar_in_items_ItemEvent_NonDeliveryReason, sisfar_in_items_ItemEvent_NonDeliveryMeasure, sisfar_in_items_ItemEvent_NextOfficeFcd, sisfar_in_items_Parcel_MailItemCategoryCd, sisfar_in_items_Parcel_ExpressInd, sisfar_in_items_Parcel_MailCategoryCd, sisfar_in_items_Parcel_CoDInd, sisfar_in_items_Parcel_CoDValue, sisfar_in_items_Parcel_CoDCurrencyCd, sisfar_in_items_Parcel_SenderInstructionCd, sisfar_in_items_Parcel_InsuredSDRValue, sisfar_in_items_Parcel_InsuredValue, sisfar_in_items_Parcel_InsuredCurrencyCd, sisfar_in_items_Letter_MailCategoryCd, sisfar_in_items_Letter_CoDValue, sisfar_in_items_Letter_InsuredCurrencyCd, sisfar_in_items_Letter_MailItemCategoryCd, sisfar_in_items_Letter_LetterCharacteristicCd, sisfar_in_items_Letter_InsuredValue, sisfar_in_items_Letter_InsuredSDRValue, sisfar_in_items_Letter_CoDInd, sisfar_in_items_Letter_ExpressInd', 'length', 'max'=>50),

			array('sisfar_in_items_RecptclId, sisfar_in_items_CodCurrencyCd', 'length', 'max'=>10),

			array('sisfar_in_items_mode', 'length', 'max'=>1),

			// The following rule is used by search().

			// Please remove those attributes that should not be searched.

			array('created_from, created_till, sisfar_customers_name, sisfar_in_items_xml_id, sisfar_in_items_ips_mailitm_pid, sisfar_in_items_ItemId, sisfar_in_items_xml, sisfar_in_items_xml_after_pre_process, sisfar_in_items_received_xml_id, sisfar_in_items_ItemWeight, sisfar_in_items_RecptclId, sisfar_in_items_CodCurrencyCd, sisfar_in_items_Content, sisfar_in_items_LocalId, sisfar_in_items_ClassCd, sisfar_in_items_AddService, sisfar_in_items_OrigCountryCd, sisfar_in_items_DestCountryCd, sisfar_in_items_PostalStatusCd, sisfar_in_items_Sender_Name, sisfar_in_items_Sender_Address, sisfar_in_items_Sender_City, sisfar_in_items_Sender_Postcode, sisfar_in_items_AdditionalData, sisfar_in_items_Sender_CountrySubEntity, sisfar_in_items_Sender_PhoneNo, sisfar_in_items_Sender_FaxNo, sisfar_in_items_Sender_Email, sisfar_in_items_Addressee_Name, sisfar_in_items_Addressee_Forename, sisfar_in_items_Addressee_Address, sisfar_in_items_Addressee_City, sisfar_in_items_Addressee_Postcode, sisfar_in_items_Addressee_CountrySubEntity, sisfar_in_items_Addressee_PhoneNo, sisfar_in_items_Addressee_Email, sisfar_in_items_ItemEvent_TNCd, sisfar_in_items_ItemEvent_Date, sisfar_in_items_ItemEvent_OfficeCd, sisfar_in_items_ItemEvent_UserFid, sisfar_in_items_ItemEvent_NonDeliveryReason, sisfar_in_items_ItemEvent_NonDeliveryMeasure, sisfar_in_items_ItemEvent_NextOfficeFcd, sisfar_in_items_Parcel_MailItemCategoryCd, sisfar_in_items_Parcel_ExpressInd, sisfar_in_items_Parcel_MailCategoryCd, sisfar_in_items_Parcel_CoDInd, sisfar_in_items_Parcel_CoDValue, sisfar_in_items_Parcel_CoDCurrencyCd, sisfar_in_items_Parcel_SenderInstructionCd, sisfar_in_items_Parcel_InsuredSDRValue, sisfar_in_items_Parcel_InsuredValue, sisfar_in_items_Parcel_InsuredCurrencyCd, sisfar_in_items_Letter_MailCategoryCd, sisfar_in_items_Letter_CoDValue, sisfar_in_items_Letter_InsuredCurrencyCd, sisfar_in_items_Letter_MailItemCategoryCd, sisfar_in_items_Letter_LetterCharacteristicCd, sisfar_in_items_Letter_InsuredValue, sisfar_in_items_Letter_InsuredSDRValue, sisfar_in_items_Letter_CoDInd, sisfar_in_items_Letter_ExpressInd, sisfar_in_items_mode, sisfar_in_items_created_by, sisfar_in_items_created_ts, sisfar_in_items_modified_by, sisfar_in_items_modified_ts', 'safe', 'on'=>'search'),

		);

	}


	/**

	 * @return array relational rules.

	 */

	public function relations()

	{

		// NOTE: you may need to adjust the relation name and the related

		// class name for the relations automatically generated below.

		return array(

			'customers' => array(self::HAS_ONE, 'SisfarCustomers', '', 'on'=>'sisfar_customers_id = sisfar_in_items_created_by'),

		);

	}


	/**

	 * @return array customized attribute labels (name=>label)

	 */

	public function attributeLabels()

	{

		return array(

			'sisfar_in_items_xml_id' => 'Sisfar In Items Xml',

			'sisfar_in_items_ips_mailitm_pid' => 'Sisfar In Items Ips Mailitm Pid',

			'sisfar_in_items_ItemId' => 'Sisfar In Items Item',

			'sisfar_in_items_xml' => 'Sisfar In Items Xml',

			'sisfar_in_items_xml_after_pre_process' => 'Sisfar In Items Xml After Pre Process',

			'sisfar_in_items_received_xml_id' => 'Sisfar In Items Received Xml',

			'sisfar_in_items_ItemWeight' => 'Sisfar In Items Item Weight',

			'sisfar_in_items_RecptclId' => 'Sisfar In Items Recptcl',

			'sisfar_in_items_CodCurrencyCd' => 'Sisfar In Items Cod Currency Cd',

			'sisfar_in_items_Content' => 'Sisfar In Items Content',

			'sisfar_in_items_LocalId' => 'Sisfar In Items Local',

			'sisfar_in_items_ClassCd' => 'Sisfar In Items Class Cd',

			'sisfar_in_items_AddService' => 'Sisfar In Items Add Service',

			'sisfar_in_items_OrigCountryCd' => 'Sisfar In Items Orig Country Cd',

			'sisfar_in_items_DestCountryCd' => 'Sisfar In Items Dest Country Cd',

			'sisfar_in_items_PostalStatusCd' => 'Sisfar In Items Postal Status Cd',

			'sisfar_in_items_Sender_Name' => 'Sisfar In Items Sender Name',

			'sisfar_in_items_Sender_Address' => 'Sisfar In Items Sender Address',

			'sisfar_in_items_Sender_City' => 'Sisfar In Items Sender City',

			'sisfar_in_items_Sender_Postcode' => 'Sisfar In Items Sender Postcode',

			'sisfar_in_items_AdditionalData' => 'Sisfar In Items Additional Data',

			'sisfar_in_items_Sender_CountrySubEntity' => 'Sisfar In Items Sender Country Sub Entity',

			'sisfar_in_items_Sender_PhoneNo' => 'Sisfar In Items Sender Phone No',

			'sisfar_in_items_Sender_FaxNo' => 'Sisfar In Items Sender Fax No',

			'sisfar_in_items_Sender_Email' => 'Sisfar In Items Sender Email',

			'sisfar_in_items_Addressee_Name' => 'Sisfar In Items Addressee Name',

			'sisfar_in_items_Addressee_Forename' => 'Sisfar In Items Addressee Forename',

			'sisfar_in_items_Addressee_Address' => 'Sisfar In Items Addressee Address',

			'sisfar_in_items_Addressee_City' => 'Sisfar In Items Addressee City',

			'sisfar_in_items_Addressee_Postcode' => 'Sisfar In Items Addressee Postcode',

			'sisfar_in_items_Addressee_CountrySubEntity' => 'Sisfar In Items Addressee Country Sub Entity',

			'sisfar_in_items_Addressee_PhoneNo' => 'Sisfar In Items Addressee Phone No',

			'sisfar_in_items_Addressee_Email' => 'Sisfar In Items Addressee Email',

			'sisfar_in_items_ItemEvent_TNCd' => 'Sisfar In Items Item Event Tncd',

			'sisfar_in_items_ItemEvent_Date' => 'Sisfar In Items Item Event Date',

			'sisfar_in_items_ItemEvent_OfficeCd' => 'Sisfar In Items Item Event Office Cd',

			'sisfar_in_items_ItemEvent_UserFid' => 'Sisfar In Items Item Event User Fid',

			'sisfar_in_items_ItemEvent_NonDeliveryReason' => 'Sisfar In Items Item Event Non Delivery Reason',

			'sisfar_in_items_ItemEvent_NonDeliveryMeasure' => 'Sisfar In Items Item Event Non Delivery Measure',

			'sisfar_in_items_ItemEvent_NextOfficeFcd' => 'Sisfar In Items Item Event Next Office Fcd',

			'sisfar_in_items_Parcel_MailItemCategoryCd' => 'Sisfar In Items Parcel Mail Item Category Cd',

			'sisfar_in_items_Parcel_ExpressInd' => 'Sisfar In Items Parcel Express Ind',

			'sisfar_in_items_Parcel_MailCategoryCd' => 'Sisfar In Items Parcel Mail Category Cd',

			'sisfar_in_items_Parcel_CoDInd' => 'Sisfar In Items Parcel Co Dind',

			'sisfar_in_items_Parcel_CoDValue' => 'Sisfar In Items Parcel Co Dvalue',

			'sisfar_in_items_Parcel_CoDCurrencyCd' => 'Sisfar In Items Parcel Co Dcurrency Cd',

			'sisfar_in_items_Parcel_SenderInstructionCd' => 'Sisfar In Items Parcel Sender Instruction Cd',

			'sisfar_in_items_Parcel_InsuredSDRValue' => 'Sisfar In Items Parcel Insured Sdrvalue',

			'sisfar_in_items_Parcel_InsuredValue' => 'Sisfar In Items Parcel Insured Value',

			'sisfar_in_items_Parcel_InsuredCurrencyCd' => 'Sisfar In Items Parcel Insured Currency Cd',

			'sisfar_in_items_Letter_MailCategoryCd' => 'Sisfar In Items Letter Mail Category Cd',

			'sisfar_in_items_Letter_CoDValue' => 'Sisfar In Items Letter Co Dvalue',

			'sisfar_in_items_Letter_InsuredCurrencyCd' => 'Sisfar In Items Letter Insured Currency Cd',

			'sisfar_in_items_Letter_MailItemCategoryCd' => 'Sisfar In Items Letter Mail Item Category Cd',

			'sisfar_in_items_Letter_LetterCharacteristicCd' => 'Sisfar In Items Letter Letter Characteristic Cd',

			'sisfar_in_items_Letter_InsuredValue' => 'Sisfar In Items Letter Insured Value',

			'sisfar_in_items_Letter_InsuredSDRValue' => 'Sisfar In Items Letter Insured Sdrvalue',

			'sisfar_in_items_Letter_CoDInd' => 'Sisfar In Items Letter Co Dind',

			'sisfar_in_items_Letter_ExpressInd' => 'Sisfar In Items Letter Express Ind',

			'sisfar_in_items_mode' => 'Sisfar In Items Mode',

			'sisfar_in_items_created_by' => 'Sisfar In Items Created By',

			'sisfar_in_items_created_ts' => 'Sisfar In Items Created Ts',

			'sisfar_in_items_modified_by' => 'Sisfar In Items Modified By',

			'sisfar_in_items_modified_ts' => 'Sisfar In Items Modified Ts',

		);

	}


	/**

	 * Retrieves a list of models based on the current search/filter conditions.

	 * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.

	 */

	public function search()

	{

		// Warning: Please modify the following code to remove attributes that

		// should not be searched.


		$criteria=new CDbCriteria;


		$criteria->compare('t.sisfar_in_items_xml_id',$this->sisfar_in_items_xml_id);

		$criteria->compare('t.sisfar_in_items_ips_mailitm_pid',$this->sisfar_in_items_ips_mailitm_pid,true);

		$criteria->compare('t.sisfar_in_items_ItemId',$this->sisfar_in_items_ItemId,true);

		$criteria->compare('t.sisfar_in_items_xml',$this->sisfar_in_items_xml,true);

		$criteria->compare('t.sisfar_in_items_xml_after_pre_process',$this->sisfar_in_items_xml_after_pre_process,true);

		$criteria->compare('sisfar_in_items_received_xml_id',$this->sisfar_in_items_received_xml_id);

		$criteria->compare('t.sisfar_in_items_ItemWeight',$this->sisfar_in_items_ItemWeight);

		$criteria->compare('t.sisfar_in_items_RecptclId',$this->sisfar_in_items_RecptclId,true);

		$criteria->compare('t.sisfar_in_items_CodCurrencyCd',$this->sisfar_in_items_CodCurrencyCd,true);

		$criteria->compare('t.sisfar_in_items_Content',$this->sisfar_in_items_Content,true);

		$criteria->compare('t.sisfar_in_items_LocalId',$this->sisfar_in_items_LocalId,true);

		$criteria->compare('t.sisfar_in_items_ClassCd',$this->sisfar_in_items_ClassCd,true);

		$criteria->compare('t.sisfar_in_items_AddService',$this->sisfar_in_items_AddService,true);

		$criteria->compare('t.sisfar_in_items_OrigCountryCd',$this->sisfar_in_items_OrigCountryCd,true);

		$criteria->compare('t.sisfar_in_items_DestCountryCd',$this->sisfar_in_items_DestCountryCd,true);

		$criteria->compare('t.sisfar_in_items_PostalStatusCd',$this->sisfar_in_items_PostalStatusCd,true);

		$criteria->compare('t.sisfar_in_items_Sender_Name',$this->sisfar_in_items_Sender_Name,true);

		$criteria->compare('t.sisfar_in_items_Sender_Address',$this->sisfar_in_items_Sender_Address,true);

		$criteria->compare('t.sisfar_in_items_Sender_City',$this->sisfar_in_items_Sender_City,true);

		$criteria->compare('t.sisfar_in_items_Sender_Postcode',$this->sisfar_in_items_Sender_Postcode,true);

		$criteria->compare('t.sisfar_in_items_AdditionalData',$this->sisfar_in_items_AdditionalData,true);

		$criteria->compare('t.sisfar_in_items_Sender_CountrySubEntity',$this->sisfar_in_items_Sender_CountrySubEntity,true);

		$criteria->compare('t.sisfar_in_items_Sender_PhoneNo',$this->sisfar_in_items_Sender_PhoneNo,true);

		$criteria->compare('t.sisfar_in_items_Sender_FaxNo',$this->sisfar_in_items_Sender_FaxNo,true);

		$criteria->compare('t.sisfar_in_items_Sender_Email',$this->sisfar_in_items_Sender_Email,true);

		$criteria->compare('t.sisfar_in_items_Addressee_Name',$this->sisfar_in_items_Addressee_Name,true);

		$criteria->compare('t.sisfar_in_items_Addressee_Forename',$this->sisfar_in_items_Addressee_Forename,true);

		$criteria->compare('t.sisfar_in_items_Addressee_Address',$this->sisfar_in_items_Addressee_Address,true);

		$criteria->compare('t.sisfar_in_items_Addressee_City',$this->sisfar_in_items_Addressee_City,true);

		$criteria->compare('t.sisfar_in_items_Addressee_Postcode',$this->sisfar_in_items_Addressee_Postcode,true);

		$criteria->compare('t.sisfar_in_items_Addressee_CountrySubEntity',$this->sisfar_in_items_Addressee_CountrySubEntity,true);

		$criteria->compare('t.sisfar_in_items_Addressee_PhoneNo',$this->sisfar_in_items_Addressee_PhoneNo,true);

		$criteria->compare('t.sisfar_in_items_Addressee_Email',$this->sisfar_in_items_Addressee_Email,true);

		$criteria->compare('t.sisfar_in_items_ItemEvent_TNCd',$this->sisfar_in_items_ItemEvent_TNCd,true);

		$criteria->compare('t.sisfar_in_items_ItemEvent_Date',$this->sisfar_in_items_ItemEvent_Date,true);

		$criteria->compare('t.sisfar_in_items_ItemEvent_OfficeCd',$this->sisfar_in_items_ItemEvent_OfficeCd,true);

		$criteria->compare('t.sisfar_in_items_ItemEvent_UserFid',$this->sisfar_in_items_ItemEvent_UserFid,true);

		$criteria->compare('t.sisfar_in_items_ItemEvent_NonDeliveryReason',$this->sisfar_in_items_ItemEvent_NonDeliveryReason,true);

		$criteria->compare('t.sisfar_in_items_ItemEvent_NonDeliveryMeasure',$this->sisfar_in_items_ItemEvent_NonDeliveryMeasure,true);

		$criteria->compare('t.sisfar_in_items_ItemEvent_NextOfficeFcd',$this->sisfar_in_items_ItemEvent_NextOfficeFcd,true);

		$criteria->compare('t.sisfar_in_items_Parcel_MailItemCategoryCd',$this->sisfar_in_items_Parcel_MailItemCategoryCd,true);

		$criteria->compare('t.sisfar_in_items_Parcel_ExpressInd',$this->sisfar_in_items_Parcel_ExpressInd,true);

		$criteria->compare('t.sisfar_in_items_Parcel_MailCategoryCd',$this->sisfar_in_items_Parcel_MailCategoryCd,true);

		$criteria->compare('t.sisfar_in_items_Parcel_CoDInd',$this->sisfar_in_items_Parcel_CoDInd,true);

		$criteria->compare('t.sisfar_in_items_Parcel_CoDValue',$this->sisfar_in_items_Parcel_CoDValue,true);

		$criteria->compare('t.sisfar_in_items_Parcel_CoDCurrencyCd',$this->sisfar_in_items_Parcel_CoDCurrencyCd,true);

		$criteria->compare('t.sisfar_in_items_Parcel_SenderInstructionCd',$this->sisfar_in_items_Parcel_SenderInstructionCd,true);

		$criteria->compare('t.sisfar_in_items_Parcel_InsuredSDRValue',$this->sisfar_in_items_Parcel_InsuredSDRValue,true);

		$criteria->compare('t.sisfar_in_items_Parcel_InsuredValue',$this->sisfar_in_items_Parcel_InsuredValue,true);

		$criteria->compare('t.sisfar_in_items_Parcel_InsuredCurrencyCd',$this->sisfar_in_items_Parcel_InsuredCurrencyCd,true);

		$criteria->compare('t.sisfar_in_items_Letter_MailCategoryCd',$this->sisfar_in_items_Letter_MailCategoryCd,true);

		$criteria->compare('t.sisfar_in_items_Letter_CoDValue',$this->sisfar_in_items_Letter_CoDValue,true);

		$criteria->compare('t.sisfar_in_items_Letter_InsuredCurrencyCd',$this->sisfar_in_items_Letter_InsuredCurrencyCd,true);

		$criteria->compare('t.sisfar_in_items_Letter_MailItemCategoryCd',$this->sisfar_in_items_Letter_MailItemCategoryCd,true);

		$criteria->compare('t.sisfar_in_items_Letter_LetterCharacteristicCd',$this->sisfar_in_items_Letter_LetterCharacteristicCd,true);

		$criteria->compare('t.sisfar_in_items_Letter_InsuredValue',$this->sisfar_in_items_Letter_InsuredValue,true);

		$criteria->compare('t.sisfar_in_items_Letter_InsuredSDRValue',$this->sisfar_in_items_Letter_InsuredSDRValue,true);

		$criteria->compare('t.sisfar_in_items_Letter_CoDInd',$this->sisfar_in_items_Letter_CoDInd,true);

		$criteria->compare('t.sisfar_in_items_Letter_ExpressInd',$this->sisfar_in_items_Letter_ExpressInd,true);

		$criteria->compare('t.sisfar_in_items_mode',$this->sisfar_in_items_mode,true);

		$criteria->compare('t.sisfar_in_items_created_by',$this->sisfar_in_items_created_by);

		//$criteria->compare('t.sisfar_in_items_created_ts',$this->sisfar_in_items_created_ts,true);

		$criteria->compare('t.sisfar_in_items_modified_by',$this->sisfar_in_items_modified_by);

		$criteria->compare('t.sisfar_in_items_modified_ts',$this->sisfar_in_items_modified_ts,true);

		

		$criteria->compare('customers.sisfar_customers_name',$this->sisfar_customers_name, true);

		

		$criteria->compare('t.sisfar_in_items_created_ts','>'.$this->created_from, true);

		$criteria->compare('t.sisfar_in_items_created_ts','<'.$this->created_till, true);

		

		$criteria->with = array('customers');

		//$criteria->together = true;

		

		//$criteria->addBetweenCondition('sisfar_in_items_created_ts', $this->created_from, $this->created_till);

		

		

		

		return new CActiveDataProvider($this, array(

			'criteria'=>$criteria,

			'sort'=>array(

			        'attributes'=>array(

			            'sisfar_customers_name'=>array(

			                'asc'=>'customers.sisfar_customers_name',

			                'desc'=>'customers.sisfar_customers_name DESC',

			),

			            '*',

			),

		),

		));

	}

}

advanced search form code:




<div class="wide form">


<?php $form=$this->beginWidget('CActiveForm', array(

	'action'=>Yii::app()->createUrl($this->route),

	'method'=>'get',

)); ?>


	<div class="row">

		<?php echo $form->label($model,'sisfar_in_items_xml_id'); ?>

		<?php echo $form->textField($model,'sisfar_in_items_xml_id'); ?>

	</div>


	<div class="row">

		<?php echo $form->label($model,'sisfar_in_items_ips_mailitm_pid'); ?>

		<?php echo $form->textField($model,'sisfar_in_items_ips_mailitm_pid',array('size'=>50,'maxlength'=>50)); ?>

	</div>


	<div class="row">

		<?php echo $form->label($model,'sisfar_in_items_ItemId'); ?>

		<?php echo $form->textField($model,'sisfar_in_items_ItemId',array('size'=>50,'maxlength'=>50)); ?>

	</div>


	<div class="row">

		<?php echo $form->label($model,'sisfar_in_items_mode'); ?>

		<?php echo $form->textField($model,'sisfar_in_items_mode',array('size'=>1,'maxlength'=>1)); ?>

	</div>

	

	<div class="row">

		<?php echo $form->label($model,'sisfar_in_items_created_ts'); ?>

		<?php echo $form->textField($model,'sisfar_in_items_created_ts'); ?>

	</div>

	

	<div class="row">

		<?php echo $form->label($model,'sisfar_customers_name'); ?>

		<?php echo $form->textField($model,'sisfar_customers_name'); ?>

	</div>

	

	<div class="row">

		<?php echo $form->label($model,'created_from'); ?>

		<?php echo $form->textField($model,'created_from'); ?>

	</div>

	

	<div class="row">

		<?php echo $form->label($model,'created_till'); ?>

		<?php echo $form->textField($model,'created_till'); ?>

	</div>


	<div class="row buttons">

		<?php echo CHtml::submitButton('Search'); ?>

	</div>


<?php $this->endWidget(); ?>


</div><!-- search-form -->



full admin view code:




<?php

$this->breadcrumbs=array(

	'Sisfar In Items2s'=>array('index'),

	'Manage',

);


$this->menu=array(

	array('label'=>'List SisfarInItems2', 'url'=>array('index')),

	array('label'=>'Create SisfarInItems2', 'url'=>array('create')),

);


Yii::app()->clientScript->registerScript('search', "

$('.search-button').click(function(){

	$('.search-form').toggle();

	return false;

});

$('.search-form form').submit(function(){

	$.fn.yiiGridView.update('sisfar-in-items2-grid', {

		data: $(this).serialize()

	});

	return false;

});

");

?>


<h1>Manage Sisfar In Items2s</h1>


<p>

You may optionally enter a comparison operator (<b>&lt;</b>, <b>&lt;=</b>, <b>&gt;</b>, <b>&gt;=</b>, <b>&lt;&gt;</b>

or <b>=</b>) at the beginning of each of your search values to specify how the comparison should be done.

</p>


<?php echo CHtml::link('Advanced Search','#',array('class'=>'search-button')); ?>

<div class="search-form" style="display:none">

<?php $this->renderPartial('_search',array(

	'model'=>$model,

)); ?>

</div><!-- search-form -->


<?php $this->widget('zii.widgets.grid.CGridView', array(

	'id'=>'sisfar-in-items2-grid',

	'dataProvider'=>$model->search(),

	'filter'=>$model,

	'columns'=>array(

		'sisfar_in_items_xml_id',

		'sisfar_in_items_ItemId',

		'sisfar_in_items_mode',

		array(

				'name' => 'sisfar_customers_name',

				'value' => '$data->customers->sisfar_customers_name',

		),

		'sisfar_in_items_created_ts',

		'sisfar_in_items_modified_ts',

	),

)); ?>




Hi,

Your code looks proper. Have you transformed date into a format that is acceptable by your DBMS?

DB stores datetime as 2012-06-11 13:39:03

i search for 2012-06-11

thanks to rawtaz got this solved.

my custom model contructor overrided default one that set scenario as ‘search’.

As result scenario was empty