8.1. Find

8.1. Find
<<< Zurück	Kapitel 8. Assistenten und ähnliche Werkzeuge	Weiter >>>

Geehrte Leser, leider hat bisher niemand eine Übersetzung der folgenden Teile erstellt. Falls Sie uns dabei helfen möchten, folgen Sie bitte der Anleitung in Gnucash wiki: How to translate the GnuCash guide and/or help files. Fragen können auf der deutschsprachigen Mailingliste gnucash-de@gnucash.org diskutiert werden.

The GnuCash Find assistant can be used to find transactions or to perform business related research on your data file.

8.1.1. Find Transaction

Find Transaction is used to search for transactions in GnuCash and display the results in a register window. To open the Find Transaction dialog in Split Search mode, you can type the keyboard shortcut Strg+f .

Exactly which transactions are searched depends on where you invoke the tool from. If you start from the main accounts hierarchy page, all transactions will be searched. If you start from an individual account register, only transactions in that account will be searched. And if you filter the transactions in a register using Ansicht → Filtern nach… , then only transactions in that account and shown by the filter will be searched.

	Anmerkung
	The first row of the Find Transaction dialog indicates that you are performing a Split Search.

There are two panes in the Find Transaction dialog. The top pane contains the Search Criteria buttons and the bottom pane contains the Type of Search selection.

There are two buttons in the top of the Search Criteria pane. The left button allows you to Add another criteria row to search for multiple criteria. The existing criteria row needs to be completed before adding a new row. The right button is used to Search for items where all criteria are met or Search for items where any criteria are met. The all criteria are met search requires all of the criteria rows to have at least one match. The any criteria are met search requires only one of the criteria rows to be matched.

The criteria row in the Search Criteria pane is used to combine different criteria buttons (see table Tabelle 8.1, „Search criteria buttons - Split Search“ for a comprehensive list of combinations)

In the Type of Search pane there are five selections. The first option is always enabled, the following three are available when you invoke the Suchen… option from a register window or after performing the first Find if the Suchen… command was invoked from any other window. The last option is available only for Business search.

New Search: Perform a new transaction search
Refine current search: Search within the results of the previous search
Add results to current search: Search based on the first set of criteria or the new criteria
Delete results from current search: Discard any results that match the previous search results
Search only active data: Search only if data are marked as active. This selector is greyed out for the Split Search as it is meaningful only for business related search

	Anmerkung
	When selecting search criteria keep in mind that criteria are applied to individual splits or fields in transactions, and that the entire transaction is included in the results. There is no visual indication in the results to indicate which split or field met the search criteria.

When search criteria are selected, you can press the Find button. You will be presented with the search results in a new register tab. A report of the search results may created and printed using Berichte → Kontenbericht . The Account Report has limited formatting options but, like all GnuCash reports, being in html format, can be copied and pasted into a spreadsheet for further formatting. Alternatively, the Account Report can be exported to an html file, and the html file may be opened in a spreadsheet.

	Anmerkung
	Press the Close button to close the Find Transaction dialog.

Tabelle 8.1. Search criteria buttons - Split Search

Button 1	Button 2	Button 3	Button 4	Button 5	Button 6	Button 7	Button 8
Description ^[a]	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex ^[b]
	does not match regex^[b]
Memo^[a]	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Number^[a]	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Action	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Notes	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Date Posted	is before	Date selection field	Remove row
	is before or on
	is on
	is not on
	is after
	is on or after
Value	has credits or debits	less than	Amount entry field	Remove row
		less than or equal to
		equal to
		not equal to
		greater than
		greater than or equal to
	has credits	less than
		less than or equal to
		equal to
		not equal to
		greater than
		greater than or equal to
	has debits	less than
		less than or equal to
		equal to
		not equal to
		greater than
		greater than or equal to
Shares	is less than	Amount entry field	Remove row
	is less than or equal to
	equals
	does not equal to
	is greater than
	is greater than or equal to
Share Price	is less than	Amount entry field	Remove row
	is less than or equal to
	equals
	is not equal to
	is greater than
	is greater than or equal to
