Table field screening method, device, computer equipment and storage medium

Abstract

The embodiment of the present invention discloses a table field screening method, device, computer equipment and storage medium, which belongs to the field of big data technology and can solve the problem of slow response of big data table field screening. The method includes: pre-setting the attributes of the field; receiving a filtering request for the field sent by the user, and judging whether the field has a value range filtering option enabled according to the attributes of the field; if the field has a value range filtering option enabled, querying the display value of the field according to the value range table; displaying the display value of the field to the user for the user to filter; and filtering the data under the field according to the implicit value corresponding to the display value selected by the user. Since the display value of the field is determined by the preset value range table for the user to filter, there is no need to scan all the values ​​of the field, and the response speed is faster. At the same time, displaying the display value of the field is also convenient for the user to identify.

Description

Technical Field

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

[0002] Tables are widely used in data statistics, and common spreadsheet tools include Excel and Superset. To facilitate statistics, tables often have a field filtering function. The existing field filtering function is implemented as follows: when the user selects a field to be filtered, the spreadsheet tool scans all values ​​in the field and returns them after deleting duplicates. This technical solution has several drawbacks:

[0003] 1. Full table scans are not a problem when the data volume is relatively small, but in large data scenarios with hundreds of millions of data points, the response time is extremely slow and affects the user experience.

[0004] 2. Hidden values ​​are usually filled in the form. The values ​​filtered by the above method are implicit values, and users cannot know their meaning. Summary of the Invention

[0005] The embodiments of the present invention provide a table field screening method, apparatus, computer device and storage medium, aiming to solve the problems of existing table field screening methods such as large computational complexity, long response time and difficulty for users to identify the screening content.

[0006] In a first aspect, an embodiment of the present invention provides a table field screening method, which includes:

[0007] Set the attributes of the field in advance;

[0008] Receive a filter request for a field from a user, and determine whether a value range filter option is enabled for the field based on the attributes of the field;

[0009] If the value range filter option is enabled for the field, the display value of the field is queried according to the value range table;

[0010] Displaying the display value of the field to the user for filtering;

[0011] The data under the field is filtered according to the implicit value corresponding to the displayed value selected by the user.

[0012] In a second aspect, an embodiment of the present invention further provides a table field screening device, comprising:

[0013] A first setting unit, used to pre-set attributes of a field;

[0014] A first judgment unit is configured to receive a field filtering request sent by a user and judge whether a value range filtering option is enabled for the field according to the attributes of the field;

[0015] A query unit, configured to query the display value of the field according to the value range table if a value range filtering option is enabled for the field;

[0016] A display unit, used to display the display value of the field to the user for the user to filter;

[0017] The first filtering unit is used to filter the data under the field according to the implicit value corresponding to the displayed value selected by the user.

[0018] In a third aspect, an embodiment of the present invention further provides a computer device, which includes a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the above method when executing the computer program.

[0019] In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, wherein the storage medium stores a computer program, and the computer program can implement the above method when executed by a processor.

[0020] An embodiment of the present invention provides a table field screening method, device, computer equipment and storage medium. The method includes: pre-setting the attributes of the field; receiving a filtering request for the field sent by the user, and judging whether the field has a value range filtering option enabled based on the attributes of the field; if the field has a value range filtering option enabled, querying the display value of the field based on the value range table; displaying the display value of the field to the user for filtering; and filtering the data under the field based on the implicit value corresponding to the display value selected by the user. Since the embodiment of the present invention determines the display value of the field for user filtering through a preset value range table, the response speed is faster than the existing method of scanning all field values ​​and removing duplicates. At the same time, displaying the display value of the field is also convenient for users to identify. BRIEF DESCRIPTION OF THE DRAWINGS

[0021] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0022] Figure 1 A flowchart of a table field screening method provided by an embodiment of the present invention;

[0023] Figure 2A schematic diagram of a sub-process of a table field screening method provided by an embodiment of the present invention;

[0024] Figure 3 A schematic diagram of a sub-process of a table field screening method provided by an embodiment of the present invention;

[0025] Figure 4 A schematic diagram of a sub-process of a table field screening method provided by an embodiment of the present invention;

