User Tools
en:handbuch:kapitel_3:3.05_bedienung_der_profi-suche_fortsetzung
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:handbuch:kapitel_3:3.05_bedienung_der_profi-suche_fortsetzung [2009/12/03 11:29] 192.168.0.76 |
en:handbuch:kapitel_3:3.05_bedienung_der_profi-suche_fortsetzung [2019/10/25 14:11] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| [[|{{|previous}}]] [[handbuch:handbuch|{{|Home}}]] [[|{{|next}}]] | [[|{{|previous}}]] [[handbuch:handbuch|{{|Home}}]] [[|{{|next}}]] | ||
| - | ====== 3.05 Using the Advanced Search (Continued) ====== | + | ====== 3.05 Using the Advanced Search (continued 1) ====== |
| Line 41: | Line 41: | ||
| In the next step, the query is defined more specifically. Only billed invoices should be copied. This information is in the document "invoice" and the field has the name "status". By using the assistant, the fields of the selected document can ... | In the next step, the query is defined more specifically. Only billed invoices should be copied. This information is in the document "invoice" and the field has the name "status". By using the assistant, the fields of the selected document can ... | ||
| - | {{:handbuch:kapitel_3:3-219.gif?direct}} | + | {{:en:handbuch:kapitel_3:using_advanced8.jpg|}} |
| ... be looked up. After selecting the status field and the field value, this condition can ... | ... be looked up. After selecting the status field and the field value, this condition can ... | ||
| - | {{:handbuch:kapitel_3:3-220.gif?direct}} | + | {{:en:handbuch:kapitel_3:using_advanced9.jpg|}} |
| ... be accepted with two mouse clicks in the query. | ... be accepted with two mouse clicks in the query. | ||
| - | {{:handbuch:kapitel_3:3-221.gif?direct}} | + | {{:en:handbuch:kapitel_3:using_advanced10.jpg|}} |
| After running the query, the query is reformatted, if necessary. In the example **invoice : status = "invoice billed"** becomes **invoice : (status = "Billed")**. The system normally sets brackets and also automatically transfers collections in the expressions (here billing type). The transformation of the queries must be made by the system because of the internationalization, so the queries can function independently of the user´s language. | After running the query, the query is reformatted, if necessary. In the example **invoice : status = "invoice billed"** becomes **invoice : (status = "Billed")**. The system normally sets brackets and also automatically transfers collections in the expressions (here billing type). The transformation of the queries must be made by the system because of the internationalization, so the queries can function independently of the user´s language. | ||
| Line 73: | Line 73: | ||
| The second condition filters invoices with the invoice date from a start value (invoice date> = $Start). In a query, a value can (for example, a date "01.12.2006") be deposited or a variable. In the example, a variable $Start is used as a placeholder for the invoice date, instead of entering this date directly into the query. | The second condition filters invoices with the invoice date from a start value (invoice date> = $Start). In a query, a value can (for example, a date "01.12.2006") be deposited or a variable. In the example, a variable $Start is used as a placeholder for the invoice date, instead of entering this date directly into the query. | ||
| - | + | ||
| {{:en:handbuch:kapitel_3:using_advanced15.jpg|}} | {{:en:handbuch:kapitel_3:using_advanced15.jpg|}} | ||
| Line 96: | Line 96: | ||
| Finally, the query is completed by sorting the definition. | Finally, the query is completed by sorting the definition. | ||
| - | {{:handbuch:kapitel_3:3-230.gif?direct}} | + | {{:en:handbuch:kapitel_3:using_advanced19.jpg|}} |
| The result list is then no longer sorted according to the internal number, but it is sorted in ascending order by the name. If sorted in descending order, you must use the additional DESC. The search query is then: | The result list is then no longer sorted according to the internal number, but it is sorted in ascending order by the name. If sorted in descending order, you must use the additional DESC. The search query is then: | ||
| - | **Invoice : ( ( Status = "Billed" ) AND ( Invoice date >= $Start ) ) SORT Invoice date.** | + | **Invoice : ( ( Status = "Billed" ) AND ( Invoice date >= $Start ) ) SORT Invoice_date.** |
| - | [[3.05_bedienung_der_profi-suche_fortsetzung1|... Continued]] | + | [[3.05_bedienung_der_profi-suche_fortsetzung1|... continued page 2]] |
en/handbuch/kapitel_3/3.05_bedienung_der_profi-suche_fortsetzung.1259836166.txt.gz · Last modified: 2019/10/25 14:09 (external edit)
