Method and device for supporting dynamic service data filtering, electronic equipment and medium

Abstract

The invention provides a method and device for supporting dynamic service data filtering, electronic equipment and a medium, and relates to the field of data processing.The method comprises the steps that a front end obtains a data processing request initiated by a user for all data in a target table; the data processing request comprises a data identifier of each piece of data and a corresponding data processing operation; the front end constructs a request parameter corresponding to the data processing operation of each piece of data, and sends the data identifier of each piece of data and the corresponding request parameter to the server; the server packages the data identifier of each piece of data and the parameter structure of the corresponding request parameter to generate a structured data processing request so as to process a complete table corresponding to a target table stored in a database and determine target data; according to the method, data screening of business scenes such as column selection and sorting of different fields of different clients can be met, meanwhile, code reuse can be supported, and different data can be queried according to different entity Schema.

Description

Technical Field

[0001] The present application relates to the field of data processing, and in particular to a method, device, electronic device and medium for supporting dynamic business data filtering. Background Art

[0002] Currently, when processing data in a data table, only the displayed data can be processed, and hidden data cannot be queried, filtered, sorted, and other operations. For developers, it is impossible to determine in advance how SQL should be spelled, and different users have different needs, and the fields to be displayed and the fields to be selected are also different. The current column selection and sorting fields are fixed and not flexible enough. To solve this problem, a large amount of non-reusable code needs to be written to support the demand, resulting in low developer work efficiency. Summary of the invention

[0003] The purpose of the embodiments of the present application is to provide a method, device, electronic device and medium that support dynamic business data filtering, so as to solve the above-mentioned problems existing in the prior art, and can support code reuse while satisfying users' flexible query scenarios.

[0004] In a first aspect, a method for supporting dynamic business data filtering is provided, which is applied to a filtering system including a front end and a server. The method may include:

[0005] The front end obtains a data processing request initiated by a user for each data in a target table, wherein the data processing request includes a data identifier of each data and a corresponding data processing operation; the target table includes display data and hidden data;

[0006] The front end constructs request parameters corresponding to the data processing operation of each data, and sends the data identifier and corresponding request parameters of each data to the server;

[0007] The server encapsulates the data identifier of each data and the parameter structure of the corresponding request parameter to obtain a structured data processing request, so as to perform data processing on the complete table corresponding to the target table stored in the database to determine the target data; wherein the complete table includes all the data in the target table; and the target data includes hidden data and / or displayed data in the target table.

[0008] In a possible implementation, the request parameters include filterBy, limit, orderBy, and select.

[0009] In a possible implementation, the server encapsulates the data identifier of each data and the parameter structure of the corresponding request parameter, including:

[0010] The server encapsulates the data identifier of each data and the parameter structure of the corresponding request parameter according to the configured interface.

[0011] In a possible implementation, the configured interface is a Query interface.

[0012] In a possible implementation, generating a structured data processing request includes:

[0013] The server generates the structured data processing request through JsonSqlBuilder based on the spelling capabilities of Schema and SqlBuilder.

[0014] In a possible implementation, after generating the structured data processing request, the method further includes:

[0015] The server uses a link manager to connect to a database to perform data processing on a complete table corresponding to the target table stored in the database to determine target data.

[0016] In a possible implementation, after determining the target data, the method further includes:

[0017] The target data is sent to the front end through the server and displayed.

[0018] In a second aspect, a device for supporting dynamic business data filtering is provided, the device is applied to a filtering system including a front end and a server, and the device may include:

[0019] An acquisition unit, used for the front end to acquire a data processing request initiated by a user for each data in a target table, wherein the data processing request includes a data identifier of each data and a corresponding data processing operation; the target table includes display data and hidden data;

[0020] A construction unit, used for the front end to construct request parameters corresponding to the data processing operation of each data, and send the data identifier and corresponding request parameters of each data to the server;

[0021] An encapsulation unit is used for the server to encapsulate the data identifier of each data and the parameter structure of the corresponding request parameter to obtain a structured data processing request, so as to perform data processing on the complete table corresponding to the target table stored in the database to determine the target data; wherein the complete table includes all the data in the target table; and the target data includes hidden data and / or displayed data in the target table.

[0022] In a third aspect, an electronic device is provided, the electronic device comprising a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory communicate with each other via the communication bus;

