Data table display method and device, equipment and storage medium

Abstract

The application provides a data table display method and device, equipment and a storage medium, and relates to the technical field of computers. The method comprises the following steps: obtaining first filtering content of a first data table, wherein the first filtering content comprises a first filtering condition and a first display field; performing data filtering on the first data table according to the first filtering content to obtain a main data table, and displaying the main data table; in response to an operation on the main data table, obtaining second filtering content, wherein the second filtering content comprises a second filtering condition and a second display field, and the second filtering condition is different from the first filtering condition; generating a floating table according to a plurality of related data tables of the first data table and the second filtering content, and displaying the floating table. The method solves the problem that the prior art does not involve dynamic data display and multi-field non-associated mixed query of a table.

Description

Technical Field

[0001] This application relates to the field of computer technology, and in particular to a method, apparatus, device and storage medium for displaying data tables. Background Technology

[0002] Forms are an important part of business management. Different companies or fields often have different needs for forms, which enables managers to make better business decisions and manage the business.

[0003] Unlike corporate reports, which are often based on data summarization and processing, tables are typically used to record daily management information. Their complexity lies in the need for interactivity and the ability to circulate data across departments and personnel. Because Excel is widely used, powerful, flexible in editing, and allows for the creation of charts and tables within Excel files, companies often use Excel for managing tables.

[0004] When using Excel spreadsheets for filtering and viewing, existing technologies do not address the dynamic display of data in the spreadsheets or the handling of mixed queries with multiple unrelated fields. Summary of the Invention

[0005] This application provides a method, apparatus, device, and storage medium for displaying data tables, in order to solve the problem that the prior art does not address the dynamic data display and multi-field non-associative mixed query of tables.

[0006] On the one hand, this application provides a method for displaying a data table, including:

[0007] Obtain the first filter content from the first data table, wherein the first filter content includes a first filter condition and a first display field;

[0008] The data in the first data table is filtered according to the first filtering content to obtain the main data table, and the main data table is displayed.

[0009] In response to the operation on the master data table, a second filter content is obtained, the second filter content includes a second filter condition and a second display field, and the second filter condition is different from the first filter condition;

[0010] A floating table is generated and displayed based on multiple related data tables of the first data table and the second filtering content.

[0011] Optionally, generating a floating table based on multiple related data tables of the first data table and the second filtering content includes:

[0012] A second data table is determined from the first data table and the plurality of related data tables;

[0013] The second data table is filtered according to the second filtering criteria to obtain the floating table.

[0014] Optionally, determining a second data table from the first data table and the plurality of related data tables includes:

[0015] Displays multiple selection controls for the first data table and the plurality of related data tables;

[0016] In response to the user's selection operation of the first selected control among the plurality of selected controls, the data table corresponding to the first selected control is determined as the second data table.

[0017] Optionally, displaying the floating table includes:

[0018] If the second data table is the same as the first data table, the floating table is displayed according to the first rendering method, in which the display attributes of each data are the same;

[0019] If the second data table is different from the first data table, then a comparison process is performed on the main data table and the floating table to obtain a comparison result, and the floating table is displayed according to the comparison result. The comparison result is used to indicate whether there is mutually exclusive data in the floating table and the main data table. The mutually exclusive data is data with the same primary key but different values.

[0020] Optionally, displaying the floating table based on the comparison result includes:

[0021] If the comparison result indicates that there is no mutually exclusive data in the floating table and the main data table, then the floating table is displayed according to the first rendering method;

[0022] If the comparison result indicates that there is mutually exclusive data in the floating table and the main data table, then the floating table is displayed according to the second rendering method, in which the display attributes of mutually exclusive data are different from those of other data.

[0023] Optionally, the display attributes include at least one of the following: color, font, and background.

[0024] Optionally, obtaining the second filter content in response to an operation on the master data table includes:

[0025] In response to a click operation on data in the master data table, obtain the current position and duration of the cursor.

[0026] If the dwell time is greater than or equal to the preset time, then the target field and target field value corresponding to the current location are obtained, and the second filtering condition is generated based on the target field and the target field value;

[0027] Display multiple display fields, and determine the field selected by the user among the multiple display fields as the second filter field.

