To sort by multiple fields, click the 'Sort' button from the toolbar. One way to sort by one field is to click the Sort arrow on the right side of the field header and select 'Sort Ascending' or 'Sort Descending' from the context menu: Sorting in Navicat is used to temporarily rearrange documents, so that you can view or update them in a different sequence. Sort Documents: MongoDB stores documents in the order in which they were added to the collection.To save your filter criteria as a profile for future use, right-click anywhere in the filter editor and select 'Save Profile' or 'Save Profile As' from the context menu:.Click on the Apply Filter button to see the result of the filtering expression:.With multiple criteria, clicking on the logical operator (next to the criteria values) toggles between "and" and "or".To remove the parentheses, right-click a bracket and select 'Delete Bracket or 'Delete Bracket and Conditions': To add parentheses to existing conditions, right-click on the selected conditions and select 'Group with Bracket' from the context menu.Repeat step i-v to add another new condition. ![]() You can also change the field type via the Field Types list: The data type used in the criteria values box is determined by the data type assigned to the corresponding field. Click on '' to activate the Criteria Editor dialog and enter the criteria value(s).You can choose '' from the list to enter the condition manually: Click on the operator (next to the field name) to choose a filter operator.Click on the field name (next to the checkbox) and choose a field from the list:.You may also add a condition with parentheses by clicking on : To add a new condition to the criteria, click the button.Click 'Filter' from the toolbar to activate the filter.Filter Wizard: The Filter Wizard allows you to create and apply filter criteria to the data grid, much in the same way that a WHERE clause does to query results.Select Text, Hex, Image, or Web from the toolbar to activate the appropriate viewer/editor:įor example, selecting "Hex" from the list displays the hex editor at the bottom of the tab: The editor allows you to view, update, insert, or delete data in a table or a collection. ![]() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |