Question number query method, device, system, electronic device and medium

Abstract

The present invention discloses a method, device, system, electronic device and medium for querying question numbers. The method comprises: extracting question numbers corresponding to the target state in an online document based on a target state query instruction to obtain a first question number set, matching the first question number set with a second question number set in the target state in a question management system to determine whether the question numbers in the first question number set are in the second question number set; if any third question number in the first question number set is not in the second question number set, determining whether the state of the third question number in the question management system is the target state; summarizing the third question numbers whose corresponding states in the question management system are not the target state to obtain a third question number set, thereby realizing automatic and rapid screening, replacing manual operations, reducing workload and improving work efficiency.

Description

Technical Field

[0001] The present invention relates to the technical field of data processing and analysis, and in particular to a question number query method, device, system, electronic equipment and medium. Background Art

[0002] The company's project problem management system includes external and internal problems. External problems refer to problems discovered by external companies, and internal colleagues submit external problems to the internal problem management system. External problems are jointly managed by online Excel documents and the internal problem management system, including problem numbers and problem status. When an external company changes the status in real time in the online Excel document, such as changing the status of a problem from open to closed, the staff must also find the corresponding problem number in the internal problem management system and perform the corresponding status change operation.

[0003] However, the staff does not know which problem numbers correspond to the latest status changes made by external companies. They need to compare and change the status of all problem numbers in this status with the internal problem management system one by one, which is a heavy workload and low work efficiency. Summary of the Invention

[0004] Therefore, the technical problem to be solved by the present invention is to overcome the existing defects of large workload and low efficiency, thereby providing a question number query method, device, system, electronic equipment and medium.

[0005] According to a first aspect, an embodiment of the present invention discloses a method for querying question numbers, the method comprising: based on a target state query instruction, extracting question numbers corresponding to the target state in an online document to obtain a first question number set, wherein the target state represents the question state corresponding to a state change of the question number by the first user; matching the first question number set with a second question number set in the target state in the question management system to determine whether the question numbers in the first question number set are in the second question number set; if any third question number in the first question number set is not in the second question number set, determining whether the state of the third question number in the question management system is the target state; summarizing the third question numbers whose corresponding states in the question management system are not the target state to obtain a third question number set.

[0006] Optionally, the method further includes: feeding back the third question number set to the second user, so that the second user changes the current state of any question number in the third question number set to the target state in the question management system.

[0007] Optionally, the method further includes: updating the second set of problem numbers after changing the current state of any problem number to the target state in the problem management system.

[0008] Optionally, the method further includes: if it is determined that the status of the third question number in the question management system is the target status, then continuing to determine whether the status of the next third question number in the first question number set in the question management system is the target status.

[0009] Optionally, before matching the first question number set with the second question number set in the question management system that is in the target state, the method further includes: obtaining second user configuration information; and obtaining the second question number set in the question management system that is in the target state based on the second user configuration information, wherein the second user configuration information includes the question management system account and password.

[0010] According to a second aspect, embodiments of the present invention further disclose a question number query system, comprising: an online document for storing question numbers and corresponding question statuses; and a question management system for extracting the status corresponding to the question number and enabling a second user to change the status. A question number query platform establishes communication connections with the online document and the question management system, respectively, and is configured to execute the question number query method described in the first aspect or any optional embodiment of the first aspect.

[0011] According to a third aspect, an embodiment of the present invention further discloses a question number query device, which includes: a question number extraction module, which is used to extract the question numbers corresponding to the target state in the online document based on the target state query instruction, and obtain a first question number set, wherein the target state represents the question state corresponding to the state of the question number after the first user changes the state of the question number; a question number matching module, which is used to match the first question number set with the second question number set in the question management system that is in the target state, and determine whether the question numbers in the first question number set are in the second question number set; a state matching module, which is used to determine whether the state of any third question number in the first question number set is the target state in the question management system if it is not in the second question number set; a question number aggregation module, which is used to aggregate the third question numbers whose corresponding states in the question management system are not the target state, and obtain a third question number set.

[0012] According to the fourth aspect, an embodiment of the present invention also discloses an electronic device, comprising: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform the steps of the question number query method as described in the first aspect or any optional embodiment of the first aspect.

[0013] According to the fifth aspect, an embodiment of the present invention further discloses a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps of the question number query method as described in the first aspect or any optional embodiment of the first aspect.

