#569 (ok 4.2) Load/Save Query By Example

Next_release
fixed
None
1
2014-05-21
2004-07-28
Anonymous
No

It would be nice if I could load and save the Query By
Example Pages on the "Query" page.

I know you can load and save SQL queries, it shouldn't
be too hard to load and save a QBE page.

Discussion

  • Hugues Peccatte

    Hugues Peccatte - 2014-02-01

    Hi,

    I'm thinking about implementing this feature.
    Would it be possible to store the information (in JSON) in phpmyadmin.pma_userconfig or is it better to create a new table ?

    Thanks.

     
  • Marc Delisle

    Marc Delisle - 2014-02-01

    I think it's better to create a new table.

     
  • Hugues Peccatte

    Hugues Peccatte - 2014-02-01

    Ok, thanks.
    Where should be the SQL to create the table please ? examples/create_tables.sql and examples/create_tables_drizzle.sql ?
    And after, I need to add a line in config.inc.php, like other lines commented, that's it ?

    I'll try to do a mock-up, to validate my idea.

     
    • Marc Delisle

      Marc Delisle - 2014-02-01

      Yes, these .sql files.
      No, we have no config.inc.php in the codebase; use config.sample.inc.php.

       
  • Hugues Peccatte

    Hugues Peccatte - 2014-02-01

    Here is a mock-up while selecting a saved search.

     
  • Hugues Peccatte

    Hugues Peccatte - 2014-02-01

    And here a mock-up while saving a new search. (A button to save is missing.)

     
  • Hugues Peccatte

    Hugues Peccatte - 2014-02-01

    I think about having a saved search for a user, a database and a table.
    The data could be stored like in pma_recent (one line by user) or like in pma_table_uiprefs (easier to get the saved searches of a table).

     
  • Marc Delisle

    Marc Delisle - 2014-02-01

    The mock-ups look fine. By the way, this feature request is about saving multi-table QBE (open a database, then click on Query); it's not about saving single-table searches.

     
  • Hugues Peccatte

    Hugues Peccatte - 2014-02-01

    Ok, I didn't catch this…
    Is there any documentation for this page please ? I've never used it before, and it seems that I didn't catch the aim of all the fields…

    Thanks.

     
    • Marc Delisle

      Marc Delisle - 2014-02-02

      Apart from the book "Mastering phpMyAdmin" I don't think that there is any doc. Do you have a specific question?

       
      • Hugues Peccatte

        Hugues Peccatte - 2014-02-02

        Yes. What ever the value I set in the last field (the one with "allo"), there is no impact on the query…
        What should be in this field please ?

        Thanks.

         
  • Marc Delisle

    Marc Delisle - 2014-02-02

    For this string "allo" to have an effect, tick the checkbox "Ins" which is on the left part of this criteria line, then click to update the query.

     
  • Hugues Peccatte

    Hugues Peccatte - 2014-02-03

    It seems that the only things that happened are that I have a new line (like the one with "allo"), but there were no effect on the query…
    Could you please give me an example where these fields have an impact on the query ?
    Thanks.

     
  • Marc Delisle

    Marc Delisle - 2014-02-03

    You found a bug. I tested on QA_3_5: writing a criteria on the second criteria link makes it appear in the generated query when clicking to update the query (you should not mark Ins, sorry). But starting with QA_4_0, the second criteria line is not used.

     
  • Hugues Peccatte

    Hugues Peccatte - 2014-02-03

    Ok, so I could work on this feature.
    The bug would be another subject.

    Thanks for all your time.

     
  • Marc Delisle

    Marc Delisle - 2014-02-26
    • summary: Load/Save Query By Example --> (ok 4.2) Load/Save Query By Example
    • Description has changed:

    Diff:

    • status: open --> resolved
    • assigned_to: Hugues Peccatte
    • Group: --> Next_release
    • Priority: 5 --> 1
     
  • Marc Delisle

    Marc Delisle - 2014-05-21
    • Status: resolved --> fixed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks