阅读说明：本技术 表格字段筛选方法、装置、计算机设备及存储介质 (Form field screening method and device, computer equipment and storage medium ) 是由 黄新华 卢清明 于 2020-07-22 设计创作，主要内容包括：本发明实施例公开了一种表格字段筛选方法、装置、计算机设备及存储介质,属于大数据技术领域,可解决大数据表格字段筛选响应慢的问题。该方法包括：预先对字段的属性进行设定；接收用户发送的对字段的筛选请求,根据所述字段的属性判断所述字段是否开启了值域筛选选项；若所述字段开启了值域筛选选项,根据所述值域表查询所述字段的显示值；向用户展示所述字段的显示值供用户进行筛选；根据用户选中的显示值所对应的隐示值对所述字段下的数据进行筛选。由于通过预设的值域表确定字段的显示值供用户筛选,无需扫描字段所有值,其响应速度更快。同时,展示字段的显示值也便于用户识别。(The embodiment of the invention discloses a table field screening method and device, computer equipment and a storage medium, belongs to the technical field of big data, and can solve the problem of slow screening response of a big data table field. The method comprises the following steps: setting the attribute of the field in advance; receiving a field screening request sent by a user, and judging whether the field opens a value range screening option according to the attribute of the field; if the field starts a value range screening option, inquiring a display value of the field according to the value range table; displaying the display value of the field to a user for the user to screen; and screening the data under the field according to the implicit value corresponding to the display value selected by the user. Because the display value of the field is determined through the preset value range table for the user to filter, all values of the field do not need to be scanned, and the response speed is higher. Meanwhile, the display value of the display field is convenient for the user to identify.)

1. A form field screening method is characterized by comprising the following steps:

setting the attribute of the field in advance;

receiving a field screening request sent by a user, and judging whether the field opens a value range screening option according to the attribute of the field;

if the field starts a value range screening option, inquiring a display value of the field according to the value range table;

displaying the display value of the field to a user for the user to screen;

and screening the data under the field according to the implicit value corresponding to the display value selected by the user.

2. The form field screening method of claim 1, wherein the pre-setting of the attributes of the fields comprises:

setting the attribute of a field according to a received field attribute setting instruction, wherein the attribute of the field comprises value range screening options, and the value range screening options comprise opening and closing;

and if the value range screening option of the attribute of the field is set to be started, acquiring all the hidden values of the field and the display values corresponding to the hidden values, and storing all the hidden values of the field and the display values corresponding to the hidden values into a preset value range table.

3. The form field screening method of claim 2, wherein the field attribute setting command includes a field ID and an attribute setting value, and the value range screening option of the field attribute includes a feature value; the setting of the attribute of the field according to the field attribute setting instruction comprises:

determining a target field according to the field ID;

and setting the characteristic value of the value range screening option of the attribute of the target field as the attribute set value.

4. The form field screening method of claim 2, wherein the obtaining all the hidden values of the field and the display values corresponding to the hidden values comprises:

acquiring all implicit values of the fields, and deleting repeated implicit values in all the implicit values of the fields;

and determining a display value corresponding to the hidden value of the field according to a preset hidden value-display value comparison table.

5. The form field screening method of claim 3, wherein said determining whether the field has a value range screening option enabled according to the attribute of the field comprises:

judging whether the characteristic value of the value range screening option of the attribute of the field is a preset first characteristic value or not;

if the characteristic value of the value range screening option of the attribute of the field is a preset first characteristic value, judging that the field starts the value range screening option;

and if the characteristic value of the value range screening option of the attribute of the field is not the preset first characteristic value, judging that the value range screening option of the field is not started.

6. The form field screening method of claim 1, wherein the presenting the display value of the field to a user for screening by the user comprises:

popping up a value range drop down list containing the display values of the fields.

7. The form field screening method of claim 1, further comprising:

if the value range screening option is not opened in the field, popping up a keyword input box for a user to input a screening keyword;

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

8. A form field screening apparatus, comprising:

the first setting unit is used for setting the attribute of the field in advance;

the first judgment unit is used for receiving a field screening request sent by a user and judging whether the field opens a value range screening option according to the attribute of the field;

the query unit is used for querying the display value of the field according to the value range table if the field starts a value range screening option;

the display unit is used for displaying the display value of the field to a user for the user to screen;

and the first screening unit is used for screening the data under the field according to the implicit value corresponding to the display value selected by the user.

9. A computer arrangement, characterized in that the computer arrangement comprises a memory having stored thereon a computer program and a processor implementing the method according to any of claims 1-7 when executing the computer program.

10. A computer-readable storage medium, characterized in that the storage medium stores a computer program which, when executed by a processor, implements the method according to any one of claims 1-7.

Technical Field

The present invention relates to the field of data processing technologies, and in particular, to a method and an apparatus for screening table fields, a computer device, and a storage medium.

Background

The table has a wide application in data statistics, and common table workers include Excel, Superset and the like. In order to facilitate user statistics, a table usually has a field screening function, and the existing field screening function is implemented in the following manner: when a user selects a field needing to be screened, the form tool scans all values of the field in a full form and then returns the values, and the technical scheme has the following defects:

1. full-table scanning is not problematic with relatively small amounts of data, but response times are very slow with billions of data in large data scenarios affecting user experience.

2. The form is usually filled with a hidden value, and the hidden value is screened in the above way, so that the user cannot know the meaning of the hidden value.

Disclosure of Invention

The embodiment of the invention provides a form field screening method, a form field screening device, computer equipment and a storage medium, and aims to solve the problems that an existing form field screening method is large in calculation amount and long in response time, and a user is difficult to identify screened contents.

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

setting the attribute of the field in advance;

receiving a field screening request sent by a user, and judging whether the field opens a value range screening option according to the attribute of the field;

if the field starts a value range screening option, inquiring a display value of the field according to the value range table;

displaying the display value of the field to a user for the user to screen;

and screening the data under the field according to the implicit value corresponding to the display value selected by the user.

In a second aspect, an embodiment of the present invention further provides a form field screening apparatus, which includes:

the first setting unit is used for setting the attribute of the field in advance;

the first judgment unit is used for receiving a field screening request sent by a user and judging whether the field opens a value range screening option according to the attribute of the field;

the query unit is used for querying the display value of the field according to the value range table if the field starts a value range screening option;

the display unit is used for displaying the display value of the field to a user for the user to screen;

and the first screening unit is used for screening the data under the field according to the implicit value corresponding to the display value selected by the user.

In a third aspect, an embodiment of the present invention further provides a computer device, which includes a memory and a processor, where the memory stores a computer program, and the processor implements the above method when executing the computer program.

In a fourth aspect, the present invention also provides a computer-readable storage medium, which stores a computer program, and the computer program can implement the above method when being executed by a processor.

The embodiment of the invention provides a table field screening method and device, computer equipment and a storage medium. Wherein the method comprises the following steps: setting the attribute of the field in advance; receiving a field screening request sent by a user, and judging whether the field opens a value range screening option according to the attribute of the field; if the field starts a value range screening option, inquiring a display value of the field according to the value range table; displaying the display value of the field to a user for the user to screen; and screening the data under the field according to the implicit value corresponding to the display value selected by the user. The embodiment of the invention determines the display value of the field through the preset value range table for the user to screen, and has higher response speed compared with the mode of scanning all values of the field and removing the duplicate in the prior art. Meanwhile, the display value of the display field is convenient for the user to identify.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.

Fig. 1 is a schematic flowchart of a table field screening method according to an embodiment of the present invention;

fig. 2 is a sub-flow diagram of a table field screening method according to an embodiment of the present invention;

fig. 3 is a sub-flow diagram of a table field screening method according to an embodiment of the present invention;

fig. 4 is a sub-flow diagram of a table field screening method according to an embodiment of the present invention;

fig. 5 is a sub-flow diagram of a table field screening method according to an embodiment of the present invention;

fig. 6 is a schematic flowchart of a table field screening method according to another embodiment of the present invention;

fig. 7 is a schematic block diagram of a table field screening apparatus according to an embodiment of the present invention;

fig. 8 is a schematic block diagram of a first setting unit of a table field screening apparatus according to an embodiment of the present invention;

fig. 9 is a schematic block diagram of a second setting unit of the form field screening apparatus according to the embodiment of the present invention;

fig. 10 is a schematic block diagram of a first obtaining unit of a form field screening apparatus according to an embodiment of the present invention;

fig. 11 is a schematic block diagram of a first determining unit of a table field screening apparatus according to an embodiment of the present invention;

FIG. 12 is a schematic block diagram of a display unit of a table field screening apparatus according to an embodiment of the present invention;

FIG. 13 is a block diagram illustrating a table field filtering apparatus according to another embodiment of the present invention;

FIG. 14 is a schematic block diagram of a computer device provided by an embodiment of the present invention.

Detailed Description

The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

It will be understood that the terms "comprises" and/or "comprising," when used in this specification and the appended claims, specify the presence of stated 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.

It is also to be understood that the terminology used in the description of the invention herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used in the specification of the present invention and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.

It should be further understood that the term "and/or" as used in this specification and the appended claims refers to and includes any and all possible combinations of one or more of the associated listed items.

As used in this specification and the appended claims, the term "if" may be interpreted contextually as "when", "upon" or "in response to a determination" or "in response to a detection". Similarly, the phrase "if it is determined" or "if a [ described condition or event ] is detected" may be interpreted contextually to mean "upon determining" or "in response to determining" or "upon detecting [ described condition or event ]" or "in response to detecting [ described condition or event ]".

Referring to fig. 1, fig. 1 is a schematic flow chart illustrating a table field screening method according to an embodiment of the present invention. The method belongs to the technical field of big data, and can solve the problem of slow response of field screening of big data tables. As shown, the method includes the following steps S1-S5.

S1, the attribute of the field is set in advance.

A field (field) representing a variable associated with an object or class. In a table, the columns of the table are called fields, each field containing information for a topic. Like in a contact list, name and contact are attributes common to all rows in the list, so these columns are referred to as the name field and the contact field.