#914 View query builder.

invalid
Marc Delisle
5
2013-06-11
2006-05-01
Eric
No
0 up votes | 0 down votes | 0%
6 comments

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.

Discussion

  • Michal Čihař
    Michal Čihař
    2006-05-01

    Logged In: YES
    user_id=192186

    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
    user_id=1512233

    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 t1.id = t2.id".
    It's going to be some long drawn out query like "SELECT *,
    (SELECT id FROM t1 WHERE t2.id = id) as id,
    (SELECT name FROM t1 WHERE t2.id = 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
    user_id=210714
    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.

     
    • status: pending-rejected --> closed-rejected
     
  • Logged In: YES
    user_id=1312539
    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