Filter-based screening configuration method, device and equipment, and storage medium

By inputting the filter configuration file into the initial status bar, a type status bar for the filter type is generated, and the component display content of the filter dimension is updated. After deduplication and intersection processing, filter items are generated, which solves the problem of high filter acquisition cost and achieves the effect of reducing filter cost.

CN115221372BActive Publication Date: 2025-12-19CHINA PING AN LIFE INSURANCE CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202210921762.X
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2022-08-02
Publication Date
2025-12-19
Estimated Expiration
2042-08-02

AI Technical Summary

Technical Problem

In existing technologies, the cost of using filters is high, as are the development and maintenance costs. How can we reduce the cost of acquiring filters?

Method used

By inputting the filter configuration file into the initial status bar, a type status bar corresponding to each filter type in the filter configuration file is generated. Each parameter in the filter configuration file is input into the input field of the corresponding filter dimension in the type status bar. Based on the parameters in the input field of each filter dimension, the component display content of the corresponding filter dimension is updated. Based on the display content of each component, the corresponding dimension value data table is retrieved from the database. After deduplication and intersection processing of the dimension values ​​in all dimension value data tables, the optional dimension values ​​are obtained and a filter item is generated in the type status bar. The dimension value triggered by the user is obtained as the filter dimension value.

Benefits of technology

This reduces the involvement of developers and maintainers, and lowers the cost of acquiring filters.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN115221372B_ABST
    Figure CN115221372B_ABST
Patent Text Reader

Abstract

The present application relates to the technical field of computer, and provides a filter-based screening configuration method and device, equipment and storage medium, wherein a filter configuration file is input into an initial state bar of a filter, a type state bar corresponding to a filter type in the filter configuration file is generated, parameters of each screening dimension in the filter configuration file are input into input items of corresponding screening dimensions in the type state bar, and according to the parameters in the input items of each screening dimension, component display content of the corresponding screening dimension is updated, corresponding dimension value data tables are obtained from a database, selectable dimension values are obtained, screening items are generated in the type state bar, the filter is configured according to the filter configuration file, corresponding dimensions of the filter are input into corresponding input items, and corresponding screening dimension values are obtained from the database according to the component content, screening is generated according to the corresponding screening dimension values, the intervention of developers and maintenance personnel is reduced, and thus the acquisition cost of the filter is reduced.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This invention relates to the field of computer technology, and in particular to a filter-based filtering configuration method, apparatus, device, and storage medium. Background Technology

[0002] Data filtering refers to selecting the desired portion from a large amount of data. It typically involves using computers or data storage and computing devices to perform conditional and selective data selection operations. Through data filtering, data that meets certain conditions is obtained to satisfy user needs.

[0003] Currently, among the existing data filtering methods, filters are set up for each dimension of data so that users can filter the data according to the corresponding dimension. Each time a user filters, they filter according to one of the filtering dimensions. When filtering multiple filtering dimensions, developers need to write different filters for different filtering dimensions in turn, which results in high development and maintenance costs. Therefore, how to reduce the cost of obtaining filters has become an urgent problem to be solved. Summary of the Invention

[0004] Therefore, it is necessary to provide a filter configuration method, apparatus, device, and storage medium based on a filter to address the above-mentioned technical problems and solve the problem of high cost of obtaining filters.

[0005] Firstly, a filter-based filtering configuration method is provided, the method comprising:

[0006] Input the filter configuration file into the initial status bar of the filter to generate the type status bar corresponding to the filter type in the filter configuration file;

[0007] Input the parameters of each filter dimension in the filter configuration file into the corresponding input item of the filter dimension in the type status bar, and update the component display content corresponding to the filter dimension according to the parameters in the input item of each filter dimension.

[0008] Based on the content displayed by each component, the corresponding dimension value data table is retrieved from the database. After deduplication and intersection processing of the dimension values ​​in all dimension value data tables, the optional dimension values ​​are obtained.

[0009] A filter item is generated in the type status bar. The filter item is used to display the optional dimension values ​​and obtain the dimension value selected by the user as the filter dimension value.

[0010] Secondly, a filter-based filter configuration device is provided, the device comprising:

[0011] The type status bar determining module is configured to input a filter configuration file into an initial status bar of the filter, and generate a type status bar corresponding to a type of the filter in the filter configuration file;

[0012] The updating module is configured to input parameters of each filtering dimension in the filter configuration file into input items of corresponding filtering dimensions in the type status bar, and update component display content corresponding to each filtering dimension according to the parameters in the input items of each filtering dimension;

[0013] The deduplication module is configured to obtain corresponding value data tables of dimensions from a database based on each component display content, and obtain selectable value of dimensions after deduplication and intersection processing of the value of dimensions in all the value data tables of dimensions.

[0014] The filtering value obtaining module is configured to generate a filtering item in the type status bar, the filtering item is configured to display the selectable value of dimensions, and obtain a value of dimensions selected by a user as a filtering value of dimensions.

[0015] In a third aspect, an embodiment of the present application provides a computer device, which comprises a processor, a memory, and a computer program stored in the memory and executable on the processor, and the processor implements the filter-based filtering configuration method according to the first aspect when executing the computer program.

[0016] In a fourth aspect, an embodiment of the present application provides a computer readable storage medium, which stores a computer program, and the computer program is executable on a processor to implement the filter-based filtering configuration method according to the first aspect.

[0017] Compared with the prior art, the present application has the following beneficial effects:

[0018] The filter configuration file is input into an initial status bar of the filter, a type status bar corresponding to a type of the filter in the filter configuration file is generated, parameters of each filtering dimension in the filter configuration file are input into input items of corresponding filtering dimensions in the type status bar, and component display content corresponding to each filtering dimension is updated according to the parameters in the input items of each filtering dimension, corresponding value data tables of dimensions are obtained from a database based on each component display content, and selectable value of dimensions is obtained after deduplication and intersection processing of the value of dimensions in all the value data tables of dimensions. BRIEF DESCRIPTION OF DRAWINGS

[0019] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the following will briefly introduce the drawings needed to be used in the description of the embodiments of the present application. Obviously, the drawings in the following description only some embodiments of the present application, and for those skilled in the art, other drawings can also be obtained without creative labor on the basis of these drawings.

[0020] Figure 1 is an application environment schematic diagram of a filter-based screening configuration method provided by an embodiment of the present application;

[0021] Figure 2 is a flow schematic diagram of a filter-based screening configuration method provided by an embodiment of the present application;

[0022] Figure 3 is a flow schematic diagram of a filter-based screening configuration method provided by an embodiment of the present application;

[0023] Figure 4 is a structure schematic diagram of a filter-based screening configuration device provided by an embodiment of the present application;

[0024] Figure 5 is a structure schematic diagram of a computer device provided by an embodiment of the present application. DETAILED DESCRIPTION

[0025] The technical solutions in the embodiments of the present application will be described clearly and completely below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are some embodiments of the present application, rather than all the embodiments. Based on the embodiments in the present application, all other embodiments obtained by those skilled in the art without creative labor are within the protection scope of the present application.

[0026] It should be understood that when used in the specification and the appended claims of the present application, the term "comprising" indicates the presence of the described features, integers, steps, operations, elements, and / or components, but does not exclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and / or groups thereof.

[0027] It should also be understood that the term "and / or" used in the specification and the appended claims of the present application means any combination of one or more of the associated listed items and all possible combinations, and includes these combinations.

[0028] As used in the description of the application and the appended claims, the term “if’ can be interpreted to mean “when” or “upon” or “in response to determining” or “in response to detecting,” depending on the context. Similarly, the phrase “if it is determined” or “if [a described condition or event] is detected” can be interpreted to mean “upon determining” or “in response to determining” or “upon detecting [the described condition or event]” or “in response to detecting [the described condition or event],” depending on the context.

[0029] In addition, in the description of the application and the appended claims, the terms “first”, “second”, “third”, etc. are only used to distinguish the description, and cannot be understood as indicating or implying relative importance.

[0030] The description of “one embodiment” or “some embodiments” or the like in the present application description means that the specific features, structures or characteristics described in connection with the embodiment are included in one or more embodiments of the present application. Therefore, the statements “in one embodiment”, “in some embodiments”, “in other some embodiments”, “in further some embodiments” and the like appearing in different places in the specification are not necessarily all referring to the same embodiment, but mean “one or more but not all embodiments”, unless otherwise specifically emphasized. The terms “include”, “contain”, “have” and their variants mean “include but not limited to”, unless otherwise specifically emphasized.

[0031] Embodiments of the present application can acquire and process related data based on artificial intelligence technology. Artificial intelligence (AI) is the use of digital computers or computer-controlled machines to simulate, extend and expand human intelligence, perceive the environment, acquire knowledge and use knowledge to obtain the best results.

[0032] The basic technology of artificial intelligence generally includes technologies such as sensors, special artificial intelligence chips, cloud computing, distributed storage, big data processing technology, operation / interaction system, mechatronics, etc. Artificial intelligence software technology mainly includes computer vision technology, robot technology, biometric technology, speech processing technology, natural language processing technology, and machine learning / deep learning, etc.

[0033] It should be understood that the size of the serial number of each step in the following embodiments does not mean the order of execution, and the execution order of each process should be determined by its function and inherent logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.

[0034] In order to illustrate the technical solutions of the present application, the following will be described by specific embodiments. In order to illustrate the technical solutions of the present application, the following will be described by specific embodiments.

[0035] The embodiment of the present application provides a filter-based screening configuration method, which can be applied to the application environment shown in Figure 1 , wherein a client communicates with a server. The client includes but is not limited to a palm computer, a desktop computer, a notebook computer, an ultra-mobile personal computer (UMPC), a netbook, a personal digital assistant (PDA) and the like computer equipment. The server can be realized by an independent server or a server cluster composed of multiple servers.

[0036] Referring to Figure 2 , it is a flowchart of a filter-based screening configuration method provided by the embodiment of the present application, and the filter-based screening configuration method can be applied to a server in Figure 1 , wherein the server is connected with a corresponding client and provides a model training service for the client. As shown in Figure 2 , the filter-based screening configuration method can include the following steps.

[0037] S201: inputting a filter configuration file into an initial state bar of a filter to generate a type state bar corresponding to a filter type in the filter configuration file.

[0038] In step S201, the filter configuration file contains corresponding parameters for generating the filter, and the initial state bar of the filter is a configurable item, and the corresponding field information can be configured in the initial state bar, so that different filters are generated according to the configured field information, and the type state bar of the filter is the style of the filter.

[0039] In the embodiment, the initial state bar of the filter is generated in the screening interface, the configuration file of the filter is input into the initial state bar, and the type state bar corresponding to the filter type in the filter configuration file is generated, wherein the type state bar corresponding to the filter type can include a drop-down type, a hierarchical filter, a list filter and a date filter. Different data fields correspond to different filter types, and the mapping relationship between the data fields and the filter types can be set, when the field information in the configuration file of the filter is mapped with the filter type, the corresponding filter type can be generated according to the field information in the filter configuration file and the initial state bar of the filter.

[0040] It should be noted that in the hierarchical filter, there is a direct affiliation between adjacent levels. In the filtering of adjacent levels, the options of the lower level can be directly and uniquely mapped to the options of the higher adjacent level to which it belongs. For example, with three levels of options such as province, city, and county, in the filtering process, the names of the corresponding provincial units are first displayed. After selecting the name of the provincial unit, the municipal units corresponding to the provincial unit appear. After determining the municipal unit, the county-level units corresponding to the municipal unit appear.

[0041] It should be noted that the type of filter can also be a combined filter. The hierarchical filter, list filter, and date filter can be combined to obtain a combined filter, and each type of filter can be reused.

[0042] It should be noted that according to the different positions of the filter, the filter can also be divided into a top multi-row filter, a top floating filter, a right floating filter, a bottom floating filter, and a full floating filter. The top multi-row filter has one dimension corresponding to each row, and more options can be displayed by swiping left on each dimension. It is suitable for scenarios with single business structure and fewer filtering dimensions. The top floating filter is suitable for scenarios with complex business and a large number of filtering options. The right floating filter is suitable for scenarios with complex business and a large number of filtering options. The bottom floating filter is usually placed at the bottom of the page when the filtering button is placed at the bottom of the page or appears alone. The full floating filter is similar to the right floating filter, but it occupies the largest area of the page and is suitable for scenarios with more complex business and more filtering dimensions.

[0043] Optionally, the filter configuration file is input into the initial state bar of the filter, and a type state bar corresponding to the type of the filter in the filter configuration file is generated, including:

[0044] The filter configuration file is parsed and processed to obtain a type state bar template parameter corresponding to the type of the filter in the filter configuration file.

[0045] According to the type state bar template parameter, a target type state bar template corresponding to the type state bar is determined, and a corresponding type state bar is generated according to the target type state bar template.

[0046] In the embodiment, when the filter configuration file is parsed, the reading result of the configuration file is obtained, the objects in the configuration file are mapped according to the reading result of the configuration file, and the mapping result is obtained. Generally, the configuration file is deployed in a fixed path of the server, and the files in the path are all configuration files. Specifically, there are folders with the names of Setting or Settings in the server, and the related configuration files are saved in the folders. The process of reading the configuration file can be realized by using related tools, for example, the configuration file is opened by using the notepad program, and then the content in the configuration file is directly obtained. The reading result of the configuration file obtained as the to-be-processed data can be saved in the computer content, so as to facilitate the subsequent parsing operation. The reading result of the configuration file includes template parameters corresponding to various related filter types and corresponding parameter attribute values, and the type status bar corresponding to the filter type in the filter configuration file is determined through the corresponding attribute value.

[0047] It should be noted that when the configuration file of the filter is parsed, each line in the configuration file is parsed, the keywords in each line are parsed, if the line data contains the keyword of the comment line, it indicates that the line data is a comment, and the comment content does not need to be parsed, if the line data contains the conditional judgment symbol if or else, the context needs to be comprehensively parsed, so that the conditional relationship can be completely characterized.

[0048] According to the type status bar template parameter, the target type status bar template corresponding to the type status bar is determined, and the corresponding type status bar is generated according to the target type status bar template, including:

[0049] According to the template parameter of the filter type, the mapping relationship between the template parameter of the filter type and the type status bar corresponding to the preset filter is determined;

[0050] According to the mapping relationship, the target type status bar template is obtained from the type status bar corresponding to the preset filter, and the corresponding type status bar is generated according to the target type status bar template.

[0051] In the embodiment, according to the template parameter of the filter type, the mapping relationship between the type status bar corresponding to the filter and the template parameter of the filter type is determined, and the mapping relationship is one-to-one between the template parameter of the filter type and the type status bar corresponding to the filter. The corresponding identification information can be set for the template of the filter type, each identification information corresponds to a unique type status bar, when the corresponding identification information is included in the template parameter of the filter type, the template of the filter type corresponding to the identification information can be determined, and the corresponding type status bar is generated according to the template of the filter type.

[0052] S202: input the parameters of each screening dimension in the filter configuration file into the input item of the corresponding screening dimension in the parameter input type status bar, and update the component display content of the corresponding screening dimension according to the parameters in the input item of each screening dimension.

[0053] In step S202, after inputting the configuration file of the filter into the initial status bar, a corresponding type of filter type status bar is generated, the screening dimension parameters corresponding to the filter are input into the input item of the status bar, and the component display content of the corresponding screening dimension is updated according to the parameters in the input item of each screening dimension.

[0054] In this embodiment, the type status bar of the screening interface includes corresponding input items, and the input items can input corresponding screening dimension parameters. Each screening dimension also corresponds to an input item, and the corresponding dimension value parameter of the screening dimension is input. The input item can be pre-written by a programmer with a standard code segment corresponding to the corresponding status bar template of the corresponding filter, and a plurality of blank code positions are reserved in the standard code segment, and the input item code content corresponding to different blank code positions is pre-configured. Different code contents correspond to different input parameters, and the above standard code segment can be adaptively filled according to the content selected or uploaded or input by the user based on the standard display template in the screening interface, to generate custom screening configuration information matching different scenarios.

[0055] When the corresponding input item inputs the corresponding parameters, the component display content of the corresponding screening dimension is updated according to the input screening dimension and the position information of the corresponding screening dimension. The component display content of the screening dimension is composed of field information of the component, the screening interface is composed of various components, the server side can store the original components of the screening interface, and when the screening dimension and the screening dimension parameter are changed, the corresponding original component is replaced with the updated component, and the corresponding component content is sent to the screening interface.

[0056] It should be noted that, due to the replacement storage method adopted by the server side, when updating, the server side directly replaces and modifies, and there is no need to store the two whole interface files before and after modification, which can reduce the storage resource overhead of the server side.

[0057] In this embodiment, the updated part is directly replaced by the corresponding original part, and no string-by-string comparison is needed, which can reduce the processing complexity. For example, according to the division area of the filtering interface, the components corresponding to the filtering interface are divided into different components, the components corresponding to the type of the status bar are divided into the first component, the components corresponding to the filtering dimension are divided into the second component, and the components corresponding to the dimension value of the filtering dimension are divided into the third component. If the content of the first component of the filtering interface is updated, if the differential file is used, the strings in the original first component content and the strings in the updated first component content need to be compared one by one to obtain the differential file. If the method of this embodiment is used, the first component content can be directly replaced without paying attention to which strings have changed, and thus the processing complexity can be reduced. In addition, assuming that only the content of one component of the filtering interface has changed, and the content of the remaining components has not changed, only the content of the corresponding component that has changed needs to be updated, and the remaining component content does not need to be updated, thereby reducing the amount of data to be replaced.

[0058] Optionally, the parameter input type of each filtering dimension in the filter configuration file is input into the input item of the corresponding filtering dimension in the status bar, and the component display content of the corresponding filtering dimension is updated according to the parameters in the input item of each filtering dimension, including:

[0059] According to the parameters in the input item of each filtering dimension in the filter configuration file, the corresponding filtering dimension is obtained.

[0060] According to the field information corresponding to the parameters in the input item of the filtering dimension, the component display content of the corresponding filtering dimension is updated.

[0061] In this embodiment, the filtering interface includes multiple input items, the configuration information corresponding to the input items in the configuration file of the filter is displayed in the corresponding input items, the corresponding filtering dimension in the configuration file is input into the corresponding input item to obtain the corresponding filtering dimension, and the component display content of the corresponding filtering dimension is updated according to the field information corresponding to the parameters in the input item of the filtering dimension.

[0062] It should be noted that the parameters in the configuration file can also be dragged to the corresponding input item, the user can automatically drag the corresponding filtering dimension and the dimension value of the corresponding filtering dimension to the input item to generate a new dimension index, in the to-be-input area of the input item, the corresponding filtering list is generated according to the corresponding filtering dimension of the filter configuration file, and the user configures the filter by selecting the filtering dimension in the filtering list. In addition, the user can also add and delete the corresponding filtering dimension.

[0063] According to the filtering dimension input in the input item and the dimension value parameter corresponding to the filtering dimension, the component display content corresponding to the filtering dimension is updated. For example, when the filtering condition is to filter female students in a class, first, the filtering dimension in the filter type status bar is gender, and the dimension value corresponding to the filtering dimension is male and female. Therefore, the display content corresponding to the female component needs to be updated.

[0064] In step S203, based on each component display content, the corresponding dimension value data table is obtained from the database. Each filtering dimension contains at least one dimension value, and each dimension value contains multiple data. The obtained dimension value data table is de-duplicated and intersected to obtain the selectable dimension value. The dimension value data table is a fact table, or a log report, or other data recording table. The table type of the data table is not limited in the embodiment of the application.

[0065] In step S203, based on each component display content, the corresponding dimension value data table is obtained from the database. Each filtering dimension contains at least one dimension value, and each dimension value contains multiple data. The obtained dimension value data table is de-duplicated and intersected to obtain the selectable dimension value. The dimension value data table is a fact table, or a log report, or other data recording table. The table type of the data table is not limited in the embodiment of the application.

[0066] In this embodiment, according to the content displayed by each component, the corresponding dimension value data table is obtained from the database. Each component is connected with the access layer in the database. The component content includes an access component and an interface component. The access component is connected with the database interface. The database interface transmits the SQL operation statement to the relational database through the relational database connection module. The relational database executes the SQL operation statement and transmits the query statement defined in the access component object to the relational database. The relational database executes the query statement. The relational database connection module transmits the returned data to the access component according to the query statement. The access component transmits the obtained data source to the interface component for display. Thus, the dimension value data table corresponding to the component content is obtained.

[0067] After obtaining the component content corresponding to the dimension value data table, the obtained data table is processed by intersection and de-duplication to obtain the selectable dimension value. When intersection and de-duplication are performed, the field information in different data tables is extracted, and the field information in the data table is matched. If the matching is successful, it is considered that the same field information exists in different data tables. The matched field information is deleted when the corresponding selectable dimension value is generated, and the selectable dimension value is generated.

[0068] It should be noted that when a large amount of dimension value data is de-duplicated, the de-duplication task can be distributed to a cluster. The data nodes in the cluster group the large amount of dimension value data to be de-duplicated based on an index. Each data node matches the corresponding dimension value data group one by one, removes the repeated data with the same grouping index and the same de-duplication index, and thus completes the de-duplication of the dimension value data.

[0069] Optionally, based on the content displayed by each component, the corresponding dimension value data table is obtained from the database, and after the dimension values in all dimension value data tables are processed by de-duplication intersection, optional dimension values are obtained, including:

[0070] According to the query component in the content displayed by each component, the corresponding dimension value data table is obtained from the database;

[0071] According to the field information of the dimension values in the dimension value data table, the dimension values in all dimension value data tables are processed by de-duplication intersection to obtain optional dimension values.

[0072] In this embodiment, according to the component display content, the query component corresponding to each component display content is obtained. For different databases, there are multiple different query components, and the query languages of each query component can be the same or different. When querying in the database by using the query component, the user needs to install the query component in advance, and the query component queries data according to the query language. The multiple query components are classified, and a set of query components with the same query language classification is screened out as the basis for subsequent data query. For example, Hadoop is a distributed file system and a non-relational database, which has multiple databases for storing data, such as a Hive database or an HBase database. Hadoop provides query components Impala, HBase, Phoenix and Kylin for querying data in the database. Impala, Phoenix and Kylin can all use the structured query language SQL to query data, and the query language of HBase is different from Impala, Phoenix and Kylin. Each query component in the query component set establishes a corresponding relationship with each data table name and query field in each database. Specifically, the name of the data table can be an English name or an English name and a Chinese name, wherein the name of the data table is the dimension value information corresponding to the filtering dimension. When the query component queries data by using the query language, the query component parses the query language so that the query component can query data.

[0073] When the query obtains the corresponding dimension value data table, field information in each data table is extracted, intersection and deduplication are performed according to the field information, column field information of each column and row field information of each row in each data table are extracted first, the column field information and the row field information are combined to form a field group, then a plurality of field groups are formed in each dimension value data table, whether the field group in each dimension value data table is same as the field group in the remaining dimension value data table is judged, when judging, whether the first field information in one of the field groups is same as any one of the field information in the remaining field groups is judged, when the field information is same, whether the second field information in the field group is same as the other field information in the field group whose first field information is same is judged, when the second field information is same, it is considered that the two field groups are same, and the same field groups are removed.

[0074] S204: Generating a filtering item in the type status bar.

[0075] In step S204, the corresponding filtering item is generated in the type status bar, the filtering item is used to display the selectable dimension value, and the dimension value selected by the user is obtained as the filtering dimension value, when the dimension value data table is obtained, the corresponding filtering item is generated in the type status bar according to the dimension value information.

[0076] In this embodiment, the selectable dimension value is sent to the filtering interface according to the obtained selectable dimension value, and the corresponding filtering item is generated in the type status bar according to the dimension value information. According to the preset connection string, the type status bar connects the corresponding selectable dimension value data table.

[0077] The corresponding filtering item is generated in the selectable type status bar in combination with the data in the selectable dimension value data table and the interface display attribute in the display attribute table, for example, field A1 of the data table A is displayed in the form of a text box, fields A2 and A3 are displayed in the form of a drop-down list box, the specific data in field A1 fills the text box, and the data in A2 and A3 fills the drop-down list.

[0078] It should be noted that, in the case where the interface display template component is not set in the system, the interface display component corresponding to the interface display attribute in the interface display attribute table is called to generate the interface display of the field indicated by the interface display attribute in the interface, and then the data in the dimension value data table is called to generate the filtering item according to the interface display attribute table.

[0079] The server in the embodiment of the present application performs constraint verification on the screening dimension value after receiving the screening dimension value triggered by the user, checks whether the screening dimension value is within the agreed range, i.e., confirms that it is within the screening item specified in the configuration file. This avoids some potential risks caused by terminal forgery of screening items. The server gives relevant prompts when it fails to pass the constraint verification. After passing the constraint verification, the server obtains the screening result according to the configuration file and the screening dimension value, and feeds back the screening result to the screening page of the terminal, thereby improving the system data security.

[0080] Optionally, the screening item is generated in the type status bar, including:

[0081] According to the mapping relationship between the preset function plug-in and the database, the display position, display form and prompt information of the dimension value data table corresponding to the optional dimension value in the type status bar are determined.

[0082] Based on the display position, display form and prompt information of the dimension value data table corresponding to the optional dimension value in the type status bar, the screening item is generated in the status bar.

[0083] In the embodiment, according to the mapping relationship between the function plug-in and the database, the corresponding screening item can be displayed in the type status bar. When the corresponding function plug-in is loaded in the screening interface, the function plug-in itself has established a mapping relationship with the database, so the fields of the corresponding data table in the database can be displayed through the type status bar in the screening interface. Meanwhile, the data in the database table can also be presented in the interface through a series of data views.

[0084] It should be noted that the display position, display form and prompt information of the function plug-in can be determined according to the mapping relationship between the function plug-in and the database, and then the corresponding layout in the type status bar can be completed according to the determined display position, display form and prompt information.

[0085] The filter configuration file is input into an initial state bar of the filter, a type state bar corresponding to a type of the filter in the filter configuration file is generated, parameters of each filter dimension in the filter configuration file are input into input items of corresponding filter dimensions in the type state bar, and according to the parameters in the input items of each filter dimension, component display content of the corresponding filter dimension is updated; based on each component display content, corresponding value data tables are obtained from a database, after value data in all value data tables are processed by de-duplication intersection, selectable value data is obtained, a filter item is generated in the type state bar, the filter item is used to display the selectable value data, and value data selected by a user is obtained as filter value data; according to the configuration file of the filter, the filter corresponding to the value data is input into the corresponding input items, and corresponding filter value data is obtained from the database according to the component content; according to the corresponding filter value data, a filter is generated, and the intervention of a developer and a maintenance personnel is reduced, so that the acquisition cost of the filter is reduced.

[0086] Referring to Figure 3 , which is a flowchart of a filter-based filter configuration method provided by an embodiment of the present application, as shown in Figure 3 , the filter-based filter configuration method can include the following steps.

[0087] S301: According to a received filter configuration request triggered by a user, a filter configuration file is obtained.

[0088] In the embodiment, when the user needs to perform data filtering, the user can trigger a filter matching request of the filter through a web page of a terminal (such as a PC or a smart phone). Specifically, after the corresponding web page is opened and logged in, the user can select a corresponding scene, filter dimensions, filter value data, and the like. According to the received filter configuration request and filterable items corresponding to the filtering scene, a server side generates a corresponding filter configuration file.

[0089] S302: The filter configuration file is input into an initial state bar of the filter, a type state bar corresponding to a type of the filter in the filter configuration file is generated, parameters of each filter dimension in the filter configuration file are input into input items of corresponding filter dimensions in the type state bar, and according to the parameters in the input items of each filter dimension, component display content of the corresponding filter dimension is updated;

[0090] S303: The filter configuration file is input into an initial state bar of the filter, a type state bar corresponding to a type of the filter in the filter configuration file is generated, parameters of each filter dimension in the filter configuration file are input into input items of corresponding filter dimensions in the type state bar, and according to the parameters in the input items of each filter dimension, component display content of the corresponding filter dimension is updated;

[0091] S304: Based on each component display content, corresponding value data tables are obtained from a database, after value data in all value data tables are processed by de-duplication intersection, selectable value data is obtained;

[0092] S305: A filter item is generated in the type state bar, the filter item is used to display the selectable value data, and value data selected by a user is obtained as filter value data.

[0093] The steps S302 to S305 are the same as the steps S201 to S204, and can be referred to the description of steps S201 to S204, which will not be repeated here.

[0094] Please see Figure 4 , Figure 4 This is a schematic diagram of a filter configuration device based on a filter according to an embodiment of the present invention. In this embodiment, the terminal includes units used for execution... Figure 2 to 3 The steps in the corresponding embodiments. Please refer to the details. Figure 2 to 3 The relevant descriptions in the corresponding embodiments are shown below. For ease of explanation, only the parts relevant to this embodiment are shown. See also... Figure 4 The filter configuration device 40 based on the filter includes: a type status bar determination module 41, an update module 42, a deduplication module 43, and a filter dimension value acquisition module 44.

[0095] The type status bar determination module 41 is used to input the filter configuration file into the initial status bar of the filter and generate the type status bar corresponding to the filter type in the filter configuration file.

[0096] The update module 42 is used to input the parameters of each filter dimension in the filter configuration file into the corresponding input item of the filter dimension in the type status bar, and update the component display content of the corresponding filter dimension according to the parameters in the input item of each filter dimension.

[0097] The deduplication module 43 is used to retrieve the corresponding dimension value data table from the database based on the content displayed by each component, and to obtain the optional dimension values ​​after deduplication and intersection processing of the dimension values ​​in all dimension value data tables.

[0098] The filter dimension value acquisition module 44 is used to generate filter items in the type status bar. The filter items are used to display the selectable dimension values ​​and obtain the dimension value selected by the user as the filter dimension value.

[0099] Optionally, the above-mentioned status bar determination module 41 includes:

[0100] The parsing unit is used to parse the filter configuration file and obtain the type status bar template parameters corresponding to the filter types in the filter configuration file.

[0101] The type status bar determination unit is used to determine the target type status bar template corresponding to the type status bar based on the type status bar template parameters, and generate the corresponding type status bar based on the target type status bar template.

[0102] Optionally, the above-mentioned status bar determination unit includes:

[0103] The mapping subunit is configured to determine a mapping relationship between the template parameters of the filter type and the type status bar corresponding to the preset filter according to the template parameters of the filter type.

[0104] The target type status bar template determining subunit is configured to obtain a target type status bar template from the type status bar corresponding to the preset filter according to the mapping relationship, and generate a corresponding type status bar according to the target type status bar template.

[0105] Optionally, the update module 42 includes:

[0106] The filter dimension obtaining unit is configured to obtain each filter dimension in the input item of the corresponding filter dimension in the type status bar according to the parameter input type status bar of each filter dimension in the filter configuration file.

[0107] The update unit is configured to update the component display content of the corresponding filter dimension according to the field information corresponding to the parameters in the input item of the filter dimension.

[0108] Optionally, the deduplication module 43 includes:

[0109] The dimension value data table obtaining unit is configured to obtain the corresponding dimension value data table from the database according to the query component in each component display content.

[0110] The optional dimension value determining unit is configured to obtain the optional dimension value by performing deduplication intersection processing on the dimension values in all dimension value data tables according to the field information of the dimension values in the dimension value data table.

[0111] Optionally, the filter value obtaining module 44 includes:

[0112] The maintained data table state display unit is configured to determine the display position, display form and prompt information of the dimension value data table corresponding to the optional dimension value in the type status bar according to the mapping relationship between the preset function plug-in and the database.

[0113] The filter item generating unit is configured to generate a filter item in the status bar based on the display position, display form and prompt information of the dimension value data table corresponding to the optional dimension value in the type status bar.

[0114] It should be noted that the information interaction, execution process and the like between the above-mentioned units are based on the same concept as the method embodiments of the present application, and the specific functions and the technical effects brought by the same can be referred to the method embodiments part, which will not be described here.

[0115] Figure 5 is a structural schematic diagram of a computer device provided by an embodiment of the present application. As shown in Figure 5 the computer device of this embodiment includes at least one processor (CPU) Figure 5The computer device can include, but is not limited to, a processor, a memory, and a computer program stored in the memory and executable on the at least one processor, the processor implementing the steps of any of the above-mentioned various filter-based screening configuration method embodiments when executing the computer program.

[0116] The computer device can include, but is not limited to, a processor, a memory, and a computer program stored in the memory and executable on the at least one processor, the processor implementing the steps of any of the above-mentioned various filter-based screening configuration method embodiments when executing the computer program. Figure 5 The computer device is merely an example and does not constitute a limitation on the computer device, the computer device can include more or fewer components than shown, or combine certain components, or include different components, for example, the computer device can also include a network interface, a display screen, an input device, and the like.

[0117] The processor can be a CPU, and the processor can also be other general-purpose processors, digital signal processors (DSP), application specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gates or transistor logic components, discrete hardware components, etc. The general-purpose processor can be a microprocessor or the processor can also be any conventional processor.

[0118] The memory includes a readable storage medium, an internal memory, etc., wherein the internal memory can be a memory of the computer device, and the internal memory provides an environment for the operation of the operating system and the computer readable instructions in the readable storage medium. The readable storage medium can be a hard disk of the computer device, and in other embodiments, the readable storage medium can also be an external storage device of the computer device, for example, a plug-in hard disk, a smart media card (SMC), a secure digital (SD) card, a flash card, etc. Further, the memory can include both an internal storage unit of the computer device and an external storage device. The memory is used to store an operating system, an application program, a boot loader, data, and other programs, such as program codes of a computer program, etc. The memory can also be used to temporarily store data that has been output or will be output.

[0119] Those skilled in the art can clearly understand that, for the convenience and brevity of description, only the above-mentioned division of each functional unit and module is exemplified, and in actual application, the above-mentioned functions can be completed by different functional units and modules according to needs, that is, the internal structure of the device is divided into different functional units or modules to complete all or part of the functions described above. Each functional unit and module in the embodiment can be integrated in one processing unit, or each unit can be physically present separately, or two or more units can be integrated in one unit. The integrated unit can be realized in the form of hardware or in the form of software functional unit. In addition, the specific names of each functional unit and module are only for easy distinction, and do not limit the protection scope of the present application. The specific working process of the unit and module in the above device can refer to the corresponding process in the foregoing method embodiment, which will not be repeated here. If the integrated unit is realized in the form of software functional unit and sold or used as an independent product, it can be stored in a computer readable storage medium. Based on this understanding, the present application realizes all or part of the processes in the above-mentioned embodiment methods, which can be completed by a computer program to instruct related hardware. The computer program can be stored in a computer readable storage medium, and when the processor executes the computer program, the steps of the above-mentioned method embodiment can be realized. The computer program includes computer program code, which can be in the form of source code, object code, executable file or some intermediate form, etc. The computer readable medium can at least include any entity or device capable of carrying computer program code, recording medium, computer memory, read-only memory (Read-Only Memory, ROM), random access memory (Random Access Memory, RAM), electrical carrier signal, telecommunication signal and software distribution medium. For example, U disk, mobile hard disk, magnetic disk or optical disk, etc. In some jurisdictions, according to legislation and patent practice, the computer readable medium cannot be an electrical carrier signal and a telecommunication signal.

[0120] The present application realizes all or part of the processes in the above-mentioned embodiment methods, which can also be completed by a computer program product. When the computer program product runs on the computer device, it makes the computer device execute the steps that can realize the above-mentioned method embodiments.

[0121] In the above embodiments, the description of each embodiment has its own emphasis, and the parts not described or recorded in detail in a certain embodiment can be referred to the related description of other embodiments.

[0122] Those skilled in the art can understand that the units and algorithm steps of each example described in combination with the embodiments disclosed herein can be realized in electronic hardware or a combination of computer software and electronic hardware. Whether the functions are realized in hardware or software depends on the specific application and design constraints of the technical solution. Those skilled in the art can use different methods to implement the described functions for each specific application, but such implementation should not be considered beyond the scope of the present application.

[0123] In the embodiments provided by the present application, it should be understood that the disclosed apparatus / computer device and method can be implemented in other manners. For example, the described apparatus / computer device embodiments are merely schematic. For example, the division of the modules or units can be different, and each can include a plurality of sub-units. Some or all of the modules or units can be combined or integrated into another system, or some features can be ignored or not executed. In addition, the displayed or discussed mutual couplings or direct couplings or communication connections can be indirect couplings or communication connections through some interfaces, devices or units, and can be in electrical, mechanical or other forms.

[0124] The units described as separate components may or may not be physically separate, and the components shown as units may or may not be physical units, i.e. may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the embodiments.

[0125] The above embodiments are only used to illustrate the technical solutions of the present application, but not to limit them; although the present application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that the technical solutions recorded in the foregoing embodiments can be modified, or some technical features can be replaced by equivalents; and these modifications or replacements do not make the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present application, and should be included in the protection scope of the present application.

Claims

1. A method of configuring a filter-based screening configuration, characterized by, The configuration method comprises: inputting a filter configuration file into an initial state bar of the filter, generating a type state bar corresponding to a filter type in the filter configuration file; inputting parameters of each filter dimension in the filter configuration file into input items of corresponding filter dimensions in the type state bar, and updating component display content corresponding to the filter dimensions according to the parameters in the input items of each filter dimension; based on each component display content, obtaining corresponding value data tables from a database, and after performing deduplication intersection processing on value data in all value data tables, obtaining selectable value data; generating a filter item in the type state bar, the filter item being used to display the selectable value data and obtain value data selected by a user as filter value data; the inputting of the filter configuration file into the initial state bar of the filter and the generation of the type state bar corresponding to the filter type in the filter configuration file comprise: performing analysis processing on the filter configuration file to obtain a type state bar template parameter corresponding to the filter type in the filter configuration file; determining a mapping relationship between the template parameter of the filter type and a type state bar corresponding to a preset filter according to the template parameter of the filter type; obtaining a target type state bar template from the type state bar corresponding to the preset filter according to the mapping relationship, and generating a corresponding type state bar according to the target type state bar template; the generation of the filter item in the type state bar comprises: determining a display position, a display form and prompt information of a value data table corresponding to the selectable value data in the type state bar according to a mapping relationship between a preset function plug-in and the database; generating a filter item in the state bar based on the display position, the display form and the prompt information of the value data table corresponding to the selectable value data in the type state bar.

2. The filter-based screening configuration method of claim 1, wherein, before the inputting of the filter configuration file into the initial state bar of the filter and the generation of the type state bar corresponding to the filter type in the filter configuration file, the method further comprises: obtaining the filter configuration file according to a filter configuration request triggered by a user.

3. The filter-based screening arrangement method of claim 1, wherein, the the inputting of the parameters of each filter dimension in the filter configuration file into the input items of the corresponding filter dimensions in the type state bar and the updating of the component display content corresponding to the filter dimensions according to the parameters in the input items of each filter dimension comprise: according to the inputting of the parameters of each filter dimension in the filter configuration file into the input items of the corresponding filter dimensions in the type state bar, obtaining the corresponding filter dimensions; according to field information corresponding to the parameters in the input items of the filter dimensions, updating the component display content corresponding to the filter dimensions.

4. The filter-based screening arrangement method of claim 1, wherein, the obtaining of the selectable value data based on each component display content, the obtaining of corresponding value data tables from a database, and the obtaining of the selectable value data after performing deduplication intersection processing on value data in all value data tables comprise: according to a query component in each component display content, obtaining corresponding value data tables from a database; after performing deduplication intersection processing on value data in all value data tables according to field information of the value data in the value data tables, obtaining the selectable value data.

5. A filter-based screening configuration apparatus, characterized by, the device comprises: The type state bar determining module is configured to input a filter configuration file into an initial state bar of the filter, and generate a type state bar corresponding to a filter type in the filter configuration file; The updating module is configured to input parameters of each filter dimension in the filter configuration file into input items of corresponding filter dimensions in the type state bar, and update component display content corresponding to each filter dimension according to the parameters in the input items of the filter dimensions; The deduplication module is configured to obtain corresponding value data tables from a database based on each component display content, and obtain selectable value after deduplication and intersection processing of value in all value data tables; The filter value obtaining module is configured to generate a filter item in the type state bar, and the filter item is configured to display the selectable value and obtain a value selected by a user as a filter value; The inputting of the filter configuration file into the initial state bar of the filter and the generation of the type state bar corresponding to the filter type in the filter configuration file include the following steps: The filter configuration file is parsed to obtain a type state bar template parameter corresponding to a filter type in the filter configuration file; A mapping relationship between the template parameter of the filter type and a type state bar corresponding to a preset filter is determined according to the template parameter of the filter type; A target type state bar template is obtained from the type state bar corresponding to the preset filter according to the mapping relationship, and a corresponding type state bar is generated according to the target type state bar template; The generation of the filter item in the type state bar includes the following steps: A display position, a display form and prompt information of a value data table corresponding to the selectable value in the type state bar are determined according to a mapping relationship between a preset function plug-in and a database; The filter item is generated in the state bar based on the display position, the display form and the prompt information of the value data table corresponding to the selectable value in the type state bar. 6.A computer device, comprising a memory, a processor, and computer readable instructions stored in the memory and executable on the processor, wherein, The computer readable instructions are the filter-based filtering configuration method of any one of claims 1-4.

7. A computer-readable storage medium, characterized in that, The computer readable storage medium stores computer instructions for causing the computer to perform the steps of the filter-based filtering configuration method of any one of claims 1-4.

Citation Information

Patent Citations

  • Index data acquisition method and device, computer equipment and storage medium

    CN111324716A

  • Information display method, device, equipment and storage medium

    CN111736825A