Table data retrieval methods, apparatus, equipment, media, and products

Abstract

This invention provides a table data search method, apparatus, device, storage medium, and product that enables precise identification of the search range, effectively avoids searching for data that does not need to be searched, optimizes the search method, conserves occupied resources as much as possible, and improves the search efficiency of table data. [Solution] The method includes: step S110 receiving a data search request for a target table via the target interface and identifying the data to be searched and a first search range in the target table based on the data search request; step S120 identifying a second search range based on predetermined search conditions corresponding to the data to be searched, the first search range, and the target table data, if the first search range includes the data to be searched; and step S130 performing a search operation on the data to be searched in the second search range to obtain search feedback data and displaying the search feedback data on the target interface.

Description

Technical Field

[0001] [Cross - reference to Related Applications] This disclosure claims the priority of Chinese Patent Application No. 202411668286.0, titled "Table Data Search Method, Apparatus, Device, Medium and Product", filed on November 20, 2024, and the entire content thereof is incorporated herein by reference as part of this application.

[0002] [Technical Field] Embodiments of the present disclosure relate to the technical field of computer processing, and particularly to table data search methods, apparatuses, devices, media and products.

Background Art

[0003] With the rapid development of telework, the analysis, processing and collection of data have become extremely important, and the application for tables is also becoming increasingly widespread. Users can store and manage data by using tables, and data search in tables is supported.

[0004] In related technologies, when searching for table data, the search range of table data is usually the set table data that needs to be searched or all table data. Such a search method has the problems of consuming a large amount of resources and taking a long time. When a large amount of table data is included in the table data, it has a great impact on the search experience of table data.

Summary of the Invention

[0005] The present disclosure provides a table data search method, apparatus, device, medium and product that can achieve accurate determination of the search range and avoid searching data that does not need to be searched.

[0006] According to a first aspect, embodiments of the present disclosure are The steps include receiving a data retrieval request for a target table via the target interface, and identifying the data to be retrieved and a first search range in the target table based on the data retrieval request, If the first search range includes target table data, the steps include: identifying a second search range based on predetermined search conditions corresponding to the search target data, the first search range, and the target table data; The present invention provides a table data search method that includes the steps of: performing a search operation on the target data within the second search range to obtain search feedback data; and displaying the search feedback data on the target interface.

[0007] According to a second aspect, embodiments of the present disclosure are A data search request module receives a data search request for a target table via a target interface and identifies the data to be searched and a first search range in the target table based on the data search request. If the first search range includes target table data, a search range identification module identifies a second search range based on predetermined search conditions corresponding to the search target data, the first search range, and the target table data. The present invention further provides a table data retrieval device comprising: a search data feedback module that performs a search operation on the target data within the second search range to obtain search feedback data and displays the search feedback data on the target interface.

[0008] According to a third aspect, embodiments of the present disclosure are One or more processors, A storage device for storing one or more programs, The present invention further provides an electronic device that causes one or more processors to implement the table data retrieval method described in any one of the embodiments of this disclosure when one or more of the aforementioned programs are executed by one or more of the aforementioned processors.

[0009] According to a fourth aspect, an embodiment of the present disclosure further provides a storage medium including a computer executable instruction, which, when executed by a computer processor, performs a table data retrieval method described in any one of the embodiments of the present disclosure.

[0010] According to a fifth aspect, an embodiment of the present disclosure further provides a computer program product including a computer program which, when executed by a processor, implements a table data retrieval method described in any one of the embodiments of the present disclosure.

[0011] According to the technical solution of the embodiment of this disclosure, a data search request for a target table is received by the target interface, and the search target data and the first search range in the target table are identified based on the data search request. This achieves the effect of accurately obtaining the search target data and the first search range corresponding to the data search request, and accurately identifying the search range for which a search has been requested in the target table. Furthermore, if the first search range includes target table data, a second search range is identified based on predetermined search conditions corresponding to the search target data, the first search range, and the target table data. This process associates the search target table data with the first search range, and by further processing the first search range in combination with predetermined search conditions corresponding to the target table data, a preliminary check can be performed on the first search range to identify a more accurate second search range before executing the data search operation, compared to a method in related technologies that directly performs a data search in the first search range. Furthermore, by performing search operations on the target data within a second search range to obtain search feedback data and displaying this data on the target interface, it is possible to solve the technical challenges of resource-intensive and time-consuming table data search methods in related technologies, achieve precise identification of the search range, effectively avoid searching for data that does not need to be searched, optimize the search method, conserve resource usage as much as possible, improve search efficiency for table data, and enhance the search experience for table data. [Brief explanation of the drawing]

[0012] The above and other features, advantages, and aspects of each embodiment of this disclosure will become even clearer when viewed in conjunction with the drawings. Throughout the drawings, identical or similar reference numerals represent identical or similar elements. The drawings are illustrative and should be understood to mean that the actual objects and elements are not necessarily depicted in proportion. [Figure 1] Figure 1 is a schematic flowchart of a table data retrieval method according to an embodiment of the present disclosure. [Figure 2] Figure 2 is a schematic diagram illustrating the effect of the target table according to the embodiment of this disclosure. [Figure 3] Figure 3 is a schematic flowchart of another table data retrieval method according to an embodiment of the present disclosure. [Figure 4] Figure 4 is a schematic flowchart of another table data retrieval method according to an embodiment of the present disclosure. [Figure 5] Figure 5 is a schematic flowchart of another table data retrieval method according to an embodiment of the present disclosure. [Figure 6] Figure 6 is a time-series flowchart of a table data retrieval method according to an embodiment of the present disclosure. [Figure 7] Figure 7 is a schematic diagram of the structure of a table data retrieval device according to an embodiment of the present disclosure. [Figure 8] Figure 8 is a schematic diagram of the structure of an electronic device for realizing an embodiment of the present disclosure. [Modes for carrying out the invention]

[0013] The embodiments of this disclosure will be described in more detail below with reference to the drawings. Although several embodiments of this disclosure are shown in the drawings, this disclosure can be realized in various forms and should not be construed as being limited to the embodiments described herein. Rather, these embodiments should be understood as being provided for a more thorough and complete understanding of this disclosure. The drawings and embodiments of this disclosure are for illustrative purposes only and should not be used to limit the scope of protection of this disclosure.

[0014] Each step described in the embodiments of the method of this disclosure may be performed in a different order and / or in parallel. Furthermore, embodiments of the method may include additional steps and / or omit the execution of the illustrated steps. The scope of this disclosure is not limited in this respect.

[0015] As used herein, the term "comprising" and variations thereof are open-ended, meaning "including but not limited to." The term "based on" means "at least in part based on." The term "an embodiment" means "at least one embodiment," the term "another embodiment" means "at least one other embodiment," and the term "some embodiments" means "at least some embodiments." Related definitions of other terms are set forth in the following description.

[0016] Note that the concepts such as "first," "second," etc. referred to in the present disclosure are for distinguishing different devices, modules or units, and are not for limiting the order or interdependence of the functions performed by these devices, modules or units.

[0017] Note that the modifiers "one" and "plural" in the present disclosure are illustrative rather than limiting, and those skilled in the art should understand them as "one or plural" unless otherwise specified.

[0018] The names of interactive messages or information between multiple devices in the embodiments of the present disclosure are not intended to limit the scope of these messages or information, and are only used for the purpose of explanation.

[0019] It can be understood that before using the technical solutions disclosed in each embodiment of the present disclosure, the types, scope of use, usage scenarios, etc. of personal information related to the present disclosure should be notified to the user in an appropriate manner in accordance with relevant laws and regulations, and the user's permission should be obtained.

[0020] For example, in response to receiving an active request from the user, prompt information is transmitted to the user so as to explicitly present to the user that the requested operation requires the acquisition and use of the user's personal information. Thereby, based on the prompt information, the user can independently select whether to provide personal information to software or hardware such as an electronic device, an application, a server or a storage medium that executes the operation of the technical solution of the present disclosure.