[0023] Memory, used to store computer programs;

[0024] The processor is used to implement any method step described in the first aspect when executing the program stored in the memory.

[0025] In a fourth aspect, a computer-readable storage medium is provided, wherein a computer program is stored in the computer-readable storage medium, and when the computer program is executed by a processor, any method step described in the first aspect is implemented.

[0026] The present application provides a method for supporting dynamic business data filtering, the method comprising: the front end obtains a data processing request initiated by a user for each data in a target table; the data processing request includes a data identifier of each data and a corresponding data processing operation; the target table includes display data and hidden data; the front end constructs a request parameter corresponding to the data processing operation of each data, and sends the data identifier of each data and the corresponding request parameter to the server; the server encapsulates the parameter structure of the data identifier of each data and the corresponding request parameter, generates a structured data processing request, and performs data processing on the complete table corresponding to the target table stored in the database to determine the target data; the existing list query and screening method is relatively fixed, and the user can only operate the query list data according to a few preset fields, which cannot meet the different customer column selection, query field different scenarios, and the code cannot be reused. The present application combines users, front ends, and back ends through QuerBuilder technology to meet the user's flexible query scenarios, and can support free column selection and sorting queries of different businesses corresponding to different business data through different entity schemas. That is to say, it can support code reuse while meeting the business scenario data screening of column selection, sorting, etc. of different fields of different customers, and query different data according to different entity schemas. BRIEF DESCRIPTION OF THE DRAWINGS

[0027] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for use in the embodiments of the present application will be briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present application and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without paying creative work.

[0028] Figure 1 A system architecture diagram of a method for supporting dynamic business data filtering provided in an embodiment of the present application;

[0029] Figure 2 A schematic diagram of a functional interface provided in an embodiment of the present application;

[0030] Figure 3 A flowchart of a method for supporting dynamic business data filtering provided in an embodiment of the present application;

[0031] Figure 4 A schematic diagram of the structure of a device supporting dynamic service data filtering provided in an embodiment of the present application;

[0032] Figure 5 A schematic diagram of the structure of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0033] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments of the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

[0034] A method for supporting dynamic business data filtering provided by an embodiment of the present application can be applied in Figure 1 In the system architecture shown in Figure 1 As shown, the system may include: a server and a front end. The server may be a physical server, or a server cluster or distributed system composed of multiple physical servers, or a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, content delivery networks (CDN), and big data and artificial intelligence platforms. The front end and the server can be connected through QuerBuilder technology.

[0035] like Figure 2 As shown, the front end is a functional interface for displaying data; this functional interface displays the expense control reimbursement system; in the reimbursement form management-document list, there are many fields displayed, such as: "Title", "Document Number", "Document Template", "Submitter", "Expense Bearing Department" and other fields. The current system supports "Title", "Document Number", "Submitter" column selection, and "Reimbursement Date" sorting;

[0036] The front end is used to obtain the data processing request (column selection field) initiated by the user for each data in the target table, and execute a method for supporting dynamic business data filtering provided by the present application;

[0037] The server is used to execute a method for supporting dynamic business data filtering provided by the present application according to the data sent by the front end.

[0038] Currently, when processing data in a data table, only the displayed data can be processed, and hidden data cannot be queried, filtered, sorted, and other operations. For developers, it is impossible to determine in advance how SQL should be spelled, and different users have different needs, and the fields to be displayed and the fields to be selected are also different. The current column selection and sorting fields are fixed and not flexible enough. To solve this problem, a large amount of non-reusable code needs to be written to support the demand, resulting in low developer work efficiency.

[0039] Therefore, a method, device, electronic device and medium supporting dynamic business data filtering are provided to solve the above-mentioned problems existing in the prior art, and can satisfy users' flexible query scenarios while supporting code reuse.

[0040] The preferred embodiments of the present application are described below in conjunction with the drawings in the specification. It should be understood that the preferred embodiments described herein are only used to illustrate and explain the present application, and are not used to limit the present application. In addition, the embodiments and features in the embodiments of the present application may be combined with each other if there is no conflict.

[0041] Figure 2 A flowchart of a method for supporting dynamic business data filtering provided by the present application is provided in an embodiment of the present application. Figure 3 As shown, the method may include:

[0042] Step S310: The front end obtains a data processing request initiated by the user for each data in the target table.

[0043] The data processing request includes the data identifier of each data and the corresponding data processing operation; the target table includes display data and hidden data.

[0044] The target table can be understood as displaying only part of the data in the table, and the data not displayed is hidden data.

[0045] Specific, combined Figure 2 As shown, the data processing request entered by the user in the display page can be: the column selection condition document template name contains "simple", and the sorting condition "department name" is sorted in reverse order. Input method: When the data of a column in the table is only partially hidden, enter the field to be filtered in the column; when all the data of a column to be filtered is hidden, the front end can obtain the field to be filtered input by the user through a separate filter box in the interface. It can be understood that a separate sorting option box is also provided in the interface, so that when all the data of a column is hidden, the front end can obtain the sorting order of the hidden data selected by the user.

[0046] Step S320: The front end constructs request parameters corresponding to the data processing operations of each data, and sends the data identifier and corresponding request parameters of each data to the server.

[0047] Specifically, the front end constructs request parameters such as "filterBy", "limit", "orderBy", "select" and so on according to the user's data processing operation, and sends the data identifier and corresponding request parameters of each data to the server.

[0048] The "filterBy", "limit", and "orderBy" request parameters can also be understood as filters.

[0049] It should be noted that the request address for front-end and back-end interaction is:

[0050] api / flow / v1 / flows / search? formType=expense;

[0051] The request method is: POST.

[0052] Using filterBy to process the data identifier can also be understood as creating a query to filter out the data through filterBy and returning an array consisting of elements containing the data identifier;

[0053] Process the target table through limit to realize data page turning;

[0054] Through orderBy, the order of data is set and the sorted array is returned;

[0055] Finally, select is used to process the data required for querying in the request.

[0056] Step S330: The server encapsulates the data identifier of each data and the parameter structure of the corresponding request parameter to generate a structured data processing request.

[0057] Specifically, the server encapsulates the data identifier of each data and the parameter structure of the corresponding request parameter according to the configured Query interface.

[0058] The Query interface stores methods for executing database queries, such as executing update, delete, or query statements.

[0059] After that, the server generates structured data processing requests through JsonSqlBuilder based on Schema and SqlBuilder's SQL writing capabilities.

[0060] Step S340: The server processes the complete table corresponding to the target table stored in the database through the structured data processing request to determine the target data.

[0061] The complete table includes all data in the target table, that is, the complete table includes the displayed data and hidden data in the target table; the target data includes the hidden data and / or displayed data in the target table.

[0062] Specifically, the server executes a structured data processing request (SQL statement) in the database through ConnectionManager (technology) to obtain the target data; then, the target data is sent to the front end through the server and displayed. In other words, the target data corresponding to the data identifier is found in the target table in the database.

[0063] In some embodiments, the data processing request may include a sorting identifier of the target data corresponding to the data identifier, and after the target data corresponding to the data identifier is found in the target table in the database, the target data is sorted according to the sorting identifier to display the sorted target data on the front end. It can be understood that the target data is a data group composed of at least one data; the data volume is determined according to the data volume corresponding to the data identifier.

[0064] In some embodiments, the data processing request may also include a user identifier that initiates the data processing request; when the target data is sent to the front end, the target data is sent to the front end corresponding to the user account that initiates the data processing request according to the user identifier and displayed.

[0065] In some embodiments, in order to ensure the security of hidden data, the hidden data in the target data may be encrypted, and it needs to be in an encrypted state throughout the entire transmission process, that is, it is encrypted throughout the entire path from the database to the front-end display process. The secure communication protocol that can be used specifically is: HTTPS: Ensure that data is encrypted during transmission between the client and the server. SFTP: A security protocol for file transfer that provides encrypted transmission and authentication mechanisms. TLS / SSL: Provides an encryption layer for communication to ensure that data is not eavesdropped or tampered with during transmission.

[0066] For example: after the user initiates a data processing request for each data in the target table, when the server determines in the database that there is hidden data in the target data corresponding to the data processing request, the server generates a random one-time key, which is encrypted through the public key, so that even if the key is intercepted during transmission, it will not cause data leakage, and encrypts the hidden data, and uses a secure channel (such as HTTPS) to send the one-time key to the client of the corresponding user.