[0026] Figure 5 A schematic diagram of a sub-process of a table field screening method provided by an embodiment of the present invention;

[0027] Figure 6 A flowchart of a table field screening method provided by another embodiment of the present invention;

[0028] Figure 7 A schematic block diagram of a table field screening device provided by an embodiment of the present invention;

[0029] Figure 8 A schematic block diagram of a first setting unit of a table field screening device provided by an embodiment of the present invention;

[0030] Figure 9 A schematic block diagram of a second setting unit of a table field screening device provided by an embodiment of the present invention;

[0031] Figure 10 A schematic block diagram of a first acquisition unit of a table field screening device provided by an embodiment of the present invention;

[0032] Figure 11 A schematic block diagram of a first judgment unit of a table field screening device provided by an embodiment of the present invention;

[0033] Figure 12 A schematic block diagram of a display unit of a table field screening device provided by an embodiment of the present invention;

[0034] Figure 13 A schematic block diagram of a table field screening device provided in another embodiment of the present invention;

[0035] Figure 14 A schematic block diagram of a computer device provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0036] The following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of them. All other embodiments obtained by ordinary technicians in this field based on the embodiments of the present invention without making any creative efforts shall fall within the scope of protection of the present invention.

[0037] It will be understood that when used in this specification and the appended claims, the terms “comprises” and “comprising” indicate the presence of described features, integers, steps, operations, elements and / or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components and / or groups thereof.

[0038] It should also be understood that the terminology used in this specification is for the purpose of describing particular embodiments only and is not intended to limit the present invention. As used in the specification and appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms unless the context clearly indicates otherwise.

[0039] It should be further understood that the term "and / or" used in the present description and the appended claims refers to and includes any and all possible combinations of one or more of the associated listed items.

[0040] As used in this specification and the appended claims, the term "if" can be interpreted as "when" or "upon" or "in response to determining" or "in response to detecting," depending on the context. Similarly, the phrase "if it is determined" or "if [described condition or event] is detected" can be interpreted as meaning "upon determination" or "in response to determining" or "upon detection of [described condition or event]" or "in response to detecting [described condition or event]," depending on the context.

[0041] See also Figure 1 , Figure 1 This is a flow chart of a table field screening method provided by an embodiment of the present invention. This method belongs to the field of big data technology and can solve the problem of slow response in big data table field screening. As shown in the figure, the method includes the following steps S1-S5.

[0042] S1, set the attributes of the field in advance.

[0043] A field represents a variable associated with an object or class. In a table, the columns are called fields, and each field contains information about a specific topic. For example, in an address book table, the name and phone number are attributes shared by all rows in the table, so these columns are called the name field and the phone number field.

[0044] In a specific implementation, the attributes of the field are set in advance. That is, the terminal sets the attributes of the field according to the user's instructions. In an embodiment of the present invention, the attributes of the field include a value range filtering option. The setting of the attributes of the field includes whether to enable the value range filtering option.

[0045] See also Figure 2 In one embodiment, the above steps include the following steps S11-S12.

[0046] S11, setting attributes of the field according to the received field attribute setting instruction, wherein the attributes of the field include a value range filtering option, and the value range filtering option includes on and off.

[0047] In a specific implementation, the attributes of the field include whether to enable a value range filtering option, and the value range filtering option includes on and off. If a field attribute setting instruction sent by a user is received, the attributes of the field are set according to the field attribute setting instruction, that is, the user sets whether to enable the value range filtering option of the field.

[0048] In one embodiment, the field attribute setting instruction includes a field ID and an attribute setting value, and the value range filtering option of the field attribute includes a characteristic value.

[0049] See also Figure 3 The above step S11 specifically includes the following steps S111-S112.

[0050] S111: Determine the target field according to the field ID.

[0051] In a specific implementation, the field ID is used to identify the field. Each field has a field ID and the field IDs of the fields are different. In this embodiment, the target field is determined according to the field ID.

[0052] S112: Setting the characteristic value of the value range screening option of the attribute of the target field as the attribute setting value.

[0053] In a specific implementation, the characteristic value of the value range screening option of the attribute of the target field is set as the attribute setting value.

