Data updating method and device for components in table, equipment and medium

Abstract

The invention provides a data updating method and device for components in a table, equipment and a medium, and the method comprises the steps that in response to an operation of creating a screening component on a component page of the table, the screening component is configured and created, the component page is used for creating different types of components, and the components comprise components used for displaying data of the table in a chart form; in response to a triggering operation on the screening component, determining screening information; according to the screening information, a target component associated with the screening information is determined from the component page, data of a data table displayed in the target component is updated, and the screening information is at least one data dimension configured in the target component. According to the invention, on the premise of not changing the configuration of a single instrument panel assembly in the table, the data displayed by the instrument panel assembly can be screened, and the range of data which can be displayed by the instrument panel assembly is expanded.

Description

Technical Field

[0001] This disclosure relates to the field of data processing technology, and in particular to a method, apparatus, device, and medium for updating data in a table component. Background Technology

[0002] With the rapid development of information technology, the amount of data is constantly increasing, and the need for data management and analysis is also growing. Tables, as a data visualization tool, can present data in a structured way, helping people understand and analyze data and make decisions accordingly.

[0003] When users view data in a table, they may need to filter the data. To meet these needs, administrator privileges are typically granted, allowing users to change the data range through global filtering. However, this approach can be compromised by user errors, such as modifying or deleting dashboard component configurations, which can corrupt the dashboard component settings and cause data filtering anomalies. Summary of the Invention

[0004] This disclosure provides a method, apparatus, device, and medium for updating data in a table component. It can filter the data displayed by the dashboard component and expand the range of data that the dashboard component can display without changing the configuration of a single dashboard component in the table.

[0005] In a first aspect, embodiments of this disclosure provide a method for updating data in a table, including:

[0006] In response to the operation of creating a filter component on the component page of the table, the filter component is configured and created. The component page is used to create different types of components, including components for displaying the data of the table in the form of charts.

[0007] In response to a triggering operation on the filtering component, filtering information is determined;

[0008] Based on the filtering information, a target component associated with the filtering information is determined from the component page, and the data in the data table displayed in the target component is updated, wherein the filtering information is at least one data dimension configured in the target component.

[0009] Secondly, embodiments of this disclosure provide a data updating apparatus for components in a table, including:

[0010] A component creation module is used to configure and create filter components in response to the operation of creating filter components on the component page of a table. The component page is used to create different types of components, including components for displaying the data of the table in the form of charts.

[0011] The information determination module is used to determine the filtering information in response to a trigger operation on the filtering component;

[0012] The data update module is used to determine the target component associated with the filter information from the component page based on the filter information, and update the data of the data table displayed in the target component, wherein the filter information is at least one data dimension configured in the target component.

[0013] Thirdly, embodiments of this disclosure provide an electronic device, including:

[0014] A processor and a memory, the memory being used to store a computer program, the processor being used to invoke and run the computer program stored in the memory to perform a data update method for the components in the table as described in any one of the embodiments of this disclosure.

[0015] Fourthly, embodiments of this disclosure provide a computer-readable storage medium for storing a computer program that causes a computer to perform a data update method for components in a table as described in any one of the embodiments of this disclosure.

[0016] Fifthly, embodiments of this disclosure provide a computer program product containing program instructions that, when executed on an electronic device, cause the electronic device to perform a data update method for components in a table as described in any one of the embodiments of this disclosure.

[0017] The technical solution disclosed in this embodiment configures and creates a filter component in response to an operation of creating a filter component on the component page of a table. The component page is used to create different types of components, including components for displaying table data in chart form. In response to a trigger operation on the filter component, filter information is determined. Then, based on the filter information, a target component associated with the filter information is determined from the component page, and the data in the data table displayed in the target component is updated. The filter information is at least one data dimension configured in the target component. Thus, by adding a filter component to the dashboard component page of the table, users can filter data using the added filter component. This allows for data filtering of the data displayed by the dashboard component without changing the configuration of individual dashboard components in the table, expanding the range of data that the dashboard component can display. Attached Figure Description

[0018] To more clearly illustrate the technical solutions in the embodiments of this disclosure, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of this disclosure. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0019] Figure 1 A flowchart illustrating a method for updating data in a table, as provided in this embodiment of the disclosure;

[0020] Figure 2a A schematic diagram of a component page for a dashboard component provided in an embodiment of this disclosure;

[0021] Figure 2b This is a schematic diagram illustrating the display of usage guidance information near the component control on a component page, as provided in an embodiment of this disclosure.

[0022] Figure 3a This is a schematic diagram of a component panel corresponding to an added component control provided in an embodiment of this disclosure;

[0023] Figure 3b A schematic diagram illustrating the display of a newly added identifier near a filter component in a component panel, provided as an embodiment of this disclosure;

[0024] Figure 4 This is a schematic diagram of a configuration interface corresponding to a filtering component provided in an embodiment of the present disclosure;

[0025] Figure 5 A flowchart for configuring and creating a filtering component is provided as an embodiment of this disclosure;

[0026] Figure 6a A schematic diagram of a first configuration area provided in an embodiment of this disclosure;

[0027] Figure 6b This is a schematic diagram illustrating how a data source configuration item supports enabling multiple data source modes, as provided in an embodiment of this disclosure.

[0028] Figure 6c A schematic diagram of field types for a multi-data source corresponding field configuration item provided in an embodiment of this disclosure;

[0029] Figure 6d This is a schematic diagram of a tiled option style provided in an embodiment of the present disclosure;

[0030] Figure 6e This is a schematic diagram of a drop-down option style provided in an embodiment of the present disclosure;

[0031] Figure 6f A schematic diagram of a one-way numerical input box provided in an embodiment of this disclosure;

[0032] Figure 6g This is a schematic diagram of a range value input box provided in an embodiment of the present disclosure;

[0033] Figure 6h A schematic diagram of a single-day date component provided in an embodiment of this disclosure;

[0034] Figure 6i A schematic diagram of a range date component provided in an embodiment of this disclosure;

[0035] Figure 6j A schematic diagram of optional components displayed below an associated component configuration item provided in an embodiment of this disclosure;

[0036] Figure 7 This is a schematic diagram of a second configuration area provided in an embodiment of the present disclosure;

[0037] Figure 8 A schematic diagram of a preview area provided for an embodiment of this disclosure;

[0038] Figure 9a A schematic diagram illustrating the adjustment of the display position of a filtering component according to an embodiment of this disclosure;

[0039] Figure 9b A schematic diagram illustrating the display size of an enlarged filtering component provided in an embodiment of this disclosure;

[0040] Figure 9c A schematic diagram illustrating a reduction in the display size of a filtering component according to an embodiment of this disclosure;

[0041] Figure 9d A schematic diagram illustrating the simultaneous magnification of the display height and display width information of a filtering component, as provided in an embodiment of this disclosure;

[0042] Figure 9e A schematic diagram illustrating a method for simultaneously reducing the display height and display width information of a filtering component according to an embodiment of this disclosure;

[0043] Figure 10 This is a schematic diagram of an operation interface displayed near a filtering component, provided as an embodiment of this disclosure;

[0044] Figure 11 A flowchart for determining filtering information is provided as an embodiment of this disclosure;

[0045] Figure 12 Another flowchart for determining filtering information provided in this disclosure embodiment;

[0046] Figure 13 A schematic block diagram of a data updating device for a component in a table, provided as an embodiment of this disclosure;

[0047] Figure 14 This is a schematic block diagram of an electronic device provided in an embodiment of the present disclosure. Detailed Implementation

[0048] The technical solutions of the embodiments of this disclosure will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this disclosure, and not all embodiments. All other embodiments obtained by those skilled in the art based on the embodiments of this disclosure without creative effort are within the scope of protection of this disclosure.

[0049] It should be noted that the terms "first," "second," etc., in the specification, claims, and accompanying drawings of this disclosure are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate so that the embodiments of this disclosure described herein can be implemented in orders other than those illustrated or described herein. Furthermore, the terms "comprising" and "having," and any variations thereof, are intended to cover non-exclusive inclusion; for example, a process, method, system, product, or server that includes a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units not explicitly listed or inherent to such processes, methods, products, or devices.

[0050] In this disclosure, the terms "exemplary" or "for example" are used to indicate that something is an example, illustration, or description. Any embodiment or scheme described as "exemplary" or "for example" in this disclosure should not be construed as being more preferred or advantageous than other embodiments or schemes. Specifically, the use of terms such as "exemplary" or "for example" is intended to present the relevant concepts in a specific manner.

[0051] In the description of embodiments of this disclosure, unless otherwise stated, "a plurality of" means two or more, that is, at least two. "At least one" means one or more. "Any" means any one or any several.

[0052] As mentioned earlier, to meet users' data filtering needs, administrator privileges are typically granted, allowing users to change the data range through global filtering. However, this method may lead to errors due to user mistakes, causing the configuration of some components in the table to be corrupted, resulting in abnormal data filtering. For example, if some components in the table are dashboard components, then if a user accidentally changes the configuration of a dashboard component, the dashboard component's configuration will be corrupted, causing abnormal data filtering displayed by the dashboard component.

[0053] To address the aforementioned technical issues, this disclosure provides a method, apparatus, device, and medium for updating data in a table component. This addresses the problem that when a user with configuration administrator privileges changes the data range through global filtering, user error may cause the configuration of the dashboard component in the table to be corrupted, resulting in abnormal data filtering displayed on the dashboard component.

[0054] The technical solutions provided by the embodiments of this disclosure will be described in detail below through some examples. The embodiments described below can be combined with each other, and the same or similar concepts or processes may not be repeated in some embodiments.

[0055] Figure 1 This is a flowchart illustrating a method for updating data in a table according to an embodiment of this disclosure. The method for updating data in a table provided in this disclosure can be executed by a data updating device for the table component. This data updating device can consist of hardware and / or software and can be integrated into an electronic device. The electronic device in this disclosure can be, but is not limited to, tablet computers, personal digital assistants, handheld devices (such as smartphones), laptops, and wearable devices. This disclosure does not specifically limit the type of electronic device.

[0056] like Figure 1 As shown, the data update method for the components in this table may include the following steps:

[0057] S101, in response to the operation of creating a filter component on the component page of the table, configure and create a filter component. The component page is used to create different types of components, including components for displaying the data of the table in the form of charts.

[0058] In this disclosure, the table mentioned above can be a multidimensional table, which can include multiple dimensions, such as displaying data in a hierarchical manner combining rows and columns.

[0059] The aforementioned filtering component refers to an interactive component used to implement data filtering functionality. Optionally, the filtering component in this disclosure can be a slicer, that is, a slicer used to filter target data related to the user-input filtering information from an associated data source component. For example, a user can use a slicer to filter data related to a target time period.

