StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>If you also want to search/sort by that column, this will probably be the best answer I can give you:</p> <p><a href="http://www.mrsoundless.com/php/yii/searching-and-sorting-a-column-from-a-related-table-in-a-cgridview/" rel="nofollow">http://www.mrsoundless.com/php/yii/searching-and-sorting-a-column-from-a-related-table-in-a-cgridview/</a></p> <p><strong>UPDATE</strong> (because I'm guessing you didn't really understand the link. Or simply didn't want to read it because it's long..)</p> <p>I'm assuming:</p> <ul> <li>You got a relation to your bookdetails table called 'bookdetails'</li> <li>You got a column in your bookDetails table called 'name'</li> </ul> <p>Step 1: Add this to your model:</p> <pre><code>private $_name = null; public function getName() { if ($this->_name === null && $this->bookDetails !== null) { $this->_name = $this->bookDetails->name; } return $this->_name; } public function setName($value) { $this->_name = $value; } </code></pre> <p>Step 2: Now add 'name' to the search rule in the 'rules' function of your Book model</p> <p>Step 3: Change your 'search' function of your Book model to:</p> <pre><code>public function search() { $criteria=new CDbCriteria; $criteria->with = "bookDetails"; // Make sure you query with the post table. $criteria->compare('t.bookId',$this->bookId,true); $criteria->compare('t.bookState',$this->bookState); $criteria->compare('t.bookBookdetailId',$this->bookBookdetailId,true); $criteria->compare('bookDetails.name', $this->name,true); $sort = new CSort(); $sort->attributes = array( 'defaultOrder'=>'t.create_time DESC', 'bookId'=>array( 'asc'=>'t.bookId', 'desc'=>'t.bookId desc', ), 'bookState'=>array( 'asc'=>'t.bookState', 'desc'=>'t.bookState desc', ), 'bookBookdetailId'=>array( 'asc'=>'t.bookBookdetailId', 'desc'=>'t.bookBookdetailId desc', ), 'name'=>array( 'asc'=>'bookDetails.name', 'desc'=>'bookDetails.name desc', ), ); return new CActiveDataProvider('Book', array( 'criteria'=>$criteria, 'sort'=>$sort )); } </code></pre> <p>Step 4: Now add 'name' to your columns array in your CGridView. Should become something like:</p> <pre><code>'dataProvider' => $model->search(), 'columns' => array( 'bookCatalgoueNumber', 'bookDescription', 'bookBookdetailId', 'name', ), </code></pre> <p>Step 5: Read the article to understand what's going on. Step 6: Enjoy</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload