View. See Data Viewer for details. Views A view is the result of the applying the specified aggregation pipeline to the source collection or view. In the main window, click View to open the view view. Show the Query Plan of the view. In the Pipeline tab, you can add, insert or delete aggregation pipeline stages. In the Operator column, select an expression operator. An expression template SELECT tab. You can specify additional output field options.  Check the DISTINCT checkbox to force the query to return distinct results.  To add the field alias, click and enter the name.

View. See Data Viewer for details. Views A view is the result of the applying the specified aggregation pipeline to the source collection or view. In the main window, click View to open the view Explain Show the Query Plan of the view. In the Pipeline tab, you can add, insert or delete aggregation pipeline stages. In the Operator column, select an expression operator. An expression template SELECT tab. You can specify additional output field options.  Check the DISTINCT checkbox to force the query to return distinct results.  To add the field alias, click and enter the name.

View. See Data Viewer for details. Views A view is the result of the applying the specified aggregation pipeline to the source collection or view. In the main window, click View to open the view Explain Show the Query Plan of the view. In the Pipeline tab, you can add, insert or delete aggregation pipeline stages. In the Operator column, select an expression operator. An expression template SELECT tab. You can specify additional output field options.  Check the DISTINCT checkbox to force the query to return distinct results.  To add the field alias, click and enter the name.

SELECT tab. You can specify additional output field options. • Check the DISTINCT checkbox to force the query to return distinct results. • To add the field alias, click and enter the name. ignored. Count Return the number of items. Null values are not counted. Count(Distinct) Return the number of distinct items. Null values are not counted. Min Return the minimum value across all records DateTime Count Return the number of items. Null values are not counted. Count(Distinct) Return the number of distinct items. Null values are not counted. Year Return the year of the date (0000-9999)

SELECT tab. You can specify additional output field options. • Check the DISTINCT checkbox to force the query to return distinct results. • To add the field alias, click and enter the name. ignored. Count Return the number of items. Null values are not counted. Count(Distinct) Return the number of distinct items. Null values are not counted. Min Return the minimum value across all records DateTime Count Return the number of items. Null values are not counted. Count(Distinct) Return the number of distinct items. Null values are not counted. Year Return the year of the date (0000-9999)

SELECT tab. You can specify additional output field options. • Check the DISTINCT checkbox to force the query to return distinct results. • To add the field alias, click and enter the name. ignored. Count Return the number of items. Null values are not counted. Count(Distinct) Return the number of distinct items. Null values are not counted. Min Return the minimum value across all records DateTime Count Return the number of items. Null values are not counted. Count(Distinct) Return the number of distinct items. Null values are not counted. Year Return the year of the date (0000-9999)

SELECT tab. You can specify additional output field options.  Check the DISTINCT checkbox to force the view to return distinct results.  To add the field alias, click and enter the name.

SELECT tab. You can specify additional output field options.  Check the DISTINCT checkbox to force the view to return distinct results.  To add the field alias, click and enter the name.