DBTNG does not support grouped joins

Created on 23 October 2011, over 13 years ago
Updated 22 June 2023, almost 2 years ago

It does not seem possible to build queries of this sort with the dynamic query API:

SELECT * FROM one LEFT JOIN (
two INNER JOIN
three ON [conditions]
) ON [conditions]

This may seem rather esoteric but has very common applications. For example: adding a filter to a View that filters out products already in the customer's shopping cart.

✨ Feature request
Status

Postponed: needs info

Version

9.5

Component
DatabaseΒ  β†’

Last updated 1 day ago

  • Maintained by
  • πŸ‡³πŸ‡±Netherlands @daffie
Created by

πŸ‡¬πŸ‡§United Kingdom joachim

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • πŸ‡ΊπŸ‡ΈUnited States smustgrave

    Wonder if this is still a needed feature request?

  • Status changed to Closed: works as designed 9 days ago
  • πŸ‡³πŸ‡ΏNew Zealand quietone

    Nearly another two years and there is no discussion or support for this idea. And it looks like this may be a support request that was answered.

    The proposal doesn't met the Criteria for evaluating proposed changes β†’ . In this case, there is not demonstrated demand and support for the change.

    If there is interest in this re-open the issue and add a comment. Or open a new issue and reference this one.

Production build 0.71.5 2024