[0054] For example, if the attribute setting value is 1, the characteristic value of the value range screening option of the attribute of the target field is set to 1.

[0055] It should be noted that, in this embodiment, the characteristic value of the value range filtering option is 1, indicating that the value range filtering option of the field is enabled; the characteristic value of the value range filtering option is 0, indicating that the value range filtering option of the field is disabled.

[0056] S12, if the value range filtering option of the attribute of the field is set to be on, all implicit values ​​of the field and the display values ​​corresponding to the implicit values ​​are obtained, and all implicit values ​​of the field and the display values ​​corresponding to the implicit values ​​are stored in a preset value range table.

[0057] In a specific implementation, if the value range filtering option of the attribute of the field is set to on, all implicit values ​​of the field and the display values ​​corresponding to the implicit values ​​are obtained, and all implicit values ​​of the field and the display values ​​corresponding to the implicit values ​​are stored in a preset value range table.

[0058] It should be noted that the implicit value of a field refers to the actual value recorded in the field. The implicit value is for computer recording. The displayed value of a field refers to the actual meaning of the implicit value. The displayed value is for user identification.

[0059] For example, in one embodiment, the field is specifically a gender field, and the implicit values ​​of the gender field are 1 and 2, where the display value of 1 is male and the display value of 2 is female.

[0060] See also Figure 4 In one embodiment, the above step S12 specifically includes the following steps S121-S122.

[0061] S121: Acquire all implicit values ​​of the field, and delete duplicate implicit values ​​among all implicit values ​​of the field.

[0062] In a specific implementation, all implicit values ​​of the field are obtained, and then repeated implicit values ​​in the obtained implicit values ​​are deleted.

[0063] For example, in one embodiment, the implicit values ​​of the field include: 1, 1, 2, and 2. Then, the repeated 1 and 2 are deleted, and the implicit values ​​of the field are finally obtained as 1 and 2.

[0064] S122: Determine the display value corresponding to the implicit value of the field according to a preset implicit value-display value comparison table.

[0065] The correspondence between implicit values ​​and displayed values ​​is set by the data administrator. The data administrator pre-stores an implicit value-displayed value comparison table in the terminal. The terminal determines the displayed value corresponding to the implicit value of the field based on the implicit value-displayed value comparison table.

[0066] S2: Receive a field filtering request sent by a user, and determine whether a value range filtering option is enabled for the field according to the attributes of the field.

[0067] In a specific implementation, if a filter request for a field is received from a user, it is determined whether a value range filter option is enabled for the field according to the attributes of the field.

[0068] See also Figure 5 In one embodiment, the above step S2 specifically includes S21-S23.

[0069] S21, determining whether the characteristic value of the value range screening option of the attribute of the field is a preset first characteristic value.

[0070] In a specific implementation, it is determined whether the characteristic value of the value range screening option of the attribute of the field is a preset first characteristic value.

[0071] In this embodiment, the first characteristic value is 1, that is, it is determined whether the characteristic value of the value range screening option of the attribute of the field is 1.

[0072] It should be noted that, in this embodiment, the characteristic value of the value range filtering option is 1, indicating that the value range filtering option of the field is enabled; the characteristic value of the value range filtering option is 0, indicating that the value range filtering option of the field is disabled.

[0073] S22: If the characteristic value of the value range filtering option of the attribute of the field is a preset first characteristic value, it is determined that the value range filtering option is enabled for the field.

[0074] S23: If the characteristic value of the value range filtering option of the attribute of the field is not a preset first characteristic value, it is determined that the value range filtering option is not enabled for the field.

[0075] S3. If the value range filtering option is enabled for the field, the display value of the field is queried according to the value range table.

[0076] In a specific implementation, if the value range filtering option is enabled for the field, the display value of the field is queried according to the value range table.

[0077] S4, displaying the display value of the field to the user for the user to filter.

[0078] In a specific implementation, the display value of the field is displayed to the user for the user to filter.

[0079] For example, in one embodiment, if the display values ​​of the queried field include "male" and "female", then "male" and "female" are displayed to the customer for the user to choose.

[0080] In one embodiment, the above step S4 specifically includes: popping up a value range drop-down list, wherein the value range drop-down list includes the display value of the field.