[0060] Considering the creation of dashboards within tables, and the ability to visually display table data to help users quickly analyze data and make corresponding decisions, this disclosure allows for the creation of dashboard components within tables and the display of their component pages. In other words, in this disclosure, "component page" refers to the component page of the dashboard component.

[0061] It should be understood that the aforementioned dashboard specifically refers to a data dashboard.

[0062] Furthermore, the component page of the dashboard component can include various interactive controls, such as component addition controls and setting controls, for example... Figure 2a As shown.

[0063] In some optional embodiments, considering that the user performing the data update operation can be determined as a new user or an old user based on the user's status information, when the user performing the data update operation may be a new user, this disclosure may display usage guidance information near the add component control on the component page. This usage guidance information includes: a first prompt message and optional controls, such as... Figure 2b As shown in the diagram. The first prompt message can be, but is not limited to, "The dashboard now supports adding filter components!", and optional controls can include "Use Now" and "OK" controls. When the user triggers the "Use Now" control, the component panel corresponding to the added component control will open; when the user triggers the "OK" control, the usage guidance information will close. This helps users quickly understand and use the newly added filter components in the component panel corresponding to the added component control. The triggering action can be a click, touch, or voice operation, etc., without any restrictions.

[0064] Accordingly, when the user performing the data update operation is an existing user, this disclosure will not display usage guidance information near the component control on the component page, thus avoiding interference with the user's use and ensuring normal user operation.

[0065] Therefore, when it is determined that the add component control on the component page has been triggered, that is, when a trigger operation is detected on the add component control, the component panel corresponding to the add component control can be displayed. This component panel can include various interactive components, such as chart components, view components, filter components, and other types of components, such as... Figure 3a As shown. Among them, chart components refer to components that display data in chart form, including bar chart components, line chart components, pie chart components, and bar graph components; view components refer to components that display data in view form, including calendar components and table components; other types of components can be components that display data in other display forms, including progress chart components, text components, and other display form components.

[0066] In other words, this publicly available component page is used to create different types of components. This means that different types of components can be created based on the various interactive components in the component panel corresponding to the component controls added on this component page.

[0067] Furthermore, different types of components can be at least one of chart components, view components, filter components, and other types of components.

[0068] It should be noted that, considering the possibility that the user performing the data update operation might be a new user, this disclosure may display a new identifier near the filter component in the component panel corresponding to the added component control. This identifier indicates that the filter component is a newly added interactive component, guiding the user to use it. For example... Figure 3b As shown. Accordingly, when the user performing the data update operation is an existing user, this disclosure will not display a new label near the filter component in the component panel corresponding to the added component control, thus avoiding interference with the user's experience and ensuring normal use.

[0069] Furthermore, when a filter component in the component panel is triggered, i.e., a creation operation for the filter component is detected, the configuration interface corresponding to that filter component can be displayed, such as... Figure 4 As shown, the filtering component can be configured and created based on this configuration interface.

[0070] In this disclosure, the number of filtering components created above is one or more, i.e., at least one.

[0071] Therefore, when there is only one filter component, it can be set for one field or multiple fields. When there are multiple filter components, some of them can be set for one field, while others can be set for multiple fields. These fields can come from the same data source or from different data sources.

[0072] In other words, the filtering components can include single-dimensional filtering components and multi-dimensional filtering components.

[0073] For example, assuming the data source is a sales record table, and the filtering components are single-dimensional filtering components with a quantity of 3, then the first filtering component can be set for the "Date" field, allowing users to select any date to filter data associated with that date; the second filtering component can be set for the "Region" field, allowing users to select any region to filter data associated with that region; and the third filtering component can be set for the "Product Category" field, allowing users to select any product category to filter data related to that product category.

[0074] For example, assuming the data source is a sales record table, and the filtering components are multi-dimensional filtering components with two components, the first filtering component can be set for the "Date" and "Region" fields, allowing users to select any date and any region associated with that date to filter related data; the second filtering component can be set for the "Region" and "Product Category" fields, allowing users to select any region and any product category associated with that region to filter related data.

[0075] S102, in response to the triggering operation of the filtering component, determine the filtering information.

[0076] S103, Based on the filtering information, determine the target component associated with the filtering information from the component page, and update the data in the data table displayed in the target component, wherein the filtering information is at least one data dimension configured in the target component.

[0077] The target component mentioned above can be any component other than the filter component located in the component page of the dashboard component, such as at least one of the following: graphic component, view component, and other types of components.

[0078] Furthermore, the data table displayed in the aforementioned target component specifically refers to a data table within a table. That is, the data within the table can be displayed in multiple dimensions, such as rows and columns.

[0079] In some alternative embodiments, after creating a filter component on the component page of the dashboard component, users can use the filter component to filter the data displayed by the dashboard component in the table and display the filtered target data.

[0080] Optionally, users can perform data filtering based on a filter component. This can be done by selecting a target field from multiple optional fields provided by the filter component and using that target field as the filter information. Then, from the component page of the dashboard component, a target component that is associated with the target field is identified. Next, the data in the data table displayed in the target component is filtered according to the target field, and the filtered target data is displayed through the target component to update the data in the data table displayed in the target component.

[0081] For example, assuming the filter component is a "Region" filter component, the user can select "xx Province" in the "Region" filter component. Then, based on "xx Province", the target component with a relationship can be determined as the sales record chart component. Then, based on "xx Province", the sales record data associated with "xx Province" can be filtered from the sales record table data displayed in the sales record chart component, and the sales record data in the sales record table displayed in the sales record chart component can be updated based on the sales record data associated with "xx Province".

[0082] In other words, the data dimensions mentioned above correspond to the target fields selected by the user from the filtering component. For example, if the target field is "region", then the data dimension is "region"; and if the target field is "date", then the data dimension is "date", and so on.

[0083] In some optional embodiments, considering that after creating a filter component in the component page of the dashboard component, this disclosure can optionally grant advanced permissions to different users based on their user identities. Therefore, when a user uses the filter component to filter data, the available fields corresponding to that user's permissions will be displayed in the corresponding fields of the filter component, and no available fields exceeding the user's permissions will be displayed. This protects the stability and security of the data displayed in the dashboard component.

[0084] For example, advanced permissions can be granted to the first user who is the creator or editor; advanced permissions can be denied to the second user who is a collaborator or a regular visitor, and no specific restrictions are imposed on them here.

[0085] The technical solution disclosed in this embodiment configures and creates a filter component in response to an operation of creating a filter component on the component page of a table. The component page is used to create different types of components, including components for displaying table data in chart form. In response to a trigger operation on the filter component, filter information is determined. Then, based on the filter information, a target component associated with the filter information is determined from the component page, and the data in the data table displayed in the target component is updated. The filter information is at least one data dimension configured in the target component. Thus, by adding a filter component to the dashboard component page of the table, users can filter data using the added filter component. This allows for data filtering of the data displayed by the dashboard component without changing the configuration of individual dashboard components in the table, expanding the range of data that the dashboard component can display.

[0086] The following is combined with Figure 5 The following is a further explanation of step S101 in the foregoing embodiments. Figure 5 As shown, step S101 may include the following steps S101-1 to S101-3:

[0087] S101-1, in response to the operation of creating a filter component on the component page of the table, displays the configuration interface of the filter component.

[0088] S101-2, in response to configuration operations on the configuration interface, obtains component configuration information.

[0089] S101-3, Create a filtering component based on the component configuration information.

[0090] In some embodiments, such as Figure 4 As shown, when a creation operation for a filter component is detected, the configuration interface corresponding to that filter component can be displayed, and the filter component can be configured and created based on the configuration interface.

[0091] In some embodiments, such as Figure 6a As shown, the configuration interface of the filtering component of this disclosure may include a first configuration area, which may include multiple first configuration items, wherein the first configuration items may include: description configuration item, data source configuration item, field configuration item, style configuration item, selection range configuration item, default value configuration item, and associated component configuration item.

[0092] Therefore, the first configuration information can be obtained by responding to a configuration operation on any first configuration item in the first configuration area. Then, this first configuration information is used as component configuration information, and a filtering component is created based on this component configuration information.

[0093] In some optional embodiments, based on the first configuration item including: description configuration item, data source configuration item, field configuration item, style configuration item, selection range configuration item, default value configuration item, and associated component configuration item, this disclosure, in response to a configuration operation on any first configuration item in the first configuration area, obtains first configuration information, which may include the following:

[0094] S11. For the first configuration item, which is the description configuration item, you can enter a custom description according to your configuration requirements, or you can use the default description. There are no restrictions on this. The custom description can be empty. It should be understood that the description here refers to the name or functional description information of the filtered component.

[0095] S12. For the first configuration item being a data source configuration item, this data source configuration item can be triggered by clicking or other operations to display selectable data tables below it. Then, any data table can be selected from the selectable data tables as the data source for the filtering component. Furthermore, this data source configuration item also supports enabling a multi-data source mode, allowing multiple data sources to be selected for this filtering component, as detailed below. Figure 6b As shown.

[0096] Optionally, when the data source configured for a data source configuration item is cleared, a prompt message can be displayed to the user. Specifically, when the user is the first user, such as the editor or creator, the prompt message could be: "Configuration data has changed, please reconfigure," etc.; when the user is the second user, such as a collaborator, the prompt message could be: "Invalid data," etc.

[0097] S13. For the first configuration item being a field configuration item, it can be triggered by clicking or other operations to display optional fields below it. Then, any optional field can be selected as a filter condition from the optional fields and used as the configuration information for that field configuration item. That is, the selected optional field as a filter condition will be applied to the filtering component.

[0098] Optional fields may include, but are not limited to, "Region," "Date," and "Product Category." Therefore, when filtering by the "Region" field from the optional fields, it can be determined that the filtering component performs region-based data filtering based on this "Region" field; that is, this filtering component is a single-dimensional filtering component based on "Region." When filtering by both the "Date" and "Region" fields from the optional fields, it can be determined that the filtering component performs multi-dimensional data filtering based on both the "Date" and "Region" fields; that is, this filtering component is a multi-dimensional filtering component based on both "Date" and "Region."

[0099] Optionally, considering that this field configuration item may not have optional fields, the index column can be selected as the default configuration information for this field configuration item. The index column refers to a column in the data source used to identify each row of data.

[0100] In some embodiments, such as Figure 6c As shown, considering that the filtering component can use multiple data sources, the field type of this configuration item must remain consistent when using multiple data sources. When switching fields from any data source, other data sources should simultaneously select fields of the same type, defaulting to the first field of the same type. If no field of the same type is found, the selected field should be cleared.

[0101] In some alternative embodiments, considering that the optional fields corresponding to the field configuration items of this disclosure may also have corresponding field types, and that a mapping relationship is established between the optional fields and the field types.

