Yii2: ActiveRecord::find()->indexBy()->column() not indexing as expected

[tom--]

Given the documentation of select(), indexBy and column() I expected

Book::find()->select('title')->indexBy('isbn')->column()

to return an associative array of book titles indexed by ISBN. It returned instead a numeric array of titles. The following produced the same result.

Book::find()->select(['title', 'isbn'])->indexBy('isbn')->column()

In other words, for the above two cases indexBy() doesn't do anything.

The following returned an array of Book models indexed by ISBN but if indexBy is only supposed to work with certain getters like all() then the documentation for indexBy() should say so.

Book::find()->indexBy('isbn')->all()

If indexBy() is really just an option for all() then shouldn't it be a parameter of that method rather than a property of Query.

[lynicidn]

accept it - https://github.com/yiisoft/yii2/issues/7107#issuecomment-72256210

[samdark]

That's more of design decision. @qiangxue is it expected or should be fixed?

[qiangxue]

This is currently working as expected as column() uses the native PDO column fetch mode.
But I think we can consider enhancing column() in this case.

We mainly need to modify yii\db\Query::column() so that when indexBy is set, it should fetch multiple columns. Things get tricky, though, when indexBy is a callable.

[lynicidn]

it worked before

[tom--]

@samdark what does "status:ready for adoption" mean?

[samdark]

Means that it is OK to improve it so it could be worked on.

[anton-p-ivanov]

I have same issue. @samdark @qiangxue when it will be adopted? This issue allows to save proccessing time and forget about ArrayHelper::map().

[samdark]

You can speed things up by working on a pull request.

[sergey-rud]

It's really good news, if select(['id', 'name']), indexBy('id') and column('name') will return result:
array(id=>name)

[lynicidn]

column($db = null)

column fetch first column, i use it

MyModel::find()->select('name', 'id')->indexBy('id')->column()

[sergey-rud]

Anyway it's more useful, than use ArrayHelper for this simple need.

[melledijkstra]

Is there already an easier way instead of using ArrayHelper to get the following result:
~
[id => name]
~
All I'm getting is (->select(id,name)->indexBy(id)->all()):
~
[id => [id, name]]
~

[tom--]

@MelleDijkstra try ->select('name')->indexBy('id')->column()

[melledijkstra]

@tom-- I'll give it a try!