[0081] For example, in one embodiment, if the display values ​​of the queried field include "male" and "female", "male" and "female" are displayed in a drop-down list for the user to select.

[0082] S5, filtering the data under the field according to the implicit value corresponding to the displayed value selected by the user.

[0083] In a specific implementation, the data under the field is filtered according to the implicit value corresponding to the display value selected by the user, that is, all data in the field whose implicit value is the implicit value corresponding to the display value is filtered out.

[0084] For example, in one embodiment, the field is specifically gender, and the implicit values ​​of gender are 1 and 2, where the display value of 1 is male and the display value of 2 is female. If the user selects the display value of male, all data in the field with the implicit value of 1 will be filtered out.

[0085] By applying the technical solution of the present invention, the attributes of the field are set in advance; a filtering request for the field sent by the user is received, and it is determined whether the field has the value range filtering option enabled based on the attributes of the field; if the value range filtering option is enabled for the field, the display value of the field is queried based on a preset value range table; the display value of the field is displayed to the user for the user to filter; thus, the display value of the field can be determined by the preset value range table for the user to filter, which is faster than the existing method of scanning all field values ​​and removing duplicates. At the same time, displaying the display value of the field also facilitates user identification.

[0086] To illustrate the technical effects of the present invention, let's take an example: a gender field contains 100 million pieces of data. Using existing methods, the existing approach requires scanning all 100 million pieces of data before deduplication, resulting in a large computational load and slow response. However, using the present invention, the displayed value of the field can be obtained simply by querying the range table, reducing computational load and facilitating fast response.

[0087] Figure 6 FIG. 1 is a flow chart of a table field screening method provided by another embodiment of the present invention. Figure 6 As shown, the table field screening method of this embodiment includes steps S51-S57. Steps S51-S55 are similar to steps S1-S5 in the above embodiment and are not repeated here. The following details the additional steps S56-S57 in this embodiment.

[0088] S56: If the value range filtering option is not enabled for the field, a keyword input box pops up for the user to input filtering keywords.

[0089] In a specific implementation, if the value range filtering option is not enabled for the field, a keyword input box will pop up for the user to input filtering keywords.

[0090] S57, receiving a screening keyword input by the user, and screening the data under the field according to the screening keyword.

[0091] In a specific implementation, the filtering keyword input by the user is accepted, and the data under the field is filtered according to the filtering keyword, that is, the data containing the keyword is filtered.

[0092] It should be noted that not all fields are suitable for enabling the value range filter option. For example, ID card fields and mobile phone number fields have almost no possibility of duplication, so it is not suitable to enable the value range filter option.

[0093] Figure 7 FIG. 6 is a schematic block diagram of a table field screening device 60 provided in an embodiment of the present invention. Figure 7 As shown, corresponding to the above table field screening method, the present invention also provides a table field screening device 60. The table field screening device 60 includes a unit for executing the above table field screening method. The table field screening device 60 can be configured in a desktop computer, tablet computer, laptop computer, etc. Specifically, please refer to Figure 7 The table field screening device 60 includes a first setting unit 61 , a first obtaining unit 62 , a first judging unit 63 , a query unit 64 , a display unit 65 and a first screening unit 66 .

[0094] A first setting unit 61 is used to pre-set attributes of a field;

[0095] The first judgment unit 62 is configured to receive a field filtering request sent by a user and determine whether a value range filtering option is enabled for the field according to the attributes of the field;

[0096] A query unit 63 is configured to query the display value of the field according to the value range table if a value range filtering option is enabled for the field;

[0097] a display unit 64, configured to display the display value of the field to the user for filtering;

[0098] The first filtering unit 65 is used to filter the data under the field according to the implicit value corresponding to the displayed value selected by the user.

[0099] In one embodiment, if Figure 8 As shown, the first setting unit 61 includes a second setting unit 611 and a first acquiring unit 612 .

[0100] A second setting unit 611 is configured to set the attributes of a field according to a field attribute setting instruction upon receiving the field attribute setting instruction, wherein the attributes of the field include a value range filtering option, and the value range filtering option includes on and off;