[0102] Furthermore, the above field types include the following types: enumeration type, numeric type, and date type.

[0103] The above enumeration classes can be further subdivided into the following categories: enumeration option classes, enumeration process classes, enumeration association classes, enumeration personnel classes, enumeration group classes, enumeration checkbox classes, and enumeration text classes.

[0104] Among them, the optional fields corresponding to the A, enumeration option class, can include the following:

[0105] The first type is a single-selection field or a multi-selection field;

[0106] The second method is to reference single-selection or multi-selection fields from other data tables;

[0107] The third type is a formula or lookup reference whose calculation result is an enumeration option field.

[0108] B. The optional fields corresponding to the enumeration process class may include the following:

[0109] The first type is process fields;

[0110] The second method is to calculate the result as a formula or lookup reference of the field type "enumeration process class".

[0111] C. The optional fields corresponding to the enumerated association class can include the following:

[0112] The first type is either unidirectional or bidirectional association;

[0113] The second method involves calculating a formula or lookup reference that enumerates the field type of the related class.

[0114] D. The optional fields corresponding to the enumerated personnel class may include the following:

[0115] The first type is the person who created or updated the content.

[0116] The second method involves calculating a formula or lookup reference whose result is an enumeration of the personnel field.

[0117] E. The optional fields corresponding to the enumerated group class may include the following:

[0118] The first type is the group;

[0119] The second method involves calculating a formula or lookup reference whose result is an enumeration of the group class field.

[0120] F. Enumerate the optional fields corresponding to the checkboxes, which may include the following:

[0121] The first type is the checkbox;

[0122] The second method involves calculating a formula or lookup reference that enumerates the checkbox field. The enumeration method includes checking and unchecking boxes.

[0123] G. The optional fields corresponding to the enumerated text class may include the following:

[0124] The first type includes text, hyperlinks, phone numbers, email addresses, geolocation, or barcodes;

[0125] The second method involves calculating a formula or lookup reference that enumerates the text field type.

[0126] The process of converting text fields into enumerations is as follows: the data source fields configured in the filtering component are deduplicated to obtain the enumeration results.

[0127] Furthermore, the following restrictions are imposed on the number of related enumerated texts:

[0128] 1. There is no limit to the number of duplicate records that can be scanned and deduplicated from the data source;

[0129] 2. The number of enumerations that can be displayed can be preset. The preset number can be flexibly set according to actual needs, such as 5000.

[0130] 3. When the number of enumerations exceeds the preset number, a pop-up window will prompt the user. The prompt message displayed in the pop-up window may include, but is not limited to, the following: "There are too many enumeration values. By default, only 5000 options are displayed. You can reduce the number of options by limiting the range of options."

[0131] In addition, when the optional field corresponding to the enumerated text class is a formula field, the formula field is treated as text.

[0132] The optional fields corresponding to the above numeric classes can include the following:

[0133] The first type includes numbers, currency, scores, progress, or automatic coding;

[0134] The second method involves formulas or lookup references whose calculation results are numerical fields.

[0135] The optional fields corresponding to the above date class may include the following:

[0136] The first type is based on date, creation time, or last update time.

[0137] The second method involves formulas or lookup references whose calculation results are date-type fields.

[0138] Optionally, when all fields configured for a field configuration item are deleted, or when the type of a field changes, a prompt message can be displayed to the user. Specifically, when the user is the primary user, such as the editor or creator, the prompt message could be something like, "Invalid data, please reconfigure." When the user is the secondary user, such as a collaborator, the prompt message could be something like, "Invalid data."

[0139] Alternatively, when some fields in a configuration item are deleted, the following method can be used to handle this:

[0140] In the first method, the filtering component remains unaffected, and the remaining field content serves as the data source.

[0141] The second approach is to clear the default value if it comes from the deleted field, restoring the field to a state with no default value.

[0142] The third method is to cancel the association between the data source and the deleted field and the corresponding component. Here, "component" refers to the component used to display the data in the table. This component can be at least one of the following: chart component, view component, and other types of components. In other words, "component" here refers to any type of component except for filter components.

[0143] S14. For the first configuration item, which is a style configuration item, it can be triggered by clicking or other operations to display selectable styles below it. Then, any selectable style can be chosen as the display style for the filter component.

[0144] In some embodiments, considering that the optional fields corresponding to the field configuration items have corresponding field types, this disclosure can provide different optional styles for the filtering component based on the field types corresponding to the optional fields, as follows:

[0145] A11. For enumeration classes, the available styles include: tiled option style and dropdown option style; among them, the tiled option style can be as follows: Figure 6d As shown; the dropdown option style can be as follows Figure 6e As shown.

[0146] A12. For numeric classes, the available styles include: numeric selection style, tiled option style, and drop-down option style.

[0147] Among them, the numeric selection style can be further divided into: operator style and numeric filter style;

[0148] The above operator styles may include:

[0149] The first type includes equal to, not equal to, greater than, greater than or equal to, less than, less than or equal to;

[0150] The corresponding preview window is a one-way numeric input box: Operator | Numeric Input Box, which can be used as follows: Figure 6f As shown.

[0151] The second type is the interval;

[0152] The corresponding preview window is a range value input box: minimum value - maximum value, as shown below. Figure 6g As shown.

[0153] The above numerical filtering styles may include:

[0154] The first method is a drop-down selection box: filter the aggregation results or filter the record details;

[0155] Furthermore, the corresponding filtering logic is as follows:

[0156] Filtering the aggregation results specifically involves filtering the numerical calculation results in the charts;

[0157] To filter the record details, you need to filter the data at the bottom.

[0158] In addition, there is corresponding prompting logic, specifically:

[0159] Filtering the aggregation results involves filtering the final result data based on the aggregation method of the selected field in each chart.

[0160] Filtering record details involves filtering the record details from the data source before generating the chart.

[0161] A13. For date-related items, the available styles include: date selection style, tiled option style, and drop-down option style.

[0162] The date selection styles also include: operator styles;

[0163] The above operator styles may include:

[0164] The first type is equal to, later than, or earlier than;

[0165] The corresponding preview window is a single-day date component, which features dynamic date selection capabilities, such as... Figure 6h As shown.

[0166] The second type is the interval;

[0167] The corresponding preview window is a range date component, which features dynamic date selection capabilities and allows for the selection of the full date type, such as... Figure 6i As shown.

[0168] S15. For the first configuration item, which is a selection range configuration item, this selection range configuration item can be triggered by clicking or other operations to display the selectable range below it. Then, any selectable range can be selected from the selectable range as the selection range for the filtering component.

[0169] In some embodiments, considering that the optional fields corresponding to the field configuration items have corresponding field types, this disclosure can provide different optional ranges for the filtering component based on the field types corresponding to the optional fields, as follows:

[0170] I. Based on the display style selected in the style configuration items, different ranges of options are provided.

[0171] A21. Enumeration type: Tile options (default) or drop-down options → option field enumeration filter style.

[0172] A22, Numerical: Tiled options, drop-down options, or numerical range (default) → Numerical field filter style.

[0173] A23, Date Category: Tiled Options, Drop-down Options, or Date Range (Default) → Date Field Enumeration Filter Style.

[0174] II. Scope of Supported Filtering

[0175] Filter only the range supported by the currently configured fields of the component, and support different filtering conditions depending on the selected field type.

[0176] Optionally, when the content of the selected range corresponding to the configuration is empty, output a "data is empty" prompt message to the user.

[0177] S16. For the first configuration item being a default value configuration item, this default value configuration item can be triggered by clicking or other operations to display optional default values ​​below it. Then, any optional default value can be selected from the optional default values ​​as the default value for the filter component.

[0178] In some alternative embodiments, the optional default values ​​displayed below the default value configuration item in this disclosure may include two cases: the first case is that the default value is empty, and the second case is that the optional content and selection method of the default value may be different for different filter components.

[0179] Alternatively, for the second case, the decision can be determined based on the field type of the optional field, as follows:

[0180] A31. For enumeration classes

[0181] The first option, optional content, includes the following:

[0182] a1. Single choice, multiple choice, process, or checkbox field

[0183] Specifically, the optional content includes the options within the filtered fields and process nodes.

[0184] In this context, the checkbox field offers the options of "checked" and "unchecked." For example, if the field is configured with options Q1, Q2, and Q3, even if the data source does not have option Q1 selected, Q1 will still be included as a possible option.

[0185] a2. One-way association, two-way association, people, creator, updater, group, text, hyperlink, phone number, email address, geolocation or barcode field

[0186] Specifically, the optional content is the deduplicated content after filtering this field in the data source.

[0187] a3. For fields in an enumeration class, if null values ​​exist in the data source, add an option to sort to the bottom.

[0188] The second option, selection method: supports selecting multiple enumeration values ​​as default values.

[0189] It should be noted that the logic for enumeration options to apply to multi-select type columns is as follows:

[0190] Multiple enumeration values ​​are ORed, meaning the chart only needs to satisfy any selected enumeration value in the filter component;

[0191] The filter components are connected by AND, meaning the chart must satisfy the conditions of all associated filter components.

[0192] A32, For numerical classes

[0193] When the display style of the filter component is: tiled option style or drop-down option style, the selectable content is the deduplicated content after filtering the data source field, and the content is displayed in the format of the numeric field.

[0194] When the display style of the filter component is: numeric range style, the selection methods include the following:

[0195] Method 1: When the numeric selection style is an operator style, and the operator style is equal to, not equal to, greater than, greater than or equal to, less than, less than or equal to, the default configuration style is a numeric input box.

[0196] Method 2: When the selected numerical style is an operator style, and that operator style is a range, the default configuration style is the range start value - the range end value, and it will check whether the range end value is greater than the range start value. If it is less, it will prompt you to modify it.

[0197] In this disclosure, the data format is based on the field configuration item format. When there are multiple data sources, the data format is based on the primary data source.

[0198] Furthermore, the input must be a number. If a non-numeric input is entered, the input will be blocked and a prompt message will be displayed, such as "Please enter a number".

[0199] A33, For date types

[0200] When the display style of the filter component is: tiled option style or drop-down option style, the selectable content is the deduplicated content after filtering the data source field, and the content is displayed in the format of the date field after deduplication.

[0201] When the filter component is displayed in the date selection style, the selection methods include the following:

[0202] Method 1: When the numeric selection style is an operator style, and the operator style is equal to, later than, or earlier than, the default configuration style is a single-day date component with dynamic date selection, such as today, tomorrow, or yesterday.

[0203] Method 2: When the numeric selection style is an operator style, and the operator style is a range, the default configuration style is a fixed range date selection component.

[0204] For dynamic date selection, options include: today, tomorrow, yesterday, this week, last week, this month, last month, within the past 7 days, within the next 7 days, within the past 30 days, or within the next 30 days.

