StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
20614576
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-12-16T15:31:37.867
FavoriteCount
0
LastActivityDate
2013-12-16T15:39:57.807
LastEditDate
2017-05-23T12:08:19.640
LastEditorUserId
-1
OwnerUserId
823109
ParentId
20545881
PostTypeId
2
Score
6
ViewCount
0
LastEditorDisplayName
text
Body
The Main reason. In your database table column(user_city_id), you have Empty values not NULL values. So your query is unable to operate "IS NULL" and "IS NOT NULL" on the corresponding column. <pre><code> 1. NULL is Special Data Type. 2. Where as Empty means a string/value which is empty. </code></pre> You can read more <a href="https://stackoverflow.com/questions/5615747/what-is-the-difference-between-null-and-empty">here</a> No need to add operator for first addCondition For your information, When you are adding a condition to your criteria, no need to add "AND" operator becoz by default "AND" is the operator in <a href="https://github.com/yiisoft/yii/blob/1.1.14/framework/db/schema/CDbCriteria.php#L218" rel="nofollow noreferrer">addConditon</a>. And no use if you add operation for first addCondition, You should add this for your next addConditions if you have any. <pre><code> //AND is not required here as AND is default operation. //This operator (AND) wont help in first condition. $criteria->addCondition('condition1=1','AND'); //This bellow condition will be concatenate with above condition so, here operator is required. $criteria->addCondition('condition2=1','OR'); </code></pre> The Solution is I dont like to disturb default search method in my model. As i'm using MVC Framework, i should follow at least some MVC rules. Otherwise there is no meaning using this MVC. So, accessing $_GET stuff in my Model is not good here. so i'm creating a new method in my Model with two parameters. <pre><code> function yourModelMethod($isParamExist,$customer_basics_id) { $criteria = new CDbCriteria; $criteria->condition = "customer_basics_id=$customer_basics_id"; if($isParamExist) { $criteria->condition='TRIM(user_city_id) =""'; } else { $criteria->condition='TRIM(return_date) !=""'; } return new CActiveDataProvider($this, array( 'criteria' => $criteria, )); } </code></pre> Now, I'm using this model method from my controller <pre><code> function actionYourController() { $model=new MyModel(); $isParamExist=isset($_GET['ulip']); $customer_basics_id=CustomerBasics::getCustomerBasicsId(Yii::app()->session['user_id']); $activeData=$model->yourModelMethod($isParamExist,$customer_basics_id); $this->render('myView',array('activeData'=>$activeData)); } </code></pre> I hope, it will definitely solve your problem. 
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POIS NOT NULL not working in Yii Active Record
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USHearaman
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POIS NOT NULL not working in Yii Active Record
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COIt worked....Thanks
 singulars
 PostPostId
 PO
 UserUserId
 USSky
2. COYou are welcome.
 singulars
 PostPostId
 PO
 UserUserId
 USHearaman

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.