[0021] As an optional but non-restrictive implementation, the method of sending information to the user in response to an active request from the user may be, for example, a pop-up window, in which the information can be displayed as text. The pop-up window may also include a selection control for the user to choose whether to "agree" or "disagree" to providing personal information to the electronic device.

[0022] The above-described notification and user consent process are merely illustrative and do not limit the forms in which this disclosure may be implemented. It should be understood that other methods that comply with applicable laws and regulations may also be applied to the implementation of this disclosure.

[0023] It is understood that the data relating to this technical solution (including, but not limited to, the data itself, the acquisition of the data, or the use of the data) must comply with the requirements of the corresponding laws and regulations.

[0024] Figure 1 is a schematic flowchart of a table data retrieval method according to an embodiment of the present disclosure. The embodiment of the present disclosure is applicable to a scenario in which table data is retrieved in a table. The method may be executed by a table data retrieval device, which may be implemented in the form of software and / or hardware, and optionally by electronic equipment, which may be a mobile terminal, PC, or server.

[0025] As shown in Figure 1, the method of this embodiment specifically includes the following steps.

[0026] S110: The target interface receives a data retrieval request for the target table and identifies the data to be retrieved and the first search range in the target table based on the data retrieval request.

[0027] Here, the target interface may be understood as an interface shown to the user for receiving data editing operations and displaying data content. In other words, the target interface may be a visualization editing interface that supports the user in editing the content displayed therein. The target interface may display a target table. The target table may be a table that supports searching for data related to the table. The target table may be any type of table. Optionally, the target table may be an independent table or a subtable in the accessed table. A data search request may be understood as an instruction requesting the execution of an operation to search for table data. A data search request may include multiple types of generation methods. Optionally, a data search request can be generated when a trigger operation for a given data search control is detected. Alternatively, a data search request can be generated when a data search trigger instruction entered by the user is received. Alternatively, a data search request can be generated when it is detected that the received audio information contains a trigger word associated with the data search. The data to be searched may be understood as the search criteria that underlie the table data search. Alternatively, the data to be searched may be understood as the keywords used for search matching in the case of a table data search. Typically, corresponding search feedback data may be fed back based on the data to be searched. The data to be searched may be any data. Selectively, the data to be searched may be data for which a specific data format exists, such as date and time. Alternatively, the data to be searched may be data that contains a specific code. Alternatively, the data to be searched may be data for which no specific data format exists and which does not contain a specific code. The first search range may be understood as the range of data that needs to be searched when performing a data search in the target table, which is initially identified based on the data search request. The first search range may be at least some of the table data contained in the target table.In other words, the first search range may be all the table data in the target table, or it may be only some of the table data in the target table.

[0028] In one optional embodiment of the embodiments of this disclosure, the target table may be a database table, and each column of the target table has a fixed field type, and the table data entered in each cell of the target table is associated with the field type of the column in which the cell is located. In other words, the table data entered in each cell of each column is associated with the field type of that column. The field type may be used to limit at least one of the following pieces of information: the data format, data type, and data content of the table data entered in the cell of that column. Exemplary, the field type may include, but is not limited to, one or more types such as text type, option type, date type, and numeric type. Accordingly, if the target table is a database table, the first search range may be table data from at least one column of the target table. The first search range may include a first search target column. The first search target column may be one or more columns of the target table. In other words, once a first search range in the target table is identified, that is, once a first search target column in the target table is identified, the search target data may be retrieved by searching based on the table data entered in the cells included in the first search column. Exemplarily, Figure 2 is a schematic diagram of the effect of a target table according to an embodiment of the present disclosure. As shown in Figure 2, the target table 20 may include four fields, Field A, Field B, Field C, and Field D, each having a fixed field type, and the data entered in each cell is associated with the field type of the column in which the cell is located. The table data corresponding to Field A are Data A1, Data A2, Data A3, Data A4, and Data A5, respectively, and in this case, Data A1, Data A2, Data A3, Data A4, and Data A5 are all associated with the field type of Field A.The table data corresponding to field B are data B1, data B2, data B3, data B4, and data B5, respectively, and in this case, data B1, data B2, data B3, data B4, and data B5 are all associated with the field type of field B. The table data corresponding to field C are data C1, data C2, data C3, data C4, and data C5, respectively, and in this case, data C1, data C2, data C3, data C4, and data C5 are all associated with the field type of field C. The table data corresponding to field D are data D1, data D2, data D3, data D4, and data D5, respectively, and in this case, data D1, data D2, data D3, data D4, and data D5 are all associated with the field type of field D.

[0029] In embodiments of this disclosure, the searchable data may include a plurality of specific methods, and may selectively include using data entered by the target interface as the searchable data, or using selected candidate search data as the searchable data, and so on.

[0030] The step of selectively receiving a data retrieval request for a target table via the target interface and identifying the data to be retrieved based on the data retrieval request includes receiving a search data entry operation for the target table via the target interface and identifying the data to be retrieved corresponding to the target table based on the search data entry operation.

[0031] Here, a search data entry operation may be understood as an operation to enter relevant search data in the target interface. A search data entry operation may include any type of data entry operation, and selectively include text data entry operations, audio data entry operations and / or image data entry operations, etc.

[0032] In one optional embodiment of the embodiments of this disclosure, if the target interface is displayed, a search data entry operation for the target table may be entered into the target interface. Furthermore, if a search data entry operation is detected, the search target data corresponding to the target table may be identified based on the search data entry operation.

[0033] The step of selectively receiving a search data entry operation for a target table via a target interface and identifying the search target data corresponding to the target table based on the search data entry operation is to display a target interface in which a data search control is displayed, the data search control comprising at least a search data entry field, receiving a data entry operation for the search data entry field, and identifying the data entered in the search data entry field as the search target data.

[0034] Here, a data search control may be understood as an entry point that allows for quick searching and positioning of data by entering keywords or selecting criteria. A search data entry field may be used to enter the data to be searched. A search data entry field may be an entry point that supports the entry of data in any format. Optionally, a search data entry field may be a text input box, an audio input box, and / or an image input box, etc. A data entry operation may be understood as an operation to enter data into a search data entry field. Optionally, a data entry operation may include a text data entry operation, an audio data entry operation, and / or an image data entry operation.

[0035] In one selectable embodiment of the embodiments of this disclosure, a target interface is displayed when a trigger operation is detected on a predetermined interface display control. A data search control is displayed on the displayed target interface, and the data search control may include a search data entry field. Furthermore, a text data entry operation may be entered on the search data entry field to enter corresponding text data. Furthermore, the text data entered on the data entry field may be used as the search target data. Exemplarily, continuing to refer to Figure 2, a data search control 21 is displayed on the target interface, and the data search control includes a search data entry field 211, and a text data entry operation may be entered on the search data entry field. Furthermore, the text data entered on the search data entry field may be used as the search target data.

[0036] In another optional embodiment of the embodiments of this disclosure, the search data entry field displayed in the target interface may be an audio input box. Furthermore, an audio data entry operation may be entered into the search data entry field to retrieve the entered audio information based on the search data entry field. Furthermore, the audio information may be parsed, and the parsed text data may be used as the search target data.

[0037] In the embodiments of this disclosure, the first search range identification method may include a plurality of methods, which selectively designate a search range input by the target interface as the first search range, or a selected candidate search range as the first search range.

[0038] In one selectable embodiment of the embodiments of the present disclosure, the step of receiving a data retrieval request to a target table via a target interface and identifying a first search range in the target table based on the data retrieval request includes displaying a target interface on which a data retrieval control is displayed, wherein the data retrieval control includes at least a search range entry field, and receiving a range entry operation on the search range entry field and identifying the range entered in the search range entry field as the first search range.

