Firehose improvements

[dwlhs]

The Firehose is probably the tool I use most inside DW (besides Assets do download log files). From DW9 to DW10, a lot of the nifty features were not considered, and the Firehose not feels like a bit of a step back to the firehose we had in the old ASP version of DW.

It's an important tool, especially considering cloud hosting, where you can't access the SQL server, so here are some improvements to get et back on track:

• Prefill the editor with "select from ". in 90 out of 100 times, you want to select--from some table of view when opening the firehose
• In DW9 you could hit Ctrl+Enter to execute the statement - please add that
• The drop-down with table names is greatly missed. Please add that and let it include views also
• The drop-down with history was a great addition. Please let's have that again.
• When entering an invalid statement, whether it's a syntax error or misspelled table, you get "No results found". Let us see the error message, please
• Every time you execute a statement, a new output overlay is added, and at some point you find yourself having many overlays to deal with. Please add the output to the same overlay.
• In 10.4 the column headers are stick, which is good, but when scrolling the result, it reveals that the "Firehose Data (1234)" is transparent, and the results are shown there also. The header of the overlay is "Firehose Data", so why not get rid of the "Firehose Data (1234)" and add the record count to the header (image 1)?
• In DW9, when doing DML operations, you would get a waning containing how many records would be affected. In DW10, you get "No results", so basically you know if the operation succeeded or if the statement caused an error. Please, let's have the warning back
• If you neglect to add a name for a column, e.g., running SELECT COUNT() FROM Page, you get an error saying "The mapping name is not specified" (see image 2). you need to know that you have to apply a name for the column, e.g., SELECT COUNT() AS NumberOfRecords FROM Page to avoid this, because the trace file is nowhere near helpful (image 3). DW9 was more forgiving and simply added "No column name". Please make the DW10 firehose more forgiving.
• The "intellisense", however, I thought was nifty, but it seams to just suggest phrases that have already been typed in. There seems to be a huge potential to improve this if e.g., it was aware of the table browser.

1

2

3

[nicped]

I agree this needs some love. A lot of it!

[Wassini]

"Every time you execute a statement, a new output overlay is added, and at some point you find yourself having many overlays to deal with. Please add the output to the same overlay."

A new feature could also be the option to add tabs to the output:

[dwlhs]

Hi :)

I just noticed that the firehose sends the query using GET. This means that the length of SQL statements that we can uses is limited to how much can be submitted in the query string by the http protocol.

Please change so that it uses POST instead.

Br. Lars