Ticket #1790 (closed enhancement: duplicate)

Opened 4 years ago

Last modified 4 years ago

PostGIS query: allow JOINs

Reported by: pcav Owned by: nobody
Priority: minor: annoyance Milestone: Version 1.2.0
Component: Data Provider Version: Trunk
Keywords: Cc:
Platform Version: Platform: All
Must Fix for Release: No Awaiting user input: no

Description

An useful addition to the query builder would be the ability of adding non only WHERE clauses, but also JOIN with other tables.

Change History

Changed 4 years ago by jef

  • status changed from new to closed
  • resolution set to duplicate

the query builder is just meant to create the where clause to filter on an existing table. That doesn't alter the set of attributes the layer has. Doing that would also require changes elsewhere (in that sense it's a duplicate of #121).

For now joins can be done using  views or - if it's just to filter the original table using information from other tables - using  subquery expressions

Note: See TracTickets for help on using tickets.