× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Ashwini Chavan
ashwini.chavan reported 2014-01-02T07:34:52Z  · tariqrahiman last modified 2014-06-14T00:03:45Z

Distinct() aggregation function is missing in drop down list of Group By column


Dev
Abdullah Asif
abdullah
QA
Tariq Rahiman
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("local")database,expand it
  Go to Collections node,expand it.
  Right click on it,select Query Builder option
  Query Builder window is opened and Add collection window get display
  
2.In Add collection window,select any collection under Collections Tab in my case I have selected "Order" collection
  then click Add and Close button,selected collection get display in Diagram Pane
  check any field which is display in collection diagram,selected field get display in Column Pane 
  in my case I have check "cust_id" field then it will get display in Column Pane
  
3.Go to Group By column then click,drop down list get display.If this column is not present
   press Ctrl+G,Group By column get added in Column Pane
   In drop down list DISTINCT() function is missing but MongoDB support DISTINCT() aggregation operation
   for more information please go thorough link: http://docs.mongodb.org/manual/core/aggregation-introduction/
2 attachments
  •  
  •  
  • No shares
  •  
All Comments (1) Change History
Sort 

Issue #11224
Closed
Fixed
Resolved 2014-06-09T22:03:42Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017