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/11 12:28] 192.168.0.51 |
en:handbuch:kapitel_3:3.05_bedienung_der_profi-suche_fortsetzung [2019/10/25 14:11] (current) |
||
---|---|---|---|
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 102: | Line 102: | ||
**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]] |