Changes for page Abfragen erstellen

Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -2,7 +2,7 @@
2	2
3	3	You can create a query either centrally via Query Management (//Client Management// > //Query Management//) or via the ribbon bar under the //Query Actions //tab. If you want the query to be sorted in a specific folder, you can first select it and then add the new query there. To do this, click the //Add// button. A wizard will open that will guide you through the necessary steps for creating the query.
4	4
5		-It is also possible to create a query without using the wizard. To do this, select Expert Mode. To select Clients in the Query or to open their Client Details, the Client ID must also be queried. By entering the SQL code directly, you can also access and execute the stored procedures of the ACMP Database. Stored procedures are instructions in the database system that can be used to call up complete sequences of commands from the client.
	5	+It is also possible to create a query without using the wizard. To do this, select Expert Mode. To select Clients in the Query or to open their Client Details, the Client ID must also be queried. By entering the SQL code directly, you can also access and execute the stored procedures of the acmp Database. Stored procedures are instructions in the database system that can be used to call up complete sequences of commands from the client.
6	6
7	7
8	8	= Create Query with the wizard =
...	...	@@ -12,13 +12,13 @@
12	12	Select an output directory ([[image:Auswählen Icon.png||height="18" width="20"]]) and enter a name for your query. Optionally, you can also add a description to the query if you want to store additional information for yourself or your colleagues. This description can help you choose the right query in the future. The next step is to select the query base. This determines the available query values, which are essential for you to continue. If you want to create a client based query, you will have different fields to those available for a query base based on cost centres or contracts.
13	13
14	14	{{aagon.infobox}}
15		-You cannot select fields from external categories that have not been released by ACMP. You will also not get these items if you enter them explicitly via the search bar.
	15	+You cannot select fields from external categories that have not been released by acmp. You will also not get these items if you enter them explicitly via the search bar.
16	16	{{/aagon.infobox}}
17	17
18	18	Enable the// //[[Create advanced Query>>doc:.Erweiterte Abfragen erstellen.WebHome]] option only if you want to create a more complex, detailed query using SQL statements, for example with the help of the SQL Wizard. Otherwise, click //Next >//.
19	19
20	20	{{aagon.infobox}}
21		-Due to the complex database structure of ACMP, we recommend that you only create an advanced query if you have the appropriate knowledge.
	21	+Due to the complex database structure of acmp, we recommend that you only create an advanced query if you have the appropriate knowledge.
22	22	{{/aagon.infobox}}
23	23
24	24	{{figure}}