[0028] On the other hand, this application provides a data table display device, including:

[0029] The acquisition module is used to acquire the first filter content of the first data table, wherein the first filter content includes the first filter condition and the first display field;

[0030] The filtering module is used to filter the data in the first data table according to the first filtering content, obtain the main data table, and display the main data table;

[0031] The acquisition module is also used to acquire second filter content in response to the operation on the master data table. The second filter content includes a second filter condition and a second display field, and the second filter condition is different from the first filter condition.

[0032] The generation module is used to generate a floating table based on multiple related data tables of the first data table and the second filtering content, and to display the floating table.

[0033] In one possible implementation, the generation module is specifically used for:

[0034] A second data table is determined from the first data table and the plurality of related data tables;

[0035] The second data table is filtered according to the second filtering criteria to obtain the floating table.

[0036] In one possible implementation, the generation module is specifically used for:

[0037] Displays multiple selection controls for the first data table and the plurality of related data tables;

[0038] In response to the user's selection operation of the first selected control among the plurality of selected controls, the data table corresponding to the first selected control is determined as the second data table.

[0039] In one possible implementation, the generation module is specifically used for:

[0040] If the second data table is the same as the first data table, the floating table is displayed according to the first rendering method, in which the display attributes of each data are the same;

[0041] If the second data table is different from the first data table, then a comparison process is performed on the main data table and the floating table to obtain a comparison result, and the floating table is displayed according to the comparison result. The comparison result is used to indicate whether there is mutually exclusive data in the floating table and the main data table. The mutually exclusive data is data with the same primary key but different values.

[0042] In one possible implementation, the generation module is specifically used for:

[0043] If the comparison result indicates that there is no mutually exclusive data in the floating table and the main data table, then the floating table is displayed according to the first rendering method;

[0044] If the comparison result indicates that there is mutually exclusive data in the floating table and the main data table, then the floating table is displayed according to the second rendering method, in which the display attributes of mutually exclusive data are different from those of other data.

[0045] In one possible implementation, the display attributes include at least one of the following: color, font, and background.

[0046] In one possible implementation, the acquisition module is specifically used for:

[0047] In response to a click operation on data in the master data table, obtain the current position and duration of the cursor.

[0048] If the dwell time is greater than or equal to the preset time, then the target field and target field value corresponding to the current location are obtained, and the second filtering condition is generated based on the target field and the target field value;

[0049] Display multiple display fields, and determine the field selected by the user among the multiple display fields as the second filter field.

[0050] A third aspect of this application provides an electronic device comprising:

[0051] Processor and memory;

[0052] The memory stores the instructions that the computer executes;

[0053] The processor executes computer execution instructions stored in memory, causing the electronic device to perform any of the methods in the first aspect.

[0054] A fourth aspect of this application provides a computer-readable storage medium storing computer-executable instructions, which, when executed by a processor, are used to determine a driver for implementing a hardware peripheral as described in any of the first aspects.

[0055] A fifth aspect of this application provides a computer program product including a computer program that, when executed by a processor, implements the method as described in any of the first aspects.

[0056] This embodiment provides a method, apparatus, device, and storage medium for displaying a data table. The method involves: acquiring first filtering content from a first data table; filtering the data in the first data table according to the first filtering content to obtain a master data table, and displaying the master data table; acquiring second filtering content in response to operations on the master data table; generating and displaying a floating table based on multiple related data tables of the first data table and the second filtering content. This method, by re-selecting data sources and forming a floating table based on the master data table formed after the initial filtering, allows simultaneous viewing of data tables obtained from both filtering processes, achieving dynamic display of the data table and improving the efficiency of data table filtering. Attached Figure Description

[0057] The accompanying drawings, which are incorporated in and form part of this specification, illustrate embodiments consistent with this application and, together with the description, serve to explain the principles of this application.

[0058] Figure 1 A diagram illustrating a specific application scenario of the data table display method provided in this application;

[0059] Figure 2a The method flow for displaying the data table provided in the embodiments of this application Figure 1 ;

[0060] Figure 2b This is the main data table for the data tables provided in the embodiments of this application;

[0061] Figure 2c A schematic diagram of the data table provided for embodiments of this application. Figure 1 ;

