CN110750192A - Filtering model method based on visual editing system - Google Patents
Filtering model method based on visual editing system Download PDFInfo
- Publication number
- CN110750192A CN110750192A CN201910901428.6A CN201910901428A CN110750192A CN 110750192 A CN110750192 A CN 110750192A CN 201910901428 A CN201910901428 A CN 201910901428A CN 110750192 A CN110750192 A CN 110750192A
- Authority
- CN
- China
- Prior art keywords
- filtering
- filter
- tree
- data
- tree structure
- 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
- 238000001914 filtration Methods 0.000 title claims abstract description 63
- 238000000034 method Methods 0.000 title claims abstract description 17
- 230000000007 visual effect Effects 0.000 title claims abstract description 16
- 238000012216 screening Methods 0.000 claims description 8
- 238000004364 calculation method Methods 0.000 claims description 3
- 238000012545 processing Methods 0.000 abstract description 6
- 238000003672 processing method Methods 0.000 abstract description 2
- 238000004458 analytical method Methods 0.000 description 3
- 238000013515 script Methods 0.000 description 2
- 238000012800 visualization Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
- G06F3/0482—Interaction with lists of selectable items, e.g. menus
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Human Computer Interaction (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a filtering model method based on a visual editing system, and relates to the technical field of data processing. The method comprises the steps that a user can select filtering from expansion buttons of fields or enter a formula configuration interface from editing buttons of a filter; adding filtering conditions on the filter by the user; the front-end server converts the filtering conditions in the filter into tree-structure filtering data and transmits the tree-structure filtering data to the Java service back end; the Java service back end organizes the tree structure filtering data from inside to outside according to the hierarchy and converts the tree structure filtering data into SQL execution statements. According to the invention, the filtering condition of the tree structure is established, and the filtering condition can be set into a plurality of layers of filtering conditions; the data processing method ensures higher expansibility and is convenient to operate and use, and improves the data processing efficiency of business personnel and developers.
Description
Technical Field
The invention belongs to the technical field of data processing, and particularly relates to a model filtering method based on a visual editing system.
Background
On a visual editing system, SQL scripts can be executed in a data model for filtering by directly writing scripts which can be identified by an analyzer, such as a BI system; this method has high expansibility, but has high requirement on the skills of the user, and is inconvenient for non-professional people to use. The method can also be configured on a visual interface, but the configuration support is weak in function, and generally supports one condition filter or several parallel condition filters; the mode has good visualization effect and is convenient to operate and use; but the scalability is weak and cannot meet complex requirements.
The invention provides a filtering model method based on a visual editing system, which is characterized in that filtering conditions of a tree structure are established, and the filtering conditions can be set into a plurality of layers of filtering conditions; the high expansibility is guaranteed, and meanwhile, the operation and the use are convenient.
Disclosure of Invention
The invention aims to provide a filtering model method based on a visual editing system, which is characterized in that filtering conditions of a tree structure are established, and the filtering conditions can be set into a plurality of layers of filtering conditions; the high expansibility is guaranteed, and meanwhile, the operation and the use are convenient.
In order to solve the technical problems, the invention is realized by the following technical scheme:
the invention relates to a filtering model method based on a visual editing system, which comprises the following steps:
s00: the user can select the [ filter ] from the expansion buttons of the fields or enter a formula configuration interface from the [ edit ] button of the filter;
s01: adding filtering conditions on the filter by the user;
wherein the filtering condition is represented by a tree structure; a parent node of the tree structure is an AND selector; the leaf nodes of the tree structure are screening conditions;
s02: the front-end server converts the filtering conditions in the filter into tree-structure filtering data and transmits the tree-structure filtering data to the Java service back end;
s03: the Java service back end organizes the tree structure filtering data from inside to outside according to the hierarchy and converts the tree structure filtering data into SQL execution statements to generate execution results.
Preferably, the screening hierarchy is also set by the screener and screening conditions are added in S01.
Preferably, the organizing, by the Java service backend to the tree structure filtering data according to the hierarchy from inside to outside in S03 specifically includes the following:
if yes, the leaf node is subjected to UNION calculation; if yes, the leaf node is calculated as INNERJOIN.
The invention has the following beneficial effects:
1. according to the invention, the filtering condition of the tree structure is established, and the filtering condition can be set into a plurality of layers of filtering conditions; the data processing method has the advantages that higher expansibility is guaranteed, operation and use are facilitated, and data processing efficiency of business personnel and developers is improved;
2. the filtering conditions are displayed through the tree structure, the connection relation and the hierarchical relation among the filtering conditions are clearly and clearly displayed, and the operation and the processing of business personnel are facilitated.
Of course, it is not necessary for any product in which the invention is practiced to achieve all of the above-described advantages at the same time.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flow chart of a method of filtering models based on a visual editing system of the present invention;
FIG. 2 is a schematic view of a visual editing system interface according to the present invention;
FIG. 3 is a schematic diagram of a filter formula configuration interface according to the present invention;
FIG. 4 is a schematic view of an interface for increasing filtration conditions in the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 2, the BI system is a set of visual editing systems for rapidly generating a data analysis interface through dragging. The design mode of the BI visualization interface is as follows: the method comprises the following steps that a canvas is used as a carrier, a user drags various chart cards on the canvas, the data and the style attributes of the cards are configured, and finally an analysis interface which meets the requirements of the user is rendered; on the analysis interface, a user can customize screening data to meet the self analysis requirement.
Referring to fig. 1, the present invention is a filtering model method based on a visual editing system, including the following steps:
s00: as shown in fig. 3, the user may select [ filter ] from the expand buttons of the fields, or enter the formula configuration interface from the [ edit ] button of the filter;
s01: adding filtering conditions on the filter by the user;
wherein, the filtering condition is displayed through a tree structure; the father node of the tree structure is an AND selector; leaf nodes of the tree structure are screening conditions; in specific use, please refer to fig. 4, wherein the button 1 is a level for adding a condition, and one click will add another layer outside the current level; the button 2 is used for increasing the number of leaf nodes, and one click is performed, so that one leaf node is added under the current father node; the filtering conditions are displayed through a tree structure, the connection relation and the hierarchical relation among the filtering conditions are clearly and clearly displayed, and operation and processing of business personnel are facilitated.
S02: the front-end server converts the filtering conditions in the filter into tree-structure filtering data and transmits the tree-structure filtering data to the Java service back end;
s03: the Java service back end organizes the tree structure filtering data from inside to outside according to the hierarchy and converts the tree structure filtering data into SQL execution statements to generate execution results.
Among them, in S01, a screening hierarchy is set by the screener and screening conditions are added.
The step of organizing the tree structure filtering data by the Java service backend according to the hierarchy from inside to outside in S03 specifically includes the following steps:
if yes, the leaf node is subjected to UNION calculation; if yes, the leaf node is calculated as INNERJOIN.
It should be noted that, in the above system embodiment, each included unit is only divided according to functional logic, but is not limited to the above division as long as the corresponding function can be implemented; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present invention.
In addition, it is understood by those skilled in the art that all or part of the steps in the method for implementing the embodiments described above may be implemented by a program instructing associated hardware, and the corresponding program may be stored in a computer-readable storage medium.
The preferred embodiments of the invention disclosed above are intended to be illustrative only. The preferred embodiments are not intended to be exhaustive or to limit the invention to the precise embodiments disclosed. Obviously, many modifications and variations are possible in light of the above teaching. The embodiments were chosen and described in order to best explain the principles of the invention and the practical application, to thereby enable others skilled in the art to best utilize the invention. The invention is limited only by the claims and their full scope and equivalents.
Claims (3)
1. The filtering model method based on the visual editing system is characterized by comprising the following steps of:
s00: the user can select the [ filter ] from the expansion buttons of the fields or enter a formula configuration interface from the [ edit ] button of the filter;
s01: adding filtering conditions on the filter by the user;
wherein the filtering condition is represented by a tree structure; a parent node of the tree structure is an AND selector; the leaf nodes of the tree structure are screening conditions;
s02: the front-end server converts the filtering conditions in the filter into tree-structure filtering data and transmits the tree-structure filtering data to the Java service back end;
s03: the Java service back end organizes the tree structure filtering data from inside to outside according to the hierarchy and converts the tree structure filtering data into SQL execution statements to generate execution results.
2. The visual editing system-based filtering model method according to claim 1, wherein in S01, a filtering hierarchy is further set and a filtering condition is added through a filter.
3. The filtering model method based on the visual editing system according to claim 1, wherein the step of organizing the tree-structured filtering data from inside to outside according to the hierarchy by the Java service backend in S03 specifically includes the following steps:
if yes, the leaf node is subjected to UNION calculation; if yes, the leaf node is calculated as INNERJOIN.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910901428.6A CN110750192A (en) | 2019-09-23 | 2019-09-23 | Filtering model method based on visual editing system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910901428.6A CN110750192A (en) | 2019-09-23 | 2019-09-23 | Filtering model method based on visual editing system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110750192A true CN110750192A (en) | 2020-02-04 |
Family
ID=69276883
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910901428.6A Pending CN110750192A (en) | 2019-09-23 | 2019-09-23 | Filtering model method based on visual editing system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110750192A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103955533A (en) * | 2014-05-13 | 2014-07-30 | 中国工商银行股份有限公司 | Device and method for acquiring page tree data based on buffering queue |
| US20160078135A1 (en) * | 2013-04-28 | 2016-03-17 | Hithink Royalflush Information Network Co., Ltd. | Query selection method and system |
| CN106933889A (en) * | 2015-12-31 | 2017-07-07 | 华为技术有限公司 | For regular collocation method, display methods and the client screened |
| CN107256148A (en) * | 2017-05-24 | 2017-10-17 | 龙芯中科技术有限公司 | The generation method and system at interface, electronic equipment and storage medium |
| CN109033157A (en) * | 2018-06-14 | 2018-12-18 | 山东鲁能软件技术有限公司 | A kind of complex data search method and system based on customized search condition tree |
-
2019
- 2019-09-23 CN CN201910901428.6A patent/CN110750192A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160078135A1 (en) * | 2013-04-28 | 2016-03-17 | Hithink Royalflush Information Network Co., Ltd. | Query selection method and system |
| CN103955533A (en) * | 2014-05-13 | 2014-07-30 | 中国工商银行股份有限公司 | Device and method for acquiring page tree data based on buffering queue |
| CN106933889A (en) * | 2015-12-31 | 2017-07-07 | 华为技术有限公司 | For regular collocation method, display methods and the client screened |
| CN107256148A (en) * | 2017-05-24 | 2017-10-17 | 龙芯中科技术有限公司 | The generation method and system at interface, electronic equipment and storage medium |
| CN109033157A (en) * | 2018-06-14 | 2018-12-18 | 山东鲁能软件技术有限公司 | A kind of complex data search method and system based on customized search condition tree |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20080163159A1 (en) | System and method for extracting UML models from legacy applications | |
| CN110245078A (en) | A kind of method for testing pressure of software, device, storage medium and server | |
| CN104679519B (en) | Graphical user interface software function acquisition methods and device | |
| CN110245270A (en) | Data genetic connection storage method, system, medium and equipment based on graph model | |
| CN108965008A (en) | A kind of generation method and its device of customized network topology structure | |
| CN108170416A (en) | A kind of method and system for building web front-end | |
| CN109471694A (en) | Drop-down list management method and drop-down list | |
| CN110519100A (en) | A kind of more cluster management methods, terminal and computer readable storage medium | |
| CN112148788A (en) | Data synchronization method and system for heterogeneous data source | |
| CN106294439A (en) | A kind of data recommendation system and data recommendation method thereof | |
| CN109002334A (en) | A kind of operation platform and its data processing method | |
| CN109284152A (en) | A kind of menu visual configuration method, equipment and computer readable storage medium | |
| CN106250134B (en) | The code automatic generation method of single language | |
| CN110689124A (en) | Method and system for constructing neural network model | |
| CN110083664B (en) | Method for automatically constructing topological model based on CMDB model | |
| CN109101229A (en) | A kind of code automatic generation method of object-oriented, device and equipment | |
| CN110750192A (en) | Filtering model method based on visual editing system | |
| CN112732242A (en) | Wide table processing script generation method and device | |
| CN116627418A (en) | Multi-level form interface visual generation method and device based on recursion algorithm | |
| JP7250009B2 (en) | How it is done by client-end programming tools | |
| CN117009441A (en) | Knowledge graph construction system and method based on relational database | |
| WO2020208613A1 (en) | Systems and methods for hierarchical process mining | |
| CN109933308A (en) | The customed general-purpose system of remote sensing satellite data prediction flow path visual based on MPI+CUDA | |
| CN111045757A (en) | Visual display system and method for IT resource operation state and storage medium | |
| CN111984633B (en) | Method for on-demand expansion and automatic relation establishment of CMDB configuration classification |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200204 |
|
| RJ01 | Rejection of invention patent application after publication |