Menu

#1241 (ok 4.4) Browse Field -> Search

Needs_decision
fixed
Low
2015-04-20
2010-05-07
No

In the structure tab, each field has a browse command. It would be great if the results table linked each result to a search for that value.

Discussion

  • Lori Lee

    Lori Lee - 2010-05-07

    Can you give an example of the SQL query that would be used to search for that value?

     
  • Olaf van der Spek

    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

     
  • Michal Čihař

    Michal Čihař - 2010-05-11

    I think that current transformations framework could be generalized to support such things.

     
  • Marc Delisle

    Marc Delisle - 2012-04-05

    This requested feature was implemented in the repository and will be part of a future release; thanks for suggesting.

     
  • Michal Čihař

    Michal Čihař - 2013-05-09
    • Status: open-accepted --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed
     
  • Olaf van der Spek

    Where was this implemented? I don't see it when I browse for unique values.

     
  • Marc Delisle

    Marc Delisle - 2014-02-10

    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.

     
  • Olaf van der Spek

    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.

     
  • Marc Delisle

    Marc Delisle - 2014-02-10

    Reopening...

     
  • Madhura Jayaratne

    • assigned_to: Madhura Jayaratne
     
  • Madhura Jayaratne

    • summary: Browse Field -> Search --> (ok 4.4) Browse Field -> Search
    • status: open --> resolved
    • Priority: 5 --> 1
     
  • Marc Delisle

    Marc Delisle - 2015-02-15
    • Priority: 1 --> Normal
     
  • Marc Delisle

    Marc Delisle - 2015-02-15
    • Priority: Normal --> Low
     
  • Marc Delisle

    Marc Delisle - 2015-04-20
    • Status: resolved --> fixed
     
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.