[0101] The first acquisition unit 612 is used to obtain all implicit values ​​of the field and the display values ​​corresponding to the implicit values ​​if the value range filtering option of the attribute of the field is set to be turned on, and store all implicit values ​​of the field and the display values ​​corresponding to the implicit values ​​in a preset value range table.

[0102] In one embodiment, the field attribute setting instruction includes a field ID and an attribute setting value, and the value range screening options of the field attribute include characteristic values, such as Figure 9 As shown, the second setting unit 611 includes a first determining unit 6111 and a third setting unit 6112 .

[0103] A first determining unit 6111 is configured to determine a target field according to the field ID;

[0104] The third setting unit 6112 is configured to set the characteristic value of the value range screening option of the attribute of the target field as the attribute setting value.

[0105] In one embodiment, if Figure 10 As shown, the first acquiring unit 612 includes a second acquiring unit 6211 and a second determining unit 6122 .

[0106] The second acquiring unit 6121 is configured to acquire all implicit values ​​of the field and delete duplicate implicit values ​​from all implicit values ​​of the field;

[0107] The second determining unit 6122 is configured to determine the display value corresponding to the implicit value of the field according to a preset implicit value-display value comparison table.

[0108] In one embodiment, if Figure 11 As shown, the first judgment unit 62 includes a second judgment unit 621 , a first judgment unit 622 and a second judgment unit 623 .

[0109] The second judging unit 621 is configured to judge whether the characteristic value of the value range screening option of the attribute of the field is a preset first characteristic value;

[0110] A first determining unit 622 is configured to determine whether the value range filtering option is enabled for the field if the characteristic value of the value range filtering option of the attribute of the field is a preset first characteristic value;

[0111] The second determining unit 623 is configured to determine that the value range filtering option of the field is not enabled if the characteristic value of the value range filtering option of the attribute of the field is not a preset first characteristic value.

[0112] In one embodiment, if Figure 12 As shown, the display unit 64 includes a first pop-up unit 641 .

[0113] The first pop-up unit 641 is used to pop up a value range drop-down list, and the value range drop-down list contains the display value of the field.

[0114] Figure 13 FIG. 6 is a schematic block diagram of a table field screening device 60 provided in another embodiment of the present invention. Figure 13 As shown, the table field screening device 60 of this embodiment is based on the above embodiment and has a second pop-up unit 66 and a second screening unit 67 added thereto.

[0115] The second pop-up unit 66 is used to pop up a keyword input box for the user to input a filtering keyword if the value range filtering option is not enabled for the field;

[0116] The second screening unit 67 is configured to receive a screening keyword input by a user and screen the data under the field according to the screening keyword.

[0117] It should be noted that those skilled in the art can clearly understand that the specific implementation process of the above-mentioned table field screening device 60 and each unit can refer to the corresponding description in the above-mentioned method embodiment. For the convenience and brevity of description, it will not be repeated here.

[0118] The above-mentioned form field screening device can be implemented in the form of a computer program. The computer program can be used in Figure 14 Runs on the computer equipment shown.

[0119] See also Figure 14 , Figure 14 1 is a schematic block diagram of a computer device provided in an embodiment of the present application. The computer device 500 is a terminal. The terminal can be an electronic device with communication capabilities, such as a smartphone, tablet computer, laptop computer, desktop computer, personal digital assistant, or wearable device.

[0120] See Figure 14 The computer device 500 includes a processor 502 , a memory, and a network interface 505 connected via a system bus 501 , wherein the memory may include a non-volatile storage medium 503 and an internal memory 504 .

[0121] The non-volatile storage medium 503 may store an operating system 5031 and a computer program 5032. When the computer program 5032 is executed, the processor 502 may execute a form field screening method.

[0122] The processor 502 is used to provide computing and control capabilities to support the operation of the entire computer device 500.

[0123] The internal memory 504 provides an environment for the operation of the computer program 5032 in the non-volatile storage medium 503 . When the computer program 5032 is executed by the processor 502 , the processor 502 can execute a form field screening method.

[0124] The network interface 505 is used to communicate with other devices through the network. Figure 14 The structure shown in the figure is merely a block diagram of a portion of the structure related to the solution of the present application, and does not constitute a limitation on the computer device 500 to which the solution of the present application is applied. The specific computer device 500 may include more or fewer components than shown in the figure, or combine certain components, or have a different component arrangement.

