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

Abstract

The invention discloses a table data processing method and device, equipment, a medium and a product, and the method comprises the steps: for a second terminal of a data table, when authority information is pre-configured for the data table and the authority information is used for indicating the access authority of each first terminal for data in the data table, the data table is sent to the second terminal; if the second terminal detects that the permission information is in an effective state, the second terminal not only displays an instrument panel for describing a data analysis result aiming at the data table, but also displays a switch assembly; therefore, a manager can flexibly configure whether to use the authority information to constrain the instrument panel displayed by each first terminal by means of the switch assembly, so that whether the data used for statistics is all the data in the data table or the data with the authority of a visitor can be flexibly configured from the dimension of the instrument panel; therefore, the content displayed by the instrument panel can be efficiently and flexibly adjusted according to the requirements of different scenes, and the user experience can be effectively improved.

Description

Technical Field

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

[0002] For some scenarios, such as data analysis result display scenarios, these scenarios have the following requirements: display the data analysis results for the data table with the help of a dashboard, so that each visitor can view the data analysis results through the dashboard. The dashboard includes multiple components, and for any component, the component is used to display the results obtained by performing a certain analysis on the data table, such as rankings, bar charts, and other results. Summary of the invention

[0003] In order to solve the above technical problems, the present application provides a method, device, equipment, medium, and product for processing table data, which is conducive to improving user experience.

[0004] In order to achieve the above objectives, the technical solutions provided by this application are as follows:

[0005] The present application provides a method for processing tabular data, the method comprising: displaying a dashboard, the dashboard being used to describe data analysis results for a data table, the data table being pre-configured with permission information, the permission information being used to indicate access rights of a first terminal to data in the data table; in response to the permission information being in an effective state, displaying a switch component, the switch component being used to use the permission information to constrain the dashboard displayed in the first terminal; in response to the switch component being in an on state, displaying first prompt information, the first prompt information being used to indicate the use of the permission information to constrain the dashboard displayed in the first terminal.

[0006] In a possible implementation manner, the method further includes: in response to the switch component being in an off state, displaying second prompt information, wherein the second prompt information is used to indicate that the authority information is not used to constrain the dashboard displayed in the first terminal.

[0007] In a possible implementation manner, the display process of the switch component includes: in response to the permission information being in an effective state, additionally displaying the switch component on the dashboard.

[0008] In one possible implementation, an entry mark of a management page is displayed on the dashboard, and the display process of the switch component includes: displaying the management page in response to a trigger operation on the entry mark, and adding the display of the switch component to the management page in response to the permission information being in effect.

[0009] In a possible implementation manner, after the switch component is added and displayed on the dashboard, the method further includes: in response to switching the permission information from a valid state to an invalid state, canceling the display of the switch component on the dashboard.

[0010] In a possible implementation manner, after adding and displaying the switch component on the management page, the method further includes: in response to switching the permission information from a valid state to an invalid state, canceling the display of the switch component on the management page.

[0011] In one possible implementation, after displaying the switch component, the method further includes: in response to switching the permission information from an effective state to an invalid state, saving the state of the switch component and canceling the display of the switch component; in response to switching the permission information from an invalid state to a effective state, displaying the switch component according to the saved state.

[0012] In one possible implementation, the method also includes: if a state switching request triggered for the switch component and a first request for requesting to switch the permission information from a valid state to an invalid state are detected at the same time, executing the first request and displaying a third prompt information, wherein the third prompt information is used to indicate that the state switching request failed to execute because the permission information is in an invalid state, and the state switching request is used to request to switch the switch component from an off state to an on state, or to switch the switch component from an on state to an off state.

[0013] In one possible implementation, the method is applied to a second terminal, and the method also includes: if a state switching request triggered for the switch component and a second request for requesting cancellation of the second terminal's management authority over the data table are detected at the same time, executing the second request and displaying a fourth prompt information, wherein the fourth prompt information is used to indicate that the state switching request failed to execute because the second terminal does not have management authority over the data table, and the state switching request is used to request to switch the switch component from an off state to an on state, or to switch the switch component from an on state to a off state.

[0014] In a possible implementation manner, different requests are triggered by different terminals, and the state switching request is triggered by the second terminal.

[0015] In one possible implementation, the data table is pre-configured with multiple first terminals; the method also includes: in response to a preview operation triggered on the dashboard, displaying a preview page, the preview page defaulting to displaying a display effect of the dashboard on a third terminal, and the multiple first terminals include the third terminal; in response to a preview object switching operation triggered on the preview page, updating the preview page, the preview object switching operation is used to indicate switching from the third terminal to a fourth terminal, the multiple first terminals include the fourth terminal, and the updated preview page is used to display the display effect of the dashboard on the fourth terminal.

[0016] The present application provides a method for processing tabular data, which is applied to a first terminal, and includes: displaying a dashboard, wherein the dashboard is determined based on the data table, the data table is pre-configured with permission information, and the permission information is used to indicate the access rights of the first terminal to the data in the data table; in response to a state switching operation triggered on a switch component on a second terminal, displaying a prompt page, wherein the prompt page is used to indicate that the data permissions of the dashboard have changed; in response to a triggering operation on an update component in the prompt page, updating the dashboard; the dashboard before the update does not use the permission information constraint, the state switching operation is used to indicate that the switch component is switched from an off state to an on state, and the dashboard after the update uses the permission information constraint, or the dashboard before the update uses the permission information constraint, the state switching operation is used to indicate that the switch component is switched from an on state to a off state, and the dashboard after the update does not use the permission information constraint.

[0017] In one possible implementation, the dashboard includes multiple components, and different components are used to display different data analysis results for the data table; when the dashboard uses the permission information constraint, if the permission information indicates that the first terminal does not have permission to access a first data set in the data table, and the first data set includes any column or any row in the data table, then for any component in the dashboard, the display process of the component includes: if the key information based on which the component is rendered includes the first data set, then the component is displayed instead of preset content, and the key information is used to form the data analysis results displayed by the component, and the preset content is used to indicate that the first terminal does not have permission to view the data analysis results displayed by the component; if the key information based on which the component is rendered does not include the first data set, then the component is rendered and displayed based on the data table.

[0018] In one possible implementation, the dashboard includes multiple components, and different components are used to display different data analysis results for the data table; when the dashboard uses the permission information constraint, if the permission information indicates that the first terminal does not have permission to access part of the data in the second data set in the data table, and the second data set includes any column or any row in the data table, then for any component in the dashboard, the display process of the component includes: if the key information based on which the component is rendered includes the second data set, then the component is rendered and displayed based on the other data in the second data set except the part of the data, and the key information is used to constitute the data analysis result displayed by the component; if the key information based on which the component is rendered does not include the second data set, but the rendering process of the component uses the second data set, then the component is rendered and displayed based on the other data in the second data set except the part of the data.

[0019] The present application provides a device for processing tabular data, including: a first display unit, used to display a dashboard, wherein the dashboard is used to describe data analysis results for a data table, the data table is pre-configured with permission information, and the permission information is used to indicate the access rights of a first terminal to the data in the data table; a second display unit, used to display a switch component in response to the permission information being in effect, wherein the switch component is used to configure whether to use the permission information to constrain the dashboard displayed by the first terminal; and a third display unit, used to display first prompt information in response to switching the switch component from an off state to an on state, wherein the first prompt information is used to indicate that the dashboard displayed by the first terminal is constrained by the permission information, or, in response to switching the switch component from an on state to a off state, display second prompt information, wherein the second prompt information is used to indicate that the dashboard displayed by the first terminal is not constrained by the permission information.

[0020] The present application provides a device for processing tabular data, including: a fourth display unit, used to display a dashboard, the dashboard is determined based on the data table, the data table is pre-configured with permission information, and the permission information is used to indicate the access rights of the first terminal to the data in the data table; a fifth display unit, used to display a prompt page in response to a state switching operation triggered on a switch component on a second terminal, the prompt page is used to indicate that the data permissions of the dashboard have changed; an update unit, used to update the dashboard in response to a triggering operation on an update component in the prompt page; the dashboard before the update does not use the permission information constraint, the state switching operation is used to indicate that the switch component is switched from an off state to an on state, and the dashboard after the update uses the permission information constraint, or the dashboard before the update uses the permission information constraint, the state switching operation is used to indicate that the switch component is switched from an on state to a off state, and the dashboard after the update does not use the permission information constraint.

[0021] The present application provides an electronic device, which includes: a processor and a memory; the memory is used to store instructions or computer programs; the processor is used to execute the instructions or computer programs in the memory, so that the electronic device executes the method for processing table data provided by the present application.

[0022] The present application provides a computer-readable medium, in which instructions or computer programs are stored. When the instructions or computer programs are executed on a device, the device executes the method for processing table data provided in the present application.

[0023] The present application provides a computer program product, which includes a computer program carried on a non-transitory computer-readable medium, and the computer program contains program codes for executing the method for processing tabular data provided by the present application.

[0024] Compared with the related art, this application has at least the following advantages:

[0025] In the technical solution provided by the present application, for the second terminal used to manage the data table, when permission information is pre-configured for the data table, and the permission information is used to indicate the access rights of each first terminal to the data in the data table, if the second terminal detects that the permission information is in effect, the second terminal not only displays a dashboard for describing the data analysis results for the data table, but also displays a switch component, so that the administrator can flexibly configure with the help of the switch component whether to use the permission information to constrain the dashboard displayed by each first terminal. In this way, it is possible to flexibly configure from the dashboard dimension whether the data used for its statistics is all the data in the data table or the data for which the visitor has permission, so that it is possible to efficiently and flexibly adjust the content displayed on the dashboard according to the needs of different scenarios (such as a general exposure scenario or a scenario considering role attributes), thereby effectively improving the user experience. BRIEF DESCRIPTION OF THE DRAWINGS

[0026] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the related technologies, the drawings required for use in the embodiments or the related technical descriptions are briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0027] Figure 1 A flowchart of a method for processing table data applied to a second terminal provided in an embodiment of the present application;

[0028] Figure 2 A schematic diagram of a display process of a switch assembly provided in an embodiment of the present application;

[0029] Figure 3 A schematic diagram of a state switching process of a switch component provided in an embodiment of the present application;

[0030] Figure 4 A schematic diagram of a preview page provided in an embodiment of the present application;

[0031] Figure 5 A flowchart of a method for processing table data applied to a first terminal provided in an embodiment of the present application;

[0032] Figure 6 A schematic diagram of the structure of a table data processing device provided in an embodiment of the present application;

[0033] Figure 7 A schematic diagram of the structure of a table data processing device provided in an embodiment of the present application;

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

[0035] Through research, it is found that in some dashboard implementation schemes, the default dashboard is only used to count the data that the visitor has permission to use, so that the scheme has at least the following defects: because the scheme only supports counting the data that the visitor has permission to use, and does not support counting all data, the scheme can only meet the needs of a single scenario (such as a scenario considering role attributes), and cannot meet the needs of other scenarios (such as a full exposure scenario), affecting the user experience.

[0036] The study also found that in order to overcome the defects shown in the previous paragraph, each component in the dashboard can be manually configured to use all data or visitor-authorized data for statistical analysis.

[0037] After research, it was found that the solution shown in the previous paragraph has the following defects: ① The configuration cost is relatively high, which affects the user experience. ② Because a dashboard as a whole corresponds to a specific scene, when the scene is switched, it is necessary to manually reconfigure all components in the dashboard for statistical analysis. The data used is all data or visitor-authorized data, which makes the scene switching cost relatively high, affecting the user experience.

[0038] Based on the above research, in order to better improve the user experience, the present application provides a method for processing tabular data, which includes: for the second terminal of the data table, when permission information is pre-configured for the data table, and the permission information is used to indicate the access rights of each first terminal to the data in the data table, if the second terminal detects that the permission information is in effect, then the second terminal not only displays a dashboard for describing the data analysis results for the data table, but also displays a switch component, so that the administrator can flexibly configure whether to use the permission information to constrain the dashboard displayed by each first terminal with the help of the switch component, so that it can be flexibly configured from the dashboard dimension whether the data used for its statistics is all the data in the data table or the data that the visitor has permission to, so that it can be realized according to the needs of different scenarios (such as a general exposure scenario or a scenario considering role attributes) to efficiently and flexibly adjust the content displayed on the dashboard, thereby effectively overcoming the defects shown in the previous paragraph, so as to effectively improve the user experience.

[0039] In addition, the present application does not limit the execution subject of the table data processing method provided in the present application. For example, the method can be applied to a terminal device. For another example, the method can also be implemented by means of a data table data processing process between a terminal device and a server. The terminal device can be a smart phone, a computer, a personal digital assistant (PDA), a tablet computer, etc. The server can be a stand-alone server, a cluster server, or a cloud server.

[0040] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings 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 in 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.

[0041] In order to better understand the technical solution provided by this application, the technical solution is described below in conjunction with some drawings. Figure 1 As shown, the embodiment of the present application provides a method for processing table data applied to a second terminal, including the following S101-S103.

[0042] S101: The second terminal displays a dashboard, where the dashboard is used to describe data analysis results for a data table. The data table is pre-configured with permission information, where the permission information is used to indicate access rights of the first terminal to the data in the data table.

[0043] The second terminal (also called the management terminal) refers to a terminal with management authority for a data table (such as the data table shown in Table 1 below), so that the administrator can use the terminal to implement some management matters for the data table. In addition, the present application does not limit the second terminal. For example, it can be implemented using a terminal used to create the data table or a terminal that is granted management authority.

[0044] Sale Date Sales Amount Salesperson area profit 2024 / 11 / 01 170 User 1 Region 1 100 2024 / 11 / 02 228 User 2 Region 1 203 2024 / 11 / 03 212 User 3 Region 1 109 2024 / 11 / 04 848 User 4 Region 1 500 2024 / 11 / 05 219 User 5 Region 1 100 2024 / 11 / 06 583 User 6 Area 2 300 2024 / 11 / 07 282 User 7 Area 2 123 2024 / 11 / 08 4954 User 8 Area 3 2555 2024 / 11 / 09 322 User 9 Area 3 299 2024 / 11 / 10 2822 User 10 Area 3 1999

[0045] Table 1 Data sheet

[0046] The dashboard is obtained by performing statistical analysis on at least one data table, so that the dashboard can represent the data analysis results for these data tables. It should be noted that for any dashboard, the dashboard can be used to describe the data analysis results for a certain data table, and can also be used to describe the data analysis results for some data tables, and this application does not make specific limitations on this.

[0047] In addition, the dashboard may include multiple components (such as Figure 2The dashboard includes text component 1, text component 2, bar chart, and ranking list as shown, and different components are used to display different data analysis results for the data table (such as sum, average, sorting results according to a certain indicator, etc.), so that the dashboard can display multiple data analysis results for the data table.

[0048] In addition, the present application does not limit the implementation methods of the components in the dashboard. For example, it can be a coordinate axis component (such as a bar chart, a line chart, a bar chart, an area chart, a scatter chart, a combination chart, a radar chart), a pie chart, a ring chart, a funnel chart, a word cloud, an indicator card, a ranking list, a Net Promoter Score (NPS) chart, a view component (such as a Gantt chart, a kanban board, a picture album, etc. for directly displaying part of the data in the data table), a text component, or a button component.

[0049] In addition, in order to improve data security, permission information can be pre-configured for the data table (for example, someone has no permission to access the "region" column in Table 1), so that the permission information can describe the access rights of each first terminal to the data in the data table, so that the data that each first terminal can view can be constrained based on the permission information. Among them, the first terminal (also called the access terminal) refers to the terminal that is granted the permission to access the data table, so that the first terminal can view the data for which it has permission from the data table and view the dashboard generated based on the data table.

[0050] It should be noted that the present application does not limit the first terminal. For example, in some scenarios, multiple first terminals can be pre-configured for the data table so that each first terminal has the authority to view the data table, so that the permission information configured for the data table is used to indicate the access rights of each first terminal to the data in the data table. In addition, the present application does not limit the implementation method of the multiple first terminals. For example, in some scenarios, the multiple first terminals can include at least one terminal that only has viewing authority for the data table (referred to as a non-second terminal, also referred to as an ordinary terminal). For example, in other scenarios, the multiple first terminals may also include at least one terminal that has management authority for the data table (referred to as a second terminal).

[0051] In addition, in order to improve flexibility, after pre-configuring the permission information for the data table, you can flexibly set whether to use the permission information to constrain the access rights of different first terminals based on some operations of the second terminal, so as to better meet the data access requirements in different scenarios. It should be noted that this application does not limit the aforementioned operations. For example, it can be used for Figure 2The open operation or close operation triggered by the advanced permission shown is implemented, so that subsequently, the permission information can be used to restrict the access rights of different first terminals by means of the open operation triggered by the advanced permission, so that the permission information is in an effective state, and the permission information can be used not to restrict the access rights of different first terminals by means of the close operation triggered by the advanced permission, so that the permission information is in an invalid state, thereby realizing flexible control over whether the permission information is effective.

[0052] S102: In response to the permission information being in effect, the second terminal displays a switch component, where the switch component is used to constrain the dashboard displayed in the first terminal using the permission information.

[0053] In the present application, for a dashboard obtained by performing statistical analysis on a data table, if it is detected that a terminal (such as a second terminal) used to display the dashboard has management authority over the data table, and it is detected that the authority information pre-configured for the data table is in effect, it can be determined that the user of the terminal may have a management requirement of "setting the dashboard to be used to count all data, or setting the dashboard to be used to count data that visitors have the authority to view". Therefore, in order to better meet this requirement, the dashboard display switch component (such as a second terminal) can be used to display the dashboard. Figure 2 The “Statistics follow advanced permissions” switch entry shown in the figure) is provided so that the user can use the switch component to flexibly choose whether the dashboard performs statistical analysis based on the permission information.

[0054] It can be seen that the display condition of the switch component is: the terminal (such as the second terminal) used to display the dashboard rendered based on the data table has the management authority of the data table, and the pre-configured permission information for the data table is in effect (such as the advanced permission is enabled for the data table). Among them, the switch component is used to configure whether to use the permission information to constrain the dashboard displayed by the first terminal; and this application does not limit the implementation method of the switch component. For example, it can adopt any component that can be flexibly switched between the on state and the off state (such as Figure 2 Statistics follow advanced permissions) as shown in the switch entry.

[0055] In addition, the present application does not limit the display method of the switch component. For example, the switch component can be directly displayed on the dashboard as an operable component, so that the user can flexibly and efficiently set the dashboard statistics method directly with the help of the switch component without leaving the dashboard. It can be seen that in a possible implementation, the above S102 can be specifically: the second terminal responds to the permission information being in an effective state, and adds a display switch component on the dashboard, which is conducive to simplifying management operations.

[0056] For example, in order to save space, the switch component can be displayed as an operable component on a secondary page of the dashboard (such as Figure 2 As can be seen, in a possible implementation, when the dashboard displays an entry mark of the management page (such as Figure 2 When the entry mark 201 is displayed, the above S102 may specifically be: the second terminal responds to the trigger operation (such as a click operation) for the entry mark and displays the management page (such as Figure 2 202 shown in FIG. 1 ), and in response to the permission information being in effect, adding a display switch component (such as Figure 2 The switch entry of "Statistics Follow Advanced Permissions" shown in the figure) can add new components without increasing the space pressure of the dashboard, which is conducive to improving the display effect of the dashboard. Among them, the entry identifier is used to uniquely identify the entry of the management page, and the management page is used to display some components that can assist in managing the dashboard, such as switch components.

[0057] In addition, the present application does not limit the default state of the switch component. For example, in some scenarios, such as scenarios that focus on data security, the switch component is in the on state by default, so that the dashboard is used to count the data that visitors have permission to view, which is conducive to better improving data security. For another example, in some scenarios, such as scenarios that focus on the user experience of existing users, the switch component is in the off state by default, so that the dashboard is used to count all data by default, so that the statistical method used by the user when using the dashboard before can be continued to avoid interference to the user.

[0058] In addition, in order to better improve the user experience, the switch component at least meets the following constraints: when the control cursor on the second terminal moves to the top of the switch component, the function introduction page of the switch component is displayed (such as Figure 2 The page 203 shown is used to enable the user to better understand the function of the switch component with the help of the page.

[0059] S103: In response to the switch component being in the on state, the second terminal displays first prompt information, where the first prompt information is used to indicate that the use permission information constrains the dashboard displayed in the first terminal.

[0060] In the present application, for the switch component displayed by the second terminal, when it is detected that the switch component is in the on state, the first prompt information (such as Figure 3 The prompt information 204 shown in the figure) can enable the first prompt information to convey to the administrator that the use permission information will be restricted in the dashboard displayed by each first terminal.

[0061] In addition, the present application does not limit the implementation method of the above S103. For example, it can be specifically: the second terminal displays a first prompt message in response to switching the switch component from an off state to an on state, so that the first prompt message is used to indicate the use of permission information to constrain the dashboard displayed in the first terminal.

[0062] It can be seen that for the switch component displayed by means of the instrument panel, if it is detected that the switch component is switched from the closed state to the open state, it can be determined that the switch component has been turned on, so the first prompt information (such as Figure 3 The prompt information 204 shown is used so that the first prompt information can convey to the administrator that the dashboard displayed by each first terminal will be restricted by the usage permission information, so that the administrator can learn from the first prompt information that the statistical data of the current dashboard has been switched from all data to data for which the visitor has permission.

[0063] Based on the relevant contents of S101 to S103 above, it can be known that the method for processing table data provided in the present application includes: for the second terminal of the data table, when permission information is pre-configured for the data table, and the permission information is used to indicate the access rights of each first terminal to the data in the data table, if the second terminal detects that the permission information is in effect, then the second terminal not only displays a dashboard for describing the data analysis results for the data table, but also displays a switch component, so that the administrator can flexibly configure whether to use the permission information to constrain the dashboard displayed by each first terminal with the help of the switch component, so that it can be flexibly configured from the dashboard dimension whether the data used for its statistics is all the data in the data table or the data for which the visitor has permission, so that it can be realized that the content displayed on the dashboard can be efficiently and flexibly adjusted according to the needs of different scenarios (such as exposure scenarios or scenarios considering role attributes), thereby effectively improving the user experience.

[0064] In addition, in order to improve flexibility, the above table data processing method may further include the following step 1.

[0065] Step 1: In response to the switch component being in the off state, the second terminal displays a second prompt message, where the second prompt message is used to indicate that the dashboard displayed in the first terminal is not constrained by the permission information.

[0066] In the present application, for the switch component displayed by the second terminal, when it is detected that the switch component is in the closed state, the second prompt information (such as Figure 3 The prompt information 205 shown in the figure) is used to enable the second prompt information to convey to the administrator that the dashboard displayed by each first terminal will not be constrained by the permission information.

[0067] In addition, the present application does not limit the implementation method of the above step one. For example, it can specifically be: in response to switching the switch component from an on state to a off state, displaying a second prompt information, the second prompt information is used to indicate that the dashboard displayed in the first terminal is not constrained by using permission information.

[0068] It can be seen that for the switch component displayed by means of the instrument panel, if it is detected that the switch component is switched from the on state to the off state, it can be determined that the switch component has been turned off, so the second prompt information (such as Figure 3 The prompt information 205 shown is displayed so that the second prompt information can convey to the administrator that the dashboard displayed by each first terminal will not be constrained by the permission information in the future, so that the administrator can know from the second prompt information that the statistical data of the current dashboard has been switched from the data for which the visitor has permission to all data.

[0069] In addition, in some scenarios, in order to better improve the user experience, the first prompt information and the second prompt information both include the entry mark of the same page (such as Figure 3 The "Learn More" entry logo shown in the figure) allows users to enter the corresponding page through the logo, such as the display page of the help center document. It should be noted that this application does not limit the implementation method of the logo. For example, it can be implemented using the access link of the help center document. In addition, the link needs to support at least multiple languages.

[0070] In addition, for a dashboard obtained by performing statistical analysis on a data table, if it is detected that the terminal used to display the dashboard has management authority over the data table, and it is detected that the permission information pre-configured for the data table is in an invalid state, it can be determined that there is no need to restrict the visitor's access rights with the help of permission information, and thus it can be determined that the visitor can access all the data in the data table, and further it can be determined that the dashboard is used to count all the data, so the switch component can be not displayed to avoid user confusion, thereby helping to better improve the user experience.

[0071] Based on this, it can be known that in a possible implementation, the above table data processing method may at least include the above S101-S102 and the following step 11. The execution time of step 11 is later than the execution time of S102.

[0072] Step 11: In response to switching the permission information from the effective state to the invalid state, the second terminal cancels the display switch component.

[0073] Example 1: When the switch component is directly deployed on the dashboard, step 11 may specifically be: in response to switching the permission information from a valid state to an invalid state, the second terminal cancels displaying the switch component on the dashboard.

[0074] Example 2: When the above switch component is deployed on the management page (such as Figure 2 When the page 202 is displayed, the above step 11 may specifically be: the second terminal cancels the display switch component on the management page in response to switching the permission information from the effective state to the invalid state.

[0075] Based on the relevant content of the above step 11, it can be known that for the dashboard displayed by the second terminal and used to describe the data analysis results of the data table, if it is detected that the permission information pre-configured for the data table is switched from an effective state to an invalid state, it can be determined that there is no need to use the permission information to restrict the visitor's data access rights, and thus it can be determined that the dashboard is used to count all the data, and further it can be determined that there is no need for the administrator to manually select the statistical mode of the dashboard, so the switch component that has lost its use value can be directly cancelled, which can effectively avoid the interference caused by the switch component, thereby helping to better improve the user experience.

[0076] According to research, in some scenarios, administrators may re-enable advanced permissions. Therefore, in order to better improve the user experience, the state of the above switch components when the advanced permissions were last closed can be used.

[0077] It can be seen that, in a possible implementation manner, the above-mentioned method for processing table data may at least include the above-mentioned S101-S102 and the following steps 21-22.

[0078] Step 21: In response to switching the permission information from the effective state to the invalid state, the second terminal saves the state of the switch component and cancels the display of the switch component, so that the saved state can represent the state of the switch component when the display of the switch component is canceled, such as the on state or the off state.

[0079] Step 22: In response to switching the permission information from the invalid state to the valid state, the second terminal displays the switch component according to the saved state, so that the redisplayed switch component can restore the state of the switch component when the advanced permission was last closed.

[0080] Based on the relevant contents of steps 21 to 22 above, it can be known that for the dashboard displayed by the second terminal and used to describe the data analysis results of the data table, if it is detected that the permission information pre-configured for the data table is switched from an effective state to an invalid state, it is necessary not only to cancel the display of the switch component, but also to save the state of the switch component, so that the saved state can represent the state of the switch component when the advanced permission is turned off, so that when it is detected that the permission information is switched from an invalid state to an effective state again, the display of the switch component can be directly restored according to the saved state, so that the redisplayed switch component can retain the state of the switch component when the advanced permission was last turned off. This can effectively avoid the defects caused by reusing the switch component for configuration, thereby helping to better improve the user experience.

[0081] Research has found that in some scenarios, such as when there are multiple administrators or the same terminal allows multiple requests to be triggered simultaneously, the following phenomenon may occur: multiple conflicting requests are triggered at the same time (such as the two requests of closing advanced permissions and turning on the switch component are triggered at the same time, or the two requests of canceling the management permissions of a terminal and turning on the switch component are triggered at the same time), which can easily lead to confusion.

[0082] Based on the above research, in order to overcome the defects shown in the previous paragraph, the table data processing method provided by the present application may include at least the following step 31 and / or step 32. There is no relationship between the execution time of step 31 and the execution time of step 32. For example, the two can be the same, the former can be earlier than the latter, or the latter can be earlier than the former, and the present application does not limit this.

[0083] Step 31: If a state switching request triggered for a switch component and a first request for requesting to switch permission information from an effective state to an invalid state are detected at the same time, the first request is executed and a third prompt message is displayed. The third prompt message is used to indicate that the state switching request failed to execute because the permission information is in an invalid state. The state switching request is used to request to switch the switch component from an off state to an on state, or to switch the switch component from an on state to an off state.

[0084] It should be noted that the present application does not limit the implementation method of step 31. For ease of understanding, two situations are combined for explanation below.

[0085] Case 1, in some scenarios, such as the scenario where the same terminal allows multiple requests to be triggered simultaneously, the above step 31 can be specifically as follows: for the second terminal 1 that is displaying the switch component, at the same time when a state switching request (such as a request to switch from an off state to an on state, or from an on state to an off state, etc.) is triggered for the switch component through the second terminal 1, a first request for requesting to switch the permission information from an effective state to an invalid state is also triggered through the second terminal 1. At this time, it is detected that there is a conflict in the execution process of the two requests, so the first request with a higher priority can be executed first to switch the permission information from an effective state to an invalid state, so that the switch component does not meet the display conditions, thereby making the state switching request triggered for the switch component lose its execution value, and it is only necessary to directly display the prompt "Operation failed, the current data table does not have advanced permissions enabled" on the second terminal 1, so that the second terminal 1 can learn from the prompt that the state of the permission information of the data table has changed.

[0086] Case 2, in some scenarios, such as scenarios where there are multiple administrators, the above step 31 can be specifically as follows: for the second terminal 1 that is displaying the switch component, at the same time when the state switching request is triggered for the switch component through the second terminal 1, the first request for requesting to switch the permission information from the effective state to the invalid state is triggered through other second terminals (such as the second terminal 2). At this time, it is detected that there is a conflict in the execution process of the two requests, so the first request with a higher priority can be executed first to switch the permission information from the effective state to the invalid state, so that the switch component does not meet the display conditions, thereby making the state switching request triggered for the switch component lose its execution value, and it is only necessary to directly display the prompt "Operation failed, the current data table does not have advanced permissions enabled" on the second terminal 1, so that the second terminal 1 can learn from the prompt that the state of the permission information of the data table has changed.

[0087] Step 32: If a state switching request triggered for the switch component and a second request for requesting cancellation of the second terminal's management authority over the data table are detected at the same time, the second request is executed and a fourth prompt message is displayed. The fourth prompt message is used to indicate that the state switching request failed to execute because the second terminal does not have management authority over the data table. The state switching request is used to request to switch the switch component from an off state to an on state, or to switch the switch component from an on state to an off state.

[0088] It should be noted that the present application does not limit the implementation method of step 32. For ease of understanding, two situations are combined for explanation below.

[0089] Case 1, in some scenarios, such as the scenario where the same terminal allows multiple requests to be triggered simultaneously, the above step 32 can be specifically as follows: for the second terminal 1 that is displaying the switch component, at the same time when the state switching request is triggered for the switch component through the second terminal 1, the second request for requesting to cancel the second terminal 1's management authority over the data table is also triggered through the second terminal 1. At this time, it is detected that there is a conflict in the execution process of the two requests, so the second request with a higher priority can be executed first to cancel the second terminal 1's management authority over the data table, so that the second terminal 1 no longer has the management authority for the data table, so that the state switching request triggered by the second terminal 1 is not allowed by its own authority, and thus the state switching request loses the value of execution, and it is only necessary to directly display the prompt "Operation failed, no permission to operate" on the second terminal 1, so that the second terminal 1 can know from the prompt that it no longer has the management authority for the data table.

[0090] Case 2, in some scenarios, such as scenarios where there are multiple administrators, the above step 32 can be specifically as follows: for the second terminal 1 that is displaying the switch component, at the same time when the state switching request is triggered for the switch component through the second terminal 1, the second request for requesting to cancel the second terminal 1's management authority over the data table is triggered through other second terminals (such as the second terminal 2). At this time, it is detected that there is a conflict in the execution process of the two requests, so the second request with a higher priority can be executed first to cancel the second terminal 1's management authority over the data table, so that the second terminal 1 no longer has the management authority for the data table, so that the state switching request triggered by the second terminal 1 is not allowed by its own authority, and thus the state switching request loses its execution value. It only needs to directly display the prompt "Operation failed, no permission to operate" on the second terminal 1, so that the second terminal 1 can know from the prompt that it no longer has the management authority over the data table.

[0091] Based on the relevant contents of the above steps 31 to 32, it can be known that for multiple requests triggered simultaneously by the same second terminal or different requests triggered simultaneously by different terminal devices, if a conflict is detected between these requests, these requests can be processed in sequence according to priority to avoid defects caused by processing these requests at the same time, such as confusion or insecurity.

[0092] Research has found that in some scenarios, the following requirements may exist: managers need to preview in advance whether the dashboards that different users can see meet their expectations.

[0093] Based on the above research, in order to better meet the requirements shown in the previous paragraph, the present application provides a possible implementation method of a method for processing tabular data. In this manner, when the data table is pre-configured with multiple first terminals, the method for processing tabular data may at least include the following steps 41-42.

[0094] Step 41: In response to a preview operation triggered on the dashboard, the second terminal displays a preview page, which displays the display effect of the dashboard on a third terminal by default. The multiple first terminals include the third terminal.

[0095] The preview operation is used to trigger the display process of the preview page; and this application does not limit the preview operation, for example, it can be: first click Figure 2 Click the "Advanced Permissions" button shown in the figure to open the option aggregation page; then click the preview option displayed by the option aggregation page to enter the preview page, as shown in the figure below: Figure 4 Page 206 is shown.

[0096] In addition, the third terminal refers to the first terminal to which the dashboard displayed by default (or initially) by the page when entering the preview page belongs, such as the above-mentioned second terminal, or any terminal of the above-mentioned multiple first terminals, or a terminal set by the user through configuration.

[0097] Step 42: The second terminal updates the preview page in response to a preview object switching operation triggered on the preview page, wherein the preview object switching operation is used to indicate switching from the third terminal to the fourth terminal, the multiple first terminals include the fourth terminal, and the updated preview page is used to display the display effect of the dashboard on the fourth terminal.

[0098] The preview object switching operation is used to indicate switching from the third terminal to the fourth terminal, so that the operation is used to request to change the content displayed by the preview page, such as switching from the third terminal (such as Figure 4 The dashboard displayed by the user A) shown in FIG. 1 is switched to the dashboard displayed by the fourth terminal (such as Figure 4 The dashboard displayed by user 1) is shown.

[0099] The fourth terminal refers to the preview object specified by the preview object switching operation, such as Figure 4 User 1 is shown.

[0100] Based on the relevant contents of the above steps 41 to 42, it can be known that for the second terminal, the preview mode can be entered through the terminal to confirm in this mode whether the dashboard seen by each visitor meets his expectations, which is conducive to improving the management experience.

[0101] In addition, the present application does not limit the application scenario of the preview process described by the above steps 41 to 42. For example, it can be: for the second terminal that is displaying the switch component, if the terminal detects that the switch component is in the on state, a new component (such as the above preview option) can be added to the dashboard displayed by the terminal, so that the preview process can be entered later by triggering the preview operation using the component. In this way, the administrator can use the preview mode to confirm whether the dashboard seen by any visitor complies with the access rights set for the visitor, thereby ensuring that the preview service is only provided in the scenario where the dashboard is generated based on data for which the visitor has permission, which is conducive to avoiding the relevant content of the component from interfering with the scenario where the dashboard is generated based on all data.

[0102] Research has found that if other terminals are accessing the dashboard while the second terminal is adjusting the statistical method for the dashboard, the dashboard displayed by other terminals needs to be updated in a timely manner to overcome defects caused by untimely dashboard updates, such as insecurity.

[0103] Based on the above research, the present application also provides a method for processing table data applied to a first terminal, which includes the following S501-S503.

[0104] S501: A first terminal displays a dashboard, where the dashboard is determined based on a data table. The data table is pre-configured with permission information, where the permission information is used to indicate access rights of the first terminal to data in the data table.

[0105] S502: In response to the state switching operation triggered on the switch component on the second terminal, the first terminal displays a prompt page, where the prompt page is used to indicate that the data permission of the dashboard has changed.

[0106] The state switching operation refers to an operation triggered on the second terminal during the period when the first terminal displays the instrument panel and is used to adjust the state of the switch component.

[0107] It can be seen that if the dashboard being displayed by the first terminal does not use permission information to constrain the dashboard displayed by the first terminal, it can be determined that the switch component has been adjusted to the closed state through the second terminal within the historical time, so that it can be determined that the state switching operation is used to indicate that the switch component displayed by the second terminal is switched from the closed state to the open state; however, if the dashboard being displayed by the first terminal uses permission information to constrain the dashboard displayed by the first terminal, it can be determined that the switch component has been adjusted to the open state through the second terminal within the historical time, so that it can be determined that the state switching operation is used to indicate that the switch component displayed by the second terminal is switched from the open state to the closed state.

[0108] In addition, the present application does not limit the implementation method of the prompt page. For example, it can be implemented in a pop-up window. The text of the pop-up window can be "Dashboard data permissions have been modified, please refresh and view". The pop-up window also includes a refresh button so that subsequent users can update the dashboard by clicking the button.

[0109] S503: The first terminal updates the dashboard in response to a trigger operation for updating a component in a prompt page; the dashboard before the update does not use permission information constraints, the state switching operation is used to indicate that the switch component is switched from an off state to an on state, and the dashboard after the update uses permission information constraints, or the dashboard before the update uses permission information constraints, the state switching operation is used to indicate that the switch component is switched from an on state to a off state, and the dashboard after the update does not use permission information constraints.

[0110] The update component refers to a component that exists on the prompt page and is used to trigger the dashboard update process, such as the refresh button mentioned above.

[0111] In addition, the present application does not limit the implementation method of the above-mentioned "update dashboard" step. For example, it can meet the following constraints: if the dashboard before the update does not use permission information constraints, and the above-mentioned state switching operation is used to indicate that the switch component is switched from the off state to the on state, then the updated dashboard uses permission information constraints; or, if the dashboard before the update uses permission information constraints, and the above-mentioned state switching operation is used to indicate that the switch component is switched from the on state to the off state, then the updated dashboard does not use permission information constraints.

[0112] Based on the relevant contents of S501 to S503 above, it can be known that for any first terminal, while the first terminal is browsing the dashboard, if the second terminal triggers a state switching operation for the switch component displayed by it, it can be determined that the second terminal has adjusted the statistical method of the dashboard, so a pop-up window can be displayed on the first terminal to prompt the user to refresh, so that the visitor can trigger the update process of the dashboard through the refresh button on the pop-up window, so that the visitor can continue to browse the updated dashboard, so that the dashboard in each first terminal can be updated in a timely manner, which is conducive to better improving the user experience.

[0113] In addition, the present application does not limit the implementation method of using permission information to constrain the dashboard. For example, it can be specifically: for any component in the dashboard, if it is detected that the data involved in the determination process of the data analysis results displayed by the component (such as intermediate data or the final displayed data) includes data for which the visitor does not have permission, then the component cannot be displayed. Instead, a pre-set no-authorization viewing fallback map is directly displayed at the display position of the component to inform the visitor that he or she does not have permission to view the component.

[0114] The research also found that if the intermediate data of a component's rendering process (such as the process of determining the data analysis results displayed by the component) uses data that the visitor does not have permission to view, but the final rendering result of the component does not use data that the visitor does not have permission to view, then when the component is displayed, there will be no risk of leaking data to the visitor that the visitor does not have permission to view, so that the component should be displayed to the visitor and should not be replaced by a pre-set fallback image for viewing without permission. This will help to better improve the user experience.

[0115] Based on the above research, in order to better improve the user experience, the present application also provides an implementation scheme for using permission information to constrain components on the dashboard. In the scheme, if the permission information indicates that the first terminal has no permission to access a first data set (such as any invisible column or any invisible row) in a data table, and the first data set includes any column or any row in the data table, then for any component in the dashboard, the process of determining the display content on the component includes:

[0116] When the key information based on which the component is rendered is used to form the data analysis results displayed by the component so that the user can directly see the key information on the component, if the key information includes the first data set, it can be determined that there is data in the display content on the component that the visitor has no authority to view, so the preset content (such as the content of the no-authority-to-view bottom-line map, etc.) can be used to replace the component for display, so that the preset content is used to indicate that the first terminal has no authority to view the data analysis results, thereby avoiding the visitor from seeing the data for which he has no authority from the component; however, if the key information does not include the first data set, it can be determined that there is no data in the display content on the component that the visitor has no authority to view, even if the acquisition process of the display content on the component uses the first data set, but because the component will not directly expose the first data set, so that the visitor still cannot see the first data set through the component, so the component can be rendered and displayed based on the data table, so that it can achieve the display of as many data analysis results as possible under the premise of avoiding the exposure of the visitor's unauthorized data. For ease of understanding, the following is an explanation in combination with three situations.

[0117] Case 1: For any component in the dashboard displayed by the first terminal, if there are invisible columns (or invisible rows) in the key information on which the rendering of the component depends (such as components of the data analysis results displayed by the component), it can be determined that the component is at risk of exposing data that the visitor does not have permission to access. Therefore, the component may not be displayed, but a no-authorization viewing fallback map may be directly displayed at the display position of the component.

[0118] It should be noted that due to the different characteristics of different components, the key information of different components is different, which leads to differences in the processing standards of different components, as shown in (1)-(3) below.

[0119] (1) For the first type of components (such as axis components, pie charts or doughnut charts), if the content displayed by the component is composed of the key information of the component so that users can directly see the key information through the component, then when it is detected that the key information uses invisible columns, it can be determined that the component cannot be displayed normally and replaced with a backup chart for those who do not have permission to view it. Among them, the key information may include the categories involved in axis components (such as the X-axis), the series involved in axis components (such as the Y-axis), the grouping basis involved in axis components, the sector grouping involved in pie charts (or doughnut charts), and the sector values ​​involved in pie charts (or doughnut charts).

[0120] (2) For the second type of components (such as funnel charts, word clouds, indicator cards, rankings, and NPS charts), if the content displayed by the component is obtained by processing the key information of the component so that users can directly see the processing results of the key information through the component, then when it is detected that the key information uses invisible columns, it can be determined that the component cannot be displayed normally and replaced with a no-authorization-to-view bottom-up chart. Among them, the key information may include the funnel layer or data statistics of the funnel chart, the keyword field of the word cloud, the statistical method of the indicator card, the ranking field or ranking basis of the ranking list, the NPS basis of the NPS chart, etc.

[0121] (3) For the third type of components (such as text components or button components), the content displayed by the component is unlikely to involve a data column in the data table (such as an invisible column), and is also unlikely to involve the processing results of the data column, so that the key information used to render the component is unrelated to the invisible column, thereby making the component unaffected by the invisible column.

[0122] It should also be noted that, for any component, the key information used to render the component can be manually set in advance, or can be determined based on the component's own properties, and this application does not make specific limitations on this.

[0123] Case 2: For any component in the dashboard displayed by the first terminal, if there is no invisible column (or invisible row) in the key information on which the rendering of the component depends, but the rendering process of the component uses the invisible column (or invisible row), it can be determined that the invisible column (or invisible row) will not be exposed when the component is displayed, so the component can be directly displayed normally. For example, if the "Region" column shown in Table 1 above is an invisible column, when the filter condition corresponding to the component is Region = Region 1, the category corresponding to the component is the sales date, and the series corresponding to the component is the sales amount, the filter takes effect, and the component is rendered normally, so that the rendered component meets the following constraints: the category includes the sales date of Region 1, and the series includes the sales amount of Region 1, and the drill-down data of the component is only used to display rows 2 to 6 in Table 1, but the region column needs to be hidden.

[0124] It should be noted that for any component, when the intermediate process involved in rendering the component includes global filtering, component filtering, or component data sorting, if the filtering or sorting uses an invisible column, the filtering and sorting results are returned normally, and subsequent rendering processing is continued based on the results. It is only necessary to ensure that the data in the invisible column and the processing results of the invisible column do not appear on the final rendered component.

[0125] It should also be noted that for any component, when a drill-down pop-up window exists in the chart displayed by the component, if the pop-up window displays the chart calculation data after filtering and sorting results, the invisible columns in the data source are hidden, and the rows after the filtering or sorting conditions take effect are displayed.

[0126] Case 3: For any component in the dashboard displayed by the first terminal, if there is no invisible column (or invisible row) in the key information on which the rendering of the component depends, but the rendering process of the component does not use the invisible column (or invisible row), it can be determined that the component is not related to the invisible column (or invisible row), so the component can be displayed normally.

[0127] Through research, it is found that in some scenarios, such as a scenario where a user has multiple role attributes, the user's data access rights for the data table are the union of the data access rights of all role attributes, so that the user's data access rights for the data table may have a grid column (or grid row), such as the user has the right to view part of the data in a column (such as the first 6 data in the "Profit" column in Table 1 above), which makes it difficult to use the grid column when generating a dashboard. Among them, the grid column, also known as the partially visible column, refers to a data column where some data is visible but other data is not visible, so that the grid column seen from the visitor's perspective appears to have data in some grids but no data in other grids.

[0128] Based on the above research, in order to solve the problem shown in the previous paragraph, the present application also provides a processing solution for the above-mentioned sub-columns. In this solution, when using permission information to constrain components on the dashboard, if the permission information indicates that the first terminal has no permission to access part of the data in the second data set (such as the sub-columns or sub-rows) in the data table, and the second data set includes any column or any row in the data table, then for any component in the dashboard, the process of determining the display content on the component includes:

[0129] When the key information based on which the component is rendered is used to form the data analysis results displayed by the component so that the user can directly see the key information on the component, if the key information includes a second data set, then the component is rendered and displayed based on the other data in the second data set except the above-mentioned partial data, so that the content displayed by the component does not include the partial data; if the key information does not include the second data set, but the rendering process of the component uses the second data set, then the component is rendered and displayed based on the other data in the second data set except the partial data, so that the content displayed by the component does not include the partial data; if the key information does not include the second data set, and the rendering process of the component does not use the second data set, then the component is rendered and displayed based on the data table. For ease of understanding, the following is an explanation in combination with three situations.

[0130] Case 1: For any component in the dashboard displayed by the first terminal, if there is a grid column (or grid row) in the key information on which the rendering of the component depends, it can be determined that part of the content displayed by the component can be displayed, but part cannot be displayed. Therefore, the visitor's authorized data in the grid column (or grid row) can be used to participate in statistical processing to obtain the component, so that the component is only used to display content related to the visitor's authorized data (also called visible data), and does not display content related to the visitor's unauthorized data (also called invisible data). For example, if the "Profit" column shown in Table 1 above belongs to a drill-down sub-column, and the first 6 data of the drill-down sub-column belong to the visitor's authorized data, and the other data belong to the visitor's unauthorized data, then when the key information that the component depends on is rendered using the drill-down sub-column, the category corresponding to the component is the sales date, and the series corresponding to the component is profit, the component is rendered based on the statistical analysis results between rows 2 to 7 in Table 1, so that the rendered component meets the following constraints: the category is used to describe the sales date involved in rows 2 to 7, and the series is used to describe the profits involved in rows 2 to 7, so that the drill-down data of the component is only used to display rows 2 to 7 in Table 1.

[0131] It should be noted that due to the different characteristics of different components, the key information of different components is different, which leads to differences in the processing standards of different components. Specifically, if the key information of the above-mentioned first-category component or the above-mentioned second-category component uses a grid sub-column, then the component is used to render based on the visible data in the grid sub-column; the above-mentioned third-category component is not affected by the grid sub-column. In addition, for the fourth type of components, such as view components, if the grouping uses a grid sub-column, the content displayed by the component is grouped according to the data row where the visible data in the grid sub-column is located; if the parent record of the table is set with a grid sub-column, the component is used to display the data with the data row where the visible data in the grid sub-column is located as the parent record; if the date uses a grid sub-column when the Gantt chart date is configured, the component is used to display the data row where the visible data in the grid sub-column is located; if the visible field uses a grid sub-column, the component is used to display the data row where the visible data in the grid sub-column is located; if the billboard or album cover uses a grid sub-column, the component is used to display the cover of the data row where the visible data in the grid sub-column is located, and rows without permission are regarded as unconfigured.

[0132] Case 2: For any component in the dashboard displayed by the first terminal, if the key information on which the rendering of the component depends does not contain a grid column (or a grid row), but the rendering process of the component uses the grid column (or a grid row), the visible data in the grid column (or a grid row) can be used to participate in the rendering process to obtain and display the component, so that the component is only used to display the data analysis results determined based on the visible data. For example, if the "Profit" column shown in Table 1 above belongs to a drill-down sub-column, and the first 6 data of the drill-down sub-column are visible, and the other data are not visible, then when the filtering condition corresponding to the component is Profit>200, the category corresponding to the component is sales date, and the series corresponding to the component is sales amount, the filtering takes effect, and only the 2nd to 7th rows in Table 1 are filtered to render the component, so that the rendered component meets the following constraints: the category includes 2024 / 11 / 02, 2024 / 11 / 04, 2024 / 11 / 06, and the series includes 203, 500, 300, so that the drill-down data of the component is only used for rows 2 to 7 in Table 1.

[0133] It should be noted that for any component, when the intermediate process involved in rendering the component includes global filtering, component filtering, or component data sorting, if the filtering or sorting uses a grid sub-column, the data rows where the visible data in the grid sub-column is located will participate in the filtering and sorting, and the subsequent rendering processing will continue based on the returned results.

[0134] It should also be noted that, for any component, when a drill-down pop-up window exists in the chart displayed by the component, if the drill-down data displayed in the pop-up window includes a grid column, only the visible data in the filtered column will be displayed.

[0135] Based on the above content, it can be known that the technical solution provided by the present application has the following advantages: ① Because the present application configures data statistics from the dashboard dimension to determine whether it is all data or visitor-authorized data, the user can flexibly choose to use all data or visitor-authorized data for statistics according to different usage scenarios of the dashboard (such as through-exposure scenarios or multi-role attribute scenarios), which is conducive to improving the flexibility of scene switching. ② Because when the present application renders any component on the dashboard, if the intermediate process (such as filtering or sorting) involved in the component uses invisible columns, the intermediate process can be executed normally. It is only necessary to ensure that the final rendered component does not display the invisible column, so that the visitor can only see the final rendering result and cannot perceive the intermediate process, which is conducive to better improving the user experience. ③ Because the present application also provides a processing method for digging out grid columns or digging out grid rows, so that the processing method can meet the requirements of the visitor-authorized data permission configuration to be refined to the cell scenario, so that the present application is suitable for scenarios where roles cross because the same user has multiple role attributes, such as digging out grid columns.

[0136] Based on the method for processing table data provided in the embodiment of the present application, the embodiment of the present application also provides a device for processing table data. Figure 6 Explain and illustrate. Figure 6 This is a schematic diagram of the structure of a table data processing device provided in an embodiment of the present application. It should be noted that for the technical details of the table data processing device provided in an embodiment of the present application, please refer to the relevant content of the table data processing method above.

[0137] like Figure 6 As shown, the table data processing device 600 provided in the embodiment of the present application includes:

[0138] A first display unit 601 is used to display a dashboard, where the dashboard is used to describe a data analysis result for a data table, where the data table is pre-configured with permission information, where the permission information is used to indicate access rights of the first terminal to the data in the data table;

[0139] A second display unit 602 is used for displaying a switch component in response to the permission information being in an effective state, wherein the switch component is used to constrain the dashboard displayed in the first terminal using the permission information;

[0140] The third display unit 603 is used to display first prompt information in response to the switch component being in the turned-on state, where the first prompt information is used to indicate the use of the permission information to constrain the dashboard displayed in the first terminal.

[0141] In a possible implementation manner, the third display unit 603 is further used to display a second prompt information in response to the switch component being in a closed state, wherein the second prompt information is used to indicate that the authority information is not used to constrain the dashboard displayed in the first terminal.

[0142] In a possible implementation manner, the second display unit 602 is specifically configured to: in response to the permission information being in an effective state, additionally display the switch component on the dashboard.

[0143] In one possible implementation, an entry mark of a management page is displayed on the dashboard, and the second display unit 602 is specifically used to: display the management page in response to a trigger operation on the entry mark, and add the display of the switch component on the management page in response to the permission information being in effect.

[0144] In one possible implementation, the tabular data processing device 600 further includes: a first cancellation unit for canceling the display of the switch component on the dashboard in response to switching the permission information from an effective state to an invalid state after the switch component is added for display on the dashboard.

[0145] In one possible implementation, the table data processing device 600 further includes: a second cancellation unit for canceling the display of the switch component on the management page in response to switching the permission information from an effective state to an invalid state after adding the display of the switch component on the management page.

[0146] In one possible implementation, the table data processing device 600 also includes: a third cancellation unit, used to save the state of the switch component and cancel the display of the switch component in response to switching the permission information from an effective state to an invalid state; and a recovery display unit, used to display the switch component according to the saved state in response to switching the permission information from an invalid state to a valid state.

[0147] In one possible implementation, the table data processing device 600 also includes: a first processing unit, which is used to execute a state switching request triggered for the switch component and a first request for requesting to switch the permission information from a valid state to an invalid state if the first request is detected at the same time, and to display a third prompt information, wherein the third prompt information is used to indicate that the state switching request failed to execute because the permission information is in an invalid state, and the state switching request is used to request to switch the switch component from an off state to an on state, or to switch the switch component from an on state to an off state.

[0148] In one possible implementation, the table data processing device 600 also includes: a second processing unit, which is used to execute the second request and display a fourth prompt message if a state switching request triggered for the switch component and a second request for requesting cancellation of the second terminal's management authority over the data table are detected at the same time. The fourth prompt message is used to indicate that the state switching request failed to execute because the second terminal does not have the management authority over the data table. The state switching request is used to request to switch the switch component from an off state to an on state, or to switch the switch component from an on state to a off state.

[0149] In a possible implementation manner, different requests are triggered by different terminals, and the state switching request is triggered by the second terminal.

[0150] In one possible implementation, the data table is pre-configured with multiple first terminals; the table data processing device 600 also includes: a preview trigger unit, used to display a preview page in response to a preview operation triggered on the dashboard, the preview page displays the display effect of the dashboard on a third terminal by default, and the multiple first terminals include the third terminal; an object switching unit, used to update the preview page in response to a preview object switching operation triggered on the preview page, the preview object switching operation is used to indicate switching from the third terminal to a fourth terminal, the multiple first terminals include the fourth terminal, and the updated preview page is used to display the display effect of the dashboard on the fourth terminal.

[0151] Based on the relevant content of the above-mentioned table data processing device 600, it can be known that the working principle of the device 600 includes: when permission information is pre-configured for the data table, and the permission information is used to indicate the access rights of each first terminal to the data in the data table, if the second terminal detects that the permission information is in effect, then the second terminal not only displays a dashboard for describing the data analysis results for the data table, but also displays a switch component, so that the administrator can flexibly configure whether to use the permission information to constrain the dashboard displayed by each first terminal with the help of the switch component, so that it can be flexibly configured from the dashboard dimension whether the data used for its statistics is all the data in the data table or the data that the visitor has permission to, so that it can be realized that the content displayed on the dashboard can be efficiently and flexibly adjusted according to the needs of different scenarios (such as a general exposure scenario or a scenario considering role attributes), thereby effectively improving the user experience.

[0152] Based on the method for processing table data provided in the embodiment of the present application, the embodiment of the present application also provides a device for processing table data. Figure 7 Explain and illustrate. Figure 7This is a schematic diagram of the structure of a table data processing device provided in an embodiment of the present application. It should be noted that for the technical details of the table data processing device provided in an embodiment of the present application, please refer to the relevant content of the table data processing method above.

[0153] like Figure 7 As shown, the table data processing device 700 provided in the embodiment of the present application includes:

[0154] A fourth display unit 701 is used to display a dashboard, where the dashboard is determined according to the data table, where the data table is pre-configured with permission information, where the permission information is used to indicate access rights of the first terminal to the data in the data table;

[0155] A fifth display unit 702, configured to display a prompt page in response to a state switching operation triggered on the switch component on the second terminal, wherein the prompt page is used to indicate that the data permission of the dashboard has changed;

[0156] An updating unit 703 is used to update the dashboard in response to a triggering operation for updating the component in the prompt page; the dashboard before the update does not use the permission information constraint, the state switching operation is used to indicate that the switch component is switched from an off state to an on state, and the dashboard after the update uses the permission information constraint, or the dashboard before the update uses the permission information constraint, the state switching operation is used to indicate that the switch component is switched from an on state to a off state, and the dashboard after the update does not use the permission information constraint.

[0157] In one possible implementation, the dashboard includes multiple components, and different components are used to display different data analysis results for the data table; when the dashboard uses the permission information constraint, if the permission information indicates that the first terminal does not have permission to access a first data set in the data table, and the first data set includes any column or any row in the data table, then for any component in the dashboard, the display process of the component includes: if the key information based on which the component is rendered includes the first data set, then the component is displayed instead of preset content, and the key information is used to form the data analysis results displayed by the component, and the preset content is used to indicate that the first terminal does not have permission to view the data analysis results displayed by the component; if the key information based on which the component is rendered does not include the first data set, then the component is rendered and displayed based on the data table.

[0158] In one possible implementation, the dashboard includes multiple components, and different components are used to display different data analysis results for the data table; when the dashboard uses the permission information constraint, if the permission information indicates that the first terminal does not have permission to access part of the data in the second data set in the data table, and the second data set includes any column or any row in the data table, then for any component in the dashboard, the display process of the component includes: if the key information based on which the component is rendered includes the second data set, then the component is rendered and displayed based on the other data in the second data set except the part of the data, and the key information is used to constitute the data analysis result displayed by the component; if the key information based on which the component is rendered does not include the second data set, but the rendering process of the component uses the second data set, then the component is rendered and displayed based on the other data in the second data set except the part of the data.

[0159] Based on the relevant content of the processing device 700 for the above-mentioned table data, it can be known that the working principle of the device 700 includes: while the visitor is browsing the dashboard with the help of the device 700, if the second terminal triggers a state switching operation for the switch component, it can be determined that the second terminal has adjusted the statistical method of the dashboard, so a pop-up window can be displayed on the device 700 to prompt the user to refresh, so that the visitor can trigger the update process of the dashboard through the refresh button on the pop-up window, so that the visitor can continue to browse the updated dashboard, so that the dashboard in other terminals except the second terminal can be updated in a timely manner, which is conducive to better improving the user experience.

[0160] In addition, an embodiment of the present application also provides an electronic device, which includes a processor and a memory: the memory is used to store instructions or computer programs; the processor is used to execute the instructions or computer programs in the memory, so that the electronic device executes any implementation of the method for processing tabular data provided in the embodiment of the present application.

[0161] See also Figure 8 , which shows a schematic diagram of the structure of an electronic device 800 suitable for implementing the embodiment of the present disclosure. The terminal device in the embodiment of the present disclosure may include but is not limited to mobile terminals such as mobile phones, laptop computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), vehicle-mounted terminals (such as vehicle-mounted navigation terminals), etc., and fixed terminals such as digital TVs, desktop computers, etc. Figure 8 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.

[0162] like Figure 8 As shown, the electronic device 800 may include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 801, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 802 or a program loaded from a storage device 808 into a random access memory (RAM) 803. In the RAM 803, various programs and data required for the operation of the electronic device 800 are also stored. The processing device 801, the ROM 802, and the RAM 803 are connected to each other via a bus 804. An input / output (I / O) interface 805 is also connected to the bus 804.

[0163] Typically, the following devices may be connected to the I / O interface 805: input devices 806 including, for example, a touch screen, a touch pad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc.; output devices 807 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; storage devices 808 including, for example, a magnetic tape, a hard disk, etc.; and communication devices 809. The communication device 809 may allow the electronic device 800 to communicate with other devices wirelessly or by wire to exchange data. Although Figure 8 The electronic device 800 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.

[0164] 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 the network through the communication device 809, or installed from the storage device 808, or installed from the ROM 802. When the computer program is executed by the processing device 801, the above-mentioned functions defined in the method of the embodiment of the present disclosure are executed.

[0165] The electronic device provided by the embodiment of the present disclosure and the method provided by the above embodiment belong to the same inventive concept. The technical details not fully described in this embodiment can be referred to the above embodiment, and this embodiment has the same beneficial effects as the above embodiment.

[0166] The embodiment of the present application also provides a computer-readable medium, in which instructions or computer programs are stored. When the instructions or computer programs are executed on a device, the device executes any implementation of the method for processing tabular data provided in the embodiment of the present application.

[0167] It should be noted that the computer-readable medium disclosed above 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 may 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, in which a computer-readable program code is carried. 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. The computer readable signal medium may also be any computer readable medium other than a computer readable storage medium, 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 suitable medium, including but not limited to: wires, optical cables, RF (radio frequency), etc., or any suitable combination of the above.

[0168] In some embodiments, the client and the server may communicate using any currently known or future developed network protocol such as HTTP (Hyper Text 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.

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

[0170] The computer-readable medium carries one or more programs, and when the one or more programs are executed by the electronic device, the electronic device can execute the method.

[0171] 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 cases involving 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).

[0172] 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.

[0173] The units involved in the embodiments described in the present disclosure may be implemented by software or hardware, wherein the name of a unit / module does not, in some cases, constitute a limitation on the unit itself.

[0174] 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.

[0175] 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 equipment, 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.

[0176] It should be noted that the various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments, and the same or similar parts between the various embodiments can be referred to each other. For the system or device disclosed in the embodiment, since it corresponds to the method disclosed in the embodiment, the description is relatively simple, and the relevant parts can be referred to the method part description.

[0177] It should be understood that in the present application, "at least one (item)" means one or more, and "plurality" means two or more. "And / or" is used to describe the association relationship of associated objects, indicating that three relationships may exist. For example, "A and / or B" can mean: only A exists, only B exists, and A and B exist at the same time, where A and B can be singular or plural. The character " / " generally indicates that the objects associated before and after are in an "or" relationship. "At least one of the following" or similar expressions refers to any combination of these items, including any combination of single or plural items. For example, at least one of a, b or c can mean: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", where a, b, c can be single or multiple.

[0178] It should also be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the presence of other identical elements in the process, method, article or device including the elements.

[0179] The steps of the method or algorithm described in conjunction with the embodiments disclosed herein may be implemented directly using hardware, a software module executed by a processor, or a combination of the two. The software module may be placed in a random access memory (RAM), a memory, a read-only memory (ROM), an electrically programmable ROM, an electrically erasable programmable ROM, a register, a hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.

[0180] The above description of the disclosed embodiments enables those skilled in the art to implement or use the present application. Various modifications to these embodiments will be apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present application. Therefore, the present application will not be limited to the embodiments shown herein, but will conform to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for processing tabular data, characterized in that: The method comprises: Displaying a dashboard, the dashboard being used to describe a data analysis result for a data table, the data table being pre-configured with permission information, the permission information being used to indicate access rights of the first terminal to the data in the data table; In response to the permission information being in a valid state, displaying a switch component, the switch component is used to use the permission information to constrain the dashboard displayed in the first terminal; In response to the switch component being in the on state, first prompt information is displayed, where the first prompt information is used to indicate that the authority information is used to constrain the dashboard displayed in the first terminal.

2. The method according to claim 1, characterized in that The method further comprises: In response to the switch component being in the off state, second prompt information is displayed, where the second prompt information is used to indicate that the authority information is not used to constrain the dashboard displayed in the first terminal.

3. The method according to claim 1, characterized in that The display process of the switch assembly includes: In response to the permission information being in an effective state, additionally displaying the switch component on the instrument panel; or, The dashboard displays an entry mark of the management page, and the display process of the switch component includes: In response to a trigger operation on the entry identifier, the management page is displayed, and in response to the permission information being in effect, the switch component is additionally displayed on the management page.

4. The method according to claim 3, characterized in that After the switch assembly is added and displayed on the instrument panel, the method further includes: In response to switching the permission information from a valid state to an invalid state, canceling the display of the switch component on the instrument panel; or, After adding and displaying the switch component on the management page, the method further includes: In response to switching the permission information from a valid state to an invalid state, the switch component is undisplayed on the management page.

5. The method according to claim 1, characterized in that After the display switch assembly, the method further comprises: In response to switching the permission information from a valid state to an invalid state, saving the state of the switch component and canceling the display of the switch component; In response to switching the permission information from an invalid state to a valid state, the switch component is displayed according to a saved state.

6. The method according to claim 1, characterized in that The method further comprises: If a state switching request triggered for the switch component and a first request for requesting to switch the permission information from a valid state to an invalid state are detected at the same time, the first request is executed and a third prompt information is displayed, wherein the third prompt information is used to indicate that the state switching request failed to execute because the permission information is in an invalid state, and the state switching request is used to request to switch the switch component from an off state to an on state, or to switch the switch component from an on state to an off state.

7. The method according to claim 1, characterized in that The method is applied to the second terminal, and the method further includes: If a state switching request triggered for the switch component and a second request for requesting cancellation of the second terminal's management authority over the data table are detected at the same time, the second request is executed and a fourth prompt message is displayed, wherein the fourth prompt message is used to indicate that the state switching request failed to execute because the second terminal does not have management authority over the data table, and the state switching request is used to request to switch the switch component from an off state to an on state, or to switch the switch component from an on state to a off state.

8. The method according to claim 6 or 7, characterized in that: Different requests are triggered by different terminals, and the state switching request is triggered by the second terminal.

9. The method according to claim 1, characterized in that: The data table is pre-configured with a plurality of first terminals; The method further comprises: In response to a preview operation triggered on the dashboard, display a preview page, the preview page displaying a display effect of the dashboard on a third terminal by default, the plurality of first terminals including the third terminal; In response to a preview object switching operation triggered for the preview page, the preview page is updated, the preview object switching operation is used to indicate switching from the third terminal to a fourth terminal, the multiple first terminals include the fourth terminal, and the updated preview page is used to display the display effect of the dashboard on the fourth terminal.

10. A method for processing tabular data, characterized in that: The method is applied to a first terminal, and the method includes: Displaying a dashboard, wherein the dashboard is determined according to a data table, wherein the data table is pre-configured with permission information, and the permission information is used to indicate access rights of the first terminal to the data in the data table; In response to a state switching operation triggered on the switch component on the second terminal, displaying a prompt page, the prompt page being used to indicate that the data permission of the dashboard has changed; In response to a trigger operation for updating a component in the prompt page, the dashboard is updated; the dashboard before the update does not use the permission information constraint, the state switching operation is used to indicate switching the switch component from an off state to an on state, and the dashboard after the update uses the permission information constraint, or the dashboard before the update uses the permission information constraint, the state switching operation is used to indicate switching the switch component from an on state to a off state, and the dashboard after the update does not use the permission information constraint.

11. The method according to claim 10, characterized in that The dashboard includes multiple components, and different components are used to display different data analysis results for the data table; When the dashboard uses the permission information constraint, if the permission information indicates that the first terminal has no permission to access a first data set in the data table, and the first data set includes any column or any row in the data table, then for any component in the dashboard, the display process of the component includes: If the key information based on which the component is rendered includes the first data set, the component is displayed using preset content instead, the key information is used to form the data analysis result displayed by the component, and the preset content is used to indicate that the first terminal has no authority to view the data analysis result displayed by the component; If the key information based on which the component is rendered does not include the first data set, the component is rendered and displayed based on the data table.

12. The method according to claim 10, characterized in that The dashboard includes multiple components, and different components are used to display different data analysis results for the data table; When the dashboard uses the permission information constraint, if the permission information indicates that the first terminal has no permission to access part of the data in the second data set in the data table, and the second data set includes any column or any row in the data table, then for any component in the dashboard, the display process of the component includes: If the key information based on which the component is rendered includes the second data set, the component is rendered and displayed based on other data in the second data set except the partial data, and the key information is used to form the data analysis result displayed by the component; If the key information based on which the component is rendered does not include the second data set, but the rendering process of the component uses the second data set, the component is rendered and displayed based on other data in the second data set except the partial data.

13. A table data processing device, characterized in that: include: A first display unit, used to display a dashboard, wherein the dashboard is used to describe a data analysis result for a data table, wherein the data table is pre-configured with permission information, and the permission information is used to indicate access rights of the first terminal to the data in the data table; A second display unit, configured to display a switch component in response to the permission information being in an effective state, wherein the switch component is configured to use the permission information to constrain the dashboard displayed in the first terminal; The third display unit is used to display first prompt information in response to the switch component being in the turned-on state, where the first prompt information is used to indicate the use of the permission information to constrain the dashboard displayed in the first terminal.

14. A device for processing tabular data, characterized in that: include: a fourth display unit, for displaying a dashboard, wherein the dashboard is determined according to the data table, wherein the data table is pre-configured with permission information, and the permission information is used to indicate access rights of the first terminal to the data in the data table; a fifth display unit, configured to display a prompt page in response to a state switching operation triggered on the switch component on the second terminal, wherein the prompt page is used to indicate that the data permission of the dashboard has changed; An updating unit, configured to update the dashboard in response to a triggering operation for updating components in the prompt page; The dashboard before the update does not use the permission information constraint, the state switching operation is used to indicate switching the switch component from an off state to an on state, and the dashboard after the update uses the permission information constraint, or the dashboard before the update uses the permission information constraint, the state switching operation is used to indicate switching the switch component from an on state to a off state, and the dashboard after the update does not use the permission information constraint.

15. An electronic device, characterized in that: The device comprises: a processor and a memory; The memory is used to store instructions or computer programs; The processor is used to execute the instructions or computer programs in the memory so that the electronic device executes the method according to any one of claims 1 to 12.

16. A computer readable medium, characterized in that The computer-readable medium stores instructions or computer programs, and when the instructions or computer programs are executed on a device, the device executes the method according to any one of claims 1 to 12.

17. A computer program product, characterized in that It comprises a computer program carried on a non-transitory computer-readable medium, the computer program comprising a program code for executing the method according to any one of claims 1 to 12.

Images