Table data processing method and device, medium, equipment and product

Abstract

The invention discloses a table data processing method and device, a medium, equipment and a product, and the method comprises the steps: responding to a received access request for a data board, and obtaining the configuration information of the data board; determining a first table and a first field according to the configuration information; determining a first query condition corresponding to the first field; and according to a first query condition corresponding to the first field, performing data query in the first table to obtain billboard data information of the data billboard. According to the technical scheme, the first query condition corresponding to the first field is determined, and the first query condition can be used for indicating data query based on all or part of the field content in the first field, so that all or part of the field content participating in the data query in the first field can be positioned; on the basis of all or part of the field content, the billboard data information of the data billboard can be counted and calculated, the situation that the billboard data cannot be obtained is avoided, and the validity of the billboard data information is guaranteed.

Description

Technical Field

[0001] The present disclosure relates to the field of computer technology, and in particular, to a table data processing method, device, medium, equipment and product. Background Art

[0002] Online spreadsheets can store, analyze and visualize data. They can also support simultaneous editing by multiple people to achieve efficient collaboration, support permission settings to ensure data security, etc.

[0003] The dashboard in the online spreadsheet can visualize the data in the table in the form of a data dashboard. There are many types of data dashboards, such as column charts, bar charts, line charts, pie charts, etc., which can count the data in the table from different dimensions. The data dashboard can be used to display the data intuitively and visually, thereby helping users to obtain valuable information from massive data. However, the data processing method in the relevant technology may not be able to produce statistical results, and thus the dashboard data cannot be obtained. Summary of the invention

[0004] This summary is provided to introduce concepts in a brief form that will be described in detail in the detailed description below. This summary is not intended to identify key features or essential features of the claimed technical solution, nor is it intended to limit the scope of the claimed technical solution.

[0005] In a first aspect, the present disclosure provides a table data processing method, the method comprising: In response to receiving an access request for a data dashboard, obtaining configuration information of the data dashboard; Determine a first table and a first field according to the configuration information, wherein the first table serves as a data source of the data dashboard, and the first field includes a field in the first table used to generate the data dashboard; Determine a first query condition corresponding to the first field, where the first query condition is used to indicate that data query is performed based on all or part of the field content in the first field; According to the first query condition corresponding to the first field, data query is performed in the first table to obtain the dashboard data information of the data dashboard.

[0006] In a second aspect, the present disclosure provides a table data processing device, the device comprising: A first acquisition module, configured to acquire configuration information of the data dashboard in response to receiving an access request for the data dashboard; A first determination module, configured to determine a first table and a first field according to the configuration information, wherein the first table is used as a data source of the data dashboard, and the first field includes a field in the first table used to generate the data dashboard; A second determination module, used to determine a first query condition corresponding to the first field, where the first query condition is used to indicate to perform a data query based on all or part of the field content in the first field; A query module is used to perform data query in the first table according to the first query condition corresponding to the first field, so as to obtain the dashboard data information of the data dashboard.

[0007] In a third aspect, the present disclosure provides a computer-readable medium having a computer program stored thereon, which, when executed by a processing device, implements the steps of the table data processing method provided in the first aspect of the present disclosure.

[0008] In a fourth aspect, the present disclosure provides an electronic device, including: a storage device having a computer program stored thereon; A processing device is used to execute the computer program in the storage device to implement the steps of the table data processing method provided in the first aspect of the present disclosure.

[0009] In a fifth aspect, the present disclosure provides a computer program product, including a computer program, which, when executed by a processor, implements the steps of the table data processing method provided in the first aspect of the present disclosure.

[0010] Through the above technical solution, the first field includes a field in the first table used to generate a data dashboard, the first query condition corresponding to the first field is determined, and data query is performed in the first table according to the first query condition to obtain the dashboard data information of the data dashboard. In this way, from the perspective of the field, that is, the perspective of the column in the first table, the corresponding first query condition is determined, and the first query condition can be used to indicate that data query is performed based on all or part of the field content in the first field, so that all or part of the field content involved in the data query in the first field can be located, and the dashboard data information of the data dashboard can be statistically calculated based on the all or part of the field content, avoiding the situation where the dashboard data cannot be obtained, and ensuring the validity of the dashboard data information.

[0011] Other features and advantages of the present disclosure will be described in detail in the following detailed description. BRIEF DESCRIPTION OF THE DRAWINGS

[0012] The above and other features, advantages and aspects of the embodiments of the present disclosure will become more apparent with reference to the following detailed description in conjunction with the accompanying drawings. Throughout the drawings, the same or similar reference numerals represent the same or similar elements. It should be understood that the drawings are schematic and the originals and elements are not necessarily drawn to scale. In the drawings: Figure 1 The figure is a flow chart of a table data processing method according to an exemplary embodiment.

[0013] Figure 2 It is a schematic diagram of a configuration page of a data dashboard according to an exemplary embodiment.

[0014] Figure 3 is a schematic diagram of a first table according to an exemplary embodiment.

[0015] Figure 4 The figure is a schematic diagram showing user authority information according to an exemplary embodiment.

[0016] Figure 5 A schematic diagram showing the user-readable area in the first table.

[0017] Figure 6 The present invention is a flowchart showing a method for determining a first query condition corresponding to a second field according to the second field and reading authority information according to an exemplary embodiment.

[0018] Figure 7 The present invention is a flowchart showing a method for determining a fourth query condition according to a third field and reading authority information according to an exemplary embodiment.

[0019] Figure 8 It is a block diagram of a table data processing device according to an exemplary embodiment.

[0020] Fig. 9 A schematic diagram of the structure of an electronic device suitable for implementing the embodiments of the present disclosure is shown. DETAILED DESCRIPTION

[0021] Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present disclosure are shown in the accompanying drawings, it should be understood that the present disclosure can be implemented in various forms and should not be construed as being limited to the embodiments described herein, which are instead provided for a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are only for exemplary purposes and are not intended to limit the scope of protection of the present disclosure.

[0022] It should be understood that the various steps described in the method embodiments of the present disclosure may be performed in different orders and / or in parallel. In addition, the method embodiments may include additional steps and / or omit the steps shown. The scope of the present disclosure is not limited in this respect.

[0023] The term "including" and its variations used herein are open inclusions, i.e., "including but not limited to". The term "based on" means "based at least in part on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments". The relevant definitions of other terms will be given in the following description.

[0024] It should be noted that the concepts such as "first" and "second" mentioned in the present disclosure are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.

[0025] It should be noted that the modifications of "one" and "plurality" mentioned in the present disclosure are illustrative rather than restrictive, and those skilled in the art should understand that unless otherwise clearly indicated in the context, it should be understood as "one or more".