[0039] In another optional embodiment of the embodiments of the present disclosure, the step of receiving a data retrieval request to a target table via a target interface and identifying a first search range in the target table based on the data retrieval request is to display a target interface on which a data retrieval control is displayed, the data retrieval control comprising: including at least a search range setting item; receiving a trigger operation on the search range setting item and displaying a range identifier corresponding to at least one candidate search range; and receiving a selection operation on the range identifier and setting the candidate search range corresponding to the selected range identifier as the first search range.

[0040] S120: If the first search range includes target table data, a second search range is identified based on predetermined search conditions corresponding to the search target data, the first search range, and the target table data.

[0041] Here, target table data may be understood as table data that corresponds to a specific data format and / or carries a specific code. Target table data may also be understood as data for which table entry restriction data is set in the data entry location of the corresponding cell. Target table data may also be table data contained in the target table. Selectively, if the target table consists of multi-column table data, and each column of the table data has a corresponding column title and a fixed field type for each column, then target table data may be any one or more columns of table data in the target table. Or, if the target table consists of multi-row table data, and each row of the table data has a corresponding row title and a fixed field type for each row, then target table data may be any one or more rows of table data in the target table. Exemplaryly, target table data may be date data, time data, option data and / or data that carries a specific code, etc. The predetermined search conditions may be information that reflects whether or not search restrictions exist in the target table data. The predetermined search conditions are associated with the field type of the target table data. In other words, a predetermined search criterion corresponding to the target table data may be identified based on the field type corresponding to the target table data. Optionally, the predetermined search criterion may include, but is not limited to, at least one of the following: the data format of the data to be searched is a predetermined format; the data to be searched carries a predetermined code; or the data to be searched is included in the target table data. Here, the predetermined format may be any data format, and optionally, a date format, time format, or option format. The predetermined code may be any code, and optionally, a code that reflects a value attribute or a custom code. The second search range may be understood as a data search range identified again on top of the first search range. The second search range may be less than or equal to the first search range.Selectively, if the first search range includes the first target column, the second search range may include the second target column, and the target table data may include the target column. If the first search range includes the target table data, the first target column includes the target column.

[0042] In practical applications, when identifying data to be searched, search operations are typically performed on the target data in the target table to obtain search feedback data. Alternatively, when identifying a first search range in the target data and target table, search operations are performed on the target data within the first search range to obtain search feedback data. Such data retrieval methods require either a full search on the target table or a search within the initially identified search range, which can consume a large amount of computing resources when executing the search task, potentially resulting in excessively long search times, low search efficiency, and negatively impacting the search experience for table data.

[0043] In response to the above situation, in embodiments of this disclosure, when identifying a first search range in the search target data and target table, the first search range may be detected in such a way as to determine whether a new search range can be identified on the first search range. Furthermore, if the first search range includes target table data, a second search range may be identified based on predetermined search conditions corresponding to the search target data, the first search range, and the target table data.

[0044] The step of selectively identifying a second search range based on predetermined search conditions corresponding to the data to be searched, a first search range, and target table data includes, if the data to be searched does not satisfy the predetermined search conditions corresponding to the target table data, removing the target table data from the first search range and obtaining the second search range.

[0045] In one optional embodiment of the embodiments of this disclosure, if the first search scope includes target table data, a predetermined search condition corresponding to the target table data may be identified, and the data to be retrieved may be detected based on the predetermined search condition. Furthermore, if the first search scope includes target table data and the data to be retrieved does not satisfy the predetermined search condition corresponding to the target table data, the target table data may be removed from the first search scope, and the first search scope after removal may be designated as the second search scope. The advantage of this configuration is that the search scope can be further narrowed before performing data operations, the resources and time required to retrieve data can be reduced, search efficiency can be improved, and the search experience for table data can be enhanced.

[0046] For example, assuming that the first search range includes the first search target column in the target table, and the target table data includes the target column in the target table, the predetermined search condition corresponding to the target column may be that the data format of the table data entered in the target column's cell is a date format. If the first search target column includes the target column, a predetermined search condition corresponding to that target column may be identified, and based on that predetermined search condition, it may be determined whether or not the data format corresponding to the search target data is a date format. Furthermore, if the data format corresponding to the search target data is not a date format, that target column may be removed from the first search column, the first search column from which the target column was removed may become the second search column, and the identified second search column may become the second search range.

[0047] In the embodiments of this disclosure, if the first search range includes target table data and the data to be searched satisfies predetermined search conditions corresponding to the target table data, the first search range may be used as the second search range.

[0048] In embodiments of this disclosure, if the target table data is not included in the first search range, search feedback data may be obtained by performing the search operation on the target data in the first search range without performing the steps of determining whether the data to be searched satisfies predetermined search conditions and determining the second search range.

[0049] S130: Perform a search operation on the target data within the second search range to obtain search feedback data, and display the search feedback data on the target interface.

[0050] Here, search feedback data may be understood as search results obtained after performing a search operation. In embodiments of this disclosure, search feedback data may be table data that satisfies predetermined matching conditions, selected after data matching of the search target data with table data within a second search range.

[0051] In embodiments of this disclosure, once a second search range is identified, a search operation may be performed on the target data within the second search range, that is, the table data included in the second search range may be traversed based on the target data. Furthermore, the traversed table data that matches the target data is used as search feedback data, and the search feedback data is displayed on the target interface.

[0052] Furthermore, when performing a table data search, a pagination search method, i.e., a partial search method that specifies the number of search feedback data, may be adopted. If the search feedback data obtained after one or more search operations is displayed in the target interface and the number of search feedback data satisfies a predetermined threshold, the execution of the search operation may be temporarily suspended. If a trigger operation for further searching is detected, the search operation may be executed again. By adopting such a search method, if the search feedback data displayed in the target interface contains the target search data required for the search operation initiation object, it is not necessary to perform subsequent search operations. This further improves search efficiency and reduces the computational resources and time required for searching.

[0053] Based on this, the search feedback data is displayed on the target interface, and further, if the retrieved search feedback data meets a predetermined data volume threshold, the execution of the search operation on the target data is temporarily suspended.

[0054] Here, the predetermined data amount threshold may be a predetermined basis for determining whether or not the search operation needs to be paused. The predetermined data amount threshold may be any numerical value, and selectively, the predetermined data amount threshold is greater than or equal to the threshold for the amount of data that can be displayed on the target interface. The threshold for the amount of data that can be displayed is the upper limit of the amount of search feedback data that can be displayed on the target interface. Generally, the threshold for the amount of data that can be displayed may be determined based on the height of the target interface and the height of the display area corresponding to a single search feedback data. More specifically, the ratio of the height of the target interface to the height of the display area corresponding to a single search feedback data may be used as the threshold for the amount of data that can be displayed. For example, the threshold for the amount of data that can be displayed may be 15 lines, 20 lines, or 50 lines. The advantage of setting the predetermined data amount threshold to a numerical value greater than or equal to the threshold for the amount of data that can be displayed on the target interface is that when a scroll display operation is input for the search feedback data, the loading display time of the search feedback data to be displayed can be shortened. Furthermore, it is possible to achieve the effect of displaying the search feedback data to be displayed at the corresponding position on the target interface while scrolling.

[0055] In one selectable embodiment of the embodiments of this disclosure, when search feedback data is acquired, the amount of data in the search feedback data may be compared to a predetermined data amount threshold. Furthermore, if the retrieved search feedback data reaches the predetermined data amount threshold, the search operation on the search target data in the second search range may be temporarily suspended. Furthermore, if a subsequent search trigger operation on the search target data is received, the search operation on the search target data in the second search range may be continued. Here, the subsequent search trigger operation may be any operation that can trigger the continued execution of the search operation. Optionally, the subsequent search trigger operation may include a scroll display operation on the search feedback data displayed in the target interface, or a trigger operation on a predetermined subsequent search control, etc.