[0062] Figure 2d Schematic diagram 2 of the data table provided for the embodiments of this application;

[0063] Figure 3a Flowchart 2 shows the method for displaying the data table provided in the embodiments of this application;

[0064] Figure 3b A schematic diagram of the control for the data table provided in the embodiments of this application;

[0065] Figure 3c Schematic diagram three of the data table provided for the embodiments of this application;

[0066] Figure 3d A schematic diagram of the data table provided for embodiments of this application. Figure 4 ;

[0067] Figure 4 Flowchart 3 shows the method for displaying the data table provided in the embodiments of this application;

[0068] Figure 5 A schematic diagram of the structure of a data table display device provided in an embodiment of this application;

[0069] Figure 6 This is a schematic diagram of the structure of an electronic device provided in an embodiment of this application.

[0070] The accompanying drawings illustrate specific embodiments of this application, which will be described in more detail below. These drawings and descriptions are not intended to limit the scope of the concept in any way, but rather to illustrate the concept of this application to those skilled in the art through reference to particular embodiments. Detailed Implementation

[0071] Exemplary embodiments will now be described in detail, examples of which are illustrated in the accompanying drawings. When the following description relates to the drawings, unless otherwise indicated, the same numbers in different drawings denote the same or similar elements. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with this application. Rather, they are merely examples of apparatuses and methods consistent with some aspects of this application as detailed in the appended claims.

[0072] Figure 1 The diagram illustrates a specific application scenario of the data table display method provided in this application. For example... Figure 1 As shown, the application scenario includes a data table interface 100, containing a toolbar 101 and a cell range 102. The toolbar includes filtering and other tools. Taking the filtering tool as an example, when filtering for the specific value of A as A1, cell range 102 displays all data where A is A1. At this point, the user can see data where A is A1 and B is B1 or B2. If the user then wants to view all data where B is B1, they need to exit the A-A1 filter and re-filter for B-B1. In this case, A1 and B1 are non-related fields. This design makes viewing non-related fields inconvenient and prevents the user from viewing the data table obtained from two filters simultaneously.

[0073] Furthermore, if multiple versions of the data table need to be viewed, the user needs to compare them one by one, which takes a long time and the accuracy of manual comparison is low.

[0074] This application provides a method for displaying a data table. This method, after the initial filtering of the data table, forms a master data table. By responding to operations on the master data table, it reselects the data source and forms a floating table. The data tables obtained from the two filtering processes can be viewed simultaneously, thus achieving dynamic display of the data table and improving the efficiency of data table filtering.

[0075] The data table display method provided in this application is intended to solve the above-mentioned technical problems of the prior art.

[0076] The technical solution of this application and how the technical solution of this application solves the above-mentioned technical problems are described in detail below with specific embodiments. These specific embodiments can be combined with each other, and the same or similar concepts or processes may not be described again in some embodiments. The embodiments of this application will now be described with reference to the accompanying drawings.

[0077] Figure 2a The method flow for displaying the data table provided in the embodiments of this application Figure 1 , Figure 2b This is the main data table provided for the data tables in the embodiments of this application. Figure 2c A schematic diagram of the data table provided for embodiments of this application. Figure 1 , Figure 2d Schematic diagram two of the data table provided in the embodiments of this application. For example... Figure 2a , Figure 2b , Figure 2c as well as Figure 2d As shown, the method in this embodiment includes:

[0078] S201. Obtain the first filter content of the first data table, wherein the first filter content includes the first filter condition and the first display field;

[0079] In this embodiment, the first data table is the user's current data source, and the first filter content is the parameter used by the user for the first filter, including the first filter condition and the first display field. Taking the case where the data table displays different types of data in columns as an example, the display field is the header of the first row. Therefore, the first display field belongs to the header, and the number of types in it is less than or equal to the number of types included in the header of the first data table. The first filter condition is the specific value under a certain field. Figure 1 For example, the first filtering condition can be all relevant data corresponding to the value A1 under field A, and the first display field can be one or more of A, B, C, D, E, F, G and H.

[0080] In this embodiment, the first data table can be an Excel spreadsheet, or a spreadsheet based on other formats and software. Obtaining the first filtered content from the first data table is typically achieved using the filter tool in the spreadsheet software's toolbar. After opening the filter tool, the controls corresponding to the first filter condition and the first display field are selected.

[0081] S202. Filter the data in the first data table according to the first filtering content to obtain the main data table, and display the main data table;

[0082] In this embodiment, after the spreadsheet software responds to the selection operation of the control corresponding to the first filter condition and the first display field in the filtering tool, the cell range will exclude data other than the first filter condition and the first display field, and only display data that meets the first filter condition and the first display field. At this point, the data table is the main data table. For example, in... Figure 1 In the data table shown, when the first filter condition is A=A1, and the first display fields are A, B, C, and D, the data in the first data table is filtered according to the first filter content, resulting in the main data table as shown. Figure 2b As shown.

[0083] S203. In response to the operation on the master data table, obtain the second filter content, which includes the second filter condition and the second display field, and the second filter condition is different from the first filter condition.

[0084] In this embodiment, in response to operations on the master data table, that is, after obtaining the master data table, further data is collected on user operations on the master data table. This operation is a secondary filtering operation performed by the user on the master data table, after which the second filtered content can be obtained. This operation can be mouse hover or keyboard selection. The second filtered content is the same as the first filtered content, including the second filtered conditions and the second displayed field. After performing the secondary filtering operation on the master data table, a new data table is obtained. Therefore, to distinguish between the two, the second filtered conditions are different from the first filtered conditions.

[0085] Meanwhile, the second filter condition must be a value from the main data table, because users operate on the main data table and cannot select data outside of it. The number of fields displayed in the second selection can be more than the number displayed in the first selection; when selecting a field in the second selection, a selection control based on fields from the first data table can be provided to the user.

[0086] Those skilled in the art will understand that a user's operation on the master data table aimed at obtaining the second filtered content includes, but is not limited to, the aforementioned mouse hovering or keyboard selection, and can also be set to other operations.

[0087] S204. Generate a floating table based on multiple related data tables of the first data table and the second filtering content, and display the floating table.

[0088] In this embodiment, the purpose of obtaining the second filter content is to generate and display a floating table. The floating table at this time is not initially formed based on the main data table, but rather on the first data table as its data source. Multiple related data tables of the first data table refer to different versions of the first data table. For example, a company's production schedule is updated at different times, resulting in multiple versions. The floating table is generated using multiple versions of the production schedule as its data source, allowing selection of one version from these versions as the data source. The advantage of this approach is that it allows for quick viewing and filtering of floating tables generated from different versions, while simultaneously displaying and highlighting differences between the first and main data tables in different versions. After generating the floating table, it is displayed. When the second filter condition is B1, and the second display fields are A, B, C, and F, the following will be generated and displayed: Figure 2c or Figure 2d The floating table 103 is shown. As you can see, the floating table can be positioned within the cell area of ​​the main data table, or it can be scaled up to place the floating table next to the main data table.

[0089] Those skilled in the art will understand that the location of the floating table includes, but is not limited to, the location described above, and may be in other locations or in other forms, such as outside the spreadsheet software interface.

[0090] This embodiment provides a method for displaying a data table. The method involves: obtaining first-filtered content from a first data table; filtering the data in the first data table according to the first-filtered content to obtain a main data table, and then displaying the main data table; in response to operations on the main data table, obtaining second-filtered content; and generating and displaying a floating table based on multiple related data tables of the first data table and the second-filtered content. This method, by forming a main data table after the initial filtering of the data table, and then reselecting data sources to form a floating table in response to operations on the main data table, allows simultaneous viewing of the data tables obtained from both filtering processes, achieving dynamic display of the data table and improving the efficiency of data table filtering.

[0091] Figure 3a Flowchart 2 shows the method for displaying the data table provided in the embodiments of this application. Figure 3b This is a schematic diagram of the control for the data table provided in an embodiment of this application. Figure 3c Schematic diagram three of the data table provided for the embodiments of this application. Figure 3d A schematic diagram of the data table provided for embodiments of this application. Figure 4 .like Figure 3a , Figure 3b , Figure 3c as well as Figure 3d As shown, the method of this embodiment, in Figure 2a , Figure 2b , Figure 2c as well as Figure 2d Based on the illustrated embodiment, the process of generating and displaying a floating table based on multiple related data tables of the first data table and the second filtering content is described in detail.