[0026] The names of the messages or information exchanged between multiple devices in the embodiments of the present disclosure are only used for illustrative purposes and are not used to limit the scope of these messages or information.

[0027] It is understandable that before using the technical solutions disclosed in the embodiments of the present disclosure, the types, scope of use, usage scenarios, etc. of the personal information involved in the present disclosure should be informed to the user and the user's authorization should be obtained in an appropriate manner in accordance with relevant laws and regulations.

[0028] For example, in response to receiving an active request from a user, a prompt message is sent to the user to clearly prompt the user that the operation requested to be performed will require obtaining and using the user's personal information. Thus, the user can autonomously choose whether to provide personal information to software or hardware such as an electronic device, application, server, or storage medium that performs the operation of the technical solution of the present disclosure according to the prompt message.

[0029] As an optional but non-limiting implementation, in response to receiving an active request from the user, the prompt information may be sent to the user in the form of a pop-up window, in which the prompt information may be presented in text form. In addition, the pop-up window may also carry a selection control for the user to choose "agree" or "disagree" to provide personal information to the electronic device.

[0030] It is understandable that the above notification and the process of obtaining user authorization are merely illustrative and do not constitute a limitation on the implementation of the present disclosure. Other methods that meet the relevant laws and regulations may also be applied to the implementation of the present disclosure.

[0031] At the same time, it is understandable that the data involved in this technical solution (including but not limited to the data itself, the acquisition or use of the data) shall comply with the requirements of relevant laws, regulations and relevant provisions.

[0032] In the related art, the method of performing statistical calculations on the data in the online table to obtain the dashboard data is generally calculated through the client. The calculation through the client has the following problems. Among them, in order to ensure data security, the administrator can pre-set the permissions of ordinary users to the rows and columns in the table, set which rows and columns in the table the user can read, edit, and add, and which rows and columns the user cannot read, add, and edit. The server can return the cropped table data to the client according to the user's permission information, that is, the data in the user's readable range that is cropped. The client can obtain the data in the user's readable range in the table returned by the server. For the data that the user does not have the reading permission, the client cannot obtain it. However, the statistical calculation of the data dashboard may use this part of the data that the client cannot obtain. In this case, the client cannot perform the corresponding statistical calculation. For example, the average salary of each job level needs to be displayed to the user through the data dashboard. The user does not have the permission to read the data in the employee job level column, but when calculating the average salary of the job level, the data in the employee job level column needs to be used. Since the client cannot obtain this part of the data, the statistical result of the average salary of the job level cannot be obtained.

[0033] The related technology also has a method that supports statistical calculations by the server. However, the method in the related technology only supports the situation where the user can read a row / column in a table, that is, the area that the user can read can form a complete rectangle. However, in actual applications, the complexity of user permissions is not limited to this. The user may not have reading permissions for only certain cells in the table, that is, the area that the user can read does not form a complete rectangle. The method in the related technology cannot support the statistical calculation of the dashboard data in this case.

[0034] In view of this, the present disclosure provides a table data processing method, device, medium, equipment and product, which can ensure the validity of dashboard data information.

[0035] Figure 1 is a flowchart of a table data processing method according to an exemplary embodiment. The method can be applied to a server, such as Figure 1 As shown, the method may include steps 11 to 14.

[0036] In step 11, in response to receiving an access request for a data dashboard, configuration information of the data dashboard is obtained.

[0037] In one embodiment, the user can click on a button for accessing the data dashboard in the client's page. The client receives the data dashboard access instruction input by the user and can send an access request for the data dashboard to the server. In one embodiment, one or more data dashboards can be established in the dashboard, each of which is independent of each other. Different data dashboards can be used to display different analysis and statistical results. For example, data dashboard 1 is used to display the profit on each sales date, and data dashboard 2 is used to display the sales of each salesperson. The user clicks on a button for viewing the dashboard in the client's page. If multiple data dashboards are established in the dashboard, it can be considered that the user's access instruction for each data dashboard has been received. The client can send an access request for each data dashboard to the server. Since different data dashboards are independent of each other, the data processing of each data dashboard by the server is also independent of each other.

[0038] There are many types of data dashboards, such as bar charts, line charts, pie charts, bar charts, scatter charts, combination charts, funnel charts, combination charts, radar charts, word clouds, rankings, NPS (Net Promoter Score) charts, statistics, etc. Among them, NPS is an indicator to measure customer loyalty and satisfaction. Different types of data dashboards can be used for data analysis in different scenarios. For example, bar charts can be used to compare data of different categories, line charts can be used to view data change trends, scatter charts can be used to collect and analyze discrete data, and word clouds are suitable for visual display of hot words in text data.

[0039] The configuration information of the data dashboard may include information configured by the administrator for generating the data dashboard. The configuration information may include a data source, which indicates which table or tables the data dashboard is based on for data statistics. In addition, the configuration information of the data dashboard displayed by coordinate axes (such as a bar chart, a line chart, a bar chart, etc.) also includes horizontal axis information and vertical axis information. The configuration information of the pie chart type data dashboard also includes sector grouping and sector values. The configuration information of the funnel chart type data dashboard also includes funnel layers and funnel directions. The configuration information of the word cloud type data dashboard also includes keyword fields. The configuration information of the ranking list type data dashboard also includes ranking fields, ranking basis, etc. The configuration information may also include configured data processing conditions, which may include screening conditions and / or sorting conditions.

[0040] In step 12, a first table and a first field are determined according to the configuration information.

[0041] The first table serves as a data source for the data dashboard, and the first field includes fields in the first table used to generate the data dashboard.

[0042] Figure 2 is a schematic diagram of a configuration page of a data dashboard according to an exemplary embodiment, and takes a bar chart as an example for explanation. Figure 2 As shown, the data source of the data dashboard is Table 1, which serves as the first table. Figure 3 is a schematic diagram of a first table according to an exemplary embodiment, wherein a record is a row of the table, and a field is a column of the table, such as Figure 3 As shown, the first table has 6 records and 5 fields, and the 5 fields are sales manager, sales date, province, sales amount, and profit.

[0043] like Figure 2 As shown, when the user clicks the button to set data processing conditions, a condition setting page will pop up. For example, a filtering condition of sales > 3 can be set. The horizontal axis information, grouping information, and vertical axis information are all fields in the first table. For example, the horizontal axis information is the sales date, and the vertical axis information is the profit. The grouping information is used to further group the horizontal axis. For example, the grouping information is the province, which is used to separately reflect the profits of different provinces in each sales date. Taking the above configuration information as an example, the profit field, sales date field, sales field, and province field in the first table are all used as the first field.

[0044] In step 13, a first query condition corresponding to the first field is determined.

[0045] The first query condition is used to indicate that data query is performed based on all or part of the field content in the first field. Taking the profit field as an example, if the user does not have the permission to read the field content of the 3rd, 4th, and 6th rows in the profit field, then the first query condition corresponding to the profit field can be used to indicate that data query is performed based on the field content of the 1st, 2nd, and 5th rows in the profit field. Taking the sales field as an example, if the user does not have the permission to read the field content of the 6th row in the sales field, then the first query condition corresponding to the sales field can be used to indicate that data query is performed based on the field content of the first 5 rows in the sales field.

[0046] In this way, even if the user cannot read all rows / columns in the first table, by determining the corresponding first query condition from the perspective of the field, that is, the column in the first table, all or part of the field content that the user can read in the first field can be located, thereby enabling statistical calculations of the dashboard data based on all or part of the field content in the first field.

[0047] In step 14, according to the first query condition corresponding to the first field, data query is performed in the first table to obtain the dashboard data information of the data dashboard.

[0048] For example, the first query condition corresponding to the first field can be converted into a query statement, and data query can be performed in the first table through the query statement. If there are multiple first fields, the first query conditions corresponding to each first field can be spliced ​​through a first preset rule, and the spliced ​​overall query condition can be converted into a query statement. Then, data query can be performed in the first table through the query statement, wherein the first preset rule can be an AND rule, which represents a logical AND operation.

[0049] After obtaining the dashboard data information, the server may send the dashboard data information to the client, and the client may render a data dashboard according to the dashboard data information.

[0050] Through the above technical solution, the first field includes a field in the first table used to generate a data dashboard, the first query condition corresponding to the first field is determined, and data query is performed in the first table according to the first query condition to obtain the dashboard data information of the data dashboard. In this way, from the perspective of the field, that is, the perspective of the column in the first table, the corresponding first query condition is determined, and the first query condition can be used to indicate that data query is performed based on all or part of the field content in the first field, so that all or part of the field content involved in the data query in the first field can be located, and the dashboard data information of the data dashboard can be statistically calculated based on the all or part of the field content, avoiding the situation where the dashboard data cannot be obtained, and ensuring the validity of the dashboard data information.

[0051] The table data processing method provided by the present disclosure may also include: Determine reading permission information; Determining the first query condition corresponding to the first field may include: A first query condition corresponding to the first field is determined according to the reading authority information.

[0052] Among them, the reading permission information includes first reading permission information and second reading permission information, the first reading permission information is used to indicate whether the user who initiates the access request has reading permission for each field in the first table, and the second reading permission information is used to indicate whether the user has reading permission for each record in the first table.

[0053] For example, the server can determine the reading permission information corresponding to the user based on the user's identification information such as the user ID. The reading permission information of the user can be preset by the administrator, and the server can store the reading permission information of the user. The first query condition corresponding to the first field is determined based on the reading permission information, and data can be queried based on the content of the field in the first field that the user has the permission to read, thereby avoiding the leakage of data that the user does not have the permission to read, thereby ensuring data security.

[0054] In one implementation, the permission information of different roles can be set, and the roles to which the user belongs can be set. Accordingly, the reading permission information includes the reading permission information corresponding to the multiple roles to which the user belongs. Figure 4 is a schematic diagram showing user authority information according to an exemplary embodiment. Figure 4 As shown, for example, the user belongs to two roles, namely, the Northwest Region Manager role and the Sales role.

[0055] Figure 4 (a) is the permission information of the Northwest Region Manager role. According to the second reading permission information of the role, the Northwest Region Manager role has the permission to read the specified records in the first table, that is, the records whose provinces are Shaanxi, Gansu and Ningxia. Other records are prohibited from viewing, that is, they do not have the permission to read. According to the first reading permission information of the role, if it is checked, it means that the role has the corresponding permission for the field. The Northwest Region Manager role has the permission to read all the fields in the first table. Therefore, the Northwest Region Manager role has the permission to read the entire contents of the 1st, 2nd and 5th records (that is, the 1st, 2nd and 5th rows) in the first table.

[0056] Figure 4 (b) is the permission information of the sales role. According to the second reading permission information of the role, the sales role has the reading permission for all records in the first table. According to the first reading permission information of the role, the sales role does not have the reading permission for the profit field. Therefore, with the leftmost sales manager field as the first field, the sales role has the reading permission for all the contents of the first four fields (i.e., the first four columns) in the first table.

[0057] Figure 5 A schematic diagram showing the user-readable area in the first table is shown. Figure 5As shown, the user does not have the permission to read the field contents of the 3rd, 4th and 6th rows in the profit field. In this way, when users belong to different roles, it may happen that the user has the permission to read a certain field, but does not have the permission to read certain field contents (i.e., cells) in the field, and at the same time, the user has the permission to read the rows to which these field contents belong, that is, the area that the user can read as a whole does not constitute a complete rectangle. In the related art, the method of performing statistical calculations by superimposing the overall permission conditions only supports the situation where the user can read a certain row / column in the table. In the present disclosure, the first query condition corresponding to the first field is determined, and all or part of the field contents that the user can read in the first field can be located. Even if the user does not read a certain row / column in the first table, the statistical calculation of the dashboard data can be performed based on the all or part of the field contents in the first field. The statistical calculation of the data dashboard under the situation where the permission information of each role is different can be compatible, and the situation where the dashboard data cannot be obtained can be avoided.

[0058] In the present disclosure, the second field is the field in the first field that is to be displayed on the data dashboard, and the third field is the field in the first field that is set with data processing conditions and is not displayed on the data dashboard. Figure 2 For example, if the horizontal axis information, vertical axis information, and grouping information are to be displayed on the data dashboard, the sales date field, profit field, and province field are all used as the second field. For example, if the data processing condition Sales Manager = AA is set, the Sales Manager field does not need to be displayed in the data dashboard, and the Sales Manager field is the third field.

[0059] There is no restriction on the setting method of data processing conditions. In the first table, a filter button and a sort button can be set, and data processing conditions can be set in the first table, such as Figure 2 In the configuration page of the data dashboard shown, data processing conditions can also be set to limit the data range. In addition, data processing conditions can also be set in the dashboard where the data dashboard is located. Data processing conditions can be set by the administrator or by the user within the scope of their authority.

[0060] In the present disclosure, determining the first query condition corresponding to the first field according to the reading permission information may include: If it is determined, based on the first reading permission information, that the user has the reading permission for the second field, a first query condition corresponding to the first field is determined based on the reading permission information.

[0061] Among them, the second field is the field to be displayed on the data dashboard. If the user does not have the permission to read the second field, the data dashboard cannot be displayed, because if it is displayed, it will lead to the leakage of data that the user does not have the permission to read. As an example, the user does not have the permission to read the profit field. If the vertical axis of the bar chart type data dashboard is set to profit, the data dashboard cannot be displayed. In this case, the server can return a prompt message to the client to prompt the user that he does not have the permission to access the data dashboard. If there are multiple second fields, when it is determined that the user has the permission to read each second field, the first query condition corresponding to the first field is determined according to the reading permission information.

[0062] Through the above technical solution, for the second field to be displayed on the data dashboard, it is first determined whether the user has the reading permission for the second field. If the user has the reading permission for the second field, the dashboard data information is then counted, which can avoid the leakage of data that the user does not have the reading permission to ensure data security.

[0063] In the present disclosure, determining the first query condition corresponding to the first field according to the reading permission information may include: In the case where no data processing condition is set for the second field, determining a first query condition corresponding to the second field according to the second field and the reading authority information; In the case where the second field is set with a data processing condition, the first query condition corresponding to the second field is determined according to the second field, the reading authority information and the data processing condition set for the second field.

[0064] If the second field is not set with a data processing condition, there is no need to filter or sort the content in the second field, and the first query condition can be determined based on the second field and the reading permission information, wherein the field content in the second field that the user has the permission to read can be determined based on the reading permission information, that is, which cells in the column of the second field are visible to the user, so that the first query condition can be used to indicate data query based on the field content in the second field that the user has the permission to read. If the second field is set with a data processing condition, the first query condition can be determined based on the second field, the reading permission information, and the data processing condition set for the second field, so that the first query condition can be used to indicate data query based on the field content in the second field that the user has the permission to read and that meets the data processing condition.

[0065] Figure 6 is a flowchart showing a method for determining a first query condition corresponding to a second field according to a second field and reading authority information according to an exemplary embodiment. Figure 6 As shown, steps 61 to 63 may be included.

[0066] In step 61, the first role is determined according to the second field and the first reading authority information corresponding to each role.

[0067] Among them, the first role is a role that has read permission for the second field among multiple roles. For example, taking the profit field as the second field, the Northwest Region Manager role has read permission for the profit field, and the Sales role does not have read permission for the profit field, so the Northwest Region Manager role is the first role. For example, taking the sales field as the second field, the Northwest Region Manager role and the Sales role both have read permission for the sales field, so the Northwest Region Manager role and the Sales role are both the first role.

[0068] In step 62, a first sub-query condition corresponding to the second field is generated according to the second field and the second reading permission information of the first role.

[0069] For example, taking the profit field as the second field, for the role of the Northwest District Manager, the second reading permission information of the role of the Northwest District Manager indicates that the records for which the role has reading permissions are row 1, row 2, and row 5. The first sub-query condition corresponding to the profit field is used to indicate data query based on the field contents of row 1, row 2, and row 5 in the profit field. Since there is only one first role in this example, the first sub-query condition can be directly used as the first query condition corresponding to the profit field.

[0070] For example, taking the sales field as the second field, for the Northwest Region Manager role, the first subquery condition corresponding to the sales field is used to indicate data query based on the field contents of the 1st, 2nd, and 5th rows in the sales field. For the sales role, the second reading permission information of the sales role indicates that the role has read permission for all records. For the sales role, the first subquery condition corresponding to the sales field is used to indicate data query based on the contents of all fields in the sales field.

[0071] In step 63, when there are multiple first roles, the first sub-query conditions corresponding to each first role are concatenated according to the second preset rule to obtain the first query condition corresponding to the second field.

[0072] The second preset rule can be an OR rule, which represents a logical OR operation. Using the above-mentioned sales field as the second field embodiment, the first sub-query condition corresponding to the Northwest District Manager role and the first sub-query condition corresponding to the sales role can be spliced ​​through the OR rule as the first query condition corresponding to the sales field. After splicing through the OR rule, the first query condition is used to indicate data query based on all field contents in the sales field.

[0073] Through the above technical scheme, when a user belongs to multiple roles and the permission information of each role is different, the first query condition corresponding to the second field can be determined according to the reading permission information corresponding to the multiple roles, and the field content in the second field that the user has the reading permission can be located, so that data query can be performed based on the content of these fields in the second field, and the statistical calculation of the data dashboard can be compatible with the situation where the permission information of each role is different.

[0074] In the present disclosure, determining the first query condition corresponding to the second field according to the second field, the reading authority information, and the data processing condition set for the second field may include: Determine a second query condition according to the second field and the reading permission information; Generate a third query condition according to the data processing condition set for the second field; The second query condition and the third query condition are concatenated using the first preset rule to obtain the first query condition corresponding to the second field.

[0075] The implementation method for determining the second query condition according to the second field and the reading permission information can refer to Figure 6 Take the profit field as the second field as an example. For example, if the profit field is set with a data processing condition profit>2, a third query condition can be generated according to the data processing condition. The third query condition is used to indicate that data query is performed from the field content of profit>2, such as Figure 5 As shown, the second row of records satisfies profit>2. The first preset rule may be an AND rule, which indicates a logical AND operation. The second query condition and the third query condition corresponding to the profit field are concatenated through the AND rule to obtain the first query condition corresponding to the profit field, which is used to indicate data query based on the field content of the second row in the profit field.

[0076] Through the above technical solution, the field content in the second field that the user has the reading permission and meets the data processing conditions can be located, and the first query condition corresponding to the second field can be accurately determined.

[0077] In the present disclosure, determining the first query condition corresponding to the first field according to the reading permission information may include: Determining whether the user has read permission for the third field according to the first reading permission information; In the case where the user has read permission for the third field, determining a first query condition corresponding to the third field according to the third field, the read permission information, and the data processing condition set for the third field; In the case that the user does not have the permission to read the third field, a first query condition corresponding to the third field is generated according to the data processing condition set for the third field.

[0078] Among them, the third field has been explained above. The third field is a field in the first field that is set with a data processing condition and is not displayed on the data dashboard. For example, the data processing condition Sales Manager = AA is set, and the content in the Sales Manager field is not displayed on the data dashboard. The Sales Manager field is used as the third field. If the user does not have the read permission for the Sales Manager field, the first query condition corresponding to the Sales Manager field can be generated according to the data processing condition. The first query condition is used to indicate that data query is performed from the content of the field where the Sales Manager is AA.

[0079] It should be noted that the configuration information of the data dashboard can be set by the administrator. The administrator has the highest authority over the first table, and the administrator can read all the contents in the first table. Although the user does not have the permission to read the third field, the third field is set with data processing conditions. Therefore, the content of the third field is required when counting the dashboard data. Therefore, the first query condition corresponding to the third field can be generated to participate in data query and statistics. In addition, the server stores all the data in the first table and can use this part of the data that the user does not have the permission to read for statistical calculations. Moreover, the third field is a field that is not displayed on the data dashboard. Even if the user does not have the permission to read the third field, since the content in the third field is only involved in data statistical calculations and is not displayed on the data dashboard, there is no risk of data leakage.

