ERP small group--key function and two development configuration--query

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.