tracker issue : CF-3861312

select a category, or use search below
(searches all categories and all time range)
Title:

Improve joining in query of query

| View in Tracker

Status/Resolution/Reason: Needs Review//

Reporter/Name(from Bugbase): Adam Cameron / Adam Cameron (Adam Cameron)

Created: 12/03/2014

Components: Database, Query-of-Query(IMQ)

Versions: 11.0

Failure Type: Enhancement Request

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Trivial / Unknown

Locale/System: English / Platforms All

Vote Count: 9

CFML's QoQ is very limited in how it can join queries:
* only two queries
* only old-school filter joins (eg: from q1, q2 where q1.pk=q2.fk)
* no outer joins

This implementation is lovely for a proof of concept, but it's not really production-ready. And it's been like this since forever.

It's about time QoQ got a second tranche of development.


NB: I'm sure I've raised this (or variation thereupon) before, but I cannot find the ticket.

-- 
Adam

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3861312

External Customer Info:
External Company:  
External Customer Name: Adam Cameron.
External Customer Email:  
External Test Config: My Hardware and Environment details:

Attachments:

Comments:

Any enhancements to QoQ would be very welcome
Vote by External U.
9787 | December 03, 2014 03:39:27 AM GMT
This would definitely make QofQ a much more powerful feature. Can't even count the number of times I've had work around the current join limitations.
Vote by External U.
9788 | December 03, 2014 10:02:06 AM GMT
hell yes! hell yes! hell yes! hell yes! hell yes!
Vote by External U.
9789 | December 03, 2014 11:28:41 AM GMT
Please, please, please improve QoQ! As I said in another ticket, a number of times where QoQ should have been the right solution to a problem I've been unable to use it due to it not having some basic functionality.
Vote by External U.
9790 | December 03, 2014 06:42:17 PM GMT
This feature should have been included a long time ago.
Vote by External U.
9791 | December 04, 2014 09:32:33 AM GMT
+1 ......................
Vote by External U.
9792 | December 06, 2014 06:30:58 AM GMT
Yes Please! This would be absolutely fantastic when trying to pull data in from different databases into one query (Oracle and DB2 for example).
Vote by External U.
9793 | December 08, 2014 03:37:47 AM GMT
Any updates on this "review" that it needs?
Comment by External U.
9784 | January 25, 2016 08:31:16 AM GMT
Please add this update...it is one the big concerns with QoQ.
Vote by External U.
9794 | January 28, 2016 03:29:26 AM GMT
> Any updates on this "review" that it needs? Hello?
Comment by Adam C.
9785 | August 02, 2017 07:10:57 AM GMT
:/
Comment by Aaron N.
9786 | August 04, 2017 08:57:28 AM GMT