[0080] In the present disclosure, when the user has the permission to read the third field, determining the first query condition corresponding to the third field according to the third field, the reading permission information and the data processing condition set for the third field may include: Determine a fourth query condition according to the third field and the reading permission information; Generate a fifth query condition according to the data processing condition set in the third field; The fourth query condition and the fifth query condition are concatenated according to the first preset rule to obtain a first query condition corresponding to the third field.

[0081] Among them, the fourth query condition is used to indicate that data query is performed based on the field content in the third field that the user has the permission to read, and the fifth query condition is used to indicate that data query is performed based on the field content in the third field that meets the data processing condition. The fourth query condition and the fifth query condition are spliced ​​through the first preset rule (such as AND) rule to obtain the first query condition. In this way, the first query condition can be used to indicate that data query is performed based on the field content in the third field that the user has the permission to read and meets the data processing condition, and the first query condition corresponding to the third field can be accurately determined.

[0082] Figure 7is a flow chart showing a method for determining a fourth query condition according to a third field and reading authority information according to an exemplary embodiment. Figure 7 As shown, it includes steps 71 to 73.

[0083] In step 71, the second role is determined according to the third field and the first reading authority information corresponding to each role.

[0084] The second role includes a role that has read permission on the third field among multiple roles. For example, if the third field is the sales manager field, the Northwest Region Manager role and the Sales role both have read permission on the sales manager field, then both the Northwest Region Manager role and the Sales role are considered as the second role.

[0085] In step 72, a second sub-query condition corresponding to the third field is generated according to the third field and the second reading permission information of the second role.

[0086] In step 73, when there are multiple second roles, the second sub-query conditions corresponding to each second role are spliced ​​according to the second preset rule to obtain the fourth query condition.

[0087] For the Northwest Region Manager role, the first sub-query condition corresponding to the Sales Manager field is used to indicate that data is queried based on rows 1, 2, and 5 in the Sales Manager field. For the sales role, the second reading permission information of the sales role indicates that the role has read permission for all records. For the sales role, the first sub-query condition corresponding to the Sales Manager field is used to indicate that data is queried based on the contents of all fields in the Sales Manager field. The second preset rule can be an OR rule, and the fourth query condition after splicing is used to indicate that data is queried based on the contents of all fields in the Sales Manager field.

[0088] Through the above technical solution, when a user belongs to multiple roles, the fourth query condition can be determined according to the reading permission information corresponding to the multiple roles, thereby being compatible with the statistical calculation of the data dashboard when the permission information of each role is different.

[0089] The following is an introduction to the table data processing method disclosed in the present invention with a complete embodiment. Figure 2 Taking the configuration information shown as an example, the sales date field, province field, and profit field are used as the second field. For example, the sales field is set with the data processing condition sales>2, and the sales field is used as the third field.

[0090] For the sales date field, the Northwest region manager role and sales role to which the user belongs both have read permission for the sales date field. For the Northwest region manager role, the first subquery condition corresponding to the sales date field is used to indicate data query based on the field contents of the 1st, 2nd and 5th rows in the sales date field. For the sales role, the first subquery condition corresponding to the sales date field is used to indicate data query based on the contents of all fields in the sales date field. After the first subquery condition is spliced ​​through the OR rule, the first query condition corresponding to the sales date field is used to indicate data query based on the contents of all fields in the sales date field.

[0091] For the province field, the Northwest Region Manager role and the sales role to which the user belongs both have read permission for the province field. After the first subquery condition corresponding to the Northwest Region Manager role and the first subquery condition corresponding to the sales role are concatenated through the OR rule, the first query condition corresponding to the province field is used to indicate data query based on all field contents in the province field.

[0092] For the profit field, the Northwest Region Manager role has read permission for the profit field. The first query condition corresponding to the profit field is used to indicate data query based on the field contents of the 1st, 2nd, and 5th rows in the profit field.

[0093] For the sales volume field, the Northwest Region Manager role and the sales role to which the user belongs both have read permissions for the sales volume field. The first sub-query condition corresponding to the Northwest Region Manager role and the first sub-query condition corresponding to the sales role are spliced ​​through the OR rule to obtain the fourth query condition used to indicate data query based on all field contents in the sales volume field. Then, based on the data processing condition of sales volume>2, the fifth query condition is generated to indicate data query based on field contents of sales volume>2 in the sales volume field. The fourth query condition and the fifth query condition are spliced ​​through the AND rule to obtain the first query condition corresponding to the sales volume field.

[0094] Afterwards, the first query conditions corresponding to the sales date field, the province field, the profit field, and the sales field are concatenated by the AND rule to obtain the target query condition, and the target query condition is converted into a database query statement. According to the database query statement, data is queried in the first table to obtain the dashboard data information of the data dashboard. The method of converting the target query condition into a database query statement can refer to the relevant technology, such as converting it into a database query statement superimposed by a select statement, a case statement, and a when statement.

[0095] Through the above technical solution, users may belong to different roles, and different roles have different permission information for the table. In the present disclosure, for each first field used to generate the data dashboard, the first query condition corresponding to the first field is determined, and the statistical calculation of the dashboard data is performed according to the first query condition corresponding to each first field. Even if the user is not able to read a certain row / column in the first table, since the corresponding first query condition is determined from the perspective of each first field, the field content in the first field that is readable by the user and meets the data processing conditions can be located, so that the statistical calculation of the dashboard data can be performed based on all or part of the field content in the first field. Therefore, it is compatible with the statistical calculation of the data dashboard when the permission information of each role is different, avoiding the situation where the dashboard data cannot be obtained.

[0096] Based on the same inventive concept, the present disclosure also provides a table data processing device, Figure 8 is a block diagram of a table data processing device according to an exemplary embodiment. Figure 8 As shown, the device 80 may include: A first acquisition module 81, configured to acquire configuration information of the data dashboard in response to receiving an access request for the data dashboard; A first determination module 82, configured to determine a first table and a first field according to the configuration information, wherein the first table is used as a data source of the data dashboard, and the first field includes a field in the first table used to generate the data dashboard; A second determination module 83, configured to determine a first query condition corresponding to the first field, wherein the first query condition is used to indicate that data query is performed based on all or part of the field content in the first field; The query module 84 is used to perform data query in the first table according to the first query condition corresponding to the first field, and obtain the dashboard data information of the data dashboard.

[0097] Optionally, the device 80 further includes: a fourth determination module, configured to determine reading permission information, wherein the reading permission information includes first reading permission information and second reading permission information, wherein the first reading permission information is used to indicate whether the user initiating the access request has reading permission for each field in the first table, and the second reading permission information is used to indicate whether the user has reading permission for each record in the first table; The second determining module 83 includes: The first determining submodule is configured to determine the first query condition corresponding to the first field according to the reading permission information.

[0098] Optionally, the first determining submodule is used to: If it is determined according to the first reading permission information that the user has reading permission for the second field, the first query condition corresponding to the first field is determined according to the reading permission information, wherein the second field is the field in the first field to be displayed on the data dashboard.

[0099] Optionally, the first determining submodule includes: A second determination submodule is used to determine the first query condition corresponding to the second field according to the second field and the reading permission information when no data processing condition is set for the second field, wherein the second field is a field in the first field to be displayed by the data dashboard, and the data processing condition includes a screening condition and / or a sorting condition; The third determination submodule is used to determine the first query condition corresponding to the second field according to the second field, the reading permission information and the data processing condition set for the second field when the second field is set with the data processing condition.

[0100] Optionally, the third determining submodule is used to: Determining a second query condition according to the second field and the reading permission information; generating a third query condition according to the data processing condition set for the second field; The second query condition and the third query condition are concatenated using a first preset rule to obtain the first query condition corresponding to the second field, where the first preset rule represents a logical AND operation.

[0101] Optionally, the second determining submodule is used to: Determine a first role according to the second field and the first reading permission information respectively corresponding to each role, where the first role is a role having reading permission for the second field among the multiple roles; Generate a first sub-query condition corresponding to the second field according to the second field and the second reading permission information of the first role; In the case where there are multiple first roles, the first sub-query conditions corresponding to each of the first roles are concatenated through a second preset rule to obtain the first query condition corresponding to the second field, and the second preset rule represents a logical OR operation.

[0102] Optionally, the first determining submodule includes: a fourth determination submodule, configured to determine whether the user has read permission for a third field according to the first reading permission information, wherein the third field is a field in the first field that is set with a data processing condition and is not displayed by the data dashboard, wherein the data processing condition includes a screening condition and / or a sorting condition; a fifth determination submodule, configured to determine, if the user has read permission for the third field, the first query condition corresponding to the third field according to the third field, the read permission information and the data processing condition set for the third field; The first generating submodule is used to generate the first query condition corresponding to the third field according to the data processing condition set for the third field when the user does not have the permission to read the third field.

[0103] Optionally, the fifth determining submodule includes: a sixth determination submodule, configured to determine a fourth query condition according to the third field and the reading authority information; A second generating submodule, used for generating a fifth query condition according to the data processing condition set for the third field; The seventh determination submodule is used to splice the fourth query condition and the fifth query condition through a first preset rule to obtain the first query condition corresponding to the third field, and the first preset rule represents a logical AND operation.

[0104] Optionally, the reading permission information includes reading permission information corresponding to multiple roles to which the user belongs; The sixth determining submodule is used to: Determine a second role according to the third field and the first reading permission information respectively corresponding to each role, where the second role includes a role having reading permission for the third field among the multiple roles; Generate a second sub-query condition corresponding to the third field according to the third field and the second reading permission information of the second role; In the case where there are multiple second roles, the second sub-query conditions corresponding to each of the second roles are concatenated through a second preset rule to obtain the fourth query condition, and the second preset rule represents a logical OR operation.

[0105] Reference below Fig. 9 , which shows a structural schematic diagram of an electronic device 600 suitable for implementing an embodiment of the present disclosure. Fig. 9 The electronic device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present disclosure.

[0106] like Fig. 9 As shown, the electronic device 600 may include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 601, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 602 or a program loaded from a storage device 608 into a random access memory (RAM) 603. In the RAM 603, various programs and data required for the operation of the electronic device 600 are also stored. The processing device 601, the ROM 602, and the RAM 603 are connected to each other via a bus 604. An input / output (I / O) interface 605 is also connected to the bus 604.

[0107] Typically, the following devices may be connected to the I / O interface 605: an input device 606 including, for example, a touch screen, a touch pad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc.; an output device 607 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; a storage device 608 including, for example, a magnetic tape, a hard disk, etc.; and a communication device 609. The communication device 609 may allow the electronic device 600 to communicate with other devices wirelessly or by wire to exchange data. Although Fig. 9 The electronic device 600 is shown with various devices, but it should be understood that it is not required to implement or possess all the devices shown. More or fewer devices may be implemented or possessed instead.

[0108] In particular, according to an embodiment of the present disclosure, the process described above with reference to the flowchart can be implemented as a computer software program. For example, an embodiment of the present disclosure includes a computer program product, which includes a computer program carried on a non-transitory computer-readable medium, and the computer program contains program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network through a communication device 609, or installed from a storage device 608, or installed from a ROM 602. When the computer program is executed by the processing device 601, the above-mentioned functions defined in the method of the embodiment of the present disclosure are executed.

[0109] It should be noted that the computer-readable medium mentioned above in the present disclosure may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present disclosure, a computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, device or device. In the present disclosure, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, which carries a computer-readable program code. This propagated data signal may take a variety of forms, including but not limited to an electromagnetic signal, an optical signal, or any suitable combination of the above. Computer readable signal media may also be any computer readable medium other than computer readable storage media, which may send, propagate or transmit a program for use by or in conjunction with an instruction execution system, apparatus or device. The program code contained on the computer readable medium may be transmitted using any appropriate medium, including but not limited to: wires, optical cables, RF (radio frequency), etc., or any suitable combination of the above.

[0110] In some embodiments, the servers may communicate using any currently known or future developed network protocol, such as HTTP (HyperText Transfer Protocol), and may be interconnected with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), an internet (e.g., the Internet), and a peer-to-peer network (e.g., an ad hoc peer-to-peer network), as well as any currently known or future developed network.

[0111] The computer-readable medium may be included in the electronic device, or may exist independently without being incorporated into the electronic device.

[0112] The above-mentioned computer-readable medium carries one or more programs. When the above-mentioned one or more programs are executed by the electronic device, the electronic device: in response to receiving an access request for a data dashboard, obtains the configuration information of the data dashboard; determines a first table and a first field according to the configuration information, wherein the first table serves as the data source of the data dashboard, and the first field includes the field in the first table used to generate the data dashboard; determines a first query condition corresponding to the first field, and the first query condition is used to indicate a data query based on all or part of the field content in the first field; and performs a data query in the first table according to the first query condition corresponding to the first field to obtain the dashboard data information of the data dashboard.

[0113] Computer program code for performing the operations of the present disclosure may be written in one or more programming languages ​​or a combination thereof, including, but not limited to, object-oriented programming languages, such as Java, Smalltalk, C++, and conventional procedural programming languages, such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., through the Internet using an Internet service provider).