[0205] It should be noted that during configuration, fixed selection and dynamic selection are mutually exclusive. When the default value is configured as dynamic date, the user will always see the dynamic date when accessing the site.

[0206] Optionally, if the default value corresponding to a default value configuration item is deleted from the data source, the default value is cleared, restoring the state to one without a default value. If the default value corresponding to a default value configuration item is deleted from the data source, but the default value is not within the scope of the linkage, the default value is not cleared.

[0207] S17. For the first configuration item being a related component configuration item, this related component configuration item can be triggered by clicking or other operations to display selectable components below it. Furthermore, any selectable component can be selected from the selectable components as the related component for the filter component, as shown in the following example. Figure 6j As shown.

[0208] Among them, the optional components can be, but are not limited to: optional chart components.

[0209] Furthermore, each optional chart component may include: a component icon and a component description, which can be understood as the component name.

[0210] In some embodiments, considering that there may be multiple configured data sources, optional chart components with a data table hierarchy can be displayed below the associated component configuration item. The data table hierarchy can be cascaded or tree-like, and there are no specific restrictions on it here.

[0211] like Figure 6j As shown, the optional chart component is displayed in the form of a drop-down list, and the drop-down list also includes a select all option. By selecting the select all option, you can select all chart components.

[0212] In some optional embodiments, this disclosure may also optionally include a switch configuration for automatically associating all chart components under the associated component configuration item. By enabling this switch, chart components selected by the data source in the user-added filter component will automatically take effect.

[0213] In some alternative embodiments, considering that the number of filter components created in the component page of the dashboard component can be multiple, this disclosure may also include: establishing a linkage relationship between at least two filter components in response to an association operation for at least two filter components.

[0214] like Figure 6j As shown, the optional components are displayed below the associated component configuration item. In addition to optional chart components, optional filter components are also included. Each optional filter component includes: a component icon and a component description, which can be understood as the component name.

[0215] Therefore, when it is necessary to establish a linkage relationship between at least two filter components, the associated filter component configuration item of the associated optional filter component can be triggered by clicking or pressing to display other filter components that are not the current filter component and have an intersection with the data source of the current filter component. Then, at least one of the other filter components can be selected from the other filter components according to the usage requirements to establish a linkage relationship with the current filter component.

[0216] It should be noted that the data sources of multiple filtering components that establish a linkage relationship in this disclosure need to have an intersection. If the data sources of multiple filtering components do not have an intersection, the linkage relationship between these multiple filtering components is not supported, thus ensuring that the multiple filtering components can be linked.

[0217] Optionally, when some of the associated components configured for an associated component configuration item are deleted, the associated component will not be displayed in the drop-down list corresponding to that component; when all the associated components configured for an associated component configuration item are deleted, the filter component will not take effect on any component. Here, associated components include: chart components and other filter components.

[0218] Furthermore, in some embodiments, such as Figure 7 As shown, the configuration interface of the filtering component of this disclosure may further include a second configuration area, which may include multiple second configuration items, including: a font color configuration item and a background color configuration item. That is, the second configuration area is specifically used to customize the color information of the filtering component.

[0219] Therefore, in response to configuration operations on the configuration interface, obtaining component configuration information may further include: in response to configuration operations on any second configuration item in the second configuration area, obtaining second configuration information. Furthermore, the first configuration information and the second configuration information are used as component configuration information for filtering components, and filtering components are created based on the first and second configuration information used as configuration information.

[0220] In some optional embodiments, based on the second configuration item including a font color configuration item and a background color configuration item, this disclosure, in response to a configuration operation on any second configuration item in the second configuration area, obtains second configuration information, which may include the following:

[0221] S21. For the second configuration item, which is the font color configuration item, it can be triggered by clicking or other operations to display the first color configuration panel below it. Then, font color configuration operations can be performed based on the first color configuration panel. The first color configuration panel includes: a restore default color option, a recommended color area, a user-selectable color area, and a transparency setting module. The font color setting applies to the description configuration item in the first configuration item.

[0222] S22. For the second configuration item being a background color configuration item, this background color configuration item can be triggered by clicking or other operations to display a second color configuration panel below it. Then, background color configuration operations can be performed based on the second color configuration panel. This second color configuration panel includes: a restore default color option, a recommended color area, a user-selectable color area, a transparency setting module, and a blur module.

[0223] In this way, the color configuration operations described above can be used to personalize the color of the filtering components to meet user needs.

[0224] In some embodiments, such as Figure 8 As shown, the configuration interface of the filtering component of this disclosure may also include a preview area. Therefore, this disclosure may optionally include at least one of the following:

[0225] In response to a configuration operation on any first configuration item in the first configuration area, the corresponding filter component is displayed in the preview area; in response to a configuration operation on any second configuration item in the second configuration area, the corresponding filter component is displayed in the preview area. This allows for real-time display of the filter component's configuration effect in the preview area of ​​the configuration interface based on the user's configuration operation, enabling the user to instantly view and adjust the configuration effect of the filter component.

[0226] In some embodiments, considering that the number of filtering components in this disclosure can be multiple, there may be cases where the optional fields of the corresponding filtering conditions of at least two filtering components have the same name.

[0227] Therefore, this disclosure handles cases of duplicate names based on the data source pattern of the filtering component, and the options include the following:

[0228] Scenario 1: When at least two filtering components have a single data source mode, they are grouped according to the unique information of the filtering components, such as ID, without deduplication and merging.

[0229] Scenario 2: When at least two filter components have a multi-data source mode, deduplication and merging are performed based on the same optional field name.

[0230] Considering that the dashboard component page may contain multiple components other than the filter component, such as multiple chart components, at least two of these components may have the same name. Therefore, the same handling method can be applied to filter components with the same name. Further details will not be elaborated here.

[0231] In some alternative embodiments, considering that after creating a filter component in the component page of the dashboard component, the display information of any filter component may not meet the usage requirements, this disclosure may optionally further include: adjusting the display information of the filter component in response to an adjustment operation on the filter component; wherein the display information includes at least one of display position and display size.

[0232] The aforementioned adjustment operation can refer to adjusting at least one of the display position and display size of any filtering component. Here, display size can be understood as the size information of the filtering component when it is displayed, which may include width and height information.

[0233] Optionally, after creating a filter component in the dashboard component's component page, if the user needs to adjust the display position of any filter component, they can trigger the filter component by long-pressing or long-touching, causing it to enter editable mode from its normal display state. The user can then drag the editable filter component to move it from its current display position to a target display position. Finally, the user can release the movement control of the filter component, and it will be displayed at the target location. Figure 9a As shown, this achieves the effect of adjusting the display position of the filter component.

[0234] Among them, a long press operation refers to a press event with a duration longer than a preset duration; a long touch operation refers to a touch event with a duration longer than a preset duration. The preset duration can be flexibly set according to actual needs, such as 2 seconds or 3 seconds, and this disclosure does not impose specific limitations on it.

[0235] In some embodiments, if it is necessary to adjust the display size of any filter component, the display size of the filter component can be enlarged by dragging any boundary of the filter component along a direction away from its center point. Figure 9b As shown; alternatively, you can drag any boundary of the filter component along a direction close to its center point to reduce its display size, as shown below. Figure 9c As shown. The direction away from the center point of the filter component can be called the first direction; the direction closer to the center point of the filter component can be called the second direction.

[0236] In some optional embodiments, considering that adjusting the display size of any filtering component may require simultaneously adjusting both the width and height information of the display size to improve the efficiency of the display size adjustment, this disclosure also allows dragging any corner of the filtering component's window along a direction away from the center point of the filtering component to simultaneously enlarge the display height and width information of the filtering component. Figure 9d As shown; alternatively, you can drag any corner of the filter component along a direction close to its center point to simultaneously reduce both its display height and width. Figure 9e As shown.

[0237] The aforementioned window corners refer to the upper left, upper right, lower left, or upper right corner of the window corresponding to the filtering component, and this disclosure does not impose any restrictions on this.

[0238] In some optional embodiments, considering that users may need to perform some basic operations on the filtering component, this disclosure may also include: displaying an operation interface corresponding to the filtering component in response to a preset operation on the filtering component; wherein the operation interface includes at least one available operation item.

[0239] In this disclosure, the preset operation can be a right-click triggered operation or a long-press operation.

[0240] The aforementioned at least one available operation item refers to a series of operation options for the filtering component. These available operation items may include, but are not limited to: configuration operation item, copy operation item, copy to operation item, add to workbench operation item, move into grouped layout operation item, and delete operation item.

[0241] Optionally, after creating a filter component in the dashboard component's component page, if you need to perform some basic operations on any filter component, you can right-click or long-press on any filter component to display an operation interface near that filter component, and this operation interface will display at least one available operation item, as shown in the example below. Figure 10 As shown. This allows users to perform at least one available action on the filtering component, thus improving user efficiency without leaving the data dashboard.

[0242] Considering that the number of filter components created can be at least one, the following will combine... Figure 11 For the case where the number of filtering components is one, step S102 in the aforementioned embodiments will be further explained. For example... Figure 11 As shown, step S102 may include the following steps S102-1A to S102-3A:

[0243] S102-1A, Determine the type information of the filtering component.

[0244] S102-2A, if the filtering component is a single-dimensional filtering component, then in response to the triggering operation of the filtering component, the target dimension of the filtering component is determined and the target dimension is used as the filtering information.

[0245] S102-3A, if the filtering component is a multi-dimensional filtering component, then in response to the trigger operation of the first dimension in the filtering component, the target first dimension of the filtering component is determined, the target second dimension of the filtering component is determined based on the target first dimension, and the filtering information is obtained based on the target first dimension and the target second dimension.

[0246] In some embodiments, the type information of a filtering component can be determined by determining the number of filtering conditions provided by the filtering component. Optionally, if a filtering component provides only one filtering condition, it is determined to be a single-dimensional filtering component; if a filtering component provides multiple filtering conditions, it is determined to be a multi-dimensional filtering component.

[0247] It should be understood that the above filtering conditions specifically refer to the optional fields provided by the filtering component. When the filtering component is a single-dimensional filtering component, there is only one type of optional field; when the filtering component is a multi-dimensional filtering component, there are multiple types of optional fields.

[0248] Furthermore, when the filtering component is determined to be a single-dimensional filtering component, when a user performs a data filtering operation on this component, they can select a target field from the single-dimensional optional fields provided by the filtering component. Subsequently, the user can trigger a data filtering operation based on this target field. When a user triggers a data filtering operation based on the single-dimensional filtering component, the target field of the single-dimensional filtering component can be obtained, and this target field can be determined as the target dimension of the filtering component, thus using this target dimension as the filtering information.

