CN101706818A - Report dynamic filtering method and device - Google Patents
Report dynamic filtering method and device Download PDFInfo
- Publication number
- CN101706818A CN101706818A CN200910250350A CN200910250350A CN101706818A CN 101706818 A CN101706818 A CN 101706818A CN 200910250350 A CN200910250350 A CN 200910250350A CN 200910250350 A CN200910250350 A CN 200910250350A CN 101706818 A CN101706818 A CN 101706818A
- Authority
- CN
- China
- Prior art keywords
- attribute
- associated data
- self
- data set
- field
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses report dynamic filtering method and device, wherein the method comprises the following steps of: establishing field association relation among entity objects to generate an association data set; importing fields in the association set in a user-defined query library; and querying the user-defined library according to query conditions to realize the dynamic filtering of reports. The report filtering scheme of the invention can provide visual interfaces to freely add fields for displaying, viewing and filtering corresponding data of fields. Since different customers have different demands, developers can not develop a large and all-embracing Query, therefore, the development of a large quantity of patches for meeting the demands of different customers can be avoided after projects are implemented, and secondary development in background can also be avoided, thereby greatly improving the flexibility of systems.
Description
Technical field
The present invention relates to computing machine and data base querying technical field, relate in particular to a kind of dynamic filtering method and device of form.
Background technology
If desired form being increased or filtered fields, is to finish by the secondary development on the backstage mostly, need carry out code compiling, if the client is ignorant of code, difficult to realize.
For example, office worker's information report commonly used because the field in office worker's information can reach thousands of, causes needing to issue the demand that a large amount of patches solves different clients after the project implementation, the dirigibility of system reduces greatly, can not embody the thought of personalized ERP (Enterprise Resources Planning) fully.
Summary of the invention
In view of this, the invention provides a kind of dynamic filtering method and device of form, need secondary development to finish Report Operations and the low problem of dirigibility that causes to solve existing scheme.
For this reason, the embodiment of the invention adopts following technical scheme:
A kind of dynamic filtering method of form comprises: set up the field incidence relation between the entity object, generate associated data set; The field that associated data is concentrated imports in the self-defined inquiry storehouse; Inquire about described self-defined inquiry storehouse according to querying condition, realize the dynamic filtration of form.
The described field incidence relation of setting up between the entity object comprises: sign on the basis at existing homepage, add a new tab in entity object; Homepage is set signs, and the connection type of setting up between the two is all row of parent object to parent object, described new tab are subobject.
The described field that associated data is concentrated imports in the self-defined inquiry storehouse and comprises: the attribute that described associated data set is set; The associated data set that sets up attribute is imported the self-defined inquiry storehouse.
The attribute of described associated data set comprises visibility attribute, or/and, but filter attribute.
Preferably, said method also comprises: the search access right that described self-defined inquiry storehouse is set; Only allow to meet of the operation of the querying condition of search access right to the self-defined inquiry storehouse.
A kind of dynamic filter of form comprises: the associated data set generation unit, be used to set up the field incidence relation between the entity object, and generate associated data set; Field imports the unit, and the field that is used for associated data is concentrated imports the self-defined inquiry storehouse; The inherent filtration unit is used for inquiring about described self-defined inquiry storehouse according to querying condition, realizes the dynamic filtration of form.
Wherein, described associated data set generation unit further comprises: new tab is added subelement, is used for signing on the basis in new tab of entity object interpolation at existing homepage; Association is provided with subelement, be used to be provided with homepage and sign to parent object, described new tab are subobject, and the connection type of setting up between the two is all row of parent object.
Wherein, described field imports the unit and further comprises: attribute is provided with subelement, is used to be provided with the attribute of described associated data set; Data set imports subelement, and the associated data set that is used for setting up attribute imports the self-defined inquiry storehouse.
Wherein, the attribute that described attribute is provided with the associated data set of subelement setting comprises visibility attribute, or/and, but filter attribute.
Preferably, said apparatus also comprises: the rights management unit is used to be provided with the search access right in described self-defined inquiry storehouse, and only allows to meet the operation of the querying condition of search access right to the self-defined inquiry storehouse.
By form dynamic filtration scheme of the present invention, can provide visual interface to add field freely and show, check and field is carried out filtering corresponding data.Because different customer demands is different, the developer can not be a large and complete Query, can after the project implementation, avoid developing the demand that a large amount of patches solves different clients thus, need not carry out secondary development on the backstage, increase the dirigibility of system greatly.
Description of drawings
Fig. 1 is the dynamic filtering method process flow diagram of form of the present invention;
Fig. 2 is the embodiment of the invention one employee's register synoptic diagram;
Fig. 3 checks synoptic diagram for the embodiment of the invention one part-time staff;
Fig. 4 sets up incidence relation synoptic diagram between the entity object for the embodiment of the invention one;
Fig. 5 is that the embodiment of the invention one imports the attribute synoptic diagram;
Fig. 6 is the synoptic diagram that the embodiment of the invention one is concentrated associated data in relevant field importing enquire storehouse;
Fig. 7 is the embodiment of the invention one a condition query synoptic diagram;
Fig. 8 is that the embodiment of the invention one dynamic filtration shows synoptic diagram;
Fig. 9 is that the embodiment of the invention two office worker's information show synoptic diagram;
Figure 10 sets up incidence relation synoptic diagram between the entity object for the embodiment of the invention two;
Figure 11 is the embodiment of the invention two querying condition synoptic diagram;
Figure 12 is provided with synoptic diagram for the embodiment of the invention two condition queries;
Figure 13 is the embodiment of the invention two a dynamic filtrations inquiry synoptic diagram;
Figure 14 is the dynamic filter structural representation of form of the present invention.
Embodiment
Shortcoming at existing scheme existence, the dynamic filtration scheme that the present invention proposes is under the prerequisite of not writing code, only will be clear that the relation between the entity object in the system, just can set up inquiry and the demonstration and the filtration of the incompatible realization field of associated group each other.
Generally, realization principle of the present invention is dynamic Q uery (inquiry), and in fact Query is exactly a SQL, and the just dynamic SQL of dynamic Q uery promptly can change SQL dynamically to reach the purpose that needs when operation.Layoutprocedure just follows that newly-built Query is the same in the BOS designer.
Referring to Fig. 1, the dynamic filtering method process flow diagram for form of the present invention comprises:
S101: set up the field incidence relation between the entity object, generate associated data set;
S102: the field that associated data is concentrated imports in the self-defined inquiry storehouse;
S103: inquire about described self-defined inquiry storehouse according to querying condition, realize the dynamic filtration of form.
Wherein, S101 further comprises:
[1] signs on the basis at existing homepage, in entity object, add a new tab;
[2] homepage is set and signs, and the connection type of setting up between the two is all row of parent object to parent object, described new tab are subobject.
S102 further comprises:
[1] attribute of described associated data set is set;
[2] associated data set that will set up attribute imports the self-defined inquiry storehouse.
Wherein, the attribute of described associated data set comprises visibility attribute, or/and, but filter attribute.
Preferably, this method is further comprising the steps of:
(1) search access right in described self-defined inquiry storehouse is set;
(2) only allow to meet of the operation of the querying condition of search access right to the self-defined inquiry storehouse.
Thus, distribute authority, can realize that the form of the form that different user views and data also are different by giving different users.
The office worker register general with enterprise is example, realizes that process of the present invention may further comprise the steps:
1, the label that carry many pages in office worker's information, and main information such as office worker's coding and office worker's title are in " employee's personal information " this master meter, if take out field information on other tab, then need to set up incidence relation with other tab and take out corresponding field with this master meter;
2, at first in entity object, added " employee information _ tenure situation " tab, parent object shows employee _ personal information like this, subobject shows office worker _ tenure situation, connection type is selected all row (belonging to the technical term in the database) of parent object, the father is ID (id)=personnel (person) to the relation of the correspondence of attribute and the foundation of subobject attribute, set up two incidence relations between the tab like this, for the data query of back is prepared;
3 if want to get field in the HR basic data, just selects the HR basic data when then newly setting up entity object, and the parent object attribute selects this entity object=ID (id) to set up incidence relation;
4 and then import field in the entity object of this new interpolation, may be displayed in the list box, this field is set a property " observability " and " can filter ", just can inquire about with the data of display field correspondence after only setting;
5, can choose these fields in " self-defined " of office worker's register query page then and carry out garbled data as filtercondition, book also can have been seen the data of this field and correspondence when preface;
6, above the process that whole dynamic filtration scheme is set up, if, then in office worker's register, office worker's detail list, office worker's information, can quote this scheme and carry out filtering data and video data to the dynamic filtration scheme search access right that the active user has distributed each function.
As seen, can add dynamic filtration scheme of the present invention in different forms or original list, the client sets up the data that different dynamic filtration schemes is provided with filtration and display field according to the actual requirements.
And the dynamic filtration scheme distribute authority can also for different users, user's difference like this, and the form of the form that views and data also are different.
Illustrate with specific embodiment below.
Embodiment one:
In the detailed form of office worker's register/office worker and office worker's information, realization can choose whether show part-time function, and method of operating is as follows:
1, referring to Fig. 1, human resource management-＞employee's management-＞the occurrences in human life form-＞office worker's register report page, " query scheme " on the click tools hurdle;
2, referring to Fig. 2, in the forms " dynamic filtration scheme " that eject, click is newly-increased, and input coding and title are as input " part-time staff checks ";
3, the entity object tab is chosen tree node " office worker _ personal information ", clicks " increase " button on the tab;
4, in the forms " selection entity object " that eject, click " searching " button in the upper right corner, input " tenure situation ".Can navigate to " office worker _ tenure situation " automatically after clicking affirmation, click and confirm that the back has just produced one " office worker _ tenure situation " in the place of entity object tree final node;
5,,, connection type is chosen as " all row of parent object " on the right of panel referring to Fig. 4.Here select " ID " at the parent object attribute, connect and select "=", the subobject attribute is selected " personnel ".Click the save button on the entity object tab;
6,, click the Import button in the field tab referring to Fig. 5.In the forms " importing attribute " that eject, can see last extensible file in the tree " office worker _ tenure situation ", open this node.Colluding " main position " point determines;
7, in the middle of this tree, two " office workers _ tenure situation " are arranged, select that of own foundation, " office worker _ tenure situation " after promptly leaning on;
8, referring to Fig. 6, the rolling table in the middle of the field tab is moved at last, can see " main position ".Choose it, display Name can be made amendment according to client's demand, and colludes " observability ".Click and preserve;
9, withdraw from " dynamic filtration scheme " forms and come the form forms of office worker's register, click " filtration " button;
10,, in the middle of the dynamic filtration scheme of office worker's register-condition query, choose " part-time staff checks " of just having set up referring to Fig. 7;
11, referring to Fig. 8, in self-defined tab, filtercondition is moved at last, and can see has main position field, here just can use this field setting to check and comprise the personnel of part-time position, be the data presentation that this " main position " is dragged to corresponding position back among Fig. 8.
Embodiment two:
For human resource management-employee management-office worker information, increase personnel type in the middle of book and the filtercondition when being implemented in preface.It mainly is situation about existing at single file table, F7 type and entity object acquiescence.
1, referring to Fig. 9, personnel's type shows with F7 in office worker's information;
2, referring to Figure 10, set up the dynamic filtration scheme, set up incidence relation wherein;
3, referring to Figure 11, here input coding, title, title will be easy to identification.And click the importing button here in field, re-use the field that the magnifier function of search finds to be needed, title can be changed into personnel's typonym after the importing, observability is chosen with filtering all;
4, referring to Figure 12, click the filtering button at interface, select personnel's type here in the dynamic filtration scheme of filtering interface.Personnel's typonym is set in the middle of filtercondition equals managerial personnel.
5, see also Figure 13 according to the dynamic filtration scheme Query Result of setting up.
For above-mentioned two embodiment, respectively comprise two core procedures:
1) in the 2nd step among step of the 5th among the embodiment one and the embodiment two, is at the field incidence relation of setting up between the entity object, thereby can obtains the data of required displaying from data centralization.
Particularly, be by ID (id)=personnel (person) between office worker's information tab, select " all row of parent object " to set up association and get field in the tab, and basic data is by personnel type=ID, selects " all row of parent object " to set up association and gets the data that basic data is set in the personal information.
2) the 3rd step among the 8th among the embodiment one step and the embodiment two is to take out the field of correspondence and import to the self-defined inquiry storehouse from the data centralization of association.
Corresponding with said method, the present invention also provides a kind of dynamic filter of form, and referring to Figure 14, this device comprises that associated data set generation unit 141, field import unit 142 and inherent filtration unit 143, wherein:
Associated data set generation unit 141 is used to set up the field incidence relation between the entity object, generates associated data set;
Field imports unit 142, and the field that is used for associated data is concentrated imports the self-defined inquiry storehouse;
Inherent filtration unit 143 is used for inquiring about described self-defined inquiry storehouse according to querying condition, realizes the dynamic filtration of form.
Wherein, associated data set generation unit 141 further comprises:
New tab is added subelement 1411, is used for signing on the basis in new tab of entity object interpolation at existing homepage;
Association is provided with subelement 1412, be used to be provided with homepage and sign to parent object, described new tab are subobject, and the connection type of setting up between the two is all row of parent object.
Wherein, field importing unit 142 further comprises:
Attribute is provided with subelement 1421, is used to be provided with the attribute of described associated data set, comprises visibility attribute, or/and, but filter attribute;
Data set imports subelement 1422, and the associated data set that is used for setting up attribute imports the self-defined inquiry storehouse.
Preferably, this device also comprises:
Rights management unit 144 is used to be provided with the search access right in described self-defined inquiry storehouse, and only allows to meet the operation of the querying condition of search access right to the self-defined inquiry storehouse.
By form dynamic filtration scheme of the present invention, can provide visual interface to add field freely and show, check and field is carried out filtering corresponding data.Because different customer demands is different, the developer can not be a large and complete Query, can after the project implementation, avoid developing the demand that a large amount of patches solves different clients thus, need not carry out secondary development on the backstage, increase the dirigibility of system greatly.
One of ordinary skill in the art will appreciate that, the process of the method for realization the foregoing description can be finished by the relevant hardware of programmed instruction, described program can be stored in the read/write memory medium, and this program is carried out the corresponding step in the said method when carrying out.Described storage medium can be as ROM/RAM, magnetic disc, CD etc.
The above only is a preferred implementation of the present invention; should be pointed out that for those skilled in the art, under the prerequisite that does not break away from the principle of the invention; can also make some improvements and modifications, these improvements and modifications also should be considered as protection scope of the present invention.
Claims (10)
1. the dynamic filtering method of a form is characterized in that, comprising:
Set up the field incidence relation between the entity object, generate associated data set;
The field that associated data is concentrated imports in the self-defined inquiry storehouse;
Inquire about described self-defined inquiry storehouse according to querying condition, realize the dynamic filtration of form.
2. according to the described method of claim 1, it is characterized in that the described field incidence relation of setting up between the entity object comprises:
Sign on the basis at existing homepage, in entity object, add a new tab;
Homepage is set signs, and the connection type of setting up between the two is all row of parent object to parent object, described new tab are subobject.
3. according to the described method of claim 1, it is characterized in that the described field that associated data is concentrated imports in the self-defined inquiry storehouse and comprises:
The attribute of described associated data set is set;
The associated data set that sets up attribute is imported the self-defined inquiry storehouse.
4. according to the described method of claim 3, it is characterized in that the attribute of described associated data set comprises visibility attribute, or/and, but filter attribute.
5. according to claim 1,2,3 or 4 described methods, it is characterized in that, also comprise:
The search access right in described self-defined inquiry storehouse is set;
Only allow to meet of the operation of the querying condition of search access right to the self-defined inquiry storehouse.
6. the dynamic filter of a form is characterized in that, comprising:
The associated data set generation unit is used to set up the field incidence relation between the entity object, generates associated data set;
Field imports the unit, and the field that is used for associated data is concentrated imports the self-defined inquiry storehouse;
The inherent filtration unit is used for inquiring about described self-defined inquiry storehouse according to querying condition, realizes the dynamic filtration of form.
7. according to the described device of claim 6, it is characterized in that described associated data set generation unit further comprises:
New tab is added subelement, is used for signing on the basis in new tab of entity object interpolation at existing homepage;
Association is provided with subelement, be used to be provided with homepage and sign to parent object, described new tab are subobject, and the connection type of setting up between the two is all row of parent object.
8. according to the described device of claim 6, it is characterized in that described field imports the unit and further comprises:
Attribute is provided with subelement, is used to be provided with the attribute of described associated data set;
Data set imports subelement, and the associated data set that is used for setting up attribute imports the self-defined inquiry storehouse.
9. described according to Claim 8 device is characterized in that the attribute that described attribute is provided with the associated data set of subelement setting comprises visibility attribute, or/and, but filter attribute.
10. according to claim 5,6,7 or 8 described devices, it is characterized in that, also comprise:
The rights management unit is used to be provided with the search access right in described self-defined inquiry storehouse, and only allows to meet the operation of the querying condition of search access right to the self-defined inquiry storehouse.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910250350A CN101706818A (en) | 2009-12-04 | 2009-12-04 | Report dynamic filtering method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910250350A CN101706818A (en) | 2009-12-04 | 2009-12-04 | Report dynamic filtering method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101706818A true CN101706818A (en) | 2010-05-12 |
Family
ID=42377043
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200910250350A Pending CN101706818A (en) | 2009-12-04 | 2009-12-04 | Report dynamic filtering method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101706818A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2012051773A1 (en) * | 2010-10-18 | 2012-04-26 | 中兴通讯股份有限公司 | Method for filtering and analyzing data set of report and device for processing report |
| CN102567032A (en) * | 2010-12-08 | 2012-07-11 | 金蝶软件（中国）有限公司 | Common interface configuration method and computer |
| CN103020750A (en) * | 2012-11-19 | 2013-04-03 | 北京数码大方科技股份有限公司 | Process report generation method and device |
| CN103761219A (en) * | 2014-02-20 | 2014-04-30 | 西双版纳恒创信息科技有限公司 | Dynamic generating method of table |
| CN106649351A (en) * | 2015-10-30 | 2017-05-10 | 北京国双科技有限公司 | Chart display method and apparatus |
| US10031939B2 (en) | 2014-09-30 | 2018-07-24 | Microsoft Technology Licensing, Llc | Automated supplementation of data model |
| CN109271375A (en) * | 2018-11-28 | 2019-01-25 | 中国海洋石油集团有限公司 | A kind of projecting method, device, equipment and storage medium |
| CN110928962A (en) * | 2019-11-26 | 2020-03-27 | 山东浪潮通软信息科技有限公司 | Query report generation method based on dynamic fields |
-
2009
- 2009-12-04 CN CN200910250350A patent/CN101706818A/en active Pending
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2012051773A1 (en) * | 2010-10-18 | 2012-04-26 | 中兴通讯股份有限公司 | Method for filtering and analyzing data set of report and device for processing report |
| CN102567032B (en) * | 2010-12-08 | 2016-01-20 | 金蝶软件（中国）有限公司 | The collocation method of General Purpose Interface and computing machine |
| CN102567032A (en) * | 2010-12-08 | 2012-07-11 | 金蝶软件（中国）有限公司 | Common interface configuration method and computer |
| CN103020750A (en) * | 2012-11-19 | 2013-04-03 | 北京数码大方科技股份有限公司 | Process report generation method and device |
| CN103761219B (en) * | 2014-02-20 | 2017-08-25 | 西双版纳恒创信息科技有限公司 | A kind of dynamic creation method of form |
| CN103761219A (en) * | 2014-02-20 | 2014-04-30 | 西双版纳恒创信息科技有限公司 | Dynamic generating method of table |
| US10031939B2 (en) | 2014-09-30 | 2018-07-24 | Microsoft Technology Licensing, Llc | Automated supplementation of data model |
| CN106649351A (en) * | 2015-10-30 | 2017-05-10 | 北京国双科技有限公司 | Chart display method and apparatus |
| CN106649351B (en) * | 2015-10-30 | 2019-10-25 | 北京国双科技有限公司 | Chart shows method and device |
| CN109271375A (en) * | 2018-11-28 | 2019-01-25 | 中国海洋石油集团有限公司 | A kind of projecting method, device, equipment and storage medium |
| CN109271375B (en) * | 2018-11-28 | 2022-04-19 | 中国海洋石油集团有限公司 | Projection method, device, equipment and storage medium |
| CN110928962A (en) * | 2019-11-26 | 2020-03-27 | 山东浪潮通软信息科技有限公司 | Query report generation method based on dynamic fields |
| CN110928962B (en) * | 2019-11-26 | 2024-03-26 | 浪潮通用软件有限公司 | Query report generation method based on dynamic field |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101706818A (en) | Report dynamic filtering method and device | |
| US6839719B2 (en) | Systems and methods for representing and editing multi-dimensional data | |
| CN101504672B (en) | Method and system for dynamically configuring physical data table | |
| US20060005124A1 (en) | User interface for complex process implementation | |
| CN102567539B (en) | Intelligent WEB report implementation method and intelligent WEB report implementation system | |
| US20040221259A1 (en) | Method and apparatus for status display with intermediate database access | |
| US20030115207A1 (en) | Hierarchical hybrid OLAP analytics generators | |
| US20030061225A1 (en) | Hierarchical hybrid OLAP scenario management system | |
| CN102541867A (en) | Data dictionary generating method and system | |
| CN103617047A (en) | Method, device and processor for developing business processes | |
| US8682936B2 (en) | Inherited entity storage model | |
| US20080086716A1 (en) | Method and apparatus for information display with intermediate datasource access | |
| CN101901262A (en) | Object-oriented model-based enterprise database construction and service data display method | |
| CN102110142A (en) | Method for dynamically expanding personnel transaction in human resource management information system | |
| CN103154942A (en) | Enterprise application work center | |
| CN103744831A (en) | Compilation method and device for multi-dimensional report | |
| CN115840567A (en) | Application editing method and related equipment | |
| CN108228846A (en) | Resource file management method and device | |
| WO2004095168A2 (en) | System and method for providing a territory management tool | |
| CN103107919A (en) | Method and system for network resource modeling | |
| CN110633267B (en) | Method and system capable of supporting multi-service report function | |
| CN101908063A (en) | Universal report query tool | |
| US20030061226A1 (en) | Data loader for handling imperfect data and supporting multiple servers and data sources | |
| US7574329B1 (en) | Object model for decision and issue tracking | |
| CN105488229A (en) | Data exchange and integration method applied to heterogeneous data environment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20100512 |