[0056] Furthermore, if the search feedback data retrieved after all searches within the second search range of the target data have been completed is less than the threshold for the amount of data that can be displayed on the target interface, the search operation on the target data may be stopped after the retrieved search feedback data has been displayed on the target interface.

[0057] The technical solutions according to the embodiments of this disclosure may be applied to both the client side and the service side. When performing a table data search, the search may be performed on the table data loaded on the client side, or a data search request may be sent to the service side, the service side may perform the search and obtain the search results, and then send them back to the client side. However, if the amount of table data is large, it may occupy a large amount of the client side's resource storage space, and consequently, it may not be possible to load all the table data on the client side, and the data search results may deteriorate. Preferably, when the technical solutions according to the embodiments of this disclosure are applied to the service side, the client side may specify the data to be searched and the first search range. Furthermore, the client side may specify a second search range based on the first search range and the data to be searched. Furthermore, a data search request may be generated based on the data to be searched and the second search range, and the data search request may be sent to the service side, so that the service side performs a table data search based on the data search request, obtains search feedback data, and feeds the search feedback data back to the client side. Furthermore, when the client side receives the search feedback data, the search feedback data is displayed based on the client side's display interface. Such a table data search method can reduce the utilization rate of the client-side resource storage space, improve search efficiency, and enhance the search experience for table data. Of course, the technical solutions according to the embodiments of this disclosure may also be applied to the client side, and the embodiments of this disclosure are not specifically limited to the implementer of the solution.

[0058] According to the technical solution of the embodiment of this disclosure, a data search request for a target table is received by the target interface, and the search target data and the first search range in the target table are identified based on the data search request. This achieves the effect of accurately obtaining the search target data and the first search range corresponding to the data search request, and accurately identifying the search range for which a search has been requested in the target table. Furthermore, if the first search range includes target table data, a second search range is identified based on predetermined search conditions corresponding to the search target data, the first search range, and the target table data. This process associates the search target table data with the first search range, and by further processing the first search range in combination with predetermined search conditions corresponding to the target table data, a preliminary check can be performed on the first search range to identify a more accurate second search range before executing the data search operation, compared to the method in related technologies that directly performs a data search in the first search range. Furthermore, by performing search operations on the target data within a second search range to obtain search feedback data and displaying this search feedback data in the target interface, it is possible to solve the technical problem of resource-intensive and time-consuming table data search methods in related technologies, achieve precise identification of the search range, effectively avoid searching for data that does not need to be searched, optimize the search method, conserve resource usage as much as possible, improve the efficiency of table data searches, and enhance the search experience for table data.

[0059] Figure 3 is a schematic flowchart of another table data retrieval method according to an embodiment of the present disclosure. The technical solution of this embodiment, based on the above embodiment, may display retrieval feedback data in the target interface, and may further receive collaborative editing operations on the target table from collaborators of the target table, and further identify the table data displayed in the target interface based on the collaborative editing operations. Selectively, when a collaborative editing operation on the target table from a collaborator is received, the edited table data corresponding to the collaborative editing operation is identified, and the target interface is displayed based on the edited table data and the retrieval feedback data displayed in the target interface. For specific embodiments, refer to the description of this embodiment. Here, technical features that are the same as or similar to those of the above-described embodiment are omitted from this description. As shown in Figure 3, the method of this embodiment may specifically include the following steps.

[0060] S210: The target interface receives a data retrieval request for the target table and identifies the data to be retrieved and the first search range in the target table based on the data retrieval request.

[0061] S220: If the first search range includes target table data, a second search range is identified based on predetermined search conditions corresponding to the search target data, the first search range, and the target table data.

[0062] S230: Perform a search operation on the target data within the second search range to obtain search feedback data, and display the search feedback data on the target interface.

[0063] S240: When a collaborative edit operation is received on a collaborator's target table, identify the edited table data corresponding to the collaborative edit operation.

[0064] Here, a collaborator may be understood as an object that collaborates on editing the target table. In embodiments of this disclosure, the target table may be a shared table that supports collaborative editing by multiple users, or it may allow the creator of the target table and collaborators of the target table after permission filtering to edit it together. A collaborative editing operation may be understood as an operation in which a collaborator edits table data in the target table. Optionally, a collaborative editing operation includes at least one of a data append operation, a data delete operation, a data modify operation, and a data query operation. The edited table data may be understood as the table data on which the collaborative editing operation acts.

[0065] In embodiments of this disclosure, after displaying search feedback data in the target interface, a collaborator on the target table may input collaborative editing operations on the table data in the target table so that the table data in the target table is edited. Furthermore, upon receiving a collaborative editing operation on the target table from a collaborator, the table data may be edited based on the collaborative editing operation so that the edited table data is obtained, and the edited table data may be used as the edited table data.

[0066] In one optional embodiment of the embodiments of this disclosure, when a collaborative edit operation on a target table is received from a collaborator, the edited table data and the edited table data may be identified based on the collaborative edit operation. Furthermore, when other collaborators perform collaborative edits on the target table, the edited table data stored in the database may be updated with the edited table data and an edit identifier may be added to the edited table data so that the corresponding collaborators can understand which data has been edited and which data has not.

[0067] S250: Displays the target interface based on the edited table data and the search feedback data displayed in the target interface.

[0068] In embodiments of this disclosure, when identifying the edited table data, the target interface including search feedback data may be displayed again. When identifying the data content displayed in the target interface, the data content displayed in the target interface may be identified based on the edited table data and the search feedback data displayed in the target interface.

[0069] The step of selectively displaying the target interface based on the edited table data and the search feedback data displayed in the target interface includes updating the search feedback data displayed in the target interface if the search feedback data displayed in the target interface includes the edited table data.

[0070] In one optional embodiment of the embodiments of this disclosure, when identifying data content displayed in the target interface, it may be determined whether the search feedback data displayed in the target interface contains the edited table data based on the edit identifier carried to the edited table data. Furthermore, if the search feedback data displayed in the target interface contains the edited table data, a data update request may be generated to request the edited table data corresponding to the edited table data based on the data update request. Furthermore, upon receiving the feedback edited table data, the edited table data in the search feedback data may be updated to the edited table data. Furthermore, the updated search feedback data may be displayed in the target interface. The advantage of this configuration is that when the search feedback data displayed in the detection target interface contains the edited table data, the target interface is updated, reducing the number of times data search requests are restarted in the collaborative editing scenario, and further reducing the search burden on the executing entity performing the data search operation.

[0071] In embodiments of this disclosure, if the search feedback data displayed in the target interface does not include the edited table data, the search feedback data displayed in the target interface is retained, and no data update operation is performed; that is, the search feedback data displayed in the target interface is not updated.

[0072] According to the technical solution of the embodiment of this disclosure, after displaying search feedback data on the target interface, when a collaborative editing operation on the target table by a collaborator is received, the edited table data corresponding to the collaborative editing operation is identified, and the target interface is displayed based on the edited table data and the search feedback data displayed on the target interface. This achieves the effect of identifying the data content displayed on the target interface based on the edited table data and the search feedback data displayed on the target interface in the collaborative editing table scenario, further enhancing the flexibility of displaying the target table on the target interface in the collaborative editing scenario, and achieving the effect of real-time collaboration on the target table.

[0073] Figure 4 is a schematic flowchart of another table data retrieval method according to an embodiment of the present disclosure. The technical solution of this embodiment further subdivides the method for identifying the first search range based on the above embodiment. The step of selectively receiving a data retrieval request for a target table by the target interface and identifying a first search range in the target table based on the data retrieval request includes receiving a range setting trigger operation for the target table by the target interface, generating a searchable range list containing a range identifier corresponding to at least one searchable range based on the table data displayed in the target interface in the target table, and displaying the searchable range list, and receiving an identifier selection operation for the range identifier and identifying a first search range in the target table based on the searchable range corresponding to the selected range identifier. For specific embodiments, refer to the description of this embodiment. Here, technical features that are the same or similar as those of the above-described embodiment are omitted from this description. As shown in Figure 4, the method of this embodiment may specifically include the following steps.

[0074] S310: The target interface receives a data retrieval request for the target table, identifies the data to be retrieved based on the data retrieval request, receives a range setting trigger operation for the target table via the target interface, generates a searchable range list based on the table data displayed in the target interface for the target table, and displays the searchable range list.

[0075] Here, a range setting trigger operation may be understood as a trigger operation that allows setting a search range. Optionally, a range setting trigger operation may include at least one operation, such as an operation that triggers a predetermined range setting control, an operation that receives a trigger keyword associated with a range setting operation from audio information, or an operation that receives a predetermined range setting operation trigger command. A searchable range list may be understood as a consolidated set of searchable ranges in a target table. A searchable range list may include a range identifier corresponding to at least one searchable range. A range identifier may be information for identifying a searchable range. A range identifier may be information in any form, and optionally, a range identifier may be a range name, range number, or other information that delineates a range. Exemplaryly, if the target table is a database table, and the searchable range is table data displayed in the target interface of the target table, the range identifier corresponding to a searchable range may be a column title corresponding to the table data column by column.

[0076] Furthermore, in order to display as much table data as possible that satisfies the search operation initiation object's requirements in the target interface, some table data in the target table may be hidden when displaying the target table and may not be displayed in the target interface. When performing a table data search, in order to improve the search efficiency of the table data and ensure that the search results better satisfy the search operation initiation object's requirements, the table data displayed in the target interface of the target table may be searched.

[0077] In embodiments of this disclosure, a range setting trigger operation may be input to the target table via the target interface to set a search range in the target table. Furthermore, upon receiving a range setting trigger operation to the target table, the table data displayed in the target interface of the target table may be identified. Further, at least one searchable range may be identified based on the displayed table data, and a range identifier corresponding to each searchable range may be identified. Furthermore, a list of searchable ranges may be generated based on the range identifiers corresponding to at least one searchable range, and the list of searchable ranges may be displayed in the target interface.

[0078] S320: Receives an identifier selection operation for a range identifier and identifies a first search range in the target table based on the searchable range corresponding to the selected range identifier.

[0079] Here, an identifier selection operation may be understood as an operation that triggers the selection of any identifier. Selectively, an identifier selection trigger operation includes, but is not limited to, at least one of the following: a click operation, a long press operation, a touch operation, or a swipe operation.

[0080] In embodiments of this disclosure, when displaying a searchable range list that includes range identifiers corresponding to at least one searchable range, an identifier selection operation may be entered for any range identifier in the searchable range list. Furthermore, upon receiving an identifier selection operation for a range identifier, the searchable range corresponding to the selected range identifier may be identified, and the identified searchable range may be set as the first search range in the target table.

[0081] The range identifiers selected may be one or more. If only one range identifier is selected, the searchable range corresponding to that range identifier may be designated as the first search range. If multiple range identifiers are selected, the searchable ranges corresponding to these range identifiers may be designated as the first search range.

[0082] Illustratively, continuing with Figure 2, the data search control 21 may further include a range setting control 212. When a trigger operation is received on the range setting control 212, a searchable range list 22 may be generated and displayed based on the table data displayed in the target interface in the target table. The searchable range list 22 may include range identifiers corresponding to four searchable ranges, such as field A, field B, field C, and field D. When an identifier selection operation is received for field A, field B, and field C, the searchable ranges corresponding to field A, field B, and field C may be designated as the first search range.

[0083] S330: If the first search range includes target table data, a second search range is identified based on predetermined search conditions corresponding to the search target data, the first search range, and the target table data.

[0084] S340: Perform a search operation on the target data within the second search range to obtain search feedback data, and display the search feedback data on the target interface.

[0085] According to the technical solution of the embodiment of this disclosure, a range setting trigger operation for the target table is received by the target interface, a searchable range list including a range identifier corresponding to at least one searchable range is generated and displayed based on the table data displayed in the target interface in the target table, and an identifier selection operation for the range identifier is received, and a first search range in the target table is identified based on the searchable range corresponding to the selected range identifier, thereby achieving the effect of accurately obtaining a first search range corresponding to a data search request, and accurately identifying the search range for which a search has been requested in the target table. Furthermore, the intelligence and flexibility of the data search process are improved and the data search method is optimized.

[0086] Figure 5 is a schematic flowchart of another table data retrieval method according to an embodiment of the present disclosure. The technical solution of this embodiment may, based on the above embodiment, display the search feedback data on the target interface and then input a scroll display operation to the search feedback data. Furthermore, the number of preloaded search feedback data may be identified based on the scroll display operation, and the search feedback data may be preloaded based on the number of preloaded data. Selectively, the scroll display operation for the search feedback data is received by the target interface, the data scroll speed and the threshold amount of data that can be displayed on the target interface are identified, the number of preloaded search feedback data is identified based on the data scroll speed and the threshold amount of data that can be displayed is identified, and the search feedback data is preloaded based on the number of preloaded data. For specific embodiments, please refer to the description of this embodiment. Here, technical features that are the same as or similar to those of the above-described embodiment are omitted from this description. As shown in Figure 5, the method of this embodiment may specifically include the following steps.

[0087] S410: The target interface receives a data retrieval request for the target table and identifies the data to be retrieved and the first search range in the target table based on the data retrieval request.

[0088] S420: If the first search range includes target table data, a second search range is identified based on predetermined search conditions corresponding to the search target data, the first search range, and the target table data.

[0089] S430: Perform a search operation on the target data within the second search range to obtain search feedback data, and display the search feedback data on the target interface.

[0090] S440: The target interface receives a scroll display operation for the search feedback data, and determines the data scroll speed and the threshold for the amount of data that can be displayed in the target interface.

[0091] Here, a scroll display operation may be understood as an operation to display data not currently displayed on the interface by scrolling the interface up or down. Selectively, a scroll display operation may include scrolling the mouse wheel, triggering directional controls on the keyboard, and triggering a predetermined scroll display control on the interface. The data scroll speed may be understood as the scrolling speed of the data on the interface. The data scroll speed may be used to indicate the length or number of units moved per second when scrolling the data. The threshold for the amount of displayable data is the upper limit of the amount of search feedback data that can be displayed on the target interface.

[0092] In embodiments of this disclosure, after displaying search feedback data on the target interface so that search feedback data not yet displayed on the target interface can be viewed, a scroll display operation may be input to the search feedback data. Furthermore, when a scroll display operation on the search feedback data is received by the target interface, the data scroll rate may be determined based on the scroll display operation. In addition, a threshold for the amount of data that can be displayed on the target interface may be determined based on the height of the target interface and the height of the display area corresponding to a single search feedback data. Furthermore, the data scroll rate on the target interface and the threshold for the amount of data that can be displayed on the target interface may be obtained.

[0093] S450: Determines the number of search feedback data to preload based on the data scrolling speed and thresholds for the amount of data that can be displayed, and preloads the search feedback data based on the number of preloaded data.

[0094] Here, the amount of data to be preloaded may be the size of the data already preloaded in memory or cache.

[0095] Furthermore, to enable the search operation initiation object to quickly retrieve the desired data, and to improve the efficiency of using search feedback data with minimal resource consumption, the execution of the search operation on the target data may be paused when the retrieved search feedback data meets a predetermined data volume threshold. Here, the predetermined data volume threshold is equal to or greater than the data volume threshold that can be displayed on the target interface. Moreover, when combined with a scroll display operation on the search feedback data, it can be understood that the search operation initiation object wants to see other search feedback data that is not displayed on the target interface. To reduce the data display load time in the case of scroll display and improve the search experience for table data, the search feedback data may be preloaded so that when a scroll display operation on the corresponding search feedback data is detected, the corresponding search feedback data is displayed on the target interface.

[0096] In one selectable embodiment of the embodiments of this disclosure, the amount of scroll data corresponding to a scroll display operation may be determined based on the data scroll speed and the execution time of the scroll display operation. Furthermore, the amount of scroll data and a threshold for the amount of displayable data may be added together, and the added amount of data may be used as the number of preloaded search feedback data. Furthermore, search feedback data may be preloaded based on the number of preloaded data.

[0097] According to the technical solution of the embodiment of this disclosure, after displaying search feedback data on the target interface, a scroll display operation on the search feedback data is received by the target interface, the data scroll speed and thresholds for the amount of data that can be displayed on the target interface are identified, the number of preloads of search feedback data is identified based on the data scroll speed and thresholds for the amount of data that can be displayed, and the search feedback data is preloaded based on the number of preloads. By preloading the search feedback data, the data display loading time in the case of scroll display is reduced, the data display efficiency is improved, and the search experience for table data is further improved.

[0098] Figure 6 is a timing flowchart of a table data retrieval method according to an embodiment of the present disclosure. As shown in Figure 6, the execution entities required to execute the table data retrieval method may include a user, a view data layer, a pre-search check, a server, a database, and collaborators. When a user enters search parameters (including the data to be searched and the first search range) through a search input box in the client-side view data layer, the client-side pre-search check layer may check the entered search parameters. Furthermore, if it is determined that there are no search results after checking the search parameters based on the pre-search check layer, it may display that there are no search results. After checking the search parameters based on the pre-search check layer, it is necessary not to reduce or change the first search range in order to obtain a second search range, and the search parameters including the second search range and the data to be searched may be sent to the server, and the target interface may display "Searching". Furthermore, when the server receives the search parameters, it may perform an authorization check on the search parameters. Furthermore, after the check passes, it searches the database based on the search parameters and feeds the search results back to the server. Then, when the server receives the search results, it performs authorization filtering on the search results. Subsequently, the search results after permission filtering may be fed back to the client-side view data layer, the search results may be populated back into the target table's data structure, and the final search results may be displayed. Furthermore, if a collaborative edit operation on the target table is received from a collaborator, the edited table data may be identified based on the collaborative edit operation. Then, a broadcast notification is sent to other collaborators. In addition, an edit identifier is added to the edited table data, and the updated search results are displayed. If it is detected that the currently displayed search results are the latest table data, there is no need to perform an update operation. Furthermore, if a user scrolls the search results, it is detected whether the currently displayed search results include the edited table data to which the edited table has been added.Furthermore, if it is detected that the currently displayed search results include edited table data to which an edited table has been added, a data update request may be initiated to the server, updating only the edited table data. The server then sends back the requested latest data, and the latest search results are displayed.

[0099] According to the technical solutions of the embodiments of this disclosure, the technical challenges of resource-intensive and time-consuming table data search methods in related technologies can be overcome. These solutions enable precise identification of the search scope, effectively avoid searching for data that does not need to be searched, optimize the search method, conserve resource usage as much as possible, improve the efficiency of table data searches, and enhance the search experience for table data.

[0100] Figure 7 is a schematic diagram of the structure of a table data retrieval device according to an embodiment of the present disclosure. As shown in Figure 7, the device comprises a data retrieval request module 510, a retrieval range specification module 520, and a retrieval data feedback module 530.

[0101] Here, the data retrieval request module 510 receives a data retrieval request for the target table via the target interface and is used to identify the data to be retrieved and the first search range in the target table based on the data retrieval request. The search range identification module 520 is used to identify a second search range based on the data to be retrieved, the first search range, and predetermined search conditions corresponding to the target table data, if the first search range includes the target table data. The search data feedback module 530 performs a search operation on the data to be retrieved in the second search range to obtain search feedback data and is used to display the search feedback data in the target interface.

[0102] According to the technical solution of the embodiment of this disclosure, the data retrieval request module 510 receives a data retrieval request for a target table via the target interface and identifies the data to be retrieved and the first search range in the target table based on the data retrieval request, thereby achieving the effect of accurately obtaining the data to be retrieved and the first search range corresponding to the data retrieval request, and accurately identifying the search range for which a search has been requested in the target table. Furthermore, if the first search range includes target table data, the search range identification module 520 identifies a second search range based on predetermined search conditions corresponding to the data to be retrieved, the first search range, and the target table data, thereby realizing the process of associating the data to be retrieved table data with the first search range. By further processing the first search range by combining predetermined search conditions corresponding to the target table data, a preliminary check can be performed on the first search range to identify a more accurate second search range before executing the data retrieval operation, compared to the method of directly performing a data retrieval in the first search range in related technologies. Furthermore, the search data feedback module 530 performs a search operation on the target data within a second search range to obtain search feedback data and displays the search feedback data on the target interface. This solves the technical problem of resource-intensive and time-consuming table data search methods in related technologies, enables precise identification of the search range, effectively avoids searching for data that does not need to be searched, optimizes the search method, conserves resources as much as possible, improves the search efficiency of table data, and enhances the search experience for table data.

[0103] Based on any one selectable technical solution of the embodiments of this disclosure, the search range identification module 520 is optionally used to obtain a second search range by deleting the target table data from the first search range if the data to be searched does not satisfy predetermined search conditions corresponding to the target table data.

[0104] Based on any one of the selectable technical solutions of the embodiments of this disclosure, a predetermined search criterion is optionally associated with a field type of target table data.

[0105] Based on any one selectable technical solution of the embodiments of the present disclosure, the apparatus optionally further comprises a search operation execution pause module, which is used to pause the execution of a search operation on the search target data when the retrieved search feedback data reaches a predetermined data volume threshold after the search feedback data has been displayed on the target interface, the predetermined data volume threshold being greater than or equal to a displayable data volume threshold on the target interface.

[0106] Based on any one selectable technical solution of the embodiments of this disclosure, the apparatus optionally further comprises a collaborative editing operation reception module and a table data display module. The collaborative editing operation reception module is used to identify the edited table data corresponding to the collaborative editing operation when it receives a collaborative editing operation on a target table from a collaborator after displaying search feedback data on the target interface. The table data display module is used to display the target interface based on the edited table data and the search feedback data displayed on the target interface.

[0107] Based on any one selectable technical solution of the embodiments of this disclosure, the table data display module is selectively used to update the search feedback data displayed in the target interface if the search feedback data displayed in the target interface includes the edited table data.

[0108] Selectively based on any one selectable technical solution of the embodiments of this disclosure, the data retrieval request module comprises a search range list display unit and a search range identification unit. The search range list display unit is used to receive a range setting trigger operation on a target table via a target interface and to generate and display a searchable range list containing range identifiers corresponding to at least one searchable range, based on the table data displayed in the target interface in the target table. The search range identification unit is used to receive an identifier selection operation on a range identifier and to identify a first search range in the target table based on the searchable range corresponding to the selected range identifier.

[0109] Based on any one selectable technical solution of the embodiments of this disclosure, the apparatus optionally further comprises a scroll display module and a data preload module. The scroll display module is used to display search feedback data on a target interface, receive scroll display operations on the search feedback data by the target interface, and determine the data scroll speed and the threshold amount of data that can be displayed on the target interface. The data preload module is used to determine the number of preloads of search feedback data based on the data scroll speed and the threshold amount of data that can be displayed, and to preload the search feedback data based on the number of preloads.

[0110] Based on any one of the selectable technical solutions of the embodiments of this disclosure, the target table has a fixed field type for each column, and the table data entered in each cell of the target table is associated with the field type of the column in which the cell is located.