[0249] For example, assuming the filter component is a single-dimensional filter component based on "time", when a user selects "today" as the target field from the multiple date options provided by the single-dimensional filter component, the target field of the single-dimensional filter component can be obtained as "today", and then "today" can be determined as the filter information entered by the user.

[0250] In some embodiments, when the filtering component is determined to be a multi-dimensional filtering component, when a user performs a data filtering operation on the filtering component, the user can provide multiple optional fields through the filtering component. Then, based on the first optional field among the multiple optional fields provided by the filtering component, the user can select a target first-dimensional field and determine this target first-dimensional field as the target first-dimensional field. Next, based on the target first-dimensional field, the available second-dimensional field in the filtering component is updated, and based on the available second-dimensional field in the filtering component, the target second-dimensional field of the filtering component is determined. Finally, the target first-dimensional field and the target second-dimensional field are used as the filtering information.

[0251] For example, suppose the filtering component is a multi-dimensional filtering component based on "province" and "city". When a user selects "YY Province" as the target first-dimensional field from the available fields of the "province" first-dimensional field provided by the multi-dimensional filtering component, the target first-dimensional field of the multi-dimensional filtering component can be determined to be "YY Province". Because there is a linkage between the first and second dimensions, based on the target first-dimensional field "YY Province", the available fields of the "city" second-dimensional field provided by the multi-dimensional filtering component can be updated to multiple available city fields associated with "YY Province". Subsequently, the user can select "aa City" as the target second-dimensional field from the available city fields of the "city" second-dimensional field provided by the multi-dimensional filtering component, and the target second-dimensional field "aa City" is determined as the target second-dimensional field. Then, the target first-dimensional field "YY Province" and the target second-dimensional field "aa City" are determined as the filtering information entered by the user.

[0252] In some optional embodiments, considering that the fields of the filtering component have corresponding field types, different interaction methods can be used for filtering components with different field types to filter target data from the data dashboard based on the filtering information. The following are some of the possible methods, but not limited to:

[0253] S31. Filtering components for enumeration classes

[0254] First, the timing of the query.

[0255] B1. For drop-down lists (drop-down options): Initiate a query after closing the drop-down list; if the drop-down list options have not changed, do not initiate a query.

[0256] B2. For the tile option: Click the option to initiate a query.

[0257] Second, option update time

[0258] B1. For drop-down lists (drop-down options): the latest data is retrieved when the list is pulled, and there is no real-time collaborative update; updates are only made when the page is refreshed.

[0259] B2. For the tiled option: It does not update in real time, but only when the page is refreshed.

[0260] Third, select interaction

[0261] B1. Multiple selections are supported.

[0262] B2. Supports deselecting by inverting the selection.

[0263] B3. For drop-down lists (drop-down options): If there is input content, the drop-down box of the filter component has a clear button, which can be triggered to clear the selected content.

[0264] B4. Fuzzy Search: The drop-down list supports fuzzy search.

[0265] Fourth, the style of the options: determined by the field type corresponding to the filter component.

[0266] B1. Single-choice fields, multiple-choice fields, or calculation results are formulas and lookup references for enumerated option classes: display option colors and text.

[0267] B2. Personnel, Creator, Updater, or Calculation Result: Formulas and lookup references for enumerating personnel classes: Display personnel avatars and names.

[0268] B3. One-way or two-way association: Displays the text of the indexed column and the style of the retained related items.

[0269] B4. Process Fields: Displays the process name and process color, etc.

[0270] B5. Groups, calculation results are formulas and lookup references for enumerated group classes: display group avatars and names.

[0271] B6. Checkboxes, text, hyperlinks, phone numbers, email addresses, geolocation, barcodes, calculation results are formulas and lookup references for enumerated text classes or enumerated checkboxes: display custom option styles.

[0272] S32. Filtering components for numerical data

[0273] First, the timing of the query.

[0274] A query will be initiated after the input content is out of focus or a click is triggered. If no content is entered, the input content is empty, or the input content has not changed, the query operation will not be initiated.

[0275] Second, the filter component style is: numerical range.

[0276] B1. The filter range is defined as: starting value - ending value = greater than or equal to {starting value} and less than or equal to {ending value}.

[0277] B2. Supports initiating query operations by only entering a start value or an end value.

[0278] Third, input validation

[0279] B1. The format of the input numeric value shall be based on the format set in the filter component field.

[0280] B2. Input content is limited to numbers. If non-numeric content is entered, no input will be possible and a prompt message will be displayed. The prompt message may include, but is not limited to: "Please enter a number".

[0281] Fourth, clear function: If there is content entered in the input box, a clear button will appear when the input box is triggered, and the selected content can be cleared by triggering the clear button.

[0282] Fifth, the style of the options: determined by the field type corresponding to the filter component.

[0283] B1. Numbers, currencies, ratings, progress, auto-encoding, or calculation results are numerical formulas and lookup references: display custom option styles.

[0284] S33. Filtering components for date categories

[0285] First, the timing of the query.

[0286] Initiate a query after closing the dropdown list; do not initiate a query if the dropdown list options have not changed.

[0287] Second, filter component styles

[0288] B1. Date Selection - Range

[0289] The user-defined display shows a date range filter component (with built-in dynamic range selection).

[0290] This date range filtering component offers dynamic and fixed ranges; the dynamic range includes, but is not limited to: today, tomorrow, yesterday, this week, last week, this month, last month, the past 7 days, the next 7 days, the past 30 days, and the next 30 days; the fixed range allows you to select a fixed period of time through a custom range.

[0291] B2. Date Selection - Earlier than, Later than, or Equal to

[0292] The input content is a date point, and the input content can include dynamic time and specific time;

[0293] Dynamic time includes, but is not limited to: today, yesterday, and tomorrow;

[0294] The specific time is selected by choosing a specific date.

[0295] Third, the clear function: If there is content entered in the input box, a clear button will appear when the input box is triggered, and the selected content can be cleared by triggering the clear button.

[0296] Fifth, the style of the options: determined by the field type corresponding to the filter component.

[0297] B1. Date, creation time, last update time, or calculation result is a date-based formula and lookup reference: Displays custom option styles.

[0298] In some alternative embodiments, considering that the filtering component can establish an association with at least one chart component, the data filtering based on the filtering component can be used to filter the data of the associated at least one chart component. That is, the way the filtering component affects the associated chart component can be as follows:

[0299] First, the filter component can be used as a "and" filter condition to apply to all chart components associated with it.

[0300] In other words, when filter criteria are entered based on a filter component, the data range of all associated chart components will be updated immediately. The filter criteria can be understood as the content or information to be filtered.

[0301] Second, when the user refreshes the page, the filter conditions entered in the filter component are not saved, and the filter component is restored to its default value or empty state.

[0302] It should be noted that when filter criteria are entered based on the filter component, if none of the chart components associated with that filter component have corresponding data, a prompt message will be output to remind the user to make adjustments. This prompt message can include, but is not limited to, statements such as "data is empty".

[0303] In some optional embodiments, considering that the number of chart components associated with the filtering component may differ—for example, some chart components may have a small number of data points (small order of magnitude), while others may have a large number of data points (large order of magnitude)—the number of chart components can be determined in this disclosure by comparing the data volume of the chart component with a data volume threshold. If the data volume of the chart component is less than the data volume threshold, it is determined to be a small order of magnitude chart component; if the data volume of the chart component is greater than or equal to the data volume threshold, it is determined to be a large order of magnitude chart component. The data volume threshold can be flexibly set according to actual application needs, and no specific restrictions are imposed here. That is, the data volume threshold is an adjustable parameter.

[0304] Therefore, for chart components of different quantities, this disclosure can maintain the ability to update in real time for chart components of small quantities; and can use an asynchronous polling method to update chart components of large quantities.

[0305] By determining the filtering information in the above manner, different levels of data filtering can be achieved based on different types of filtering components. For example, a single-dimensional filtering component can perform simple data filtering operations, which can improve data filtering efficiency, while a multi-dimensional filtering component can perform relatively complex data filtering operations, which can obtain target data more accurately.

[0306] In some alternative embodiments, considering that the number of filtering components created can be at least one, then the following is combined with Figure 12 For cases where there are multiple filtering components, step S102 in the aforementioned embodiments will be further explained. For example... Figure 12 As shown, step S102 may include the following steps S102-1B to S102-3B:

[0307] S102-1 B, in response to a trigger operation on the first filtering component, determine the first filtering information.

[0308] S102-2B, If there is a linkage between the first filtering component and the second filtering component, then the second filtering information of the second filtering component is determined according to the first filtering information, and the first filtering information and the second filtering information are used as filtering information.

[0309] S102-3B, If there is no linkage between the first filtering component and the second filtering component, then the first filtering information is determined as the filtering information.

[0310] The first and second filtering components can be either single-dimensional or multi-dimensional filtering components, without specific restrictions. For example, the first filtering component can be a single-dimensional filtering component and the second filtering component can be a multi-dimensional filtering component; or, the first filtering component can be a multi-dimensional filtering component and the second filtering component can be a single-dimensional filtering component; or, the first filtering component can be a multi-dimensional filtering component and the second filtering component can also be a multi-dimensional filtering component; or, the first filtering component can be a single-dimensional filtering component and the second filtering component can also be a single-dimensional filtering component.

[0311] Furthermore, the number of the aforementioned second filtering components can be one or more, and the second filtering components are different from the first filtering components. That is, when the number of filtering components created in this disclosure is multiple, the filtering components include a first filtering component and at least one second filtering component.

[0312] In some alternative embodiments, when performing a data filtering operation based on the first filtering component, the user can select a target field from the optional fields provided by the first filtering component and determine the target field as the first filtering information.

[0313] Considering that the first filtering component may have a linkage relationship with the second filtering component, after determining the first filtering information, this disclosure can determine whether there is a linkage relationship between the first filtering component and any second filtering component based on the component configuration information in the associated component configuration item. If it is determined that there is no linkage relationship between the first filtering component and all second filtering components, then the first filtering information is determined as the filtering information. If it is determined that there is a linkage relationship between the first filtering component and any second filtering component, then determining the first filtering information corresponding to the first filtering component will affect the available filtering information corresponding to the second filtering component. At this time, the available filtering information of the second filtering component can be updated according to the first filtering information, and the second filtering information of the second filtering component can be determined according to the available filtering information of the second filtering component. Then, the first filtering information and the second filtering information are determined to be the filtering information input by the user.

[0314] For example, assuming there is one second filter component that is linked to the first filter component, when the user selects "202X" in the "Year" field using the first filter component, the available filter information associated with the "Quarter" field of the second filter component will be automatically updated based on the year "202X" to the quarter options within the selected "202X" for the user to further filter.