Reconcile ^[c]	is	Not Cleared	Cleared	Reconciled	Frozen	Voided	Remove row
Reconcile ^[c]	is not	Not Cleared	Cleared	Reconciled	Frozen	Voided	Remove row
Balanced	is	set true	Remove row
Balanced	is not	set true	Remove row
Account ^[d]	matches any account	Choose Accounts	Remove row
Account ^[d]	matches no accounts	Choose Accounts	Remove row
All Accounts ^[e]	matches all accounts	Choose Accounts	Remove row
^[a]The Description, Memo, Number are common to all lines in a transaction. ^[b]regex means regular expression text search as used in various computer programs such as `Perl` ^[c]The Reconcile option applies the selected criteria to each line of a transaction individually. Each transaction line may have only one of the indicated values, but there is often a mix of values within a complete transaction, so companion lines may not meet the selected criteria. See separate note defining status values. For a detailed description of transaction statuses see Abschnitt 6.11, „Setzen des Abgleichstatus (Feld A) einer Buchung.“ ^[d]The Account option performs a search where the accounts selected in the Choose Accounts dialog will both be searched individually for results. This means that a match in any of the selected accounts will either be displayed (matches any account) or discarded (matches no account). ^[e]The All Accounts option performs a search where accounts selected in the Choose Accounts dialog will only return results that match in both accounts.

8.1.1.1. Explanations of the Criteria

The Reconcile criterion deserves some more explanation. Think of the selected reconciliation status buttons (Not Cleared, Cleared, and so on) as a single group, joined with a logical “or”. In other words, the selection “is ” or “is not” applies to the “or” of the selected status buttons. The buttons which are left unselected are simply ignored. (It’s not the same as saying the reconciliation status must not be one of these.)

For example: if you select Reconcile is Cleared Reconciled, that means you’re saying “I want all transactions which contain cleared splits OR reconciled splits” (imagine an invisible “OR” between all the selected status buttons). It’s the same as selecting Reconcile is Cleared, then adding another search criterion with the Add button, then on the new line selecting Reconcile is Reconciled, and finally selecting Search for items where any criteria are met. In either case, GnuCash will show you exactly the same set of transactions.

8.1.2. Find Customer, Invoice, Job, Vendor, Bill, Employee, Expense Voucher

The business find assistant is used to search for business related items (Customer, Invoice, Job, Vendor, Bill, Employee, Expense Voucher). To open the business search dialog select the desired item to Find from the Geschäft → Kunden → Kunde suchen…, Geschäft → Lieferant → Lieferant suchen… or Geschäft → Mitarbeiter → Mitarbeiter suchen… submenus.

	Tipp
	The titlebar and the first row of the assistant dialog reports the item type you are searching for: Customer, Invoice, Job, Vendor, Bill, Employee, Expense Voucher.

There are two panes in the Find dialog. The top pane contains the Search Criteria buttons and the bottom pane contains the Type of Search selection.

8.1.2.1. Search Criteria section

There are two buttons in the top of the Search Criteria pane. The left button allows you to Add another criteria row to search for multiple criteria.

	Anmerkung
	The existing criteria row needs to be completed before adding a new row.

The right button is used to Search for items where all criteria are met or Search for items where any criteria are met. The all criteria are met search requires all of the criteria rows to have at least one match. The any criteria are met search requires only one of the criteria rows to be matched.

The criteria row in the Search Criteria pane is used to combine different criteria buttons (see tables Tabelle 8.2, „Search criteria buttons - Customer Search“, Tabelle 8.3, „Search criteria buttons - Invoice Search“, Tabelle 8.4, „Search criteria buttons - Job Search“, Tabelle 8.5, „Search criteria buttons - Vendor Search“, Tabelle 8.6, „Search criteria buttons - Bill Search“, Tabelle 8.7, „Search criteria buttons - Employee Search“ Tabelle 8.8, „Search criteria buttons - Expense Voucher Search“ for a comprehensive list of combinations)

8.1.2.2. Type of Search section

In the Type of Search pane there are five selections. The first and alst options are always selectable while the following three are available only when you perform the first search by setting some search criteria and pressing the Find button.

New Search: Perform a new search
Refine current search: Search within the results of the previous search
Add results to current search: Search based on the first set of criteria or the new criteria
Delete results from current search: Discard any results that match the previous search results
Search only active data: Search only if data are marked as active.

