#11229: Wrong default collection get selected in Query Builder

ashwini.chavan reported 2014-01-02T09:57:39Z · last modified 2014-06-04T00:05:26Z

Wrong default collection get selected in Query Builder

Dev	abdullah
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Query Builder
Version	15.0

Aqua Data Studio 15.0.0-dev-58

Database: MongoDB 2.4.6

1.Select MongoDB Server node,expand it

Expand Databases node and select any desired database("Mongodb",expand it

Go to Collections node,expand it.

Select any collection,right click on it and select Query Builder option

In my case I have selected "Order" collection,right click on it and select Query Builder option

Query Builder window is opened and Add collection window get displayed

2.But in Add collection window first collection that is "Addtoset" get selected

it should be select "Order" collection instead of "Addtoset"

I have compared with Teradata Aster it display correct default table as selected,please go through screenshot

4 attachments

Add collection.jpg

2014-01-02T09:57:39Z

307 KB
aster.jpg

2014-01-02T09:57:39Z

304 KB
QB1.png

2014-06-03T09:11:19Z

124 KB
QB2.png

2014-06-03T09:11:19Z

136 KB

All Comments (4) Change History

SachinPrakash 2014-01-02T17:25:29Z

We can address this in new query builder

abdullah 2014-05-29T01:54:05Z

In new QB, we dont have "Quick Table Add" open when the QB is loaded. Here is behavior implemented in new QB:

If a user launches QB from a table/view selection, the next "Quick Table Add" will show user's selection.

ashwini.chavan 2014-06-03T09:10:37Z

See attached screenshots (QB1 and QB2) Is that the accepted scenarios?

Case 1:Expand any collection(i.e."baseball")

Expand fields folder,select any column(i.e."teamName") then opened QB

In QB window go to "Worksheet" menu and select "Quick Collection Add..." option

In Quick Collection Add window all collections get listed

Case 2:Create two collection with same name(i.e.geoJson,geoJson1)

Select any collection,opened QB

In QB window go to "Worksheet" menu and select "Quick Collection Add..." option

In Quick Collection Add window both collections get listed

tariqrahiman 2014-06-04T00:05:26Z

Yes… There are a few improvements that are logged in the other project and that will take care of this. I am closing this issue, since there are multiple issues existing

Search Tips

Aqua Data Studio / nhilam

Wrong default collection get selected in Query Builder

4 attachments

Issue #11229

Completion

1 issue link

Issue #12007

Search Tips

Aqua Data Studio / nhilam

Title

Wrong default collection get selected in Query Builder

4 attachments

Issue #11229

Completion

1 issue link

Issue #12007