[0315] For example, suppose there are two second filter components that are linked to the first filter component, namely second filter components Z1 and Z2. When the user selects "Yunnan Province" in "Province" using the first filter component, the available filter information associated with the "City" field of the second filter component Z1 will be automatically updated to the city options associated with the selected "Yunnan Province" based on the province "Yunnan Province". Furthermore, the available filter information associated with the "Region" field of the second filter component Z2 will be automatically updated to the region options related to the selected province "Yunnan Province" and city "XXX" based on the province "Yunnan Province" and city "XXX".

[0316] In other words, once the first filter component selects a filter condition, the other linked filter components will automatically filter based on that filter condition, thus helping users to more accurately filter the data they need.

[0317] In some optional embodiments, this disclosure may also include: in response to the existence of a linkage relationship between the first filtering component and the second filtering component, and the data source associated with the first filtering component and the data source associated with the second filtering component being partially the same, determining an intersection data source based on the data source associated with the first filtering component and the data source associated with the second filtering component; and determining a target component that is associated with the filtering information and corresponds to the intersection data source from the component page based on the filtering information, and updating the data in the data table displayed in the target component.

[0318] Considering that at least two filtering components are linked, such as the first filtering component and the second filtering component, the data source may be exactly the same or different.

[0319] Specifically, when the data sources of the first and second filtering components that are linked are exactly the same, and the data source mode is a single data source, linked calculations can be performed according to each row of a single table, i.e., linked filtering.

[0320] When the data sources of the first and second filtering components that are linked are exactly the same, and the data source mode is multiple data sources, the union of multiple tables can be taken, and this union can be treated as a single table for linked calculation.

[0321] When the data sources of the first and second filtering components that are linked are not completely identical (partially identical), and the data source mode is multiple data sources, this disclosure can determine the intersection of the data source associated with the first filtering component and the data source associated with the second filtering component, and then obtain the target data corresponding to the filtering information based on the intersection, thereby realizing the linkage between multiple filtering components.

[0322] For example, suppose the first filtering component is an employee filtering component, and the fields of this employee filtering component are configured from multiple data sources: [Employee Information Table A], [Employee Information Table B], and [Employee Performance Table]. The second filtering component is a department filtering component, and the fields of this department filtering component are also configured from multiple data sources: [Employee Information Table A] and [Employee Information Table B]. When the employee filtering component and the department filtering component are linked, the intersection of these two filtering components is [Employee Information Table A] and [Employee Information Table B]. The target data can then be filtered based on this intersection [Employee Information Table A] and [Employee Information Table B].

[0323] In some alternative embodiments, considering that the filtering conditions of the first filtering component may change in the first and second filtering components that are linked, and that such change may affect the selected conditions of the second filtering component, the following approach can be used to handle this situation:

[0324] Method 1: When the filtering conditions of the first filtering component change, it only affects the selectable range of the second filtering component, but does not affect the selected conditions of the second filtering component. In this case, the filtering conditions of the first filtering component and the selected conditions of the second filtering component are not cleared.

[0325] Method 2: When the filtering conditions of the first filtering component change, affecting the second filtering component to have no selectable conditions, if the second filtering component is not configured with a default value, then the second filtering component is determined to be "not selected", and data is filtered only based on the filtering conditions of the first filtering component.

[0326] In some optional embodiments, considering that the data source associated with either the first or second filtering component that has an established linkage relationship may change, the linkage relationship between the first and second filtering components can be adjusted in the following way:

[0327] In the first method, if the data source associated with the first or second filter component changes, resulting in no overlap between the data sources associated with the first and second filter components, the linkage relationship will be automatically terminated.

[0328] In the second approach, if the data source associated with the first or second filtering component changes, but a new linkage relationship is identified, or the data source of an existing linkage relationship changes, then a new data intersection can be determined, and the filtering linkage logic can be implemented based on this new data intersection.

[0329] For example, suppose the first filtering component is an employee filtering component, and the fields of this employee filtering component are configured from multiple data sources: [Employee Information Table A] & [Employee Information Table B]. The second filtering component is a department filtering component, and the fields of this department filtering component are configured from multiple data sources: [Employee Information Table A]. Then, when the fields of the department filtering component change from [Employee Information Table A] to [Employee Information Table A] & [Employee Information Table B], the logic for updating the linked calculation will be to perform the linked calculation based on [Employee Information Table A] & [Employee Information Table B].

[0330] The following is a reference to the appendix. Figure 13 This disclosure describes a data updating apparatus for components in a table, as proposed in an embodiment. Figure 13 As shown, the data update device 400 for the components in the table includes: a component creation module 410, an information determination module 420, and a data update module 430.

[0331] The component creation module 410 is configured and created in response to the operation of creating a filter component on the component page of the table. The component page is used to create different types of components, including components for displaying the data of the table in the form of charts.

[0332] Information determination module 420 is used to determine filtering information in response to a trigger operation on the filtering component;

[0333] The data update module 430 is used to determine the target component associated with the filter information from the component page according to the filter information, and update the data of the data table displayed in the target component, wherein the filter information is at least one data dimension configured in the target component.

[0334] In one optional implementation of this disclosure, the component creation module 410 is specifically used for:

[0335] In response to the operation of creating a filter component on the component page of the table, the configuration interface of the filter component is displayed;

[0336] In response to configuration operations on the configuration interface, obtain component configuration information;

[0337] The filtering component is created based on the component configuration information.

[0338] In one optional implementation of this disclosure, the configuration interface includes a first configuration area, the first configuration area includes a plurality of first configuration items, and the component creation module 410 is further configured to:

[0339] In response to a configuration operation on any of the first configuration items in the first configuration region, first configuration information is obtained and used as the component configuration information.

[0340] In one optional implementation of this disclosure, the configuration interface further includes a second configuration area, the second configuration area including a plurality of second configuration items, and the component creation module 410 is further configured to:

[0341] In response to a configuration operation on any of the second configuration items in the second configuration area, second configuration information is obtained and used as the component configuration information.

[0342] In an optional implementation of this disclosure, the configuration interface further includes a preview area, and the component creation module 410 further includes a display unit, which is configured to perform at least one of the following:

[0343] In response to a configuration operation on any of the first configuration items in the first configuration area, the filter component corresponding to the configuration operation is displayed in the preview area;

[0344] In response to a configuration operation on any of the second configuration items in the second configuration area, the filter component corresponding to the configuration operation is displayed in the preview area.

[0345] In one optional implementation of this disclosure, the data updating device 400 for the components in the table further includes:

[0346] The interface display module is used to display the operation interface corresponding to the filter component in response to a preset operation on the filter component; wherein the operation interface includes at least one available operation item.

[0347] In one optional implementation of this disclosure, the data updating device 400 for the components in the table further includes:

[0348] An adjustment module is configured to adjust the display information of the filtering component in response to an adjustment operation on the filtering component; wherein the display information includes at least one of display position and display size.

[0349] In one optional implementation of this disclosure, the number of filtering components is multiple, and the data updating device 400 for the components in the table further includes:

[0350] The linkage module is used to establish a linkage relationship between at least two of the filtering components in response to an association operation for at least two of the filtering components.

[0351] In one optional implementation of this disclosure, the filtering component includes a single-dimensional filtering component and a multi-dimensional filtering component.

[0352] In one optional implementation of this disclosure, the information determination module 420 is specifically used for:

[0353] If the filtering component is a single-dimensional filtering component, then in response to the triggering operation of the filtering component, the target dimension of the filtering component is determined, and the target dimension is used as the filtering information;

[0354] If the filtering component is a multi-dimensional filtering component, then in response to a trigger operation on the first dimension of the filtering component, the target first dimension of the filtering component is determined, the target second dimension of the filtering component is determined based on the target first dimension, and the filtering information is obtained based on the target first dimension and the target second dimension.

[0355] In an optional implementation of this disclosure, the information determination module 420 is further configured to:

[0356] Based on the first objective dimension, update the available second dimension of the filtering component;

[0357] Based on the available second dimension, the target second dimension of the filtering component is determined.

[0358] In one optional implementation of this disclosure, the number of filtering components is multiple, and the information determination module 420 is specifically used for:

[0359] In response to a trigger operation on the first filtering component, determine the first filtering information;

[0360] If there is a linkage between the first filtering component and the second filtering component, then based on the first filtering information, the second filtering information of the second filtering component is determined, and the first filtering information and the second filtering information are used as the filtering information.

[0361] In an optional implementation of this disclosure, the information determination module 420 is further configured to:

[0362] Based on the first filtering information, update the available filtering information of the second filtering component;

[0363] Based on the available filtering information of the second filtering component, determine the second filtering information of the second filtering component.

[0364] It should be understood that the device embodiments and the foregoing method embodiments can correspond to each other, and similar descriptions can be found in the first aspect of the method embodiments. To avoid repetition, further details will not be provided here. Specifically, Figure 13 The device 400 shown can perform Figure 1The corresponding method embodiments, and the foregoing and other operations and / or functions of each module in device 400 are respectively implemented to achieve Figure 1 For the sake of brevity, the corresponding processes in each method are not described in detail here.

[0365] The apparatus 400 of this disclosure embodiment has been described above from the perspective of functional modules in conjunction with the accompanying drawings. It should be understood that this functional module can be implemented in hardware, in software instructions, or in a combination of hardware and software modules. Specifically, the steps of the first aspect method embodiment of this disclosure can be completed by integrated logic circuits in the processor's hardware and / or by software instructions. The steps of the first aspect method disclosed in this disclosure can be directly embodied as being executed by a hardware decoding processor, or by a combination of hardware and software modules in the decoding processor. Optionally, the software module can be located in a mature storage medium in the art, such as random access memory, flash memory, read-only memory, programmable read-only memory, electrically erasable programmable memory, registers, etc. This storage medium is located in memory, and the processor reads information from the memory and, in conjunction with its hardware, completes the steps of the first aspect method embodiment described above.

[0366] Figure 14 This is a schematic block diagram of an electronic device provided as an embodiment of this disclosure. Figure 14 As shown, the electronic device 500 may include a memory 510 and a processor 520. The memory 510 stores a computer program and transmits the program code to the processor 520. In other words, the processor 520 can retrieve and run the computer program from the memory 510 to implement the data update method for the components in the table according to any one of the embodiments of this disclosure.

[0367] For example, the processor 520 can be used to execute a data update method for any of the components in the table as described in the computer program.

[0368] In some embodiments of this disclosure, a method for updating data in a table includes:

[0369] In response to the operation of creating a filter component on the component page of the table, the filter component is configured and created. The component page is used to create different types of components, including components for displaying the data of the table in the form of charts.

[0370] In response to a triggering operation on the filtering component, filtering information is determined;

[0371] Based on the filtering information, a target component associated with the filtering information is determined from the component page, and the data in the data table displayed in the target component is updated, wherein the filtering information is at least one data dimension configured in the target component.