[0092] S301. Display multiple selected controls for the first data table and multiple related data tables;

[0093] In this embodiment, to obtain data from a source different from the main data table, after obtaining the second filter content, multiple selection controls for the first data table and multiple related data tables are displayed. These selection controls include the data source for generating the floating table, that is, determining one table from the first data table and multiple related data tables as the basis for the floating table. For example... Figure 3b As shown, if the first data table has two versions, namely the first data table A and the first data table B, then multiple selection controls can be used as shown in Figure 104. In this case, the version of the first data table is the first data table A.

[0094] S302. In response to the user's selection operation on the first selected control among multiple selected controls, the data table corresponding to the first selected control is determined as the second data table;

[0095] In this embodiment, after displaying multiple selected controls of the first data table and multiple related data tables, the user's selected control operation is obtained; the control selected by the user at this time is the first selected control. Then, in response to the user's selection operation of the first selected control among the multiple selected controls, the data table corresponding to the first selected control is determined as the second data table. For example... Figure 3b As shown, if the user selects the control corresponding to the first data table B, then the first data table B will be used as the data source for the floating table, i.e., the second data table.

[0096] S303. Filter the second data table according to the second filtering content to obtain a floating table;

[0097] In this embodiment, the second filtering condition is set to B1, and the second display fields are A, B, C, and F. The second data table is then filtered in this way to obtain a floating table.

[0098] S304. If the second data table is the same as the first data table, then the floating table is displayed according to the first rendering method, and the display attributes of each data in the first rendering method are the same.

[0099] In this embodiment, if the version of the first data table is first data table A and the version of the second data table is first data table A, that is, the second data table is the same as the first data table, then there is no data with different values ​​under the same field in the main data table and the floating table. That is, the data is rendered in the same way as the display attributes of each data. This rendering method is the first rendering method.

[0100] Optionally, the display attributes include at least one of the following: color, font, and background.

[0101] In this embodiment, the display attributes of data in the data table include color, font, and background. Therefore, when notifying the user of the existence of mutually exclusive data, one or more of the data's color, font, and background can be changed to make the data more prominent.

[0102] S305. If the second data table is different from the first data table, then the main data table and the floating table are compared to obtain the comparison result.

[0103] In this embodiment, the comparison result is used to indicate whether mutually exclusive data exists in the floating table and the main data table. Mutually exclusive data consists of data with the same primary key but different values. The primary key is the field in the table header where mutually exclusive data exists. For example, if the version of the first data table is first data table A, and the version of the second data table is first data table B, then the second data table is different from the first data table. The values ​​of the first data table B are as follows: Figure 3c As shown, the value of field C in row 6 is C1 in the first data table A and C2 in the first data table B. In this case, in the main data table, the value of field C in row 3 is C1, and in the floating table, the value of field C in row 2 is C2. At this point, the main data table looks like this: Figure 3d As shown in 102, the floating table is as follows Figure 3d As shown in 103.

[0104] Therefore, a comparison process is needed between the master data table and the floating table. This comparison refers to comparing the values ​​at corresponding positions under the same field in the two data tables. However, this "position" doesn't refer to the numerical value's exact location within the master and floating tables, but rather its location within the first data table (A) and the first data table (B). Specifically, it should compare the value corresponding to field C in row 6 of both first data tables. The result will be that the value corresponding to field C in row 6 of the first data table is mutually exclusive; the values ​​in the master and floating tables are different, and this value is located in row 2 of the floating table under field C.

[0105] S306. If the comparison result indicates that there is no mutually exclusive data in the floating table and the main data table, then the floating table is displayed according to the first rendering method.

[0106] S307. If the comparison result indicates that there is mutually exclusive data in the floating table and the main data table, then the floating table is displayed according to the second rendering method. In the second rendering method, the display attributes of mutually exclusive data are different from those of other data.

[0107] In this embodiment, after determining the comparison result—that is, after identifying mutually exclusive data located in the floating table below field C in row 2—the floating table is displayed using the second rendering method. This involves changing the attributes of the mutually exclusive data to display attributes different from those of the main data table before rendering. Figure 3d As shown, the background of the data at that location is changed to a shadow. This is done to remind the user of the existence of mutual exclusion.

