tracker issue : CF-3647042

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

Enable "spreadsheet to query" for functions

| View in Tracker

Status/Resolution/Reason: Needs Review//

Reporter/Name(from Bugbase): Raymond Camden / Raymond Camden (Raymond Camden)

Created: 10/07/2013

Components: Document Management, Office Integration

Versions: 10.0

Failure Type: Enhancement Request

Found In Build/Fixed In Build: Final /

Priority/Frequency: Trivial / Unknown

Locale/System: English / Platforms All

Vote Count: 3

As far as I can tell, there is no easy way (with functions) to create a query from a spreadsheet. If you use cfspreadsheet, you can quickly convert a file into a query. To do so with tags is more difficult. First, there is no way to get a rowcount. You can see if if you run getMetadata() on the SS object, but that isn't really documented. 

Obviously the tag does a bit of sniffing to figure out how many active rows and headers exist. That functionality should be exposed in a function as well.

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

Watson Bug ID:	3647042

Deployment Phase:	Release Candidate

External Customer Info:
External Company:  
External Customer Name: cfjedimaster
External Customer Email:  
External Test Config: My Hardware and Environment details:

Attachments:

Comments:

These were my findings too. And it should not be the case. +1 to fix. -- Adam
Vote by External U.
14317 | October 07, 2013 10:27:40 AM GMT
Should absolutely implement. All of the cfspreadsheet functionality should be available as scripted functions.
Vote by External U.
14318 | October 09, 2013 07:04:53 AM GMT
+1 ......................
Vote by External U.
14319 | September 05, 2015 01:35:40 AM GMT
Doesn't the generic script syntax serve the purpose here?
Comment by Vamseekrishna N.
14315 | September 24, 2015 06:35:10 AM GMT
I would imagine so.
Comment by External U.
14316 | September 24, 2015 07:37:55 AM GMT