[0372] In some embodiments of this disclosure, configuring and creating the filter component in response to the operation of creating a filter component on the component page of the table includes:

[0373] In response to the operation of creating a filter component on the component page of the table, the configuration interface of the filter component is displayed;

[0374] In response to configuration operations on the configuration interface, obtain component configuration information;

[0375] The filtering component is created based on the component configuration information.

[0376] In some embodiments of this disclosure, the configuration interface includes a first configuration area, the first configuration area including a plurality of first configuration items, and the step of obtaining component configuration information in response to a configuration operation on the configuration interface includes:

[0377] In response to a configuration operation on any of the first configuration items in the first configuration region, first configuration information is obtained and used as the component configuration information.

[0378] In some embodiments of this disclosure, the configuration interface further includes a second configuration area, which includes a plurality of second configuration items. The step of obtaining component configuration information in response to a configuration operation on the configuration interface further includes:

[0379] In response to a configuration operation on any of the second configuration items in the second configuration area, second configuration information is obtained and used as the component configuration information.

[0380] In some embodiments of this disclosure, the configuration interface further includes a preview area, and the method further includes at least one of the following:

[0381] In response to a configuration operation on any of the first configuration items in the first configuration area, the filter component corresponding to the configuration operation is displayed in the preview area;

[0382] In response to a configuration operation on any of the second configuration items in the second configuration area, the filter component corresponding to the configuration operation is displayed in the preview area.

[0383] In some embodiments of this disclosure, the method further includes:

[0384] In response to a preset operation on the filtering component, an operation interface corresponding to the filtering component is displayed; wherein the operation interface includes at least one available operation item.

[0385] In some embodiments of this disclosure, the method further includes:

[0386] In response to an adjustment operation on the filtering component, the display information of the filtering component is adjusted; wherein the display information includes at least one of display position and display size.

[0387] In some embodiments of this disclosure, the number of filtering components is multiple, and the method further includes:

[0388] In response to an association operation on at least two of the filtering components, an association relationship is established between at least two of the filtering components.

[0389] In some embodiments of this disclosure, the filtering component includes a single-dimensional filtering component and a multi-dimensional filtering component.

[0390] In some embodiments of this disclosure, determining the filtering information in response to a triggering operation on the filtering component includes:

[0391] If the filtering component is a single-dimensional filtering component, then in response to the triggering operation of the filtering component, the target dimension of the filtering component is determined, and the target dimension is used as the filtering information;

[0392] If the filtering component is a multi-dimensional filtering component, then in response to a trigger operation on the first dimension of the filtering component, the target first dimension of the filtering component is determined, the target second dimension of the filtering component is determined based on the target first dimension, and the filtering information is obtained based on the target first dimension and the target second dimension.

[0393] In some embodiments of this disclosure, determining the target second dimension of the filtering component based on the target first dimension includes:

[0394] Based on the first objective dimension, update the available second dimension of the filtering component;

[0395] Based on the available second dimension, the target second dimension of the filtering component is determined.

[0396] In some embodiments of this disclosure, the number of filtering components is multiple, and determining the filtering information in response to a triggering operation on the filtering components includes:

[0397] In response to a trigger operation on the first filtering component, determine the first filtering information;

[0398] If there is a linkage between the first filtering component and the second filtering component, then based on the first filtering information, the second filtering information of the second filtering component is determined, and the first filtering information and the second filtering information are used as the filtering information.

[0399] In some embodiments of this disclosure, determining the second filtering information of the second filtering component based on the first filtering information includes:

[0400] Based on the first filtering information, update the available filtering information of the second filtering component;

[0401] Based on the available filtering information of the second filtering component, determine the second filtering information of the second filtering component.

[0402] In some embodiments of this disclosure, the processor 520 may include, but is not limited to:

[0403] General-purpose processors, digital signal processors (DSPs), application-specific integrated circuits (ASICs), field-programmable gate arrays (FPGAs), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc.

[0404] In some embodiments of this disclosure, the memory 510 includes, but is not limited to:

[0405] Volatile memory and / or non-volatile memory. Non-volatile memory can be read-only memory (ROM), programmable read-only memory (PROM), erasable programmable read-only memory (EPROM), electrically erasable programmable read-only memory (EEPROM), or flash memory. Volatile memory can be random access memory (RAM), which is used as an external cache. By way of example, but not limitation, many forms of RAM are available, such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDR SDRAM), Enhanced Synchronous DRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), and Direct Rambus RAM (DR RAM).

[0406] In some embodiments of this disclosure, the computer program may be divided into one or more modules, which are stored in the memory 510 and executed by the processor 520 to complete the data update method for the components in the table as described in any one embodiment of this disclosure. The one or more modules may be a series of computer program instruction segments capable of performing a specific function, which describe the execution process of the computer program in the electronic device.

[0407] like Figure 14 As shown, the electronic device 500 may further include:

[0408] Transceiver 530, which can be connected to processor 520 or memory 510.

[0409] The processor 520 can control the transceiver 530 to communicate with other devices; specifically, it can send information or data to other devices or receive information or data sent by other devices. The transceiver 530 may include a transmitter and a receiver. The transceiver 530 may further include antennas, and the number of antennas may be one or more.

[0410] It should be understood that the various components in the electronic device are connected through a bus system, which includes a data bus, a power bus, a control bus, and a status signal bus.

[0411] This disclosure also provides a computer storage medium having a computer program stored thereon, which, when executed by a computer, enables the computer to perform the data update method for the components in the table as described in any one of the embodiments of this disclosure.

[0412] In some embodiments of this disclosure, a method for updating data in a table includes:

[0413] In response to the operation of creating a filter component on the component page of the table, the filter component is configured and created. The component page is used to create different types of components, including components for displaying the data of the table in the form of charts.

[0414] In response to a triggering operation on the filtering component, filtering information is determined;

[0415] Based on the filtering information, a target component associated with the filtering information is determined from the component page, and the data in the data table displayed in the target component is updated, wherein the filtering information is at least one data dimension configured in the target component.

[0416] In some embodiments of this disclosure, configuring and creating the filter component in response to the operation of creating a filter component on the component page of the table includes:

[0417] In response to the operation of creating a filter component on the component page of the table, the configuration interface of the filter component is displayed;

[0418] In response to configuration operations on the configuration interface, obtain component configuration information;

[0419] The filtering component is created based on the component configuration information.

[0420] In some embodiments of this disclosure, the configuration interface includes a first configuration area, the first configuration area including a plurality of first configuration items, and the step of obtaining component configuration information in response to a configuration operation on the configuration interface includes:

[0421] In response to a configuration operation on any of the first configuration items in the first configuration region, first configuration information is obtained and used as the component configuration information.

[0422] In some embodiments of this disclosure, the configuration interface further includes a second configuration area, which includes a plurality of second configuration items. The step of obtaining component configuration information in response to a configuration operation on the configuration interface further includes:

[0423] In response to a configuration operation on any of the second configuration items in the second configuration area, second configuration information is obtained and used as the component configuration information.

[0424] In some embodiments of this disclosure, the configuration interface further includes a preview area, and the method further includes at least one of the following:

[0425] In response to a configuration operation on any of the first configuration items in the first configuration area, the filter component corresponding to the configuration operation is displayed in the preview area;

[0426] In response to a configuration operation on any of the second configuration items in the second configuration area, the filter component corresponding to the configuration operation is displayed in the preview area.

[0427] In some embodiments of this disclosure, the method further includes:

[0428] In response to a preset operation on the filtering component, an operation interface corresponding to the filtering component is displayed; wherein the operation interface includes at least one available operation item.

[0429] In some embodiments of this disclosure, the method further includes:

[0430] In response to an adjustment operation on the filtering component, the display information of the filtering component is adjusted; wherein the display information includes at least one of display position and display size.

[0431] In some embodiments of this disclosure, the number of filtering components is multiple, and the method further includes:

[0432] In response to an association operation on at least two of the filtering components, an association relationship is established between at least two of the filtering components.

[0433] In some embodiments of this disclosure, the filtering component includes a single-dimensional filtering component and a multi-dimensional filtering component.

[0434] In some embodiments of this disclosure, determining the filtering information in response to a triggering operation on the filtering component includes:

[0435] If the filtering component is a single-dimensional filtering component, then in response to the triggering operation of the filtering component, the target dimension of the filtering component is determined, and the target dimension is used as the filtering information;

[0436] If the filtering component is a multi-dimensional filtering component, then in response to a trigger operation on the first dimension of the filtering component, the target first dimension of the filtering component is determined, the target second dimension of the filtering component is determined based on the target first dimension, and the filtering information is obtained based on the target first dimension and the target second dimension.

[0437] In some embodiments of this disclosure, determining the target second dimension of the filtering component based on the target first dimension includes:

[0438] Based on the first objective dimension, update the available second dimension of the filtering component;

[0439] Based on the available second dimension, the target second dimension of the filtering component is determined.

[0440] In some embodiments of this disclosure, the number of filtering components is multiple, and determining the filtering information in response to a triggering operation on the filtering components includes:

[0441] In response to a trigger operation on the first filtering component, determine the first filtering information;

[0442] If there is a linkage between the first filtering component and the second filtering component, then based on the first filtering information, the second filtering information of the second filtering component is determined, and the first filtering information and the second filtering information are used as the filtering information.

[0443] In some embodiments of this disclosure, determining the second filtering information of the second filtering component based on the first filtering information includes:

[0444] Based on the first filtering information, update the available filtering information of the second filtering component;

[0445] Based on the available filtering information of the second filtering component, determine the second filtering information of the second filtering component.

[0446] This disclosure also provides a computer program product containing program instructions that, when executed on an electronic device, cause the electronic device to perform a data update method capable of executing any of the components in the table described in any one of the embodiments of this disclosure.

[0447] In some embodiments of this disclosure, a method for updating data in a table includes:

[0448] In response to the operation of creating a filter component on the component page of the table, the filter component is configured and created. The component page is used to create different types of components, including components for displaying the data of the table in the form of charts.

[0449] In response to a triggering operation on the filtering component, filtering information is determined;

[0450] Based on the filtering information, a target component associated with the filtering information is determined from the component page, and the data in the data table displayed in the target component is updated, wherein the filtering information is at least one data dimension configured in the target component.

[0451] In some embodiments of this disclosure, configuring and creating the filter component in response to the operation of creating a filter component on the component page of the table includes:

[0452] In response to the operation of creating a filter component on the component page of the table, the configuration interface of the filter component is displayed;

[0453] In response to configuration operations on the configuration interface, obtain component configuration information;

[0454] The filtering component is created based on the component configuration information.

