CN116186042A - Data table display method, device, equipment and storage medium - Google Patents

Data table display method, device, equipment and storage medium Download PDF

Info

Publication number
CN116186042A
CN116186042A CN202310176209.2A CN202310176209A CN116186042A CN 116186042 A CN116186042 A CN 116186042A CN 202310176209 A CN202310176209 A CN 202310176209A CN 116186042 A CN116186042 A CN 116186042A
Authority
CN
China
Prior art keywords
data table
data
screening
displaying
suspension
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202310176209.2A
Other languages
Chinese (zh)
Inventor
张勤琼
李卓
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Construction Bank Corp
CCB Finetech Co Ltd
Original Assignee
China Construction Bank Corp
CCB Finetech Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by China Construction Bank Corp, CCB Finetech Co Ltd filed Critical China Construction Bank Corp
Priority to CN202310176209.2A priority Critical patent/CN116186042A/en
Publication of CN116186042A publication Critical patent/CN116186042A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/903Querying
    • G06F16/9035Filtering based on additional data, e.g. user or group profiles
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/904Browsing; Visualisation therefor

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Computational Linguistics (AREA)
  • Digital Computer Display Output (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

The application provides a data table display method, device, equipment and storage medium, and relates to the technical field of computers. The method comprises the following steps: acquiring first screening content of a first data table, wherein the first screening content comprises first screening conditions and a first display field; performing data screening on the first data table according to the first screening content to obtain a main data table, and displaying the main data table; responding to the operation of the main data table, and acquiring second screening content, wherein the second screening content comprises second screening conditions and second display fields, and the second screening conditions are different from the first screening conditions; and generating a suspension table according to the plurality of related data tables of the first data table and the second screening content, and displaying the suspension table. The method solves the problem that the prior art does not relate to dynamic data display and multi-field non-associated mixed query of the table.

Description

Data table display method, device, equipment and storage medium
Technical Field
The present disclosure relates to the field of computer technologies, and in particular, to a method, an apparatus, a device, and a storage medium for displaying a data table.
Background
Forms are an important ring in enterprise management, and different enterprises or fields often have different demands on the forms, so that management staff can better make enterprise decisions and management.
Tables are often based on the summarization and processing of data, unlike enterprise reports, which are often used to record the daily management of an enterprise, and are complex in that they must be interactive and able to accommodate the flow between departments and personnel of the enterprise. Because Excel is widely used, powerful, flexible to edit, and can create charts and tables in an Excel file, enterprises often employ Excel to handle tables.
When using Excel tables for screening review, the prior art does not involve dynamic data presentation and multi-field non-associative hybrid queries to the tables.
Disclosure of Invention
The application provides a method, a device, equipment and a storage medium for displaying a data table, which are used for solving the problem that the prior art does not relate to dynamic data display and multi-field non-associated mixed query of the table.
In one aspect, the present application provides a method for displaying a data table, including:
acquiring first screening content of a first data table, wherein the first screening content comprises first screening conditions and a first display field;
performing data screening on the first data table according to the first screening content to obtain a main data table, and displaying the main data table;
responding to the operation of the main data table, and acquiring second screening content, wherein the second screening content comprises second screening conditions and second display fields, and the second screening conditions are different from the first screening conditions;
and generating a suspension table according to the plurality of related data tables of the first data table and the second screening content, and displaying the suspension table.
Optionally, the generating a floating table according to the plurality of related data tables of the first data table and the second filtering content includes:
determining a second data table among the first data table and the plurality of related data tables;
and screening the second data table according to the second screening content to obtain the suspension table.
Optionally, determining a second data table among the first data table and the plurality of related data tables includes:
displaying a plurality of selected controls of the first data table and the plurality of related data tables;
and responding to the selection operation of the user on a first selected control in the plurality of selected controls, and determining the data table corresponding to the first selected control as the second data table.
Optionally, displaying the suspension table includes:
if the second data table is the same as the first data table, displaying the suspension table according to a first rendering mode, wherein the display attribute of each data in the first rendering mode is the same;
and if the second data table is different from the first data table, comparing the main data table with the suspension table to obtain a comparison result, and displaying the suspension table according to the comparison result, wherein the comparison result is used for indicating whether mutually exclusive data exist in the suspension table and the main data table, and the mutually exclusive data are data with the same main key and different values.
Optionally, displaying the suspension table according to the comparison result includes:
if the comparison result indicates that the mutual exclusion data do not exist in the suspension table and the main data table, displaying the suspension table according to a first rendering mode;
and if the comparison result indicates that the mutually exclusive data exists in the suspension table and the main data table, displaying the suspension table according to a second rendering mode, wherein the mutually exclusive data in the second rendering mode is different from other data in display attribute.
Optionally, the display attribute includes at least one of: color, font, and background.
Optionally, the obtaining the second filtering content in response to the operation on the main data table includes:
responding to clicking operation of data in the main data table, and acquiring the current position and the stay time of a cursor;
if the stay time length is greater than or equal to the preset time length, acquiring a target field and a target field value corresponding to the current position, and generating the second screening condition according to the target field and the target field value;
and displaying a plurality of display fields, and determining a field selected by a user from the plurality of display fields as the second screening field.
In another aspect, the present application provides a display device for a data table, including:
the acquisition module is used for acquiring first screening contents of the first data table, wherein the first screening contents comprise first screening conditions and first display fields;
the screening module is used for carrying out data screening on the first data table according to the first screening content to obtain a main data table and displaying the main data table;
the acquisition module is further used for responding to the operation of the main data table to acquire second screening content, wherein the second screening content comprises second screening conditions and second display fields, and the second screening conditions are different from the first screening conditions;
and the generating module is used for generating a suspension table according to the plurality of related data tables of the first data table and the second screening content and displaying the suspension table.
In one possible implementation manner, the generating module is specifically configured to:
determining a second data table among the first data table and the plurality of related data tables;
and screening the second data table according to the second screening content to obtain the suspension table.
In one possible implementation manner, the generating module is specifically configured to:
displaying a plurality of selected controls of the first data table and the plurality of related data tables;
and responding to the selection operation of the user on a first selected control in the plurality of selected controls, and determining the data table corresponding to the first selected control as the second data table.
In one possible implementation manner, the generating module is specifically configured to:
if the second data table is the same as the first data table, displaying the suspension table according to a first rendering mode, wherein the display attribute of each data in the first rendering mode is the same;
and if the second data table is different from the first data table, comparing the main data table with the suspension table to obtain a comparison result, and displaying the suspension table according to the comparison result, wherein the comparison result is used for indicating whether mutually exclusive data exist in the suspension table and the main data table, and the mutually exclusive data are data with the same main key and different values.
In one possible implementation manner, the generating module is specifically configured to:
if the comparison result indicates that the mutual exclusion data do not exist in the suspension table and the main data table, displaying the suspension table according to a first rendering mode;
and if the comparison result indicates that the mutually exclusive data exists in the suspension table and the main data table, displaying the suspension table according to a second rendering mode, wherein the mutually exclusive data in the second rendering mode is different from other data in display attribute.
In a possible implementation manner, the display attribute includes at least one of the following: color, font, and background.
In one possible implementation manner, the acquiring module is specifically configured to:
responding to clicking operation of data in the main data table, and acquiring the current position and the stay time of a cursor;
if the stay time length is greater than or equal to the preset time length, acquiring a target field and a target field value corresponding to the current position, and generating the second screening condition according to the target field and the target field value;
and displaying a plurality of display fields, and determining a field selected by a user from the plurality of display fields as the second screening field.
In a third aspect of the present application, there is provided an electronic device, comprising:
a processor and a memory;
the memory stores computer-executable instructions;
the processor executes computer-executable instructions stored in the memory to cause the electronic device to perform the method of any one of the first aspects.
In a fourth aspect of the present application, there is provided a computer-readable storage medium having stored therein computer-executable instructions which, when executed by a processor, are adapted to carry out a method of determining a driver of a hardware peripheral as in any of the first aspects.
In a fifth aspect of the present application, there is provided a computer program product comprising a computer program which, when executed by a processor, implements the method according to any of the first aspects.
The embodiment provides a method, a device, equipment and a storage medium for displaying a data table, wherein the method comprises the steps of obtaining first screening content of a first data table; performing data screening on the first data table according to the first screening content to obtain a main data table, and displaying the main data table; responding to the operation of the main data table, and acquiring second screening content; and generating a floating table according to the plurality of related data tables of the first data table and the second screening content, and displaying the floating table. According to the method, on the basis of the main data table formed after the data table is screened for the first time, the data sources are selected again by responding to the operation of the main data table to form the suspension table, so that the data table obtained by screening for two times can be checked at the same time, the dynamic display of the data table is completed, and the screening efficiency of the data table is improved.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the application and together with the description, serve to explain the principles of the application.
Fig. 1 is a specific application scenario diagram of a method for displaying a data table provided in the present application;
FIG. 2a is a flowchart showing a method for displaying a data table according to an embodiment of the present application;
FIG. 2b is a primary data table of the data table provided for embodiments of the present application;
FIG. 2c is a diagram I of a data table according to an embodiment of the present application;
FIG. 2d is a second schematic diagram of a data table according to an embodiment of the present disclosure;
FIG. 3a is a flowchart illustrating a method for displaying a data table according to an embodiment of the present disclosure;
FIG. 3b is a control schematic diagram of a data table according to an embodiment of the present disclosure;
FIG. 3c is a third diagram of a data table according to an embodiment of the present disclosure;
FIG. 3d is a fourth schematic diagram of a data table according to an embodiment of the present disclosure;
fig. 4 is a flowchart III of a method for displaying a data table according to an embodiment of the present application;
fig. 5 is a schematic structural diagram of a display device for a data table according to an embodiment of the present application;
fig. 6 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Specific embodiments thereof have been shown by way of example in the drawings and will herein be described in more detail. These drawings and the written description are not intended to limit the scope of the inventive concepts in any way, but to illustrate the concepts of the present application to those skilled in the art by reference to specific embodiments.
Detailed Description
Reference will now be made in detail to exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numbers in different drawings refer to the same or similar elements, unless otherwise indicated. The implementations described in the following exemplary examples are not representative of all implementations consistent with the present application. Rather, they are merely examples of apparatus and methods consistent with some aspects of the present application as detailed in the accompanying claims.
Fig. 1 is a specific application scenario diagram of a method for displaying a data table provided in the present application. As shown in fig. 1, the application scenario includes: a data form interface 100, which contains a toolbar 101 and a cell area 102. Among other things, the toolbar includes screening and other tools. When using the screening tool, taking a case where a specific value of a is A1 as an example, the cell region 102 is displayed as data when all a is A1, and when a is A1, the user can see data in which B is B1 or B2. When the user further wants to view all data when B is B1, he needs to exit the screening for A1 and re-screen B1. At this time, A1 and B1 are non-associated fields. The design makes the process of checking the non-associated fields inconvenient for the user, and the data table obtained by screening twice cannot be checked at the same time.
Meanwhile, if a plurality of versions exist in the data table to be checked, the user is required to compare one by one during checking, the process needs longer time, and the manual comparison precision is lower.
According to the method, after the data table is screened for the first time, the formed main data table is subjected to response to operation on the main data table, the data source is selected again, the suspended table is formed, the data table obtained through screening for two times can be checked at the same time, dynamic display of the data table is completed, and the screening efficiency of the data table is improved.
The display method of the data table aims at solving the technical problems in the prior art.
The following describes the technical solutions of the present application and how the technical solutions of the present application solve the above technical problems in detail with specific embodiments. The following embodiments may be combined with each other, and the same or similar concepts or processes may not be described in detail in some embodiments. Embodiments of the present application will be described below with reference to the accompanying drawings.
Fig. 2a is a flowchart of a method for displaying a data table provided in an embodiment of the present application, fig. 2b is a main data table of a data table provided in an embodiment of the present application, fig. 2c is a schematic diagram of a data table provided in an embodiment of the present application, and fig. 2d is a schematic diagram of a data table provided in an embodiment of the present application. As shown in fig. 2a, 2b, 2c and 2d, the method of the present embodiment includes:
s201, acquiring first screening content of a first data table, wherein the first screening content comprises first screening conditions and a first display field;
in this embodiment, the first data table is a current data source of the user, and the first filtering content is a parameter for the first filtering performed by the user, including a first filtering condition and a first display field. The case that the data table displays different types of data by using columns as units is taken as an example for explanation, the display field is the header of the first row, so that the first display field belongs to the header, and the number of types is less than or equal to the number of types included in the first data table. The first filtering condition is a specific value under a certain field. Taking fig. 1 as an example, the first filtering condition may be all relevant data corresponding to a value A1 under the field a, and the first display field may be one or more of A, B, C, D, E, F, G and H.
In this embodiment, the first data table may be an Excel-based table, or may be a table based on other forms and software. The retrieval of the first screening content of the first data table is typically accomplished by a screening tool in a toolbar of the form software. And after the screening tool is opened, selecting the control corresponding to the first screening condition and the first display field.
S202, carrying out data screening on the first data table according to the first screening content to obtain a main data table, and displaying the main data table;
in this embodiment, after the form software responds to the selection operation performed on the control corresponding to the first screening condition and the first display field in the screening tool, the cell area excludes the data except for the first screening condition and the first display field, and only the data meeting the first screening condition and the first display field is displayed, where the data table is the main data table. For example, in the data table shown in fig. 1, when the first filtering condition is A1 and the first display field is A, B, C and D, the data of the first data table is filtered according to the first filtering content, so as to obtain the main data table as shown in fig. 2 b.
S203, responding to the operation of the main data table, and acquiring second screening contents which comprise second screening conditions and second display fields, wherein the second screening conditions are different from the first screening conditions;
in this embodiment, the operation of the user on the main data table is continuously collected in response to the operation on the main data table, that is, on the basis of obtaining the main data table. The operation is an operation that a user performs secondary screening on the primary data table, and then the secondary screening content can be acquired. The operation may be a hovering of a mouse or a selection of a keyboard. The second filtering content is the same as the first filtering content and comprises second filtering conditions and second display fields. After performing a secondary screening operation on the primary data table, a new data table is obtained. Thus, to distinguish between the two, the second screening conditions are different from the first screening conditions.
Meanwhile, the second filtering condition must be a value in the main data table because the user operates on the main data table and cannot select data other than the main data table. And the number of the second presentation fields can be more than that of the first presentation fields, and the second presentation fields can be provided for a user to select controls according to the fields in the first data table when the second presentation fields are selected.
It will be appreciated by those skilled in the art that the user's operation of the primary data sheet for the purpose of obtaining the second filter content, including but not limited to the above-mentioned hovering of a mouse or selection of a keyboard, may also be configured as other operations.
S204, generating a suspension table according to the plurality of related data tables of the first data table and the second screening content, and displaying the suspension table.
In this embodiment, the purpose of acquiring the second screening content is to produce and display a floating table. The floating tables are first formed not based on the primary data table but on the primary data table as the data source. The plurality of related data tables of the first data table refers to different versions of the data table of the first data table. For example, a production schedule for a business may be updated at different times, so that there are multiple versions. At this time, the suspension table is generated by using the production schedule of the plurality of versions as the data source, and one version of the production schedule of the plurality of versions can be selected as the data source of the suspension table. The method has the advantages that the suspension tables generated by different versions can be quickly checked and screened, and meanwhile, the data with differences between the first data table and the main data table of different versions is displayed and prompted. After the floating tables are generated, the floating tables are displayed. When the second screening condition is B1, the second display field is A, B, C and F, the suspension table 103 shown in fig. 2c or fig. 2d is generated and displayed. It can be seen that the position of the floating tables can be in the cell area of the main data table, or the main data table can be scaled, and the floating tables are placed beside the main data table.
Those skilled in the art will appreciate that the positions of the float table, including but not limited to those described above, may be other positions or in other forms, such as external to the form software interface.
The embodiment provides a display method of a data table, which comprises the steps of obtaining first screening content of a first data table; performing data screening on the first data table according to the first screening content to obtain a main data table, and displaying the main data table; responding to the operation of the main data table, and acquiring second screening content; and generating a floating table according to the plurality of related data tables of the first data table and the second screening content, and displaying the floating table. According to the method, after the data table is screened for the first time, a main data table is formed, and the data sources are selected again through responding to the operation of the main data table to form the suspension table, so that the data table obtained by screening for two times can be checked at the same time, the dynamic display of the data table is completed, and the screening efficiency of the data table is improved.
Fig. 3a is a flowchart of a second method for displaying a data table provided in an embodiment of the present application, fig. 3b is a control schematic diagram of the data table provided in an embodiment of the present application, fig. 3c is a schematic diagram three of the data table provided in an embodiment of the present application, and fig. 3d is a schematic diagram four of the data table provided in an embodiment of the present application. As shown in fig. 3a, 3b, 3c and 3d, the method of the present embodiment is based on the embodiments shown in fig. 2a, 2b, 2c and 2d, and the process of generating and displaying a floating table from a plurality of related data tables of the first data table and the second filtering content is described in detail.
S301, displaying a first data table and a plurality of selected controls of a plurality of related data tables;
in this embodiment, in order to obtain a data source different from the main data table, after obtaining the second filtering content, a plurality of selected controls of the first data table and a plurality of related data tables are displayed. These selected controls include the source of data that generated the floating tables, i.e., one table is determined as the basis of the floating table in the first data table and the plurality of related data tables. If the first data table has two versions, i.e., the first data table a and the first data table B, as shown in fig. 3B, the plurality of selected controls may be shown as 104, where the version of the first data table is the first data table a.
S302, responding to the selection operation of a user on a first selected control in a plurality of selected controls, and determining a data table corresponding to the first selected control as a second data table;
in this embodiment, after a plurality of selected controls of the first data table and the plurality of related data tables are displayed, an operation of selecting a control by a user is obtained, and at this time, the control selected by the user is the first selected control. And then, responding to the selection operation of the user on the first selected control in the plurality of selected controls, and determining the data table corresponding to the first selected control as the second data table. As shown in fig. 3B, if the user selects the control corresponding to the first data table B, the first data table B is used as the data source of the floating table, i.e. the second data table.
S303, screening the second data table according to the second screening content to obtain a suspension table;
in this embodiment, in the second filtering content, the second filtering condition is B1, the second display field is A, B, C and F, and the second data table is filtered to obtain the suspension table.
S304, if the second data table is the same as the first data table, displaying the floating table according to a first rendering mode, wherein the display attribute of each data in the first rendering mode is the same;
in this embodiment, if the version of the first data table is the first data table a, and the version of the second data table is the first data table a, that is, the second data table is the same as the first data table, at this time, the main data table and the floating table do not have data with different values in the same field, that is, rendering is performed in the same manner according to the display attribute of each data, and the rendering manner is the first rendering manner.
Optionally, the display attribute includes at least one of: color, font, and background.
In this embodiment, in the data table, the display attribute of the data includes color, font, and background. Thus, when a user is prompted for the presence of mutually exclusive data, one or more of the color, font, and background of the data may be changed to make the data noticeable.
S305, if the second data table is different from the first data table, comparing the main data table with the suspension table to obtain a comparison result;
in this embodiment, the comparison result is used to indicate whether mutually exclusive data exists in the suspension table and the main data table, where the mutually exclusive data is data with the same main key and different values. The primary key is the field of the header where the mutually exclusive data exists. For example, if the version of the first data table is the first data table a, the version of the second data table is the first data table B, i.e. the second data table is different from the first data table. As shown in fig. 3C, the value of the first data table B is C1 in the first data table a and C2 in the first data table B, which corresponds to the C field of the 6 th row. In this case, in the main data table, the value of the C field in row 3 is C1, and the value of the C field in row 2 in the floating table is C2. At this time, the main data table is shown as 102 in fig. 3d, and the floating table is shown as 103 in fig. 3 d.
Therefore, the main data table and the floating table need to be subjected to comparison processing. The comparison processing herein refers to comparing the values of the corresponding positions in the same field in the two data tables, where the positions are not the positions of the values in the main data table and the floating table, but the positions of the values in the first data table a and the first data table B, that is, the values corresponding to the C field in the 6 th row in the two first data tables should be compared. The comparison result at this time is that the value corresponding to the C field in the 6 th row in the first data table is mutually exclusive data, the values in the main data table and the floating table are different, and the value is under the C field in the 2 nd row in the floating table.
S306, if the comparison result indicates that the mutual exclusion data do not exist in the suspension table and the main data table, displaying the suspension table according to a first rendering mode;
s307, if the comparison result indicates that the mutual exclusion data exists in the floating table and the main data table, the floating table is displayed according to a second rendering mode, and the mutual exclusion data in the second rendering mode is different from other data in display attribute.
In this embodiment, after the comparison result is determined, that is, the mutual exclusion data exists and is located under the 2 nd row C field in the floating table, the floating table is displayed according to the second rendering mode. That is, the attribute of the mutually exclusive data is changed to be different from the display attribute of the main data table, and then rendering is performed, and as shown in fig. 3d, the data background of the position is changed to be shadow. This serves to alert the user to the existence of a mutex effect.
It will be appreciated by those skilled in the art that mutually exclusive data includes, but is not limited to, data having the same primary key and different values in the primary data table and the float table, and that when different versions of the first data table have the same primary key and different values, and such data are not displayed in both the primary data table and the float table, they may appear in other hinting manners when displayed in the float table, such as displaying the "mutually exclusive data present" word below the float table.
The embodiment provides a display method of a data table, which comprises the steps of displaying a first data table and a plurality of selected controls of a plurality of related data tables; responding to the selection operation of a user on a first selected control in a plurality of selected controls, and determining a data table corresponding to the first selected control as a second data table; screening the second data table according to the second screening content to obtain a suspension table; if the second data table is the same as the first data table, displaying the suspension table according to a first rendering mode; if the second data table is different from the first data table, comparing the main data table with the suspension table to obtain a comparison result; if the comparison result indicates that the mutual exclusion data do not exist in the suspension table and the main data table, displaying the suspension table according to a first rendering mode; and if the comparison result indicates that the mutual exclusion data exists in the floating table and the main data table, displaying the floating table according to a second rendering mode. According to the method, the data sources of the floating table are selected by a user through providing the selected control, when the main data table and the floating table have mutually exclusive data due to the data sources, the rendering mode is changed, the user is reminded of the existence of the mutually exclusive data, the data sources of the floating table are more flexible, and meanwhile the user can conveniently check the mutually exclusive data.
Fig. 4 is a flowchart of a method for displaying a data table according to an embodiment of the present application. As shown in fig. 4, the method of the present embodiment, based on the embodiments shown in fig. 2a, 2b, 2c, and 2d, describes in detail a process of acquiring the second screening content in response to an operation on the main data table.
S401, responding to clicking operation of data in a main data table, and acquiring the current position and the stay time of a cursor;
in this embodiment, when the user performs a click operation on data in the main data table, it is necessary to respond to this operation. In order to avoid misoperation of a user, the current position and the stay time of the cursor need to be acquired. And positioning data which the user wants to display the hover table according to the current position of the cursor, and determining that the user has a requirement for displaying the hover table according to the stay time. The user can be realized by a mouse when clicking. This may simplify the flow of the user re-using the screening function.
Those skilled in the art will appreciate that the user may operate on the master data table to generate a floating table, including but not limited to the operations described above.
S402, if the stay time length is greater than or equal to the preset time length, acquiring a target field and a target field value corresponding to the current position, and generating a second screening condition according to the target field and the target field value;
in this embodiment, it is determined that the user is not operating by mistake by comparing the stay time of the cursor with the preset time. And when the stay time length is greater than or equal to the preset time length, acquiring the target field and the value of the target field corresponding to the current position, and generating a second screening condition according to the target field and the value of the target field. When the stay time is less than the preset time, no additional operation is performed. The method has the advantages of saving the resources of the computer and avoiding that the user generates the second screening condition at any moment when browsing the data table. And simultaneously popping up a selection window of a plurality of display fields, thereby disturbing the user to use the data table.
S403, displaying a plurality of display fields, and determining the field selected by the user from the plurality of display fields as a second screening field.
In this embodiment, after the second filtering condition is determined, in order to improve the use experience of the user, a plurality of display fields are provided for the user to select, so that the display fields of the floating table are not limited to the display fields of the main data table, and the selection of the user to the display fields is obtained, that is, the second filtering field is determined.
The embodiment provides a display method of a data table, which comprises the steps of responding to clicking operation of data in a main data table to obtain the current position and the stay time of a cursor; if the stay time length is greater than or equal to the preset time length, acquiring a target field and a target field value corresponding to the current position, and generating a second screening condition according to the target field and the target field value; and displaying the plurality of presentation fields, and determining a field selected by a user from the plurality of presentation fields as a second screening field. According to the method, the requirement of the user for displaying the suspension table is confirmed through the current position and the stay time of the cursor, and a plurality of display fields are provided for the user to select, so that the user can conveniently and flexibly confirm the second screening content, and meanwhile, the waste of computer resources is avoided.
Fig. 5 is a schematic structural diagram of a display device for a data table according to an embodiment of the present application. The apparatus of this embodiment may be in the form of software and/or hardware. As shown in fig. 5, a display device 500 for a data table provided in an embodiment of the present application includes an obtaining module 501, a screening module 502 and a generating module 503,
an obtaining module 501, configured to obtain first filtering content of a first data table, where the first filtering content includes a first filtering condition and a first display field;
the screening module 502 is configured to perform data screening on the first data table according to the first screening content to obtain a main data table, and display the main data table;
the obtaining module 501 is further configured to obtain second screening content in response to an operation on the main data table, where the second screening content includes a second screening condition and a second display field, and the second screening condition is different from the first screening condition;
a generating module 503, configured to generate a floating table according to the plurality of related data tables and the second filtering content of the first data table, and display the floating table.
In one possible implementation manner, the generating module is specifically configured to:
determining a second data table among the first data table and the plurality of related data tables;
and screening the second data table according to the second screening content to obtain a suspension table.
In one possible implementation manner, the generating module is specifically configured to:
displaying a first data table and a plurality of selected controls of a plurality of related data tables;
and responding to the selected operation of the user on the first selected control in the plurality of selected controls, and determining the data table corresponding to the first selected control as the second data table.
In one possible implementation manner, the generating module is specifically configured to:
if the second data table is the same as the first data table, displaying the suspension table according to a first rendering mode, wherein the display attribute of each data in the first rendering mode is the same;
if the second data table is different from the first data table, comparing the main data table with the suspension table to obtain a comparison result, displaying the suspension table according to the comparison result, wherein the comparison result is used for indicating whether mutually exclusive data exist in the suspension table and the main data table, and the mutually exclusive data are the data with the same main key and different values.
In one possible implementation manner, the generating module is specifically configured to:
if the comparison result indicates that the mutual exclusion data do not exist in the suspension table and the main data table, displaying the suspension table according to a first rendering mode;
if the comparison result indicates that the mutual exclusion data exists in the floating table and the main data table, the floating table is displayed according to a second rendering mode, and the mutual exclusion data in the second rendering mode is different from other data in display attribute.
In one possible implementation, the display attribute includes at least one of: color, font, and background.
In one possible implementation manner, the acquiring module is specifically configured to:
responding to clicking operation of data in a main data table, and acquiring the current position and the stay time of a cursor;
if the stay time length is greater than or equal to the preset time length, acquiring a target field and a target field value corresponding to the current position, and generating a second screening condition according to the target field and the target field value;
and displaying the plurality of presentation fields, and determining a field selected by a user from the plurality of presentation fields as a second screening field.
The device for displaying the data table provided in the embodiment may be used to execute the above method embodiment, and its implementation principle and technical effects are similar, and this embodiment will not be described herein again.
An embodiment of the present application provides a schematic structural diagram of an electronic device, referring to fig. 6, the electronic device 20 may include a processor 21 and a memory 22. The processor 21, the memory 22, and the like are illustratively interconnected by a bus 23.
Memory 22 stores computer-executable instructions;
the processor 21 executes computer-executable instructions stored in the memory 22 to cause the electronic device to perform the method of presentation of a data table as described above.
It should be understood that the processor 21 may be a central processing unit (in english: central Processing Unit, abbreviated as CPU), or may be other general purpose processors, digital signal processors (in english: digital Signal Processor, abbreviated as DSP), application specific integrated circuits (in english: application Specific Integrated Circuit, abbreviated as ASIC), or the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of a method disclosed in connection with the present invention may be embodied directly in a hardware processor for execution, or in a combination of hardware and software modules in a processor for execution. The memory 22 may include a high-speed random access memory (in english: random Access Memory, abbreviated as RAM), and may further include a Non-volatile memory (in english: NVM), such as at least one magnetic disk memory, and may also be a U-disk, a removable hard disk, a read-only memory, a magnetic disk, or an optical disk.
The embodiment of the application correspondingly provides a computer readable storage medium, wherein computer execution instructions are stored in the computer readable storage medium, and the computer execution instructions are used for realizing the display method of the data table when being executed by the processor.
The embodiment of the application correspondingly provides a computer program product, which comprises a computer program, and the computer program realizes the display method of the data table when being executed by a processor.
It should be noted that, the user information (including but not limited to user equipment information, user personal information, etc.) and the data (including but not limited to data for analysis, stored data, presented data, etc.) related to the present application are information and data authorized by the user or fully authorized by each party, and the collection, use and processing of the related data need to comply with the related laws and regulations and standards of the related country and region, and provide corresponding operation entries for the user to select authorization or rejection.
Other embodiments of the present application will be apparent to those skilled in the art from consideration of the specification and practice of the invention disclosed herein. This application is intended to cover any variations, uses, or adaptations of the application following, in general, the principles of the application and including such departures from the present disclosure as come within known or customary practice within the art to which the application pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the application being indicated by the following claims.
It is to be understood that the present application is not limited to the precise arrangements and instrumentalities shown in the drawings, which have been described above, and that various modifications and changes may be effected without departing from the scope thereof. The scope of the application is limited only by the appended claims.

Claims (11)

1. A method for displaying a data table, comprising:
acquiring first screening content of a first data table, wherein the first screening content comprises first screening conditions and a first display field;
performing data screening on the first data table according to the first screening content to obtain a main data table, and displaying the main data table;
responding to the operation of the main data table, and acquiring second screening content, wherein the second screening content comprises second screening conditions and second display fields, and the second screening conditions are different from the first screening conditions;
and generating a suspension table according to the plurality of related data tables of the first data table and the second screening content, and displaying the suspension table.
2. The method of claim 1, wherein generating a floating table from the plurality of related data tables of the first data table and the second filtering content comprises:
determining a second data table among the first data table and the plurality of related data tables;
and screening the second data table according to the second screening content to obtain the suspension table.
3. The method of claim 2, wherein determining a second data table among the first data table and the plurality of related data tables comprises:
displaying a plurality of selected controls of the first data table and the plurality of related data tables;
and responding to the selection operation of the user on a first selected control in the plurality of selected controls, and determining the data table corresponding to the first selected control as the second data table.
4. A method according to claim 2 or 3, wherein displaying the suspension table comprises:
if the second data table is the same as the first data table, displaying the suspension table according to a first rendering mode, wherein the display attribute of each data in the first rendering mode is the same;
and if the second data table is different from the first data table, comparing the main data table with the suspension table to obtain a comparison result, and displaying the suspension table according to the comparison result, wherein the comparison result is used for indicating whether mutually exclusive data exist in the suspension table and the main data table, and the mutually exclusive data are data with the same main key and different values.
5. The method of claim 4, wherein displaying the levitation list based on the comparison result comprises:
if the comparison result indicates that the mutual exclusion data do not exist in the suspension table and the main data table, displaying the suspension table according to a first rendering mode;
and if the comparison result indicates that the mutually exclusive data exists in the suspension table and the main data table, displaying the suspension table according to a second rendering mode, wherein the mutually exclusive data in the second rendering mode is different from other data in display attribute.
6. The method of claim 5, wherein the display attributes comprise at least one of: color, font, and background.
7. The method of any of claims 1-6, wherein the obtaining second screening content in response to the operation on the master data table comprises:
responding to clicking operation of data in the main data table, and acquiring the current position and the stay time of a cursor;
if the stay time length is greater than or equal to the preset time length, acquiring a target field and a target field value corresponding to the current position, and generating the second screening condition according to the target field and the target field value;
and displaying a plurality of display fields, and determining a field selected by a user from the plurality of display fields as the second screening field.
8. A display device for a data sheet, comprising:
the acquisition module is used for acquiring first screening contents of the first data table, wherein the first screening contents comprise first screening conditions and first display fields;
the screening module is used for carrying out data screening on the first data table according to the first screening content to obtain a main data table and displaying the main data table;
the acquisition module is further used for responding to the operation of the main data table to acquire second screening content, wherein the second screening content comprises second screening conditions and second display fields, and the second screening conditions are different from the first screening conditions;
and the generating module is used for generating a suspension table according to the plurality of related data tables of the first data table and the second screening content and displaying the suspension table.
9. An electronic device, comprising: a processor and a memory;
the memory stores computer-executable instructions;
the processor executing computer-executable instructions stored in the memory to cause the electronic device to perform the method of any one of claims 1 to 7.
10. A computer readable storage medium, wherein computer executable instructions are stored in the computer readable storage medium, the computer executable instructions when executed by a processor are for implementing a method of exposing a data table according to any of claims 1 to 7.
11. A computer program product comprising a computer program which, when executed by a processor, implements the method of any of claims 1 to 7.
CN202310176209.2A 2023-02-27 2023-02-27 Data table display method, device, equipment and storage medium Pending CN116186042A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310176209.2A CN116186042A (en) 2023-02-27 2023-02-27 Data table display method, device, equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310176209.2A CN116186042A (en) 2023-02-27 2023-02-27 Data table display method, device, equipment and storage medium

Publications (1)

Publication Number Publication Date
CN116186042A true CN116186042A (en) 2023-05-30

Family

ID=86434316

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310176209.2A Pending CN116186042A (en) 2023-02-27 2023-02-27 Data table display method, device, equipment and storage medium

Country Status (1)

Country Link
CN (1) CN116186042A (en)

Similar Documents

Publication Publication Date Title
CN109992589B (en) Method, device, server and medium for generating SQL (structured query language) statements based on visual page
US11663229B2 (en) System and user interfaces for searching resources and related documents using data structures
US8230322B2 (en) Electronic spreadsheet for displaying and/or hiding a range of cells
US8095867B2 (en) System and computer program product for copying and pasting displayed elements of a range of cells in an electronic spreadsheet
Matejka et al. Patina: Dynamic heatmaps for visualizing application usage
US20020091728A1 (en) Multidimensional electronic spreadsheet system and method
KR101794373B1 (en) Temporary formatting and charting of selected data
US11341314B2 (en) Method for managing and selectively arranging sets of multiple documents and pages within documents
US20210224328A1 (en) Data visualization tool with guided visualization creation and secure publication features, and graphical user interface thereof
US20090059305A1 (en) Apparatus and method for integrating print preview with data modeling document editing
CA2823832C (en) A method for multiple pass symbol and components-based visual object searching of documents
US7590933B2 (en) Method for displaying an annotated file
US7146561B2 (en) Method and system in an electronic spreadsheet for comparing series of cells
US8375324B1 (en) Computer-implemented document manager application enabler system and method
US20030188258A1 (en) System and method in an electronic spreadsheet for displaying and/or hiding range of cells
AU2017218166A1 (en) Method of computerized presentation of a document set view for auditing information and managing sets of multiple documents and pages
CN116186042A (en) Data table display method, device, equipment and storage medium
CN109213979B (en) Method and device for screening electronic forms, electronic equipment and storage medium
CN114238724A (en) Data visualization method and device
WO1997021176A1 (en) A multidimensional electronic spreadsheet system and method
US20070156775A1 (en) Metadata transformation in copy and paste scenarios between heterogeneous applications
KR20010038078A (en) Method and apparatus for generating patent map
Creed et al. Towards a graphical grammar for task analysis visualization
CN118153496A (en) FPGA architecture visualization method
TW201737121A (en) Data acquisition and analysis system comprising a database and a client-end webpage program having an intuitive operation interface

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination