# Toad 3.8 - Possible to default to "All Results" view in editor grid?

**URL:** <https://forums.toadworld.com/t/toad-3-8-possible-to-default-to-all-results-view-in-editor-grid/34642>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [December 9, 2015, 7:39am UTC](https://forums.toadworld.com/t/toad-3-8-possible-to-default-to-all-results-view-in-editor-grid/34642 "2015-12-09T07:39:25Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![alloyd\_640](https://avatars.discourse-cdn.com/v4/letter/a/cc9497/32.png) [@alloyd\_640](https://forums.toadworld.com/u/alloyd_640)\
**Post date:** [December 9, 2015, 7:39am UTC](https://forums.toadworld.com/t/toad-3-8-possible-to-default-to-all-results-view-in-editor-grid/34642/1 "2015-12-09T07:39:25Z")

</div>

Thank you TOAD team for adding the functionality to see multiple query results in a single results grid. Is it possible to default to this view?

---

<div class="post-metadata">

**Author:** ![mercier104\_000](https://avatars.discourse-cdn.com/v4/letter/m/8e8cbc/32.png) [@mercier104\_000](https://forums.toadworld.com/u/mercier104_000)\
**Post date:** [December 10, 2015, 8:20am UTC](https://forums.toadworld.com/t/toad-3-8-possible-to-default-to-all-results-view-in-editor-grid/34642/2 "2015-12-10T08:20:52Z")

</div>

Hi, It’s already possible !

---

<div class="post-metadata">

**Author:** ![alloyd\_640](https://avatars.discourse-cdn.com/v4/letter/a/cc9497/32.png) [@alloyd\_640](https://forums.toadworld.com/u/alloyd_640)\
**Post date:** [December 10, 2015, 10:25am UTC](https://forums.toadworld.com/t/toad-3-8-possible-to-default-to-all-results-view-in-editor-grid/34642/3 "2015-12-10T10:25:21Z")

</div>

How?

---

<div class="post-metadata">

**Author:** ![mercier104\_000](https://avatars.discourse-cdn.com/v4/letter/m/8e8cbc/32.png) [@mercier104\_000](https://forums.toadworld.com/u/mercier104_000)\
**Post date:** [December 11, 2015, 3:39am UTC](https://forums.toadworld.com/t/toad-3-8-possible-to-default-to-all-results-view-in-editor-grid/34642/4 "2015-12-11T03:39:59Z")

</div>

Editor Menu, choose “Windows” (at the bottom) and “group execute”

When enable, buttons appear on the upper right of the “Group Execute window”

---

<div class="post-metadata">

**Author:** ![alloyd\_640](https://avatars.discourse-cdn.com/v4/letter/a/cc9497/32.png) [@alloyd\_640](https://forums.toadworld.com/u/alloyd_640)\
**Post date:** [December 11, 2015, 6:15am UTC](https://forums.toadworld.com/t/toad-3-8-possible-to-default-to-all-results-view-in-editor-grid/34642/5 "2015-12-11T06:15:06Z")

</div>

No, I think you misunderstood my original post. In an editor window, I can highlight multiple queries, and run them. Usually, each query shows as a seperate dataset within a new editor results tab. New with 3.8 is the addition of the “All Results” dataset. I am asking if, when executing multiple queries within a single editor, if we can default the results view to this “All Results” set.

![allresults.png](https://global.discourse-cdn.com/quest/original/2X/8/873c33be5295ea7c9f577b57879ef590c9222267.png)

---

<div class="post-metadata">

**Author:** ![RyanJohnson](https://avatars.discourse-cdn.com/v4/letter/r/f04885/32.png) [@RyanJohnson](https://forums.toadworld.com/u/RyanJohnson)\
**Post date:** [December 11, 2015, 7:12pm UTC](https://forums.toadworld.com/t/toad-3-8-possible-to-default-to-all-results-view-in-editor-grid/34642/6 "2015-12-11T19:12:13Z")

</div>

I put in QAT-6896 so we can discuss this

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [December 11, 2015, 7:20pm UTC](https://forums.toadworld.com/t/toad-3-8-possible-to-default-to-all-results-view-in-editor-grid/34642/7 "2015-12-11T19:20:44Z")

</div>

The way we wrote it the feature is it will only display when you have the option on. And then when you use F5 to execute a script and have multiple sets it will stack them. See the option below. are you asking that single executes keep stacking themselves? Or is using the setting with F5 workable for you?

 ![all grid.png](https://global.discourse-cdn.com/quest/original/2X/a/ac8bc5db567a1216a8eaa5ff465b438a390b7411.png)

---

<div class="post-metadata">

**Author:** ![haybeecee](https://avatars.discourse-cdn.com/v4/letter/h/edb3f5/32.png) [@haybeecee](https://forums.toadworld.com/u/haybeecee)\
**Post date:** [December 12, 2015, 1:24pm UTC](https://forums.toadworld.com/t/toad-3-8-possible-to-default-to-all-results-view-in-editor-grid/34642/8 "2015-12-12T13:24:08Z")

</div>

ok

---

<div class="post-metadata">

**Author:** ![mercier104\_000](https://avatars.discourse-cdn.com/v4/letter/m/8e8cbc/32.png) [@mercier104\_000](https://forums.toadworld.com/u/mercier104_000)\
**Post date:** [December 14, 2015, 2:32am UTC](https://forums.toadworld.com/t/toad-3-8-possible-to-default-to-all-results-view-in-editor-grid/34642/9 "2015-12-14T02:32:55Z")

</div>

Hi,

why don’t you use SQL command UNION or UNION ALL ??

---

<div class="post-metadata">

**Author:** ![alloyd\_640](https://avatars.discourse-cdn.com/v4/letter/a/cc9497/32.png) [@alloyd\_640](https://forums.toadworld.com/u/alloyd_640)\
**Post date:** [December 14, 2015, 6:27am UTC](https://forums.toadworld.com/t/toad-3-8-possible-to-default-to-all-results-view-in-editor-grid/34642/10 "2015-12-14T06:27:52Z")

</div>

UNION and UNION ALL only apply for like data sets (same datatypes and same # of columns). It wouldn’t work for totally unrelated data sets.

---

<div class="post-metadata">

**Author:** ![mercier104\_000](https://avatars.discourse-cdn.com/v4/letter/m/8e8cbc/32.png) [@mercier104\_000](https://forums.toadworld.com/u/mercier104_000)\
**Post date:** [December 15, 2015, 1:49am UTC](https://forums.toadworld.com/t/toad-3-8-possible-to-default-to-all-results-view-in-editor-grid/34642/11 "2015-12-15T01:49:23Z")

</div>

I don’t understand utility of merging heterogeneous datasets.

Would you explain your idea ?

---

<div class="post-metadata">

**Author:** ![alloyd\_640](https://avatars.discourse-cdn.com/v4/letter/a/cc9497/32.png) [@alloyd\_640](https://forums.toadworld.com/u/alloyd_640)\
**Post date:** [December 15, 2015, 6:18am UTC](https://forums.toadworld.com/t/toad-3-8-possible-to-default-to-all-results-view-in-editor-grid/34642/12 "2015-12-15T06:18:39Z")

</div>

This doesn’t merge them, it just shows the together at the same time. SQL Management Studio has done this for years (much better than even Toad’s recent implementation). As an analyst, I’m constantly looking at tons of disparate but related data, and this just speeds up the process.