[0108] Those skilled in the art will understand that mutually exclusive data includes, but is not limited to, data in the main data table and the floating table that have the same primary key but different values. When different versions of the first data table contain data with the same primary key but different values, and such data is not displayed in both the main data table and the floating table, it can appear in other ways when displayed in the floating table, such as displaying the words "mutually exclusive data exists" below the floating table.

[0109] This embodiment provides a method for displaying a data table. The method involves displaying a first data table and multiple selection controls for multiple related data tables. In response to a user's selection of the first selection control, the data table corresponding to the first selection control is determined as the second data table. The second data table is then filtered according to a second filtering condition to obtain a floating table. If the second data table is the same as the first data table, the floating table is displayed using a first rendering method. If the second data table is different from the first data table, a comparison is performed between the main data table and the floating table to obtain a comparison result. If the comparison result indicates that there is no mutually exclusive data between the floating table and the main data table, the floating table is displayed using the first rendering method. If the comparison result indicates that there is mutually exclusive data between the floating table and the main data table, the floating table is displayed using a second rendering method. This method provides selection controls to allow users to choose the data source for the floating table. When mutually exclusive data exists between the main data table and the floating table due to data sources, the rendering method is changed to remind the user of the existence of mutually exclusive data, making the data source for the floating table more flexible and facilitating user comparison of mutually exclusive data.

[0110] Figure 4 Flowchart 3 shows the method for displaying the data table provided in this application embodiment. For example... Figure 4 As shown, the method of this embodiment, in Figure 2a , Figure 2b , Figure 2c as well as Figure 2d Based on the illustrated embodiment, the process of obtaining the second filter content in response to operations on the master data table is described in detail.

[0111] S401. In response to a click operation on data in the master data table, obtain the current position and duration of the cursor.

[0112] In this embodiment, when a user clicks on data in the main data table, a response is required. To avoid accidental clicks, the current cursor position and duration of cursor stay are needed. The current cursor position is used to locate the data the user wants to display in the floating table, and the duration of cursor stay confirms the user's need for the floating table. Clicking can be done with the mouse. This simplifies the process for users to use the filtering function again.

[0113] Those skilled in the art will understand that when users operate on the master data table to generate a floating table, they include, but are not limited to, the operations described above.

[0114] S402. If the dwell time is greater than or equal to the preset time, obtain the target field and target field value corresponding to the current location, and generate a second filtering condition based on the target field and target field value.

[0115] In this embodiment, the user's action is determined to be normal by comparing the cursor dwell time with a preset time. Only when the dwell time is greater than or equal to the preset time is the target field and its value retrieved for the current position, and a second filter condition is generated based on these. If the dwell time is less than the preset time, no additional action is taken. This approach saves computer resources and avoids constantly generating a second filter condition while the user is browsing the data table. It also prevents multiple pop-up fields from interfering with the user's data table usage.

[0116] S403. Display multiple display fields and determine the field selected by the user among the multiple display fields as the second filter field.

[0117] In this embodiment, after determining the second filtering condition, in order to improve the user experience, multiple display fields are provided for the user to choose from, so that the display fields of the floating table are not limited to the display fields of the main data table. The user's choice of display fields is obtained, that is, the second filtering field is determined.

[0118] This embodiment provides a method for displaying a data table. The method responds to click operations on data in the main data table by obtaining the current cursor position and dwell time. If the dwell time is greater than or equal to a preset time, the method obtains the target field and target field value corresponding to the current position, and generates a second filtering condition based on the target field and target field value. Multiple display fields are then displayed, and the field selected by the user among these display fields is determined as the second filtering field. This method confirms the user's need to display a floating table by using the current cursor position and dwell time, and provides multiple display fields for the user to choose from, making it convenient and flexible for the user to confirm the second filtering content, while avoiding waste of computer resources.

[0119] Figure 5 This is a schematic diagram of a data table display device provided in an embodiment of this application. The device in this embodiment can be in the form of software and / or hardware. Figure 5 As shown in the figure, an embodiment of this application provides a data table display device 500, including an acquisition module 501, a filtering module 502, and a generation module 503.