[0111] The table data retrieval device according to the embodiment of this disclosure can perform the table data retrieval method according to any embodiment of this disclosure and has corresponding functional modules and beneficial effects for performing the table data retrieval method.

[0112] Furthermore, the units and modules of the above-mentioned device are merely divided according to functional logic and are not limited to the above division; they only need to be able to realize the corresponding function. Also, the specific names of each unit and module are merely for the purpose of distinguishing them from one another and do not limit the scope of protection of the embodiments of this disclosure.

[0113] Hereinafter, refer to Figure 8, which shows a schematic diagram of the structure of an electronic device (e.g., terminal device or server) 600 that implements an embodiment of the present disclosure. The terminal device in the embodiment of the present disclosure may include, but is not limited to, mobile devices such as mobile phones, laptop computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), and in-vehicle terminals (e.g., in-vehicle navigation terminals), as well as fixed terminals such as digital TVs and desktop computers. The electronic device shown in Figure 8 is merely an example and does not in any way limit the functions and scope of use of the embodiment of the present disclosure.

[0114] As shown in Figure 8, the electronic device 700 may include a processing unit (e.g., a central processing unit, graphics processor, etc.) 701, which can perform various appropriate operations and processes by programs stored in a read-only memory (ROM) 702 or by programs loaded from a storage device 708 into a random access memory (RAM) 703. The RAM 703 stores various programs and data necessary for the operation of the electronic device 700. The processing unit 701, ROM 702, and RAM 703 are interconnected via a bus 704. An input / output (I / O) interface 705 is also connected to the bus 704.

[0115] Generally, an input device 706, including, for example, a touchscreen, touch panel, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc., an output device 707, including, for example, a liquid crystal display (LCD), speaker, oscillator, etc., a storage device 708, including, for example, magnetic tape, hard disk, etc., and a communication device 709 may be connected to the I / O interface 705. The communication device 709 enables the electronic device 700 to exchange data with other devices via wireless or wired communication. Figure 8 shows an electronic device 700 equipped with various devices, but it should be understood that it is not required to implement or have all of the devices shown. Alternatively, it is possible to implement or have more or fewer devices.

[0116] In particular, according to embodiments of the present disclosure, the process described above can be implemented as a computer software program with reference to the flowchart. For example, embodiments of the present disclosure include a computer program product which includes a computer program mounted on a non-temporary computer-readable medium, and the computer program includes program code for performing the method shown in the flowchart. In such embodiments, the computer program may be downloaded and installed from a network via a communication device 709, or installed from a storage device 708, or installed from a ROM 702. When the computer program is executed by a processing unit 701, it performs the functions described above, limited to the methods of embodiments of the present disclosure.

[0117] The names of the interactive messages or information between multiple devices in the embodiments of this disclosure are used for illustrative purposes only and are not intended to limit the scope of such messages or information.

[0118] The electronic device according to the embodiment of this disclosure belongs to the same inventive concept as the table data retrieval method according to the above embodiment, and for technical details not described in detail in the embodiment of this disclosure, the above embodiment may be referred to, and this embodiment and the above embodiment have similar beneficial effects.

[0119] Embodiments of this disclosure provide a computer storage medium that stores a computer program that implements the table data retrieval method according to the above embodiment when executed by a processor.

[0120] The computer-readable medium described above in this disclosure may be a computer-readable signal medium or a computer-readable storage medium, or any combination of the two. The computer-readable storage medium may be, but is not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specifically, the computer-readable storage medium may include, but is not limited to, an electrical connection having one or more wires, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof. In embodiments of this disclosure, the computer-readable storage medium may be any tangible medium containing or storing a program, which can be used in or in combination with an instruction execution system, apparatus, or device. In embodiments of this disclosure, the computer-readable signal medium may contain a data signal propagated in the baseband or as part of a carrier wave, which contains computer-readable program code. The data signals propagated in this manner may take many forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. The computer-readable signal medium may further be any computer-readable medium other than a computer-readable storage medium, and this computer-readable medium can transmit, propagate, or transmit programs used in or in combination with instruction execution systems, apparatus, or devices. The program code contained in the computer-readable medium can be transmitted by any suitable medium, including but not limited to electric wires, optical cables, RF (radio frequency), etc., or any suitable combination thereof.

[0121] According to one or more embodiments of this disclosure, in [Example 1], The process involves receiving a data retrieval request for a target table via the target interface, and identifying the data to be retrieved and the first search range in the target table based on the data retrieval request. If the first search range includes target table data, the steps include: identifying a second search range based on predetermined search conditions corresponding to the search target data, the first search range, and the target table data; The present invention provides a table data search method that includes the steps of: performing a search operation on the target data within a second search range to obtain search feedback data; and displaying the search feedback data in a target interface.

[0122] According to one or more embodiments of the present disclosure, [Example 2] provides the method of Example 1, wherein the step of selectively identifying a second search range based on predetermined search conditions corresponding to the data to be searched, a first search range, and target table data includes, if the data to be searched does not satisfy the predetermined search conditions corresponding to the target table data, removing the target table data from the first search range to obtain the second search range.

[0123] According to one or more embodiments of the present disclosure, [Example 3] provides the method of Example 1, which optionally includes a predetermined search criterion associated with a field type of target table data.

[0124] According to one or more embodiments of the present disclosure, [Example 4] provides the method of Example 1, further comprising the step of displaying search feedback data on a target interface, and then pausing the execution of a search operation on the search target data if the retrieved search feedback data reaches a predetermined data volume threshold, wherein the predetermined data volume threshold is greater than or equal to a displayable data volume threshold on the target interface.

[0125] According to one or more embodiments of the present disclosure, [Example 5] provides the method of Example 1, and optionally further includes the steps of: displaying search feedback data in the target interface, and then, upon receiving a collaborative edit operation on a target table from a collaborator, identifying the edited table data corresponding to the collaborative edit operation; and displaying the target interface based on the edited table data and the search feedback data displayed in the target interface.

[0126] According to one or more embodiments of the present disclosure, [Example 6] provides a method of Example 5, wherein the step of displaying the target interface based on the edited table data and the search feedback data displayed in the target interface further includes updating the search feedback data displayed in the target interface if the search feedback data displayed in the target interface includes the edited table data.

[0127] According to one or more embodiments of the present disclosure, [Example 7] provides a method of Example 1, wherein the step of selectively receiving a data retrieval request to a target table by a target interface and identifying a first search range in the target table based on the data retrieval request further includes receiving a range setting trigger operation to the target table by the target interface, generating and displaying a searchable range list containing range identifiers corresponding to at least one searchable range based on the table data displayed in the target interface in the target table, and receiving an identifier selection operation for a range identifier and identifying a first search range in the target table based on the searchable range corresponding to the selected range identifier.

[0128] According to one or more embodiments of the present disclosure, [Example 8] provides the method of Example 1, further comprising the steps of: displaying search feedback data on a target interface; receiving a scroll display operation on the search feedback data by the target interface; determining a data scroll speed and a threshold for the amount of data the target interface can display; determining a number of preloads of search feedback data based on the data scroll speed and the threshold for the amount of data the target interface can display; and preloading the search feedback data based on the number of preloads.

[0129] According to one or more embodiments of the present disclosure, [Example 9] provides the method of Example 1, wherein each column of the target table has a fixed field type, and the table data entered in each cell of the target table is associated with the field type of the column in which the cell is located.

[0130] According to one or more embodiments of the present disclosure, [Example 10] provides a table data retrieval device.

[0131] In some embodiments, clients and servers can communicate using any known or future-to-be-developed network protocol such as HTTP (Hypertext Transfer Protocol) and can interconnect with digital data communications (e.g., communication networks) in any form or medium. Examples of communication networks include local area networks ("LANs"), wide area networks ("WANs"), the Internet (e.g., interconnected networks), peer-to-peer networks (e.g., ad hoc peer-to-peer networks), and any known or future-to-be-developed networks.