[0014] The technical solution of the present invention has the following advantages:

[0015] The question number query method provided by the present invention extracts the question numbers corresponding to the target state in the online document based on the target state query instruction to obtain a first question number set, matches the first question number set with the second question number set in the target state in the question management system to determine whether the question numbers in the first question number set are in the second question set; if any third question number in the first question number set is not in the second question number set, determines whether the state of the third question number in the question management system is the target state; summarizes the third question numbers whose corresponding states in the question management system are not the target state to obtain a third question number set. This method changes the problem that can only be matched and modified manually based on the question numbers corresponding to the target state in the online document and the corresponding states in the question management system one by one. This method establishes a communication connection between the question management system and the online document, realizes automatic screening of question numbers corresponding to the target state of the online document, automatically extracts question numbers corresponding to the target state in the question management system, automatically performs question number matching and filtering, and finally summarizes question numbers that only need to be modified in state, replacing manual operations, reducing workload and improving work efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0017] Figure 1 This is a flowchart of a specific example of a method for querying question numbers in an embodiment of the present invention;

[0018] Figure 2 This is a specific example diagram of a question number query system according to an embodiment of the present invention;

[0019] Figure 3 is a principle block diagram of a specific example of a question number query device according to an embodiment of the present invention;

[0020] Figure 4 FIG. 4 is a diagram showing a specific example of an electronic device in an embodiment of the present invention. DETAILED DESCRIPTION

[0021] The technical solution of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the embodiments described are only some embodiments of the present invention, not all embodiments. All other embodiments obtained by ordinary technicians in this field based on the embodiments of the present invention without making any creative efforts shall fall within the scope of protection of the present invention.

[0022] In the description of the present invention, it should be noted that the terms "center," "upper," "lower," "left," "right," "vertical," "horizontal," "inner," and "outer," etc., indicating orientations or positional relationships, are based on the orientations or positional relationships shown in the accompanying drawings and are intended solely to facilitate and simplify the description of the present invention. They are not intended to indicate or imply that the devices or components referred to must have, be constructed, or operate in a specific orientation, and therefore should not be construed as limitations on the present invention. Furthermore, the terms "first," "second," and "third" are used for descriptive purposes only and should not be construed as indicating or implying relative importance.

[0023] In addition, the technical features involved in different embodiments of the present invention described below can be combined with each other as long as they do not conflict with each other.

[0024] The embodiment of the present invention discloses a method for querying question numbers, such as Figure 1 As shown, the method includes the following steps:

[0025] Step 101: Based on a target state query instruction, extract question numbers corresponding to the target state in an online document to obtain a first question number set.

[0026] The target state represents the state of the question corresponding to the state of the question number after the first user changes the state.

[0027] Exemplarily, the first user is the object that changes the status corresponding to the problem number in the online document. It can be a company, etc., or an external individual user, etc., just as an example. In the embodiment of the present application, the company fills the problems found in the online document for internal staff to repair the problems based on the problems in the online document. When the company believes that one or some problems do not exist, the company changes the status of the corresponding problem number in the online document based on the actual situation. For example, the initial open state is changed to a closed state, indicating that the problem has been solved. All problem numbers in the closed state in the online document can be extracted to obtain a first problem number set, where the online document can be an Excel file or other documents that can be edited online, just as an example.

[0028] Step 102: Match the first question number set with the second question number set in the question management system in the target state, and determine whether the question number in the first question number set is in the second question set.

[0029] For example, in an embodiment of the present application, after a company makes a real-time change to the status of a question number in an online document, internal staff are required to change the status corresponding to the question number to the latest status in the question management system. They can first obtain all the question numbers that are in a closed state in the current existing question management system, that is, the question numbers that are in a closed state in the question management system before the company updates the status, match the first question number set with the second question number set, and determine whether the question numbers in the first question number set are in the second question number set. If a question number is not in the second question number set, it means that the status of the question number is the latest change of the company, and a corresponding status change needs to be made in the internal management system. If a question number is in the second question number set, the question number is directly filtered out without any processing. This is just an example.

[0030] As an optional embodiment of the present invention, the method further includes: if the current question number in the first question number set is in the second question number set, matching the next question number in sequence.