[0067] The present application provides a method for supporting dynamic business data filtering, the method comprising: the front end obtains a data processing request initiated by a user for each data in a target table; the data processing request includes a data identifier of each data and a corresponding data processing operation; the target table includes display data and hidden data; the front end constructs a request parameter corresponding to the data processing operation of each data, and sends the data identifier of each data and the corresponding request parameter to the server; the server encapsulates the parameter structure of the data identifier of each data and the corresponding request parameter, generates a structured data processing request, and performs data processing on the complete table corresponding to the target table stored in the database to determine the target data; the existing list query and screening method is relatively fixed, and the user can only operate the query list data according to a few preset fields, which cannot meet the different customer column selection, query field different scenarios, and the code cannot be reused. The present application combines users, front ends, and back ends through QuerBuilder technology to meet the user's flexible query scenarios, and can support free column selection and sorting queries of different businesses corresponding to different business data through different entity schemas. That is to say, it can support code reuse while meeting the business scenario data screening of column selection, sorting, etc. of different fields of different customers, and query different data according to different entity schemas.

[0068] Corresponding to the above method, the embodiment of the present application also provides a device supporting dynamic service data filtering, such as Figure 4 As shown, the device comprises:

[0069] An acquisition unit 410 is used for the front end to acquire a data processing request initiated by a user for each data in a target table, wherein the data processing request includes a data identifier of each data and a corresponding data processing operation; the target table includes display data and hidden data;

[0070] A construction unit 420, configured for the front end to construct request parameters corresponding to data processing operations of each data, and to send the data identifier of each data and the corresponding request parameters to the server;

[0071] The encapsulation unit 430 is used for the server to encapsulate the data identifier of each data and the parameter structure of the corresponding request parameter to obtain a structured data processing request, so as to perform data processing on the complete table corresponding to the target table stored in the database to determine the target data; wherein the complete table includes all the data in the target table; and the target data includes hidden data and / or displayed data in the target table.

[0072] The functions of each functional unit of a device supporting dynamic business data filtering provided in the above-mentioned embodiment of the present application can be realized through the above-mentioned method steps. Therefore, the specific working process and beneficial effects of each unit in a device supporting dynamic business data filtering provided in the embodiment of the present application will not be repeated here.

[0073] The present application also provides an electronic device, such as Figure 5 As shown, it includes a processor 510 , a communication interface 520 , a memory 530 and a communication bus 540 , wherein the processor 510 , the communication interface 520 , and the memory 530 communicate with each other via the communication bus 540 .

[0074] Memory 530, for storing computer programs;

[0075] The processor 510 is used to execute the program stored in the memory 530 to implement the following steps:

[0076] The front end obtains a data processing request initiated by a user for each data in a target table, wherein the data processing request includes a data identifier of each data and a corresponding data processing operation; the target table includes display data and hidden data;

[0077] The front end constructs request parameters corresponding to the data processing operation of each data, and sends the data identifier and corresponding request parameters of each data to the server;

[0078] The server encapsulates the data identifier of each data and the parameter structure of the corresponding request parameter to obtain a structured data processing request, so as to perform data processing on the complete table corresponding to the target table stored in the database to determine the target data; wherein the complete table includes all the data in the target table; and the target data includes hidden data and / or displayed data in the target table.

[0079] The communication bus mentioned above can be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus, etc. The communication bus can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, only one thick line is used in the figure, but it does not mean that there is only one bus or one type of bus.

[0080] The communication interface is used for communication between the above electronic device and other devices.

[0081] The memory may include a random access memory (RAM) or a non-volatile memory (NVM), such as at least one disk memory. Optionally, the memory may also be at least one storage device located away from the aforementioned processor.

[0082] The above-mentioned processor can be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it can also be a digital signal processor (DSP), an application specific integrated circuit (ASIC), a field programmable gate array (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components.

[0083] The implementation methods and beneficial effects of the components of the electronic device in the above embodiments to solve the problems can be seen in Figure 2 The various steps in the illustrated embodiment are implemented, therefore, the specific working process and beneficial effects of the electronic device provided by the embodiment of the present application are not repeated here.

[0084] In another embodiment provided in the present application, a computer-readable storage medium is provided, in which instructions are stored. When the computer-readable storage medium is executed on a computer, the computer executes a method for supporting dynamic business data filtering as described in any of the above embodiments.

[0085] In another embodiment provided by the present application, a computer program product including instructions is also provided, which, when executed on a computer, enables the computer to execute a method for supporting dynamic business data filtering as described in any one of the above embodiments.

[0086] Those skilled in the art will appreciate that the embodiments in the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt a complete hardware embodiment, a complete software embodiment, or a form of an embodiment combining software and hardware. Moreover, the present application may adopt a form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0087] The embodiments of the present application are described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0088] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0089] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0090] Unless otherwise defined, the technical terms or scientific terms used in this application should be understood by people with ordinary skills in the field to which the present invention belongs. "First", "second" and similar words used in this application do not indicate any order, quantity or importance, but are only used to distinguish different components. "Include" or "comprise" and similar words mean that the elements or objects appearing before the word cover the elements or objects listed after the word and their equivalents, without excluding other elements or objects. "Connect", "couple" or "connected" and similar words are not limited to physical or mechanical connections, but may include electrical connections, whether direct or indirect. "Up", "down", "left", "right" and the like are only used to indicate relative positional relationships. When the absolute position of the described object changes, the relative positional relationship may also change accordingly.

[0091] Although the preferred embodiments of the present application have been described, those skilled in the art may make additional changes and modifications to these embodiments once they are aware of the basic creative concepts. Therefore, the present application embodiments are intended to be interpreted as including the preferred embodiments and all changes and modifications that fall within the scope of the present application embodiments.

[0092] Obviously, those skilled in the art can make various changes and modifications to the embodiments in the present application without departing from the spirit and scope of the embodiments in the present application. Thus, if these modifications and variations of the embodiments in the present application are within the scope of the embodiments in the present application and their equivalents, the embodiments in the present application are also intended to include these modifications and variations.

Claims

1. A method for supporting dynamic business data filtering, characterized in that: Applied to a filtering system including a front end and a server, the method comprises: The front end obtains a data processing request initiated by a user for each data in a target table, wherein the data processing request includes a data identifier of each data and a corresponding data processing operation; the target table includes display data and hidden data; The front end constructs request parameters corresponding to the data processing operation of each data, and sends the data identifier and corresponding request parameters of each data to the server; The server encapsulates the data identifier of each data and the parameter structure of the corresponding request parameter to obtain a structured data processing request, so as to perform data processing on the complete table corresponding to the target table stored in the database to determine the target data; wherein the complete table includes all the data in the target table; and the target data includes hidden data and / or displayed data in the target table.

2. The method according to claim 1, characterized in that The request parameters include filterBy, limit, orderBy and select.

3. The method according to claim 1, characterized in that The server encapsulates the data identifier of each data and the parameter structure of the corresponding request parameter, including: The server encapsulates the data identifier of each data and the parameter structure of the corresponding request parameter according to the configured interface.

4. The method according to claim 3, characterized in that The configured interface is a Query interface.

5. The method according to claim 1, characterized in that Generate structured data processing requests, including: The server generates the structured data processing request through JsonSqlBuilder based on the spelling capabilities of Schema and SqlBuilder.

6. The method according to claim 1, characterized in that After generating the structured data processing request, the method further includes: The server uses a link manager to connect to a database to perform data processing on a complete table corresponding to the target table stored in the database to determine target data.

7. The method according to claim 1, characterized in that After determining the target data, the method further includes: The target data is sent to the front end through the server and displayed.

8. A device supporting dynamic business data filtering, characterized in that: Applicable to a filtering system including a front end and a server, the device includes: An acquisition unit, used for the front end to acquire a data processing request initiated by a user for each data in a target table, wherein the data processing request includes a data identifier of each data and a corresponding data processing operation; the target table includes display data and hidden data; A construction unit, used for the front end to construct request parameters corresponding to the data processing operation of each data, and send the data identifier and corresponding request parameters of each data to the server; An encapsulation unit is used for the server to encapsulate the data identifier of each data and the parameter structure of the corresponding request parameter to obtain a structured data processing request, so as to perform data processing on the complete table corresponding to the target table stored in the database to determine the target data; wherein the complete table includes all the data in the target table; and the target data includes hidden data and / or displayed data in the target table.

9. An electronic device, characterized in that: The electronic device comprises a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory communicate with each other via the communication bus; Memory, used to store computer programs; A processor, for implementing the method steps described in any one of claims 1 to 7 when executing a program stored in a memory.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the method steps described in any one of claims 1 to 7 are implemented.

Images