#1189 Add an ajax search tool to be able to quickly find ids

Needs_decision
out-of-date
nobody
Normal
2015-02-18
2009-12-24
Anonymous
No

Sometime you have many relationships in a table, and you need to insert data. It becomes a painful task when you constantly have to go check the ids of your parent rows for each foreign keys.

Is there a tool that make this task easier, by allowing me to do a kind of ajax search for ids while I am inserting data?

For exemple, if I would add a message, I would do an "ajax search" for the author "Steve". and it would return a list of authors with the name "Steve" along with their id and other columns. I could then choose the right row and column and the id would be added to the field

Discussion

  • PHPcian

    PHPcian - 2012-12-25

    Was this feature request worked on?

     
  • Shajini

    Shajini - 2014-11-14

    I hope this will help in database handling. I really like to implement this. May I try this?

     
  • Marc Delisle

    Marc Delisle - 2014-11-14

    Sure, you may. Note that the UI for this has not been discussed.

     
  • Shajini

    Shajini - 2015-01-14

    I attached UI document here. Can you tell about your comments for this UI?

     
    • Marc Delisle

      Marc Delisle - 2015-01-14

      In phpMyAdmin we already have a feature that shows the foreign keys + one display column. How is your proposal different?

       
  • Shajini

    Shajini - 2015-01-16

    Is there any features to retrieve relational data by connecting foreign keys and display them in table view? Can we insert or update through that feature?

     
    • Marc Delisle

      Marc Delisle - 2015-01-16

      Yes, there is. Try it with two InnoDB tables and a foreign key. You can insert and update in the main table, not in the related table.

       
  • Shajini

    Shajini - 2015-02-16

    Here i attached as pdf what we did until now. please check out and tell your opinion.
    thank you.

     
    • Marc Delisle

      Marc Delisle - 2015-02-18
      1. Why did you replace Search with Relational_Search? If you want to add a feature, you should not replace another feature.

      2. I don't believe that what you describe corresponds to what was asked in this feature request. The request mentions that the user is inserting data. You want the user to start by doing a search.

       
  • Marc Delisle

    Marc Delisle - 2015-02-18

    The search feature of "Browse foreign values" already exists and IMO fulfills this feature request.

     
  • Marc Delisle

    Marc Delisle - 2015-02-18
    • status: open --> out-of-date
    • Group: --> Needs_decision