[0031] For example, if a question number of the first question number is in the second question number set, it means that the status of the question number has been changed before, and no processing is required. The next question number can be matched in the order of the extracted number summary.

[0032] Step 103: If any third question number in the first question number set is not in the second question number set, determine whether the status of the third question number in the question management system is the target status.

[0033] For example, in the embodiment of the present application, if it is determined that any problem number is not in the second problem number set, it means that the status of the problem number is the latest change of the company enterprise, and a corresponding status change needs to be made in the internal management system. However, it may happen that when an external enterprise changes the status of a certain problem, it notifies the internal staff in real time, and the internal staff changes the status corresponding to the problem in the problem management system. Therefore, after determining that any problem number is not in the second problem number set, it is also necessary to determine the status of the problem number in the problem management system, such as whether it is in a closed state, to reduce the query workload. If not, it means that the staff needs to change the status corresponding to the problem number. If the status of the problem number in the problem management system is closed, the problem number is filtered out and no processing is performed. This is just an example.

[0034] As an optional embodiment of the present invention, the method also includes: if it is determined that the status of the third question number in the question management system is the target status, then continue to determine whether the status of the next third question number in the first question number set in the question management system is the target status.

[0035] For example, in the embodiment of the present application, if it is determined that the status of a certain question number in the question management system is closed, it means that an internal staff has changed the status corresponding to the question number, so no processing is required, and the next question number that is not in the second question number set can be directly determined to determine whether the status in the question management system is closed. The above embodiment is repeated only as an example.

[0036] Step 104 : Summarize the third problem numbers whose corresponding states are not the target state in the problem management system to obtain a third problem number set.

[0037] Exemplarily, an embodiment of the present application may aggregate all question numbers that require internal staff to change the status corresponding to the question number to obtain a third question number set.

[0038] The method described in the above embodiment can not only be used for companies to change problem status, but also can be used for companies to update the attendance status of staff in real time, such as changing the attendance status from work to leave in the management system, etc. There is no limitation on the application of the above method.

[0039] The question number query method provided by the present invention extracts the question numbers corresponding to the target state in the online document based on the target state query instruction to obtain a first question number set, matches the first question number set with the second question number set in the target state in the question management system to determine whether the question numbers in the first question number set are in the second question set; if any third question number in the first question number set is not in the second question number set, determines whether the state of the third question number in the question management system is the target state; summarizes the third question numbers whose corresponding states in the question management system are not the target state to obtain a third question number set. This method changes the problem that can only be matched and modified manually based on the question numbers corresponding to the target state in the online document and the corresponding states in the question management system one by one. This method establishes a communication connection between the question management system and the online document, realizes automatic screening of question numbers corresponding to the target state of the online document, automatically extracts question numbers corresponding to the target state in the question management system, automatically performs question number matching and filtering, and finally summarizes question numbers that only need to be modified in state, replacing manual operations, reducing workload and improving work efficiency.

[0040] As an optional embodiment of the present invention, the method further includes: feeding back the third question number set to the second user, so that the second user changes the current state of any question number in the third question number set to the target state in the question management system.

[0041] Exemplarily, the third question set obtained by the above real-time summary is fed back to the second user, wherein the second user is an internal staff member. The second user can change the current status of all question numbers in the summarized third question set to the target status. After automatic screening, only the question numbers corresponding to the latest updated status need to be changed in the question management system, thereby improving work efficiency.

[0042] As an optional implementation of the present invention, the method further includes: updating the second set of question numbers after changing the current state of any question number to the target state in the question management system.

[0043] For example, after the internal staff of the embodiment of the present application changes the current status of all question numbers in the third question number set in the question management system to the target status, such as changing it to a closed status, it means that the number of question numbers in the closed status in the question management system has changed, so the second question number set needs to be updated, which improves the accuracy and comprehensiveness of the next round of question number queries, thereby further reducing the workload.

[0044] As an optional embodiment of the present invention, before matching the first question number set with the second question number set in the question management system that is in the target state, the method further includes: obtaining second user configuration information; based on the second user configuration information, obtaining the second question number set in the question management system that is in the target state, the second user configuration information including the question management system account and password.

