tracker issue : CF-3860956

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

Provide more fully featured version of Query of Queries (QoQ). Support more functions

| View in Tracker

Status/Resolution/Reason: Needs Review//

Reporter/Name(from Bugbase): Gerry Gurevich / Gerry Gurevich (Gerry Gurevich)

Created: 12/02/2014

Components: Database

Versions: 11.0

Failure Type: Enhancement Request

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Trivial / Unknown

Locale/System: English / Win CE

Vote Count: 3

Almost any ANSI standard SQL command would be welcomed here.  In particular I was looking for something in the order by clause that would allow me to sort with NULLS first or NULLS last.

Absent that I tried to use COALESCE to put some values in the null field for sorting.  That also was not supported in QoQ.

The official docs list dozens of reserved words that look to be DB commands that aren't supported in QoQ.  Why not support them.

Other QoQ enhancements would be to get rid of the wonky way they handle data types.  With ColdFusion being typeless, it gets hard to deal with underlying type enforcement when it pops up.  QoQ has always been difficult in this way.

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

Watson Bug ID:	3860956

External Customer Info:
External Company:  
External Customer Name: GerryGurevich
External Customer Email:  
External Test Config: My Hardware and Environment details are not relevant in this situation.

Attachments:

Comments:

I was forced to pick a platform, but that is meaningless in this case. This should be part of the language core and available on all platforms.
Comment by External U.
9818 | December 02, 2014 03:47:45 PM GMT
+1 //////////////////////////////
Vote by External U.
9819 | December 02, 2014 04:50:08 PM GMT
+1 ......................
Vote by External U.
9820 | December 03, 2014 12:34:34 AM GMT
+1 this is long overdue!!!!!!
Vote by External U.
9821 | December 03, 2014 04:22:35 AM GMT
---- +1 ...................... Comment by External U. ---- should be ---- +1 ...................... Comment by Aaron N. ---- Yeah, QoQ needs unhandcuffed. Thanks!, -Aaron
Comment by Aaron N.
30182 | February 02, 2019 04:57:36 AM GMT
Related ticket: CF-4200041
Comment by Aaron N.
30183 | February 02, 2019 05:01:22 AM GMT