Overview
In the implementation process to make queries, the query provides two groups of configuration methods, the need to first analyze from the following perspective, the need to make the query of what category, and then choose the appropriate way to make.
Query needs to determine whether the group query or subsidiary query, loaded according to the type of configuration. The basis for judging the query type is the data source.
If the primary data source table is data stored on the OA server, and the entire group of users have a need to view , such as group attendance analysis, then this query is the group query, if the main data source on the subsidiary database, such as the subsidiary's outstanding order schedule, then the subsidiary query.
Example
Group Query configuration Method one
1. in the group auxiliary Materials, add Group query, enter the number, name and category of the group that need to be set up for custom query, click Add.
2. Run the Group Configuration Wizard, see small group--run the Group Configuration Wizard .
3. set up a query to be licensed to all users throughout the group.
Group Query Configuration Method II
1. after making a query in the Suite tool, click the data Source (Group) button on the parameter Settings page to automatically add a row of data source parameters.
2. The control type of the parameter can be selected Dbnameeditor (drop-down box), dbnamechecklist (check list).
3. set the default values for the parameters according to the actual requirements and select some databases .
4. The drop- down box and the check controls are as follows:
considerations
1. subsidiary query, if you debug the query, found that some tables of data in the group database, if on the same server, you need to write the database name before the table name, for example: SELECT * FROM AIO7.dbo.CATsk; If it is not a server, you can do the settings of the linked server, see sql cross-server queries by establishing a linked server .
2. Query Using the wizard set to the group query and query parameters to add data source parameters are conflicting, we recommend only one way, general settings query parameters more flexible.
ERP small group--key function and two development configuration--query