[0045] For example, before extracting the second set of question numbers in the target state in the management system, the embodiment of the present application requires internal staff to provide configuration information, where the configuration information includes the account and password of the question management system. The second set of question numbers can only be extracted when the account and password are correct, thereby ensuring the security and confidentiality of internal data. After logging in based on this account and password, you can directly log in to the question management system corresponding to the account and extract the corresponding second set of question numbers. This makes it less likely that data in other question management systems will be confused, thereby improving the accuracy of question number matching. This is just an example.

[0046] The embodiment of the present invention also discloses a question number query system, such as Figure 2 As shown, the system includes:

[0047] Online document, used to store issue numbers and corresponding issue status;

[0048] The issue management system is used to extract the status corresponding to the issue number and enable the second user to perform status change operations.

[0049] The question number query platform establishes communication connections with the online document and question management system, respectively, and is used to execute the question number query method of the above embodiment. Detailed descriptions refer to the above embodiment and will not be repeated here.

[0050] The embodiment of the present invention also discloses a question number query device, such as Figure 3 As shown, the device includes:

[0051] The question number extraction module 301 is configured to extract question numbers corresponding to the target states in the online document based on the target state query instruction to obtain a first question number set, wherein the target state represents the question state corresponding to the question number after the first user changes the state of the question number;

[0052] A question number matching module 302 is configured to match the first question number set with a second question number set in the question management system in the target state, and determine whether a question number in the first question number set is within the second question number set;

[0053] a state matching module 303 for determining whether the state of any third question number in the first question number set is the target state in the question management system if the third question number in the first question number set is not in the second question number set;

[0054] The question number aggregation module 304 is configured to aggregate the third question numbers whose corresponding states in the question management system are not the target state to obtain a third question number set.

[0055] The question number query device provided by the present invention extracts the question numbers corresponding to the target state in the online document based on the target state query instruction to obtain a first question number set, matches the first question number set with the second question number set in the target state in the question management system to determine whether the question numbers in the first question number set are in the second question set; if any third question number in the first question number set is not in the second question number set, determines whether the state of the third question number in the question management system is the target state; summarizes the third question numbers whose corresponding states in the question management system are not the target state to obtain a third question number set. This method changes the problem that can only be matched and modified manually based on the question numbers corresponding to the target state in the online document and the corresponding states in the question management system one by one. This method establishes a communication connection between the question management system and the online document, realizes automatic screening of question numbers corresponding to the target state of the online document, automatically extracts question numbers corresponding to the target state in the question management system, automatically performs question number matching and filtering, and finally summarizes question numbers that only need to be modified in state, replacing manual operations, reducing workload and improving work efficiency.

[0056] As an optional embodiment of the present invention, the device also includes: a state change module, which is used to feed back the third question number set to the second user, so that the second user changes the current state of any question number in the third question number set to the target state in the question management system.

[0057] As an optional embodiment of the present invention, the device further includes: a number set updating module, configured to update the second question number set after changing the current state of any question number in the question management system to the target state.

[0058] As an optional embodiment of the present invention, the device further includes: a sequential matching module, configured to match the next question number in sequence if the current question number in the first question number set is in the second question number set.

[0059] As an optional embodiment of the present invention, the device also includes: a state sequence matching module, which is used to continue to determine whether the state of the next third question number in the first question number set in the question management system is the target state if it is determined that the state of the third question number in the question management system is the target state.

[0060] As an optional embodiment of the present invention, before matching the first question number set with the second question number set in the question management system that is in the target state, the device also includes: a configuration information acquisition module for acquiring second user configuration information; a second question number set acquisition module for obtaining the second question number set in the target state in the question management system based on the second user configuration information, wherein the second user configuration information includes the question management system account and password.

[0061] The embodiment of the present invention further provides an electronic device, such as Figure 4 As shown, the electronic device may include a processor 401 and a memory 402, wherein the processor 401 and the memory 402 may be connected via a bus or other means. Figure 4 The bus connection is taken as an example.

[0062] The processor 401 may be a central processing unit (CPU). The processor 401 may also be other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or a combination of the above chips.

[0063] Memory 402, as a non-transitory computer-readable storage medium, can be used to store non-transitory software programs, non-transitory computer-executable programs, and modules, such as the program instructions / modules corresponding to the question number query method in the embodiments of the present invention. Processor 401 executes the non-transitory software programs, instructions, and modules stored in memory 402 to perform various processor functions and data processing, thereby implementing the question number query method in the above-mentioned method embodiments.