[0114] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present disclosure. In this regard, each square box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some implementations as replacements, the functions marked in the square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two square boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0115] The modules involved in the embodiments described in the present disclosure may be implemented by software or hardware. The name of a module does not limit the module itself in some cases. For example, the first acquisition module may also be described as a "module for acquiring configuration information".

[0116] The functions described above herein may be performed at least in part by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), complex programmable logic devices (CPLDs), and the like.

[0117] In the context of the present disclosure, a machine-readable medium may be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, device, or equipment. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or device, or any suitable combination of the foregoing. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0118] According to one or more embodiments of the present disclosure, Example 1 provides a table data processing method, the method comprising: In response to receiving an access request for a data dashboard, obtaining configuration information of the data dashboard; Determine a first table and a first field according to the configuration information, wherein the first table serves as a data source of the data dashboard, and the first field includes a field in the first table used to generate the data dashboard; Determine a first query condition corresponding to the first field, where the first query condition is used to indicate that data query is performed based on all or part of the field content in the first field; According to the first query condition corresponding to the first field, data query is performed in the first table to obtain the dashboard data information of the data dashboard.

[0119] According to one or more embodiments of the present disclosure, Example 2 provides the method of Example 1, wherein the method further includes: Determine reading permission information, the reading permission information including first reading permission information and second reading permission information, the first reading permission information is used to indicate whether the user who initiates the access request has reading permission for each field in the first table, and the second reading permission information is used to indicate whether the user has reading permission for each record in the first table; The determining the first query condition corresponding to the first field includes: The first query condition corresponding to the first field is determined according to the reading permission information.

[0120] According to one or more embodiments of the present disclosure, Example 3 provides the method of Example 2, wherein determining the first query condition corresponding to the first field according to the reading permission information includes: If it is determined according to the first reading permission information that the user has reading permission for the second field, the first query condition corresponding to the first field is determined according to the reading permission information, wherein the second field is the field in the first field to be displayed on the data dashboard.

[0121] According to one or more embodiments of the present disclosure, Example 4 provides the method of Example 2, wherein determining the first query condition corresponding to the first field according to the reading permission information includes: In the case where no data processing condition is set for the second field, determining the first query condition corresponding to the second field according to the second field and the reading permission information, wherein the second field is a field in the first field to be displayed by the data dashboard, and the data processing condition includes a screening condition and / or a sorting condition; In the case where the second field is set with the data processing condition, the first query condition corresponding to the second field is determined according to the second field, the reading authority information and the data processing condition set for the second field.

[0122] According to one or more embodiments of the present disclosure, Example 5 provides the method of Example 4, wherein determining the first query condition corresponding to the second field according to the second field, the reading permission information, and the data processing condition set for the second field includes: Determining a second query condition according to the second field and the reading permission information; generating a third query condition according to the data processing condition set for the second field; The second query condition and the third query condition are concatenated using a first preset rule to obtain the first query condition corresponding to the second field, where the first preset rule represents a logical AND operation.

[0123] According to one or more embodiments of the present disclosure, Example 6 provides the method of Example 4, wherein the reading permission information includes reading permission information corresponding to the multiple roles to which the user belongs; The determining, according to the second field and the reading permission information, the first query condition corresponding to the second field includes: Determine a first role according to the second field and the first reading permission information respectively corresponding to each role, where the first role is a role having reading permission for the second field among the multiple roles; Generate a first sub-query condition corresponding to the second field according to the second field and the second reading permission information of the first role; In the case where there are multiple first roles, the first sub-query conditions corresponding to each of the first roles are concatenated through a second preset rule to obtain the first query condition corresponding to the second field, and the second preset rule represents a logical OR operation.

[0124] According to one or more embodiments of the present disclosure, Example 7 provides the method of Example 2, wherein determining the first query condition corresponding to the first field according to the reading permission information includes: Determining whether the user has read permission for a third field according to the first reading permission information, wherein the third field is a field in the first field that is set with a data processing condition and is not displayed by the data dashboard, wherein the data processing condition includes a screening condition and / or a sorting condition; In the case where the user has read permission for the third field, determining the first query condition corresponding to the third field according to the third field, the read permission information and the data processing condition set for the third field; In a case where the user does not have the permission to read the third field, the first query condition corresponding to the third field is generated according to the data processing condition set for the third field.

[0125] According to one or more embodiments of the present disclosure, Example 8 provides the method of Example 7, wherein determining the first query condition corresponding to the third field according to the third field, the reading permission information, and the data processing condition set for the third field includes: Determining a fourth query condition according to the third field and the reading permission information; generating a fifth query condition according to the data processing condition set in the third field; The fourth query condition and the fifth query condition are concatenated through a first preset rule to obtain the first query condition corresponding to the third field, where the first preset rule represents a logical AND operation.

[0126] According to one or more embodiments of the present disclosure, Example 9 provides the method of Example 8, wherein the reading permission information includes reading permission information corresponding to the multiple roles to which the user belongs; The determining of the fourth query condition according to the third field and the reading authority information includes: Determine a second role according to the third field and the first reading permission information respectively corresponding to each role, where the second role includes a role having reading permission for the third field among the multiple roles; Generate a second sub-query condition corresponding to the third field according to the third field and the second reading permission information of the second role; In the case where there are multiple second roles, the second sub-query conditions corresponding to each of the second roles are concatenated through a second preset rule to obtain the fourth query condition, and the second preset rule represents a logical OR operation.

[0127] According to one or more embodiments of the present disclosure, Example 10 provides a table data processing device, the device comprising: A first acquisition module, configured to acquire configuration information of the data dashboard in response to receiving an access request for the data dashboard; A first determination module, configured to determine a first table and a first field according to the configuration information, wherein the first table is used as a data source of the data dashboard, and the first field includes a field in the first table used to generate the data dashboard; A second determination module, used to determine a first query condition corresponding to the first field, where the first query condition is used to indicate to perform a data query based on all or part of the field content in the first field; A query module is used to perform data query in the first table according to the first query condition corresponding to the first field, so as to obtain the dashboard data information of the data dashboard.

[0128] According to one or more embodiments of the present disclosure, Example 11 provides a computer-readable medium having a computer program stored thereon, which implements the steps of any of the methods described in Examples 1-9 when executed by a processing device.

[0129] According to one or more embodiments of the present disclosure, Example 12 provides an electronic device, including: a storage device having a computer program stored thereon; A processing device is used to execute the computer program in the storage device to implement the steps of any one of the methods described in Examples 1-9.