[0120] The acquisition module 501 is used to acquire the first filter content of the first data table, wherein the first filter content includes the first filter condition and the first display field;

[0121] The filtering module 502 is used to filter the data in the first data table according to the first filtering content, obtain the main data table, and display the main data table;

[0122] The acquisition module 501 is also used to retrieve the second filter content in response to the operation on the master data table. The second filter content includes the second filter condition and the second display field, and the second filter condition is different from the first filter condition.

[0123] The generation module 503 is used to generate a floating table based on multiple related data tables of the first data table and the second filtering content, and to display the floating table.

[0124] In one possible implementation, the generation module is specifically used for:

[0125] Determine the second data table from the first data table and multiple related data tables;

[0126] The second data table is filtered based on the second selection criteria to obtain a floating table.

[0127] In one possible implementation, the generation module is specifically used for:

[0128] Displays multiple selected controls for the first data table and multiple related data tables;

[0129] In response to the user's selection of the first selected control among multiple selected controls, the data table corresponding to the first selected control is determined as the second data table.

[0130] In one possible implementation, the generation module is specifically used for:

[0131] If the second data table is the same as the first data table, the floating table is displayed according to the first rendering method, and the display attributes of each data are the same in the first rendering method;

[0132] If the second data table is different from the first data table, a comparison is performed between the main data table and the floating table to obtain the comparison result. The floating table is then displayed based on the comparison result. The comparison result is used to indicate whether there is mutually exclusive data in the floating table and the main data table. Mutually exclusive data is data with the same primary key but different values.

[0133] In one possible implementation, the generation module is specifically used for:

[0134] If the comparison result indicates that there is no mutually exclusive data in the floating table and the main data table, then the floating table is displayed according to the first rendering method;

[0135] If the comparison result indicates that there is mutually exclusive data in the floating table and the main data table, the floating table will be displayed according to the second rendering method, in which the display attributes of mutually exclusive data are different from those of other data.

[0136] In one possible implementation, the display attributes include at least one of the following: color, font, and background.

[0137] In one possible implementation, the acquisition module is specifically used for:

[0138] In response to click operations on data in the master data table, obtain the current position and duration of cursor dwell;

[0139] If the dwell time is greater than or equal to the preset time, the target field and target field value corresponding to the current location are obtained, and a second filtering condition is generated based on the target field and target field value.

[0140] Display multiple display fields and select the field chosen by the user from among the multiple display fields as the second filter field.

[0141] The device for displaying the data table provided in this embodiment can be used to execute the above method embodiment. Its implementation principle and technical effect are similar, and will not be described again here.

[0142] This application provides a schematic diagram of the structure of an electronic device. Please refer to [link / reference]. Figure 6 The electronic device 20 may include a processor 21 and a memory 22. Exemplarily, the processor 21 and the memory 22 are interconnected via a bus 23.

[0143] Memory 22 stores instructions executed by the computer;

[0144] The processor 21 executes computer execution instructions stored in the memory 22, causing the electronic device to perform the data table display method described above.

[0145] It should be understood that the processor 21 described above can be a Central Processing Unit (CPU), or other general-purpose processors, digital signal processors (DSPs), application-specific integrated circuits (ASICs), etc. A general-purpose processor can be a microprocessor or any conventional processor. The steps of the method disclosed in this invention can be directly implemented by a hardware processor, or implemented by a combination of hardware and software modules within the processor. The memory 22 may include high-speed random access memory (RAM), and may also include non-volatile memory (NVM), such as at least one disk storage device, or a USB flash drive, external hard drive, read-only memory, disk, or optical disc, etc.

[0146] This application also provides a computer-readable storage medium storing computer-executable instructions, which are used by a processor to implement a method for displaying a data table.

[0147] This application also provides a computer program product, including a computer program that, when executed by a processor, implements a method for displaying a data table.

[0148] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, data stored, data displayed, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties. Furthermore, the collection, use and processing of the relevant data must comply with the relevant laws, regulations and standards of the relevant countries and regions, and corresponding operation portals are provided for users to choose to authorize or refuse.

