SourceForge has been redesigned. Learn more.

#914 View query builder.


View query builder.

Check the boxes next to the fields you want to
include from the Structure page, click "Create View".

Next page would ask if you want to add another table,
then click Next.

Next page should ask which fields (if any) you want
to use to join the two tables, then click Next.

Next page asks if you want to add another table.

Keep going through until you get everything you want
in your view.


  • Michal Čihař

    Michal Čihař - 2006-05-01

    Logged In: YES

    Would not be better to modify Query tab on database to allow
    creating view instead of select?

  • Eric

    Eric - 2006-05-03

    Logged In: YES

    That would work except, most of the time when you make a
    view, it's not just going to be for some simple query
    like "SELECT t1.*, t2.* FROM t1, t2 WHERE =".
    It's going to be some long drawn out query like "SELECT *,
    (SELECT id FROM t1 WHERE = id) as id,
    (SELECT name FROM t1 WHERE = id) as name
    FROM t2, t3 WHERE t2.entry = (SELECT entry FROM t3 WHERE
    id = 5)"

  • Marc Delisle

    Marc Delisle - 2008-03-06
    • assigned_to: nobody --> lem9
    • status: open --> pending-rejected
  • Marc Delisle

    Marc Delisle - 2008-03-06

    Logged In: YES
    Originator: NO

    Well, what you suggested in your initial post is already supported via the Query menu. When your query is ready, you execute it and you can create a view from it, directly from the interface.

    For your other long query, you can browse a table, click "Create view" and type the query directly.

  • SourceForge Robot

    • status: pending-rejected --> closed-rejected
  • SourceForge Robot

    Logged In: YES
    Originator: NO

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).

  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-rejected --> invalid