[0064] The memory 402 may include a program storage area and a data storage area, wherein the program storage area may store an operating system and applications required for at least one function; the data storage area may store data created by the processor 401, etc. In addition, the memory 402 may include a high-speed random access memory, and may also include a non-volatile memory, such as at least one disk storage device, a flash memory device, or other non-volatile solid-state storage device. In some embodiments, the memory 402 may optionally include a memory remotely located relative to the processor 401, and these remote memories may be connected to the processor 401 via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0065] The one or more modules are stored in the memory 402 and when executed by the processor 401, perform the following steps: Figure 1 The question number query method in the illustrated embodiment.

[0066] For details of the above electronic equipment, please refer to Figure 1 The corresponding descriptions and effects in the embodiments shown can be understood and will not be repeated here.

[0067] Those skilled in the art will appreciate that all or part of the processes in the above-mentioned embodiments can be implemented by instructing the relevant hardware through a computer program. The program can be stored in a computer-readable storage medium. When the program is executed, it can include the processes of the embodiments of the above-mentioned methods. The storage medium can be a magnetic disk, an optical disk, a read-only memory (ROM), a random access memory (RAM), a flash memory, a hard disk drive (HDD), or a solid-state drive (SSD). The storage medium can also include a combination of the above-mentioned types of memory.

[0068] Although the embodiments of the present invention have been described with reference to the accompanying drawings, those skilled in the art may make various modifications and variations without departing from the spirit and scope of the present invention, and such modifications and variations are all within the defined scope.

Claims

1. A method for querying question numbers, characterized in that: The method comprises: Based on the target state query instruction, extract the question number corresponding to the target state in the online document to obtain a first question number set, wherein the target state represents the question state corresponding to the question number after the first user changes the state; Matching the first set of question numbers with a second set of question numbers in the question management system that is in the target state, and determining whether a question number in the first set of question numbers is within the second set of question numbers; If any third question number in the first question number set is not in the second question number set, determining whether the state of the third question number in the question management system is the target state; The third question numbers whose corresponding states in the question management system are not the target state are summarized to obtain a third question number set.

2. The question number query method according to claim 1, characterized in that: The method further comprises: The third set of question numbers is fed back to the second user, so that the second user changes the current state of any question number in the third set of question numbers to the target state in the question management system.

3. The question number query method according to claim 2, characterized in that: The method further comprises: After the current state of any issue number is changed to the target state in the issue management system, the second issue number set is updated.

4. The method according to claim 1, wherein The method further comprises: If the current question number in the first question number set is in the second question number set, the next question number is matched in sequence.

5. The question number query method according to claim 1, characterized in that: The method further comprises: If it is determined that the status of the third question number in the question management system is the target status, then continue to determine whether the status of the next third question number in the first question number set in the question management system is the target status.

6. The question number query method according to claim 1, characterized in that: Before matching the first set of question numbers with the second set of question numbers in the question management system that is in the target state, the method further includes: Obtaining second user configuration information; Based on the second user configuration information, a second set of problem numbers in the target state in the problem management system is obtained, where the second user configuration information includes an account and a password for the problem management system.

7. A question number query system, characterized in that: The system comprises: Online document, used to store issue numbers and corresponding issue status; The issue management system is used to extract the status corresponding to the issue number and enable the second user to perform status change operations; The question number query platform establishes communication connections with the online document and question management system respectively, and is used to execute the question number query method as described in any one of claims 1-6.

8. A question number query device, characterized in that: The device comprises: A question number extraction module is configured to extract question numbers corresponding to the target states in the online document based on the target state query instruction to obtain a first question number set, wherein the target state represents the question state corresponding to the question number after the first user changes the state of the question number; a question number matching module, configured to match the first question number set with a second question number set in the question management system in the target state, and determine whether a question number in the first question number set is within the second question number set; a state matching module, configured to determine whether a state of any third question number in the first question number set is the target state in the question management system if the third question number in the first question number set is not in the second question number set; The problem number aggregation module is used to aggregate the third problem numbers whose corresponding states in the problem management system are not the target state to obtain a third problem number set.

9. An electronic device, characterized in that: include: at least one processor; And a memory communicatively connected to the at least one processor; wherein the memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform the steps of the question number query method as described in any one of claims 1-6.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the question number query method according to any one of claims 1 to 6 are implemented.

Images