[0149] Other embodiments of this application will readily occur to those skilled in the art upon consideration of the specification and practice of the invention disclosed herein. This application is intended to cover any variations, uses, or adaptations of this application that follow the general principles of this application and include common knowledge or customary techniques in the art not disclosed herein. The specification and examples are to be considered exemplary only, and the true scope and spirit of this application are indicated by the following claims.

[0150] It should be understood that this application is not limited to the precise structure described above and shown in the accompanying drawings, and various modifications and changes can be made without departing from its scope. The scope of this application is limited only by the appended claims.

Claims

1. A method for displaying a data table, characterized in that, include: Obtain the first filter content from the first data table, wherein the first filter content includes a first filter condition and a first display field; The data in the first data table is filtered according to the first filtering content to obtain the main data table, and the main data table is displayed. In response to the operation on the master data table, a second filter content is obtained, the second filter content includes a second filter condition and a second display field, and the second filter condition is different from the first filter condition; Based on multiple related data tables of the first data table and the second filtering content, a floating table is generated and displayed; The step of obtaining the second filter content in response to an operation on the master data table includes: In response to a click operation on data in the master data table, the current position and dwell time of the cursor are obtained; if the dwell time is greater than or equal to a preset time, the target field and target field value corresponding to the current position are obtained, and the second filtering condition is generated based on the target field and the target field value; multiple display fields are displayed, and the field selected by the user among the multiple display fields is determined as the second display field.

2. The method according to claim 1, characterized in that, The step of generating a floating table based on multiple related data tables of the first data table and the second filtering content includes: A second data table is determined from the first data table and the plurality of related data tables; The second data table is filtered according to the second filtering criteria to obtain the floating table.

3. The method according to claim 2, characterized in that, Determining the second data table from the first data table and the plurality of related data tables includes: Displays multiple selection controls for the first data table and the plurality of related data tables; In response to the user's selection operation of the first selected control among the plurality of selected controls, the data table corresponding to the first selected control is determined as the second data table.

4. The method according to claim 2 or 3, characterized in that, Displaying the floating table includes: If the second data table is the same as the first data table, the floating table is displayed according to the first rendering method, in which the display attributes of each data are the same; If the second data table is different from the first data table, then a comparison process is performed on the main data table and the floating table to obtain a comparison result, and the floating table is displayed according to the comparison result. The comparison result is used to indicate whether there is mutually exclusive data in the floating table and the main data table. The mutually exclusive data is data with the same primary key but different values.

5. The method according to claim 4, characterized in that, The floating table, as shown in the comparison results, includes: If the comparison result indicates that there is no mutually exclusive data in the floating table and the main data table, then the floating table is displayed according to the first rendering method; If the comparison result indicates that there is mutually exclusive data in the floating table and the main data table, then the floating table is displayed according to the second rendering method, in which the display attributes of mutually exclusive data are different from those of other data.

6. The method according to claim 5, characterized in that, The display attributes include at least one of the following: color, font, and background.

7. A data table display device, characterized in that, include: The acquisition module is used to acquire the first filter content of the first data table, wherein the first filter content includes the first filter condition and the first display field; The filtering module is used to filter the data in the first data table according to the first filtering content, obtain the main data table, and display the main data table; The acquisition module is also used to acquire second filter content in response to the operation on the master data table. The second filter content includes a second filter condition and a second display field, and the second filter condition is different from the first filter condition. The generation module is used to generate a floating table based on multiple related data tables of the first data table and the second filtering content, and to display the floating table; The acquisition module is specifically used for: In response to a click operation on data in the master data table, the current position and dwell time of the cursor are obtained; if the dwell time is greater than or equal to a preset time, the target field and target field value corresponding to the current position are obtained, and the second filtering condition is generated based on the target field and the target field value; multiple display fields are displayed, and the field selected by the user among the multiple display fields is determined as the second display field.

8. An electronic device, comprising: Processor and memory; The memory stores computer-executed instructions; The processor executes computer execution instructions stored in the memory, causing the electronic device to perform the method of any one of claims 1 to 6.

9. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer-executable instructions, which, when executed by a processor, are used to implement a data table display method as described in any one of claims 1 to 6.

10. A computer program product comprising a computer program that, when executed by a processor, implements the method of any one of claims 1 to 6.

Images