[0132] The computer-readable medium described above may be included in the electronic device described above, or it may exist independently without being mounted on the electronic device.

[0133] The above computer-readable medium holds one or more programs, and when the above one or more programs are executed by the electronic device, the electronic device... The process involves receiving a data retrieval request for a target table via the target interface, and identifying the data to be retrieved and the first search range in the target table based on the data retrieval request. If the first search range includes target table data, the steps include: identifying a second search range based on predetermined search conditions corresponding to the search target data, the first search range, and the target table data; The system is made to perform the following steps: execute a search operation on the target data within a second search range to obtain search feedback data, and display the search feedback data on the target interface.

[0134] Computer program code for performing the operations disclosed herein may be written in one or more programming languages ​​or a combination thereof, including, but not limited to, object-oriented programming languages ​​such as Java®, Smalltalk, and C++, and more specifically, general procedural programming languages ​​such as the "C" language or similar programming languages. The program code may run entirely on a user computer, partially on a user computer, run as a standalone software package, run partly on a user computer and partly on a remote computer, or run entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user computer by any network, including a local area network (LAN) or a wide area network (WAN), or it may be connected to an external computer (for example, via the Internet using an Internet service provider).

[0135] The flowcharts and block diagrams in the drawings illustrate the implementable system architectures, functions, and operations of systems, methods, and computer program products relating to various embodiments of the present disclosure. In this regard, each block in a flowchart or block diagram may represent a module, program segment, or part of code, which includes one or more executable instructions for implementing a given logical function. It should also be noted that in some alternative implementations, the functions represented in a block may be implemented in a different order than those shown in the drawings. For example, two consecutively shown blocks may be executed substantially in parallel, or they may be executed in opposite orders depending on the function. It should also be noted that each block in a block diagram and / or flowchart, and combinations of blocks in a block diagram and / or flowchart, may be implemented by a dedicated hardware-based system that performs a given function or operation, or by a combination of dedicated hardware and computer instructions.

[0136] The units described in the embodiments of this disclosure may be implemented in software or in hardware. Herein, the names of the units are not limited in some cases; for example, a data retrieval request module may be further described as a "module that receives data retrieval requests for a target table."

[0137] The functions described herein may be performed, at least in part, by one or more hardware logic components. For example, exemplary types of hardware logic components that may be used include, but are not limited to, field-programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standards (ASSPs), systems on chips (SOCs), coupled programmable logic devices (CPLDs), and the like.

[0138] In the context of this disclosure, machine-readable media may be tangible storage media that contain or store programs used in or in combination with instruction execution systems, devices, or equipment. Machine-readable media may be machine-readable signal media or machine-readable storage media. Machine-readable media may include, but are not limited to, electrical, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices, or equipment, or any suitable combination thereof. More specifically, machine-readable storage media include electrical connections based on one or more wires, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fibers, compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination thereof.

[0139] The above description is merely a description of preferred embodiments and applicable technical principles of the present disclosure. Those skilled in the art should understand that the scope of the present disclosure is not limited to technical solutions formed by specific combinations of the above technical features, but should also include other technical solutions formed by arbitrarily combining the above technical features or equivalent features without departing from the above-disclosed concept. For example, it also includes technical solutions formed by substituting the above features with (not limited to) similar functional technical features disclosed in the present disclosure.

[0140] Furthermore, although the operations have been described in a specific order, it should not be understood that these operations must be performed in a specific order or sequence as indicated. In certain environments, multitasking and parallel processing may be advantageous. Similarly, although the above description includes various specific implementation details, these should not be construed as limiting the scope of this disclosure. Some features described in the context of a single embodiment may be implemented in combination in a single embodiment. Conversely, various features described in the context of a single embodiment may also be implemented in multiple embodiments, individually or in any appropriate partial combination.

[0141] Although this topic has been described using language specific to constituent features and / or methodological logic and operation, it should not be understood that the topic limited to the attached claims is limited to the specific features or operations described above. Rather, the specific features and operations described above are merely illustrative forms of realizing the claims.

Claims

1. The steps include receiving a data retrieval request for a target table via the target interface, and identifying the data to be retrieved and a first search range in the target table based on the data retrieval request, If the first search range includes target table data, the steps include: identifying a second search range based on predetermined search conditions corresponding to the search target data, the first search range, and the target table data; A table data search method characterized by comprising the steps of: performing a search operation on the target data within the second search range to obtain search feedback data; and displaying the search feedback data on the target interface.

2. The step of identifying a second search range based on predetermined search conditions corresponding to the search target data, the first search range, and the target table data is as follows: The table data search method according to claim 1, characterized in that if the search target data does not satisfy the predetermined search conditions corresponding to the target table data, the method includes deleting the target table data from the first search range and obtaining a second search range.

3. The table data search method according to claim 1, characterized in that the predetermined search conditions are associated with the field type of the target table data.

4. After displaying the search feedback data on the target interface, The method further includes the step of temporarily suspending the execution of the search operation on the search target data when the acquired search feedback data reaches a predetermined data volume threshold, The table data retrieval method according to claim 1, characterized in that the threshold for the predetermined amount of data is greater than or equal to the threshold for the amount of data that can be displayed on the target interface.

5. After displaying the search feedback data on the target interface, When a collaborative editing operation on the target table is received from a collaborator, the steps include identifying the edited table data corresponding to the collaborative editing operation, The table data search method according to claim 1, further comprising the step of displaying the target interface based on the edited table data and the search feedback data displayed on the target interface.

6. The step of displaying the target interface based on the edited table data and the search feedback data displayed in the target interface is: The table data search method according to claim 5, characterized in that if the search feedback data displayed in the target interface includes the edited table data, the method includes updating the search feedback data displayed in the target interface.

7. The steps include receiving the data retrieval request for the target table via the target interface and determining the first search range in the target table based on the data retrieval request, The target interface receives a range setting trigger operation for the target table, and generates and displays a searchable range list containing a range identifier corresponding to at least one searchable range, based on the table data displayed in the target interface in the target table. The table data retrieval method according to claim 1, characterized by comprising: receiving an identifier selection operation for the range identifier, and identifying the first search range in the target table based on the searchable range corresponding to the selected range identifier.

8. After displaying the search feedback data on the target interface, The steps include: receiving a scroll display operation on the search feedback data via the target interface, and determining the data scroll speed and the threshold amount of data that can be displayed by the target interface; The table data search method according to claim 1, further comprising the steps of determining the number of preloaded search feedback data based on the data scrolling speed and the threshold of the amount of displayable data, and preloading the search feedback data based on the number of preloaded data.

9. The table data retrieval method according to claim 1, characterized in that each column of the target table has a fixed field type, and the table data entered in each cell of the target table is associated with the field type of the column in which the cell is located.

10. A data search request module receives a data search request for a target table via a target interface and identifies the data to be searched and a first search range in the target table based on the data search request. If the first search range includes target table data, a search range identification module identifies a second search range based on predetermined search conditions corresponding to the search target data, the first search range, and the target table data. A search data feedback module that performs a search operation on the target data within the second search range to obtain search feedback data and displays the search feedback data on the target interface, A table data retrieval device characterized by comprising the following features.

11. One or more processors, A storage device for storing one or more programs, An electronic device characterized in that, when the one or more programs are executed by the one or more processors, the one or more processors implement the table data retrieval method described in any one of claims 1 to 9.

12. A storage medium including a computer-executable instruction, wherein the computer-executable instruction, when executed by a computer processor, executes the table data retrieval method described in any one of claims 1 to 9.

13. A computer program product comprising a computer program, wherein the computer program, when executed by a processor, implements the table data retrieval method described in any one of claims 1 to 9.

Images