[0125] The processor 502 is configured to execute a computer program 5032 stored in the memory to implement the following steps:

[0126] Set the attributes of the field in advance;

[0127] Receive a filter request for a field from a user, and determine whether a value range filter option is enabled for the field based on the attributes of the field;

[0128] If the value range filter option is enabled for the field, the display value of the field is queried according to the value range table;

[0129] Displaying the display value of the field to the user for filtering;

[0130] The data under the field is filtered according to the implicit value corresponding to the displayed value selected by the user.

[0131] In one embodiment, when the processor 502 implements the step of presetting the attributes of the field, it specifically implements the following steps:

[0132] Setting attributes of the field according to the received field attribute setting instruction, wherein the attributes of the field include a value range filtering option, and the value range filtering option includes on and off;

[0133] If the value range filtering option of the attribute of the field is set to be on, all implicit values ​​of the field and the display values ​​corresponding to the implicit values ​​are obtained, and all implicit values ​​of the field and the display values ​​corresponding to the implicit values ​​are stored in a preset value range table.

[0134] In one embodiment, the field attribute setting instruction includes a field ID and an attribute setting value, and the value range screening option of the field attribute includes a characteristic value. When the processor 502 implements the step of setting the field attribute according to the field attribute setting instruction, it specifically implements the following steps:

[0135] Determine the target field according to the field ID;

[0136] The characteristic value of the value range screening option of the attribute of the target field is set as the attribute setting value.

[0137] In one embodiment, when the processor 502 implements the step of obtaining all implicit values ​​of the field and the displayed values ​​corresponding to the implicit values, the processor 502 specifically implements the following steps:

[0138] Obtain all implicit values ​​of the field, and delete duplicate implicit values ​​among all implicit values ​​of the field;

[0139] The display value corresponding to the implicit value of the field is determined according to a preset implicit value-display value comparison table.

[0140] In one embodiment, when implementing the step of determining whether the value range filtering option is enabled for the field according to the attribute of the field, the processor 502 specifically implements the following steps:

[0141] Determine whether a characteristic value of a value range screening option of an attribute of the field is a preset first characteristic value;

[0142] If the characteristic value of the value range filtering option of the attribute of the field is a preset first characteristic value, it is determined that the value range filtering option is enabled for the field;

[0143] If the characteristic value of the value range filtering option of the attribute of the field is not the preset first characteristic value, it is determined that the value range filtering option is not enabled for the field.

[0144] In one embodiment, when implementing the step of displaying the display value of the field to the user for the user to perform filtering, the processor 502 specifically implements the following steps:

[0145] A value range drop-down list pops up, and the value range drop-down list contains the display value of the field.

[0146] In one embodiment, the processor 502 further implements the following steps:

[0147] If the value range filtering option is not enabled for the field, a keyword input box will pop up for the user to enter the filtering keyword;

[0148] Receive the filtering keyword input by the user, and filter the data under the field according to the filtering keyword.

[0149] It should be understood that in the embodiment of the present application, the processor 502 may be a central processing unit (CPU), and the processor 502 may also be other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor may be a microprocessor or any conventional processor, etc.

[0150] Those skilled in the art will appreciate that all or part of the steps in the method of the above-described embodiment can be implemented by instructing the relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium. The computer program is executed by at least one processor in the computer system to implement the steps in the method of the above-described embodiment.

[0151] Therefore, the present invention also provides a storage medium. The storage medium may be a computer-readable storage medium. The storage medium stores a computer program. When the computer program is executed by a processor, the processor performs the following steps:

[0152] Set the attributes of the field in advance;

[0153] Receive a filter request for a field from a user, and determine whether a value range filter option is enabled for the field based on the attributes of the field;

[0154] If the value range filter option is enabled for the field, the display value of the field is queried according to the value range table;

[0155] Displaying the display value of the field to the user for filtering;

[0156] The data under the field is filtered according to the implicit value corresponding to the displayed value selected by the user.

[0157] In one embodiment, when the processor executes the computer program to implement the step of presetting the attributes of the field, the processor specifically implements the following steps:

[0158] Setting attributes of the field according to the received field attribute setting instruction, wherein the attributes of the field include a value range filtering option, and the value range filtering option includes on and off;

[0159] If the value range filtering option of the attribute of the field is set to be on, all implicit values ​​of the field and the display values ​​corresponding to the implicit values ​​are obtained, and all implicit values ​​of the field and the display values ​​corresponding to the implicit values ​​are stored in a preset value range table.

[0160] In one embodiment, the field attribute setting instruction includes a field ID and an attribute setting value, and the value range screening options of the field attribute include a characteristic value; when the processor executes the computer program to implement the step of setting the field attribute according to the field attribute setting instruction, the processor specifically implements the following steps:

[0161] Determine the target field according to the field ID;

[0162] The characteristic value of the value range screening option of the attribute of the target field is set as the attribute setting value.

[0163] In one embodiment, when the processor executes the computer program to implement the step of obtaining all implicit values ​​of the field and the displayed values ​​corresponding to the implicit values, the processor specifically implements the following steps:

[0164] Obtain all implicit values ​​of the field, and delete duplicate implicit values ​​among all implicit values ​​of the field;

[0165] The display value corresponding to the implicit value of the field is determined according to a preset implicit value-display value comparison table.

[0166] In one embodiment, when the processor executes the computer program to implement the step of determining whether the value range filtering option is enabled for the field based on the attribute of the field, the processor specifically implements the following steps:

[0167] Determine whether a characteristic value of a value range screening option of an attribute of the field is a preset first characteristic value;

[0168] If the characteristic value of the value range filtering option of the attribute of the field is a preset first characteristic value, it is determined that the value range filtering option is enabled for the field;

[0169] If the characteristic value of the value range filtering option of the attribute of the field is not the preset first characteristic value, it is determined that the value range filtering option is not enabled for the field.

[0170] In one embodiment, when the processor executes the computer program to implement the step of displaying the display value of the field to the user for the user to perform screening, the processor specifically implements the following steps:

[0171] A value range drop-down list pops up, and the value range drop-down list contains the display value of the field.

[0172] In one embodiment, the processor further implements the following steps when executing the computer program:

[0173] If the value range filtering option is not enabled for the field, a keyword input box will pop up for the user to enter the filtering keyword;

[0174] Receive the filtering keyword input by the user, and filter the data under the field according to the filtering keyword.

[0175] The storage medium is a physical, non-transient storage medium, for example, a USB flash drive, a mobile hard disk, a read-only memory (ROM), a magnetic disk, or an optical disk, etc., which can store program codes.

[0176] Those skilled in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the above description has generally described the composition and steps of each example according to function. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.

[0177] In the several embodiments provided herein, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are merely illustrative. For example, the division of the various units is merely a logical functional division, and actual implementation may employ other division methods. For example, multiple units or components may be combined or integrated into another system, or some features may be omitted or not implemented.

[0178] The steps in the methods of the embodiments of the present invention may be adjusted in order, combined, or deleted as needed. The units in the devices of the embodiments of the present invention may be combined, divided, or deleted as needed. Furthermore, the functional units in the various embodiments of the present invention may be integrated into a single processing unit, each unit may exist physically separately, or two or more units may be integrated into a single unit.

[0179] If this integrated unit is implemented as a software functional unit and sold or used as an independent product, it can be stored in a storage medium. Based on this understanding, the technical solution of the present invention, or the part that contributes to the existing technology, or all or part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes a number of instructions for causing a computer device (which can be a personal computer, terminal, or network device, etc.) to execute all or part of the steps of the method described in various embodiments of the present invention.

[0180] In the above embodiments, the description of each embodiment has its own focus. For parts that are not described in detail in a certain embodiment, reference can be made to the relevant descriptions of other embodiments.

[0181] Obviously, those skilled in the art may make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. Thus, to the extent such changes and modifications fall within the scope of the claims and their equivalents, the present invention is intended to encompass such changes and modifications.

[0182] The above description is merely a specific embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Any person skilled in the art can easily conceive of various equivalent modifications or substitutions within the technical scope disclosed in the present invention, and such modifications or substitutions are intended to be within the scope of protection of the present invention. Therefore, the scope of protection of the present invention shall be subject to the scope of protection of the claims.