[0455] In some embodiments of this disclosure, the configuration interface includes a first configuration area, the first configuration area including a plurality of first configuration items, and the step of obtaining component configuration information in response to a configuration operation on the configuration interface includes:

[0456] In response to a configuration operation on any of the first configuration items in the first configuration region, first configuration information is obtained and used as the component configuration information.

[0457] In some embodiments of this disclosure, the configuration interface further includes a second configuration area, which includes a plurality of second configuration items. The step of obtaining component configuration information in response to a configuration operation on the configuration interface further includes:

[0458] In response to a configuration operation on any of the second configuration items in the second configuration area, second configuration information is obtained and used as the component configuration information.

[0459] In some embodiments of this disclosure, the configuration interface further includes a preview area, and the method further includes at least one of the following:

[0460] In response to a configuration operation on any of the first configuration items in the first configuration area, the filter component corresponding to the configuration operation is displayed in the preview area;

[0461] In response to a configuration operation on any of the second configuration items in the second configuration area, the filter component corresponding to the configuration operation is displayed in the preview area.

[0462] In some embodiments of this disclosure, the method further includes:

[0463] In response to a preset operation on the filtering component, an operation interface corresponding to the filtering component is displayed; wherein the operation interface includes at least one available operation item.

[0464] In some embodiments of this disclosure, the method further includes:

[0465] In response to an adjustment operation on the filtering component, the display information of the filtering component is adjusted; wherein the display information includes at least one of display position and display size.

[0466] In some embodiments of this disclosure, the number of filtering components is multiple, and the method further includes:

[0467] In response to an association operation on at least two of the filtering components, an association relationship is established between at least two of the filtering components.

[0468] In some embodiments of this disclosure, the filtering component includes a single-dimensional filtering component and a multi-dimensional filtering component.

[0469] In some embodiments of this disclosure, determining the filtering information in response to a triggering operation on the filtering component includes:

[0470] If the filtering component is a single-dimensional filtering component, then in response to the triggering operation of the filtering component, the target dimension of the filtering component is determined, and the target dimension is used as the filtering information;

[0471] If the filtering component is a multi-dimensional filtering component, then in response to a trigger operation on the first dimension of the filtering component, the target first dimension of the filtering component is determined, the target second dimension of the filtering component is determined based on the target first dimension, and the filtering information is obtained based on the target first dimension and the target second dimension.

[0472] In some embodiments of this disclosure, determining the target second dimension of the filtering component based on the target first dimension includes:

[0473] Based on the first objective dimension, update the available second dimension of the filtering component;

[0474] Based on the available second dimension, the target second dimension of the filtering component is determined.

[0475] In some embodiments of this disclosure, the number of filtering components is multiple, and determining the filtering information in response to a triggering operation on the filtering components includes:

[0476] In response to a trigger operation on the first filtering component, determine the first filtering information;

[0477] If there is a linkage between the first filtering component and the second filtering component, then based on the first filtering information, the second filtering information of the second filtering component is determined, and the first filtering information and the second filtering information are used as the filtering information.

[0478] In some embodiments of this disclosure, determining the second filtering information of the second filtering component based on the first filtering information includes:

[0479] Based on the first filtering information, update the available filtering information of the second filtering component;

[0480] Based on the available filtering information of the second filtering component, determine the second filtering information of the second filtering component.

[0481] When implemented using software, it can be implemented entirely or partially as a computer program product. This computer program product includes one or more computer instructions. When these computer program instructions are loaded and executed on a computer, all or part of the processes or functions described in the embodiments of this disclosure are generated. The computer can be a general-purpose computer, a special-purpose computer, a computer network, or other programmable device. The computer instructions can be stored in a computer-readable storage medium or transmitted from one computer-readable storage medium to another. For example, the computer instructions can be transmitted from one website, computer, server, or data center to another via wired (e.g., coaxial cable, fiber optic, digital subscriber line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.) means. The computer-readable storage medium can be any available medium accessible to a computer or a data storage device such as a server or data center that integrates one or more available media. The available medium can be a magnetic medium (e.g., floppy disk, hard disk, magnetic tape), an optical medium (e.g., digital video disc (DVD)), or a semiconductor medium (e.g., solid-state disk (SSD)).

[0482] Those skilled in the art will recognize that the modules and algorithm steps of the various examples described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are implemented in hardware or software depends on the specific application and design constraints of the technical solution. Those skilled in the art can use different methods to implement the described functions for each specific application, but such implementation should not be considered beyond the scope of this disclosure.

[0483] In the embodiments provided in this disclosure, it should be understood that the disclosed systems, apparatuses, and methods can be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative; for instance, the division of modules is only a logical functional division, and in actual implementation, there may be other division methods. For example, multiple modules or components may be combined or integrated into another system, or some features may be ignored or not executed. Furthermore, the coupling or direct coupling or communication connection shown or discussed may be through some interfaces; the indirect coupling or communication connection between apparatuses or modules may be electrical, mechanical, or other forms.

[0484] The modules described as separate components may or may not be physically separate. The components shown as modules may or may not be physical modules; that is, they may be located in one place or distributed across multiple network units. Some or all of the modules can be selected to achieve the purpose of this embodiment according to actual needs. For example, the functional modules in the various embodiments of this disclosure may be integrated into one processing module, or each module may exist physically separately, or two or more modules may be integrated into one module.

[0485] In this disclosure, the terms "module" or "unit" refer to a computer program or part of a computer program that has a predetermined function and works with other related parts to achieve a predetermined goal, and can be implemented wholly or partially using software, hardware (such as processing circuitry or memory), or a combination thereof. Similarly, a processor (or multiple processors or memory) can be used to implement one or more modules or units. Furthermore, each module or unit can be part of an overall module or unit that includes the functionality of that module or unit.

[0486] The above description is merely a specific embodiment of this disclosure, but the scope of protection of this disclosure is not limited thereto. Any variations or substitutions that can be easily conceived by those skilled in the art within the scope of the technology disclosed in this disclosure should be included within the scope of protection of this disclosure. Therefore, the scope of protection of this disclosure should be determined by the scope of the claims.

Claims

1. A method for updating data in a table component, characterized in that, include: In response to the operation of creating a filter component on the component page of the table, the filter component is configured and created. The component page is used to create different types of components, including components for displaying the data of the table in the form of charts. In response to a triggering operation on the filtering component, filtering information is determined; Based on the filtering information, a target component associated with the filtering information is determined from the component page, and the data in the data table displayed in the target component is updated, wherein the filtering information is at least one data dimension configured in the target component.

2. The method according to claim 1, characterized in that, The operation of configuring and creating a filter component in response to the creation of a filter component on the component page of the table includes: In response to the operation of creating a filter component on the component page of the table, the configuration interface of the filter component is displayed; In response to configuration operations on the configuration interface, obtain component configuration information; The filtering component is created based on the component configuration information.

3. The method according to claim 2, characterized in that, The configuration interface includes a first configuration area, which includes multiple first configuration items. The step of obtaining component configuration information in response to a configuration operation on the configuration interface includes: In response to a configuration operation on any of the first configuration items in the first configuration region, first configuration information is obtained and used as the component configuration information.

4. The method according to claim 2, characterized in that, The configuration interface further includes a second configuration area, which includes multiple second configuration items. The step of obtaining component configuration information in response to a configuration operation on the configuration interface further includes: In response to a configuration operation on any of the second configuration items in the second configuration area, second configuration information is obtained and used as the component configuration information.

5. The method according to claim 3 or 4, characterized in that, The configuration interface further includes a preview area, and the method further includes at least one of the following: In response to a configuration operation on any of the first configuration items in the first configuration area, the filter component corresponding to the configuration operation is displayed in the preview area; In response to a configuration operation on any of the second configuration items in the second configuration area, the filter component corresponding to the configuration operation is displayed in the preview area.

6. The method according to claim 1, characterized in that, The method further includes: In response to a preset operation on the filtering component, an operation interface corresponding to the filtering component is displayed; wherein the operation interface includes at least one available operation item.

7. The method according to claim 1, characterized in that, The method further includes: In response to an adjustment operation on the filtering component, the display information of the filtering component is adjusted; wherein the display information includes at least one of display position and display size.

8. The method according to claim 1, characterized in that, The number of filtering components is multiple, and the method further includes: In response to an association operation on at least two of the filtering components, an association relationship is established between at least two of the filtering components.

9. The method according to claim 1, characterized in that, The filtering components include single-dimensional filtering components and multi-dimensional filtering components.

10. The method according to claim 9, characterized in that, The step of determining the filtering information in response to a trigger operation on the filtering component includes: If the filtering component is a single-dimensional filtering component, then in response to the triggering operation of the filtering component, the target dimension of the filtering component is determined, and the target dimension is used as the filtering information; If the filtering component is a multi-dimensional filtering component, then in response to a trigger operation on the first dimension of the filtering component, the target first dimension of the filtering component is determined, the target second dimension of the filtering component is determined based on the target first dimension, and the filtering information is obtained based on the target first dimension and the target second dimension.

11. The method according to claim 10, characterized in that, Determining the target second dimension of the filtering component based on the target first dimension includes: Based on the first objective dimension, update the available second dimension of the filtering component; Based on the available second dimension, the target second dimension of the filtering component is determined.

12. The method according to claim 9, characterized in that, The number of filtering components is multiple, and the step of determining filtering information in response to a trigger operation on the filtering components includes: In response to a trigger operation on the first filtering component, determine the first filtering information; If there is a linkage between the first filtering component and the second filtering component, then based on the first filtering information, the second filtering information of the second filtering component is determined, and the first filtering information and the second filtering information are used as the filtering information.

13. The method according to claim 12, characterized in that, The step of determining the second filtering information of the second filtering component based on the first filtering information includes: Based on the first filtering information, update the available filtering information of the second filtering component; Based on the available filtering information of the second filtering component, determine the second filtering information of the second filtering component.

14. A data updating device for components in a table, characterized in that, include: A component creation module is used to configure and create filter components in response to the operation of creating filter components on the component page of a table. The component page is used to create different types of components, including components for displaying the data of the table in the form of charts. The information determination module is used to determine the filtering information in response to a trigger operation on the filtering component; The data update module is used to determine the target component associated with the filter information from the component page based on the filter information, and update the data of the data table displayed in the target component, wherein the filter information is at least one data dimension configured in the target component.

15. An electronic device, characterized in that, include: A processor and a memory, the memory for storing a computer program, the processor for calling and running the computer program stored in the memory to perform the method as described in any one of claims 1 to 13.

16. A computer-readable storage medium, characterized in that, Used to store a computer program that causes a computer to perform the method as described in any one of claims 1 to 13.

17. A computer program product containing program instructions, characterized in that, When the program instructions are executed on the electronic device, the electronic device causes the electronic device to perform the method as described in any one of claims 1 to 13.

Images