Searching and Sorting このトピックを印刷 前のページ 1つ上のレベル 次のページ

ホーム >  Retrieving and Editing Data >

Searching and Sorting

Data that has been retrieved from a database is displayed in DatabaseSpy's 結果ウィンドウ. If you are searching for a particular string in your data, you can either create an appropriate SELECT statement using a WHERE clause to retrieve only rows that include that string, or, you can make use of DatabaseSpy''s search functionality directly in the 結果ウィンドウ. This allows you to find also parts of words in various columns included in the result of a database query.


You can call the Find ダイアログボックス by clicking the Find ic_find ボタン in the 結果ウィンドウ ツールバー, or by pressing 標準 shortcut Ctrl+F when the cursor is located in the 結果ウィンドウ.


Please note that the Find ic_find ボタン is also available when the 結果ウィンドウ is in the Editing mode.



To find a string in the 結果ウィンドウ:

1.データの取得 from the table you want to search.
2.結果ウィンドウ内で、 click the Find ic_find ボタン to display the Find ダイアログボックス. または、you can also click into the result grid and select メニューオプション Edit | Find... を選択、または、「Ctrl+F」を押します。
3.Type the string you are looking for into the Find what field.
4.任意で、 activate the Match whole word only チェックボックス if you want to restrict your search to entire words that match the search term.
5.任意で、 activate the Match case チェックボックス if you want to consider the case when searching.
6.Click Find next to start the search. The first occurrence of the search term is highlighted in the result grid.
7.任意で、 click Find next again to jump to the next occurrence of search term or click Find prev to jump to the previous occurrence of the search term, if available.
8.To quit the search, click Cancel.


Sorting results

デフォルトでは、 the data is sorted according to its primary key column in ascending order. You can change the sort order in the result grid using コンテキストメニュー, or by clicking the sorting arrows in the column headers, provided that this option has been activated in the SQL エディターオプション.


If sorting symbols are displayed in the column headers, you can click them to toggle the sorting order in the sequence ascending – descending – default. The shape of the 個々の sorting symbol changes accordingly.


In the example illustrated 上のスクリーンショットでは、 data is sorted in ascending order according to the "BirthDate" column.



To sort data in the result grid:



Right-click anywhere in the column to be sorted and select either 昇順 or 降順 from the Sorting サブメニュー of コンテキストメニュー.
Click the sorting symbol in any of the column headers to sort the data. The data is sorted according to the contents of that column in ascending order. Click the same column again to sort in descending order. A third click restores the default sort order.



To restore the default sort order:

Right-click anywhere in the table and choose Sorting | Restore default をコンテキストメニューから選択します。

(C) 2019 Altova GmbH