Difference between #46 and #47 of
Yii v2 snippet guide II

Revision #47 has been created by rackycz on Oct 5, 2020, 8:20:23 PM with the memo:

Search sort related column
« previous (#46) next (#48) »

Changes

Title unchanged

Yii v2 snippet guide II

Category unchanged

Tutorials

Yii version unchanged

2.0

Tags unchanged

tutorial,beginner,yii2,snippets

Content changed

[...]
// You must use joinWith() in order to have both tables in one JOIN - then you can call WHERE and ORDER BY on the 2nd table.
// Explanation here:
// https://stackoverflow.com/questions/25600048/what-is-the-difference-between-with-and-joinwith-in-yii2-and-when-to-use-them

$query = Invoice::find()->joinWith('companyRelation');

// Appending new sortable column:
$sort = $dataProvider->getSort();
$sort->attributes['company_name'] = [
'asc' => ['table.column' => SORT_ASC],
[...]
4 0
3 followers
Viewed: 73 232 times
Version: 2.0
Category: Tutorials
Tags: beginner, snippets, tutorial, yii2
Written by: rackycz
Last updated by: rackycz
Created on: Aug 26, 2020
Last updated: 2 years ago
Update Article
Revert to #46 | Revert to #47

Revisions

View all history