Common use of Projection Clause in Contracts

Projection. In this tab, you can choose which fields to include or exclude in the returned documents. If you not specify the projection, all fields will be returned. In this tab, you can sort the returned documents by fields in ascending or descending order. In this tab, you can limit the maximum number of documents to return and set the number of documents to skip. Code Snippets Code Snippets provide an easy way for you to insert reusable code into editor when writing statements or scripts. The Code Snippet pane is on the right side of the editor. You can click the icon to open the library. The library includes built-in and user-defined snippets. Choose a label from the drop-down list or enter a search string in the Search box to filter the list. If you want to show the available snippets according to your database type, you can right-click anywhere on the library and disable Show Snippets For Other Database Type. Built-in snippets are non-editable. A user-defined snippet can be edited by double-clicking it in the library. If you want to hide the built-in snippets, you can right-click anywhere on the library and disable Show Preset Snippets. There are two ways to insert a snippet into the editor. • You can start typing the name of a snippet in the editor. Smart code completion will pop up a list of suggestions for the word completion automatically. Select a snippet name from the list, the saved code will be inserted to the editor. • You can simply drag and drop a snippet from the library into the editor. After inserting the snippet with placeholders to the editor, you can easily navigate to them by clicking on one of the placeholders, and then using the TAB key and entering the information. You can create your own code snippets and add them to the library. To create a code snippet, select your desired code in the editor, then right-click and select Create Snippet. Alternatively, click in the Code Snippet pane. If you use this method, you must manually enter the code in the New Snippet window; code selected in the editor is not automatically added to the Code box.

Projection. In this tab, you can choose which fields to include or exclude in the returned documents. If you not specify the projection, all fields will be returned. In this tab, you can sort the returned documents by fields in ascending or descending order. In this tab, you can limit the maximum number of documents to return and set the number of documents to skip. Code Snippets Code Snippets provide an easy way for you to insert reusable code into editor when writing statements or scripts. The Code Snippet pane is on the right side of the editor. You can click the icon to open the library. The library includes built-in and user-defined snippets. Choose a label from the drop-down list or enter a search string in the Search box to filter the list. If you want to show the available snippets according to your database type, you can right-click anywhere on the library and disable Show Snippets For Other Database Type. Built-in snippets are non-editable. A user-defined snippet can be edited by double-clicking it in the library. If you want to hide the built-in snippets, you can right-click anywhere on the library and disable Show Preset Snippets. There are two ways to insert a snippet into the editor. • You can start typing the name of a snippet in the editor. Smart code completion will pop up a list of suggestions for the word completion automatically. Select a snippet name from the list, the saved code will be inserted to the editor. • You can simply drag and drop a snippet from the library into the editor. After inserting the snippet with placeholders to the editor, you can easily navigate to them by clicking on one of the placeholders, and then using the TAB key and entering the information. You can create your own code snippets and add them to the library. To create a code snippet, select your desired code in the editor, then right-click and select Create Snippet. Alternatively, click in the Code Snippet pane. If you use this method, you must manually enter the code in the New Snippet window; code selected in the editor is not automatically added to the Code box. Hint: Code snippets (.nsnippet) are stored in the snippets folder under the Profiles Location.

Projection. In this tab, you can choose which fields to include or exclude in the returned documents. If you not specify the projection, all fields will be returned. In this tab, you can sort the returned documents by fields in ascending or descending order. In this tab, you can limit the maximum number of documents to return and set the number of documents to skip. Code Snippets Code Snippets provide an easy way for you to insert reusable code into editor when writing statements or scripts. The Code Snippet pane is on the right side of the editor. You can click the icon to open the library. The library includes built-in and user-defined snippets. Choose a label from the drop-down list menu or enter a search string in the Search box to filter the list. If you want to show the available snippets according to your database type, you can rightcontrol-click anywhere on the library and disable Show Snippets For Other Database Type. Built-in snippets are non-editable. A user-defined snippet can be edited by double-clicking it in the librarylibrary and clicking Edit. If you want to hide the built-in snippets, you can rightcontrol-click anywhere on the library and disable Show Preset Snippets. There are two ways to insert a snippet into the editor. • You can start typing the name of a snippet in the editor. Smart code completion will pop up a list of suggestions for the word completion automatically. Select a snippet name from the list, the saved code will be inserted to the editor. • You can simply drag and drop a snippet from the library into the editor. After inserting the snippet with placeholders to the editor, you can easily navigate to them by clicking on one of the placeholders, and then using the TAB key and entering the information. You can create your own code snippets and add them to the library. To create a code snippet, select your desired code in the editor, then rightcontrol-click and select Create Snippet, or simply drag and drop the selected code to the Code Snippet pane. Alternatively, click in the Code Snippet pane. If you use this method, you must manually enter the code in the New Snippet window; code selected in the editor is not automatically added to the Code box. Untitled text box Enter the name of the snippet that displays in the library and the code completion list. Database Type Choose the database server type of the snippet. Label Choose an existing label or enter a new label name for the snippet. Remarks Enter a description for the snippet that displays in the library. Code Enter the code. Add a placeholder by highlighting any words in the code and click this button. The placeholder will be highlighted in light green. Remove a placeholder by highlighting it in the code and click this button.