8.1.2.3. The rest of the search dialog

When search criteria are selected, you can press the Find button. You will be presented with the list of search results in the same Find dialog.

	Tipp
	Aside from the results, `GnuCash` gives you some buttons to manage the highlighted result.

	Tipp
	In the bottom right of the Find dialog there is a button that allows you to create a New business item.

	Anmerkung
	Press the Close button to close the Find assistant dialog.

8.1.2.4. List of search criteria buttons

Tabelle 8.2. Search criteria buttons - Customer Search

Button 1	Button 2	Button 3	Button 4	Button 5
Company Name	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Customer ID	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Billing Contact	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Shipping Contact	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]

Tabelle 8.3. Search criteria buttons - Invoice Search

Button 1	Button 2	Button 3	Button 4	Button 5	Button 6
Invoice ID	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Company Name	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Date Opened	is before	Date selection field	Remove row
	is before or on
	is on
	is not on
	is after
	is on or after
Is Posted?	is	set true	Remove row
Is Posted?	is not	set true	Remove row
Date Posted	is before	Date selection field	Remove row
	is before or on
	is on
	is not on
	is after
	is on or after
Is Paid?	is	set true	Remove row
Is Paid?	is not	set true	Remove row
Billing ID	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Invoice Notes	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Invoice Owner	is	Customer	Criteria entry field	Select...	Remove row
		Vendor
		Employee
		Job
	is not	Customer
		Vendor
		Employee
		Job

Tabelle 8.4. Search criteria buttons - Job Search

Button 1	Button 2	Button 3	Button 4	Button 5
Job Name	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Job Number	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Billing ID	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Only Active?	is	set true	Remove row
Only Active?	is not	set true	Remove row
Owner's Name	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]

Tabelle 8.5. Search criteria buttons - Vendor Search

Button 1	Button 2	Button 3	Button 4	Button 5
Company Name	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Vendor ID	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Billing Contact	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]

Tabelle 8.6. Search criteria buttons - Bill Search

Button 1	Button 2	Button 3	Button 4	Button 5	Button 6
Bill ID	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Company Name	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Due Date	is before	Date selection field	Remove row
	is before or on
	is on
	is not on
	is after
	is on or after
Date Opened	is before	Date selection field	Remove row
	is before or on
	is on
	is not on
	is after
	is on or after
Is Posted?	is	set true	Remove row
Is Posted?	is not	set true	Remove row
Date Posted	is before	Date selection field	Remove row
	is before or on
	is on
	is not on
	is after
	is on or after
Is Paid?	is	set true	Remove row
Is Paid?	is not	set true	Remove row
Billing ID	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Bill Notes	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Bill Owner	is	Customer	Criteria entry field	Select...	Remove row
		Vendor
		Employee
		Job
	is not	Customer
		Vendor
		Employee
		Job

Tabelle 8.7. Search criteria buttons - Employee Search

Button 1	Button 2	Button 3	Button 4	Button 5
Employee Name	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Employee Username	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Employee ID	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]

Tabelle 8.8. Search criteria buttons - Expense Voucher Search

Button 1	Button 2	Button 3	Button 4	Button 5	Button 6
Voucher ID	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Employee Name	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Due Date	is before	Date selection field	Remove row
	is before or on
	is on
	is not on
	is after
	is on or after
Date Opened	is before	Date selection field	Remove row
	is before or on
	is on
	is not on
	is after
	is on or after
Is Posted?	is	set true	Remove row
Is Posted?	is not	set true	Remove row
Date Posted	is before	Date selection field	Remove row
	is before or on
	is on
	is not on
	is after
	is on or after
Is Paid?	is	set true	Remove row
Is Paid?	is not	set true	Remove row
Billing ID	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Voucher Notes	contains	Criteria entry field	Is entry Case Insensitive?	Remove row
	matches regex^[b]
	does not match regex^[b]
Voucher Owner	is	Customer	Criteria entry field	Select...	Remove row
		Vendor
		Employee
		Job
	is not	Customer
		Vendor
		Employee
		Job

<<< Zurück	Zum Anfang	Weiter >>>
Kapitel 8. Assistenten und ähnliche Werkzeuge	Nach oben	8.2. Der „Seit letztem Aufruf“ Dialog