Maybe we did not understand correctly the feature request. Let's take for example the sakila sample database. When I show the structure for film_actor, the actor_id column has a "Distinct values" link. When I click on this, the resulting page shows distinct values and each value is linked to the related actor table.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
On demo.pma.net it works, but on my local 4.1.7 it doesn't.
It does 'allow' me to edit the value when I double-click, but then it throws a fatal JS error.
It also displays only the first 25 rows.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Can you give an example of the SQL query that would be used to search for that value?
Field browse: SELECT COUNT( * ) AS `Rows` , `uid` FROM `xwi_players` GROUP BY `uid` ORDER BY `uid`
Field search: SELECT * FROM `xwi_players` WHERE `uid` =18086
I think that current transformations framework could be generalized to support such things.
This requested feature was implemented in the repository and will be part of a future release; thanks for suggesting.
Where was this implemented? I don't see it when I browse for unique values.
Maybe we did not understand correctly the feature request. Let's take for example the sakila sample database. When I show the structure for film_actor, the actor_id column has a "Distinct values" link. When I click on this, the resulting page shows distinct values and each value is linked to the related actor table.
On demo.pma.net it works, but on my local 4.1.7 it doesn't.
It does 'allow' me to edit the value when I double-click, but then it throws a fatal JS error.
It also displays only the first 25 rows.
Reopening...
Implemented with https://github.com/phpmyadmin/phpmyadmin/commit/7a9d9f4f14ce5c73a04bac0198f48ebc1932a4e3