Claims

1. A table field screening method, characterized in that: include: Set the attributes of the field in advance; Receive a filter request for a field from a user, and determine whether a value range filter option is enabled for the field based on the attributes of the field; If the value range filter option is enabled for the field, the display value of the field is queried according to the value range table; Displaying the display value of the field to the user for filtering; Filter the data under the field according to the implicit value corresponding to the displayed value selected by the user; If the value range filtering option is not enabled for the field, a keyword input box pops up for the user to enter the filtering keyword; Receive a filter keyword input by a user, and filter the data under the field according to the filter keyword; The pre-setting of the attributes of the fields includes: Setting attributes of the field according to the received field attribute setting instruction, wherein the attributes of the field include a value range filtering option, wherein the value range filtering option includes an on and off option, and the value range filtering option is controlled by a user's subjective setting; If the value range filtering option of the attribute of the field is set to be on, all implicit values ​​of the field and the display values ​​corresponding to the implicit values ​​are obtained, and all implicit values ​​of the field and the display values ​​corresponding to the implicit values ​​are stored in a preset value range table.

2. The table field screening method according to claim 1, characterized in that: The field attribute setting instruction includes a field ID and an attribute setting value, and the value range screening option of the field attribute includes a characteristic value; and setting the field attribute according to the received field attribute setting instruction includes: Determine the target field according to the field ID; The characteristic value of the value range screening option of the attribute of the target field is set as the attribute setting value.

3. The table field screening method according to claim 1, characterized in that: The acquiring of all implicit values ​​of the field and displayed values ​​corresponding to the implicit values ​​includes: Obtain all implicit values ​​of the field, and delete duplicate implicit values ​​among all implicit values ​​of the field; The display value corresponding to the implicit value of the field is determined according to a preset implicit value-display value comparison table.

4. The table field screening method according to claim 2, characterized in that: The determining, based on the attributes of the field, whether the value range filtering option is enabled for the field includes: Determine whether a characteristic value of a value range screening option of an attribute of the field is a preset first characteristic value; If the characteristic value of the value range filtering option of the attribute of the field is a preset first characteristic value, it is determined that the value range filtering option is enabled for the field; If the characteristic value of the value range filtering option of the attribute of the field is not the preset first characteristic value, it is determined that the value range filtering option is not enabled for the field.

5. The table field screening method according to claim 1, characterized in that: The display value of the field is displayed to the user for the user to filter, including: A value range drop-down list pops up, and the value range drop-down list contains the display value of the field.

6. A table field screening device, characterized in that: include: A first setting unit, used to pre-set attributes of a field; A first judgment unit is configured to receive a field filtering request sent by a user and judge whether a value range filtering option is enabled for the field according to the attributes of the field; A query unit, configured to query the display value of the field according to the range table if a range filter option is enabled for the field; A display unit, used to display the display value of the field to the user for the user to filter; A first filtering unit, configured to filter the data under the field according to the implicit value corresponding to the displayed value selected by the user; A second pop-up unit is used to pop up a keyword input box for the user to input a filtering keyword if the value range filtering option is not enabled for the field; a second screening unit, configured to receive a screening keyword input by a user and screen the data under the field according to the screening keyword; Wherein, the first setting unit includes: a second setting unit configured to, upon receiving a field attribute setting instruction, set attributes of the field according to the field attribute setting instruction, wherein the attributes of the field include a value range filtering option, the value range filtering option includes an on option and a off option, and the value range filtering option is controlled by a user's subjective setting; The first acquisition unit is used to obtain all implicit values ​​of the field and the display values ​​corresponding to the implicit values ​​if the value range filtering option of the attribute of the field is set to be turned on, and store all implicit values ​​of the field and the display values ​​corresponding to the implicit values ​​in a preset value range table.

7. A computer device, characterized in that: The computer device includes a memory and a processor, the memory stores a computer program, and the processor implements the method according to any one of claims 1 to 5 when executing the computer program.

8. A computer-readable storage medium, characterized in that The storage medium stores a computer program, and when the computer program is executed by a processor, the method according to any one of claims 1 to 5 can be implemented.

Images