[0130] According to one or more embodiments of the present disclosure, Example 13 provides a computer program product, including a computer program, which implements the steps of any one of the methods described in Examples 1 to 9 when executed by a processor.

[0131] The above description is only a preferred embodiment of the present disclosure and an explanation of the technical principles used. Those skilled in the art should understand that the scope of disclosure involved in the present disclosure is not limited to the technical solutions formed by a specific combination of the above technical features, but should also cover other technical solutions formed by any combination of the above technical features or their equivalent features without departing from the above disclosed concept. For example, the above features are replaced with the technical features with similar functions disclosed in the present disclosure (but not limited to) by each other to form a technical solution.

[0132] In addition, although each operation is described in a specific order, this should not be understood as requiring these operations to be performed in the specific order shown or in a sequential order. Under certain circumstances, multitasking and parallel processing may be advantageous. Similarly, although some specific implementation details are included in the above discussion, these should not be interpreted as limiting the scope of the present disclosure. Some features described in the context of a separate embodiment can also be implemented in a single embodiment in combination. On the contrary, the various features described in the context of a single embodiment can also be implemented in multiple embodiments individually or in any suitable sub-combination mode.

[0133] Although the subject matter has been described in language specific to structural features and / or method logic actions, it should be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or actions described above. On the contrary, the specific features and actions described above are merely example forms of implementing the claims. Regarding the device in the above embodiment, the specific manner in which each module performs the operation has been described in detail in the embodiment related to the method, and will not be elaborated here.

Claims

1. A table data processing method, characterized in that: The method comprises: In response to receiving an access request for a data dashboard, obtaining configuration information of the data dashboard; Determine a first table and a first field according to the configuration information, wherein the first table serves as a data source of the data dashboard, and the first field includes a field in the first table used to generate the data dashboard; Determine a first query condition corresponding to the first field, where the first query condition is used to indicate that data query is performed based on all or part of the field content in the first field; According to the first query condition corresponding to the first field, data query is performed in the first table to obtain the dashboard data information of the data dashboard.

2. The method according to claim 1, characterized in that The method further comprises: Determine reading permission information, the reading permission information including first reading permission information and second reading permission information, the first reading permission information is used to indicate whether the user who initiates the access request has reading permission for each field in the first table, and the second reading permission information is used to indicate whether the user has reading permission for each record in the first table; The determining the first query condition corresponding to the first field includes: The first query condition corresponding to the first field is determined according to the reading permission information.

3. The method according to claim 2, characterized in that The determining the first query condition corresponding to the first field according to the reading permission information includes: If it is determined according to the first reading permission information that the user has reading permission for the second field, the first query condition corresponding to the first field is determined according to the reading permission information, wherein the second field is the field in the first field to be displayed on the data dashboard.

4. The method according to claim 2, characterized in that: The determining the first query condition corresponding to the first field according to the reading permission information includes: In the case where no data processing condition is set for the second field, determining the first query condition corresponding to the second field according to the second field and the reading permission information, wherein the second field is a field in the first field to be displayed by the data dashboard, and the data processing condition includes a screening condition and / or a sorting condition; In the case where the second field is set with the data processing condition, the first query condition corresponding to the second field is determined according to the second field, the reading authority information and the data processing condition set for the second field.

5. The method according to claim 4, characterized in that The determining the first query condition corresponding to the second field according to the second field, the reading authority information and the data processing condition set for the second field includes: Determining a second query condition according to the second field and the reading permission information; generating a third query condition according to the data processing condition set for the second field; The second query condition and the third query condition are concatenated using a first preset rule to obtain the first query condition corresponding to the second field, where the first preset rule represents a logical AND operation.

6. The method according to claim 4, characterized in that The reading permission information includes reading permission information corresponding to the multiple roles to which the user belongs; The determining, according to the second field and the reading permission information, the first query condition corresponding to the second field includes: Determine a first role according to the second field and the first reading permission information respectively corresponding to each role, where the first role is a role having reading permission for the second field among the multiple roles; Generate a first sub-query condition corresponding to the second field according to the second field and the second reading permission information of the first role; In the case where there are multiple first roles, the first sub-query conditions corresponding to each of the first roles are concatenated through a second preset rule to obtain the first query condition corresponding to the second field, and the second preset rule represents a logical OR operation.

7. The method according to claim 2, characterized in that The determining the first query condition corresponding to the first field according to the reading permission information includes: Determining whether the user has read permission for a third field according to the first reading permission information, wherein the third field is a field in the first field that is set with a data processing condition and is not displayed by the data dashboard, wherein the data processing condition includes a screening condition and / or a sorting condition; In the case where the user has read permission for the third field, determining the first query condition corresponding to the third field according to the third field, the read permission information and the data processing condition set for the third field; In a case where the user does not have the permission to read the third field, the first query condition corresponding to the third field is generated according to the data processing condition set for the third field.

8. The method according to claim 7, characterized in that The determining the first query condition corresponding to the third field according to the third field, the reading authority information and the data processing condition set for the third field includes: Determining a fourth query condition according to the third field and the reading permission information; generating a fifth query condition according to the data processing condition set in the third field; The fourth query condition and the fifth query condition are concatenated through a first preset rule to obtain the first query condition corresponding to the third field, where the first preset rule represents a logical AND operation.

9. The method according to claim 8, characterized in that The reading permission information includes reading permission information corresponding to the multiple roles to which the user belongs; The determining of the fourth query condition according to the third field and the reading authority information includes: Determine a second role according to the third field and the first reading permission information respectively corresponding to each role, where the second role is a role having reading permission for the third field among the multiple roles; Generate a second sub-query condition corresponding to the third field according to the third field and the second reading permission information of the second role; In the case where there are multiple second roles, the second sub-query conditions corresponding to each of the second roles are concatenated through a second preset rule to obtain the fourth query condition, and the second preset rule represents a logical OR operation.

10. A table data processing device, characterized in that: The device comprises: A first acquisition module, configured to acquire configuration information of the data dashboard in response to receiving an access request for the data dashboard; A first determination module, configured to determine a first table and a first field according to the configuration information, wherein the first table is used as a data source of the data dashboard, and the first field includes a field in the first table used to generate the data dashboard; A second determination module, used to determine a first query condition corresponding to the first field, where the first query condition is used to indicate to perform a data query based on all or part of the field content in the first field; A query module is used to perform data query in the first table according to the first query condition corresponding to the first field, so as to obtain the dashboard data information of the data dashboard.

11. A computer readable medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processing device, the steps of the method according to any one of claims 1 to 9 are implemented.

12. An electronic device, characterized in that: include: a storage device having a computer program stored thereon; A processing device, configured to execute the computer program in the storage device to implement the steps of the method according to any one of claims 1 to 9.

13. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 9 are implemented.

Images