Data processing method and apparatus, and electronic device and storage medium

By setting calculation formulas associated with target work items in the project management system, obtaining and computing data, and applying them to business scenarios, the problem of difficulty for users to obtain information is solved, multi-dimensional display and business impact are achieved, and user experience is improved.

WO2024235207A1PCT designated stage expired Publication Date: 2024-11-21BEIJING ZITIAO NETWORK TECH CO LTD
View PDF 5 Cites 0 Cited by

Patent Information

Application Number
PCT/CN2024/092943
Authority / Receiving Office
WO · WO
Patent Type
Applications
Current Assignee / Owner
Priority Date
2023-05-16
Filing Date
2024-05-13
Publication Date
2024-11-21

AI Technical Summary

Technical Problem

In project management systems, it is difficult for users to obtain more information and more complex analysis results to meet their needs, and the existing technology cannot effectively use calculation formulas to provide multi-dimensional and multi-level demonstrations of work items and impact business scenarios.

Method used

Provides a data processing method and device, by setting calculation formulas associated with target work items, obtaining calculation data and logical information, computing and applying calculation results to business scenarios in the project management system, displaying or affecting the process of work items.

Benefits of technology

It realizes the impact of multi-dimensional and multi-level presentation and business scenarios on the target work items in the project management system, meets more user needs and improves user experience.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN2024092943_21112024_PF_FP_ABST
    Figure CN2024092943_21112024_PF_FP_ABST
Patent Text Reader

Abstract

Provided in the present disclosure are a data processing method and apparatus, and an electronic device and a storage medium. The method is applied to a project management system, and comprises: in response to a setting operation for a first calculation formula of a target work item, acquiring calculation data information and calculation logic information of the first calculation formula, wherein the first calculation formula is associated with the target work item; acquiring corresponding calculation data on the basis of the calculation data information, and performing operations on the acquired calculation data on the basis of the calculation logic information, so as to obtain a calculation result; and in response to an operation for adding the first calculation formula to a target service scenario in the project management system, presenting, in the target service scenario, the calculation result corresponding to the first calculation formula, or influencing a service of the target service scenario on the basis of the calculation result corresponding to the first calculation formula.
Need to check novelty before this filing date? Find Prior Art

Description

Data processing method, device, electronic device and storage medium

[0001] CROSS-REFERENCE TO RELATED APPLICATIONS

[0002] This application claims the benefit of Chinese Patent Application No. 202310552453.4, filed May 16, 2023. The entire teachings of the above application are incorporated herein by reference. Technical Field

[0003] The present disclosure relates to the field of data processing technology, and in particular to a data processing method, device, electronic device, and storage medium. Background Art

[0004] Managing work tasks using a project management system is a common work management model, widely used across various industries. In a project management system, users can manage tasks based on work items. When managing work items, users need more information.

[0005] Summary of the Invention

[0006] In view of this, the purpose of the present disclosure is to provide a data processing method, device, electronic device and storage medium.

[0007] Based on the above objectives, a first aspect of the present disclosure provides a data processing method, which is applied to a project management system, comprising:

[0008] In response to a setting operation on a first calculation formula of a target work item, obtaining calculation data information and calculation logic information of the first calculation formula, wherein the first calculation formula is associated with the target work item;

[0009] Based on the calculation data information, corresponding calculation data is acquired, and based on the calculation logic information, calculation is performed on the acquired calculation data to obtain a calculation result;

[0010] In response to the operation of adding the first calculation formula to the target business scenario in the project management system, the calculation result corresponding to the first calculation formula is displayed in the target business scenario, or the business of the target business scenario is affected based on the calculation result corresponding to the first calculation formula.

[0011] A second aspect of the present disclosure provides a data processing device, including:

[0012] an acquisition module configured to: in response to a setting operation on a first calculation formula of a target work item, acquire calculation data information and calculation logic information of the first calculation formula, wherein the first calculation formula is associated with the target work item;

[0013] a calculation module configured to: acquire corresponding calculation data based on the calculation data information, and perform calculations on the acquired calculation data based on the calculation logic information to obtain a calculation result;

[0014] The adding module is configured to: in response to the operation of adding the first calculation formula to the target business scenario in the project management system, display the calculation result corresponding to the first calculation formula in the target business scenario, or affect the business of the target business scenario based on the calculation result corresponding to the first calculation formula.

[0015] A third aspect of the present disclosure provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the method described in the first aspect when executing the program.

[0016] A fourth aspect of the present disclosure provides a non-transitory computer-readable storage medium, wherein the non-transitory computer-readable storage medium stores computer instructions, and the computer instructions are used to cause the computer to execute the method described in the first aspect.

[0017] As can be seen from the above, the data processing method, device, electronic device and storage medium provided by the present disclosure, in a project management system, set a first calculation formula associated with the target work item in the project management system, and use the first calculation formula to operate on the calculation data to obtain a calculation result associated with the target work item in the project management system, and then apply the calculation result to each target business scenario in the project management system, so as to display the related information of the target work item in the target business scenario in more dimensions and more levels based on the calculation result, or use the calculation result to advance or block the process of the target work item in the target business scenario, so as to meet more user needs and improve user experience. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0019] FIG1 shows a flow chart of an exemplary method provided by an embodiment of the present disclosure.

[0020] FIG2A shows a schematic diagram of an exemplary page according to an embodiment of the present disclosure.

[0021] FIG2B shows a schematic diagram of an exemplary page according to an embodiment of the present disclosure.

[0022] FIG2C shows a schematic diagram of an exemplary page according to an embodiment of the present disclosure.

[0023] FIG2D shows a schematic diagram of an exemplary page according to an embodiment of the present disclosure.

[0024] FIG2E shows a schematic diagram of an exemplary page according to an embodiment of the present disclosure.

[0025] FIG2F shows a schematic diagram of an exemplary page according to an embodiment of the present disclosure.

[0026] FIG2G shows a schematic diagram of an exemplary page according to an embodiment of the present disclosure.

[0027] FIG3 shows a schematic diagram of an exemplary device provided by an embodiment of the present disclosure.

[0028] FIG4 shows a schematic diagram of the hardware structure of an exemplary computer device provided by an embodiment of the present disclosure. DETAILED DESCRIPTION

[0029] In order to make the objectives, technical solutions and advantages of the present disclosure more clearly understood, the present disclosure is further described in detail below in conjunction with specific embodiments and with reference to the accompanying drawings.

[0030] It should be noted that, unless otherwise defined, the technical terms or scientific terms used in the embodiments of the present disclosure should have the usual meanings understood by people with ordinary skills in the field to which the present disclosure belongs. The "first", "second" and similar words used in the embodiments of the present disclosure do not indicate any order, quantity or importance, but are only used to distinguish different components. "Include" or "comprise" and similar words mean that the elements or objects appearing before the word include the elements or objects listed after the word and their equivalents, without excluding other elements or objects. "Connect" or "connected" and similar words are not limited to physical or mechanical connections, but may include electrical connections, whether direct or indirect. "Up", "down", "left", "right" and the like are only used to indicate relative position relationships. When the absolute position of the described object changes, the relative position relationship may also change accordingly.

[0031] It should be understood that the term "several" in this document refers to one or more, and "multiple" refers to two or more. "And / or" describes the relationship between associated objects, indicating that three possible relationships exist. For example, "A and / or B" can mean: A exists alone, A and B exists simultaneously, or B exists alone. The character " / " generally indicates that the associated objects are in an "or" relationship.

[0032] First, a brief introduction to the terms in the project management system involved in the embodiments of this application is given:

[0033] A project is a temporary effort to complete a unique product or service. Temporary means the project has a definite start and end date, and unique means the end result will not be repeated.

[0034] A work item refers to a collaborative task within a team, or it can be a collection of tasks broken down into a project. It can include requirements, defects, versions, and more.

[0035] Requirements refer to the software functions that users need to solve a problem / achieve a certain goal. They help team members track specific details of the problem.

[0036] Nodes are the stage division points of requirements and are composed of standard task items of requirements.

[0037] A defect is a failure to meet the originally defined business requirements.

[0038] A form is a page that hosts fields.

[0039] A process is a basic step in the life cycle of an event, which is composed of process nodes and execution methods in an orderly manner.

[0040] Node flow breaks down work items into specific executable tasks and connects them into a directed process.

[0041] State flow, which connects the stages of work items in series to form transformation rules.

[0042] Views, including tables, boards, Gantt charts, staff scheduling, views, workbenches, etc.

[0043] Measurement is the continuous quantitative process of defining, collecting and analyzing data about software development projects, processes and their products, such as demand throughput, quality, cycle time and labor estimation.

[0044] Metric charts, including bar charts, line charts, area charts, donut charts, bar charts, funnel charts, indicator cards, data tables, pivot tables, combination charts, burndown charts, etc.

[0045] As shown in FIG1 , an embodiment of the present disclosure provides a data processing method, which is applied to a project management system and includes:

[0046] Step S101 : in response to a setting operation on a first calculation formula of a target work item, obtaining calculation data information and calculation logic information of the first calculation formula, wherein the first calculation formula is associated with the target work item.

[0047] In this embodiment, a calculation formula associated with the target work item may be set for the target work item; and after setting a first calculation formula for the target work item, calculation data information and calculation logic information of the first calculation formula are obtained.

[0048] The calculation data information is used to determine the specific calculation data of the first calculation formula, and the calculation logic information is used to represent the calculation logic of the first calculation formula. That is, the calculation logic information of the first calculation formula may include symbols such as operators and functions that represent the calculation logic. A calculation formula can be composed of calculation data and calculation logic. The calculation logic is used to operate on the calculation data to obtain the calculation result of the calculation formula.

[0049] In this embodiment, a calculation formula can be set for the target work item, for example, a first calculation formula can be set; or, multiple calculation formulas can be set for the target work item, each calculation formula can be targeted at different calculation data information, and / or, each calculation formula can have different calculation logic information, so that when the calculation formula is used to calculate the calculation data, different data information can be obtained.

[0050] Step S103: acquiring corresponding calculation data based on the calculation data information, and performing operations on the acquired calculation data based on the calculation logic information to obtain calculation results.

[0051] In this embodiment, the calculation object of the first calculation formula, i.e., the calculation data corresponding to the calculation data information, can be determined based on the calculation data information. The calculation data is then operated on based on the calculation logic information of the first calculation formula, i.e., the calculation data is operated on using the operators and functions included in the first calculation formula to obtain a calculation result. Because the first calculation formula is associated with the target work item, the obtained calculation result is also correspondingly associated with the target work item.

[0052] In this embodiment, in the project management system, a first calculation formula associated with the target work item is set for the target work item in the project management system, and the calculation data information and calculation logic information of the first calculation formula are obtained based on the first calculation formula. The calculation data is determined by the calculation data information, and then the calculation logic information is used to operate the calculation data to obtain the calculation result associated with the target work item. That is, the first calculation formula can be used to operate the calculation data to obtain the calculation result associated with the target work item in the project management system, so as to obtain more related information with the target work item based on the calculation result.

[0053] In some embodiments, the method described in FIG1 further includes:

[0054] Step S105, in response to the operation of adding the first calculation formula to the target business scenario in the project management system, displaying the calculation result corresponding to the first calculation formula in the target business scenario, or affecting the business of the target business scenario based on the calculation result corresponding to the first calculation formula.

[0055] In some embodiments, the project management system may include multiple business scenarios, such as process management scenarios, page management scenarios, and view management scenarios. Process management scenarios include scenarios such as processes, node flows, and state flows; page management scenarios include forms, detail page forms, node transition forms, and state transition forms; and view management scenarios include tables, dashboards, Gantt charts, personnel scheduling, views, and workbenches.

[0056] The first calculation formula can be added to the page management scenario and the view management scenario to display the data of the page management scenario and the view management scenario based on the calculation results of the first calculation formula. For example, the calculation results of the first calculation formula can be displayed in forms, detail page forms, node flow forms, status flow forms, as well as tables, dashboards, Gantt charts, personnel schedules, views, and workbenches, so that users can view the calculation results of the first calculation formula, or perform statistics, sorting, etc. based on the calculation results of the first calculation formula.

[0057] Alternatively, the first calculation formula can also be added to the process management scenario to affect the process in the process management scenario based on the calculation result of the first calculation formula, such as performing node control on the process, node flow, status flow, etc., to achieve blocking or promotion of the process, node flow, and status flow.

[0058] In this embodiment, in the project management system, a first calculation formula associated with the target work item is set for the target work item, and the calculation data is operated using the first calculation formula to obtain a calculation result associated with the target work item in the project management system, and then the calculation result is applied to each target business scenario in the project management system, so as to display the associated information of the target work item in the target business scenario in more dimensions and more levels based on the calculation result, or use the calculation result to advance or block the process of the target work item in the target business scenario to meet more user needs and improve user experience. In some embodiments, the first calculation formula belongs to the target work item, that is, the data of the calculation logic information used to implement the first calculation formula belongs to the target work item. Among them, the data of the calculation logic information used to implement the first calculation formula can be fields, and these fields can be fields in the target work item.

[0059] In some embodiments, the calculation data corresponding to the calculation data information includes at least the data of the target work item. In this embodiment, if the calculation data corresponding to the calculation data information is the data of the target work item, then the calculation result obtained by operating the calculation data based on the calculation logic information of the first calculation formula is also the calculation result of the target work item.

[0060] Optionally, the calculation data corresponding to the calculation data information may also include dates, constants, etc., that is, the calculation data corresponding to the calculation data information in this embodiment includes dates, constants and data of the target work item, thereby obtaining calculation results related to the cycle and value of the target work item.

[0061] When the target work item is a demand and the target business scenario is a large demand judgment, when the R&D manpower scale is greater than the preset value, the demand can be determined as a large demand; when the R&D manpower scale is less than the preset value, the demand can be determined as a small demand. In this case, the first calculation formula can be determined by data (field: estimated score of R&D node), functions (conditional function if(), sum function sum(), filter function filter(), matching function match()) and preset values:

[0062] if(sum(filter({process node},match(each.{name},"development")).{node estimated score})>preset value,"large demand","small demand").

[0063] The calculation logic of the first calculation formula states that if the estimated score of a development node is greater than a preset value, the calculation result is a large demand; if the estimated score of the development node is less than or equal to the preset value, the calculation result is a small demand. The calculation logic of the first calculation formula is used to calculate the calculation data in the demand work item, and the calculation result (large demand or small demand) is the calculation result related to the value of the target work item.

[0064] When the target work item is a requirement and the target business scenario is the actual time required to determine the requirement, the first calculation formula is determined by using data (fields: node name, node last start time), functions (workdaysBetween(), find()), and date:

[0065] workdaysBetween(find({process node},each.{name}=="start").{node last start time},find({process node},each.{name}=="technical review").{node last start time}).

[0066] The calculation logic of the first calculation formula is as follows: use the find() function to find the first start time of two nodes; then use workdaysBetween() to calculate the working day as the calculation result. If you want to include non-working days, use the daysBetween() function to calculate the natural day as the calculation result.

[0067] In some embodiments, the calculation data corresponding to the calculation data information includes the data of the target work item and the data of other work items other than the target work item. That is, in this embodiment, not only can the data of the target work item to which it belongs be calculated based on the first calculation formula, but the data of other work items can also be introduced if necessary, and the combined data of the target work item data and the data of other work items can be used as calculation data. The combined data of the target work item data and the data of other work items are calculated based on the calculation logic information of the first calculation formula, thereby realizing cross-work item data calculation and obtaining more data results.

[0068] In some embodiments, the calculation data corresponding to the calculation data information includes data of the target work item and data of other work items other than the target work item, wherein the other work items include work items that have a relationship with the target work item.

[0069] The relationship between work items is also a term / concept in project management systems. For example, "Requirement-Related Versions" is a relationship between work items. This relationship allows you to retrieve the work items associated with both ends. Alternatively, you can first identify a requirement and then, based on the relationship between the requirement and "Requirement-Related Versions," retrieve the versions associated with the requirement.

[0070] In some embodiments, the setting operation of the first calculation formula of the target work item includes: in response to an editing operation on the first calculation formula, editing at least one of the field name, field type, calculation formula, and calculation result of the first calculation formula.

[0071] In this embodiment, the first calculation formula can be edited by a user with preset permissions in the project management system. Among them, the user with preset permissions can be an administrator, or a user in the project management system who needs to set up or view the target business scenario, and this embodiment does not limit this. Among them, the administrator can be a system administrator of the project management system, or an administrator of the target work item in the project management system. The user who needs to set up or view the target business scenario can be a user who performs process management, node flow management, and status flow management on the target business scenario, or a user who needs to view corresponding data in a form, detail page form, node flow form, status flow form, table, board, Gantt chart, personnel scheduling, view, or workbench, and this embodiment does not limit this.

[0072] In this embodiment, editing the calculation formula of the first calculation formula includes: editing the calculation data information and calculation logic information of the first calculation formula.

[0073] Among them, the calculation data information can be information such as fields. The field can be a field in the target work item to which the first calculation formula belongs, or it can also be a field in the project management system. Fields can include different types of fields, such as numbers, dates, Boolean values, objects, strings, arrays, rich text, icons, etc. When the content of the field is a date, the data format of the date can be accurate to year, half year, bimonthly, month, week, day, hour, minute, second, etc. When the content of the field is a constant, the data format of the constant can be automatic (i.e., automatically displayed according to user input), integer, decimal (after selecting this item, the number of decimal places can be further set, supporting 1 digit, 2 digits, etc.), and one hundred percent (after selecting this item, the number of decimal places of percentage can be further set, supporting 1 digit, 2 digits, etc.). In this embodiment, the data format of each field can be set in the field management page of the project management system to apply the data to the first calculation formula.

[0074] Computational logic information may include symbols such as functions and operators that represent computational logic.

[0075] The function may be a function supported in the project management system, such as if(), sum(), filter(), match(), find(), count(), empty(), etc.

[0076] Operators can include >, <, ==, @, etc.

[0077] In this embodiment, a first calculation formula may be generated through fields, functions, and operators, and then calculation data information and calculation logic information of the first calculation formula may be determined.

[0078] In some embodiments, editing the calculation data information of the first calculation formula includes:

[0079] Step S201: Obtain a list of data to be selected.

[0080] Step S203, in response to a selection operation on the list of data to be selected, obtaining target data in the list of data to be selected, so as to determine the calculated data information based on the target data;

[0081] The data in the list of data to be selected belongs to the target work item, or the data in the list of data to be selected belongs to the target work item and other designated work items.

[0082] When editing the calculation data information of the first calculation formula, the user can obtain a list of data to be selected. The list of data to be selected can display data belonging to the target work item. The data belonging to the target work item can be information such as fields belonging to the target work item. That is, the list of data to be selected displays fields in the target work item so that when editing the calculation data information of the first calculation formula, the user can select fields in the target work item, thereby obtaining the calculation result associated with the target work item when obtaining the calculation result of the first calculation formula.

[0083] Alternatively, the data list to be selected may also display data belonging to the target work item and other designated work items. In some embodiments, it may be a work item that has a relationship with the target work item. That is, the fields in the target work item and the fields in the work item that has a relationship with the target work item may be displayed simultaneously in the data list to be selected, so that when the user edits the calculation data information of the first calculation formula, he or she can select both the fields of the target work item and the fields in the work item that has a relationship with the target work item, so that when obtaining the calculation result of the first calculation formula, he or she can obtain a calculation result that has an association relationship with both the target work item and the work item that has a relationship with the target work item.

[0084] In some embodiments, editing the calculation result of the first calculation formula includes: editing the type of the calculation result of the first calculation formula; the type of the calculation result of the first calculation formula includes at least one of a number, a date, a Boolean value, an object, a string, an array, rich text, and an icon.

[0085] Among them, when the type of the calculation result of the first calculation formula is a number, you can set integer, percentage, decimal (number of decimal places), etc.; when the type of the calculation result is a date, you can set it to be accurate to year, half a year, bimonthly, month, week, day, hour, minute, second, etc.; when the type of the calculation result is a Boolean value, the field type selection is displayed, which can be set to switch by default and cannot be modified; when the type of the calculation result is an object, you can set personnel, work items or others; when the type of the calculation result is a string, you can set single-line text or multi-line text; when the type of the calculation result is an array, you can set multiple selections of personnel, multiple selections of associated work items or multiple selections of strings; when the type of the calculation result is an icon or rich text, you can set the type of icon or rich text.

[0086] In this embodiment, the type of the calculation result can be set to an icon or rich text, and the icon or rich text can be an emoticon, a logo, etc. For example, for the calculation result of the first calculation formula, when the calculation result is "passed", the calculation result can be displayed as a green icon, and when the calculation result is "different passes", the calculation result can be displayed as a red icon; for the calculation result of the first calculation formula, when the calculation result is "completed", the calculation result can be displayed as a smiling face, and when the calculation result is "unfinished", the calculation result can be displayed as a crying face; for the calculation result of the first calculation formula, different icons can be displayed based on the progress, for example, 100% progress is displayed as ten solid balls "●●●●●●●●●●", 50% progress is displayed as five consecutive solid balls and five consecutive hollow balls "●●●●●○○○○○", and 75% progress is displayed as seven consecutive solid balls, one half-solid and half-hollow ball, and two hollow balls "●●●●●●● ○○”, this embodiment does not limit this.

[0087] In some embodiments, the process of editing the calculation formula of the first calculation formula may further include: displaying preview information of the calculation result of the first calculation formula.

[0088] In this embodiment, during the process of editing the calculation formula of the first calculation formula, preview information of the calculation result of the first calculation formula may also be displayed, thereby helping the user to check whether the editing of the first calculation formula is correct.

[0089] In some embodiments, the project management system provides a field management page for the target work item, in which a new field control for creating a new field can be displayed. When the new field control is triggered, a first window can be displayed in the field management page.

[0090] After the first window is displayed, you can set the field name, field type, calculation formula, calculation result and other information of the first calculation formula through setting operations on the first window.

[0091] In some embodiments, as shown in FIG2A , when a new field control in a field management page for a target work item is triggered, a window 11 may be displayed in the field management page, and the window 11 may display optional field types.

[0092] When the user selects the calculation formula as the field type to be created, a first window 12 is displayed, as shown in FIG2B , and the field name, field type, calculation formula, and other information of the field can be set in the first window 12. Since the calculation formula has been selected as the field type in window 11, the field type is displayed as calculation formula by default in window 12.

[0093] Alternatively, when a new field control is triggered in the field management page for the target work item, the first window 12 can be directly displayed in the field management page, and the field type in the first window 12 is optional. The field type, field name, calculation formula and other information of the field can be directly set in the first window 12.

[0094] As shown in Figure 2B, the first window 12 also displays a configuration control 121 for editing the first calculation formula. When the configuration control 121 is triggered, the second window 13 can be displayed in the field management page. As shown in Figure 2C, the second window 13 includes a formula editing area 131, a list of selected data 132, and a calculation result type setting area 134.

[0095] The corresponding fields are displayed in the list of data to be selected 132. The user can directly select the corresponding fields from the list of data to be selected 132 and display them in the formula editing area 131. Alternatively, the user can directly enter the desired fields in the formula editing area 131. Furthermore, the user can directly enter functions and operators in the formula editing area 131, as well as constants, dates, etc., which are not limited in this embodiment.

[0096] In this embodiment, error checking can be performed based on the function operation mode and supported parameter types, achieving real-time checking and error guidance during the calculation formula editing process. In addition, a prompter is supported after entering the function. When entering array / object data type data, a drop-down box can be automatically opened in the calculation formula for selection. For example, as shown in Figure 2D, when "priority ==" is entered, the "P0, P1, P2, To be determined" options corresponding to "priority" will be automatically opened and displayed in the drop-down box for the user to select. For time type data, a drop-down box can also be displayed to select the time.

[0097] 2C , the type of the calculation result of the first calculation formula can also be set in the calculation result type setting area 134. The type of the calculation result of the calculation formula field includes at least one of a number, a date, a Boolean value, an object, a string, an array, rich text, and an icon.

[0098] As shown in FIG2C , the second window 13 also includes a field information display area 133. When any field in the list of selected data 132 is selected, the field information of the selected field is displayed in the field information display area 133, so that the user can view relevant information of the selected field when editing the calculation formula of the first calculation formula. The field information of the selected field may include information such as the field name, field type, and field description.

[0099] As shown in FIG2C , the second window 13 further includes a calculation result preview area 135 , in which preview information of the calculation result of the first calculation formula can be displayed, thereby helping the user to check whether the editing of the first calculation formula is correct.

[0100] After the calculation formula is edited, the confirmation operation of the formula editing is realized by triggering the confirmation control in the second window 13, and the first calculation formula can be generated based on the fields, functions and operators in the formula editing area.

[0101] In some embodiments, after the first calculation formula is created, the first calculation formula may be modified, including:

[0102] Step S301: in response to receiving a modification operation on the first calculation formula, modify the first calculation formula.

[0103] Step S303: In response to the type of the calculation result of the modified first calculation formula being the same as the type of the calculation result of the first calculation formula before modification, a confirmation control is displayed and the modified first calculation formula is generated based on a confirmation operation on the confirmation control.

[0104] Step S305, in response to the fact that the type of the calculation result of the modified first calculation formula is different from the type of the calculation result of the first calculation formula before modification, the confirmation control is set to an untriggerable state and a first prompt message is displayed, wherein the first prompt message is used to indicate that the type of the calculation result of the first calculation formula is not allowed to be modified.

[0105] In this embodiment, the successfully created first calculation formula can be modified. As shown in Figure 2E, the successfully created first calculation formula will be displayed as a field on the field management page. When the first calculation formula is triggered, the field information of the first calculation formula, such as the field name, field type, and calculation formula, can be displayed on the field management page, and a modification formula control for modifying the calculation formula can be displayed. When the user triggers the modification formula control, the modification page of the first calculation formula can be displayed, and the formula of the first calculation formula can be modified.

[0106] When the type of the calculation result of the modified first calculation formula is the same as the type of the calculation result of the first calculation formula before the modification, a confirmation control is displayed in the modification window of the first calculation formula, and the modification of the first calculation formula is completed after the confirmation control is triggered; when the type of the calculation result of the modified first calculation formula is different from the type of the calculation result of the first calculation formula before the modification, the modification is not allowed. At this time, the confirmation control is set to an untriggerable state and a first prompt message is displayed. The first prompt message is used to indicate that the type of the calculation result of the first calculation formula is not allowed to be modified.

[0107] In some embodiments, the method further includes: in response to at least a portion of the calculation data information of the first calculation formula being deleted in the project management system, deleting the at least a portion of the calculation data information in the first calculation formula and displaying placeholder information in the location of the at least a portion of the calculation data information. In this embodiment, when the data deleted in the project management system is the calculation data information of the first calculation formula, the corresponding data is also deleted in the first calculation formula, and a placeholder information is displayed in the location of the deleted data in the first calculation formula, so that the user can be informed of the existence of the deleted data in the first calculation formula.

[0108] In some embodiments, the method further includes: in response to at least part of the calculation data information of the first calculation formula being deleted in the project management system, canceling the display of the calculation result corresponding to the first calculation formula in the target business scenario, or, the calculation result corresponding to the first calculation formula does not affect the business of the target business scenario.

[0109] In this embodiment, if at least part of the calculation data information of the first calculation formula is deleted in the project management system, the deleted data will no longer be included in the first calculation formula, and the calculation result of the first calculation formula will no longer be obtained. If the first calculation formula has already been added to a target business scenario in the project management system, the calculation result corresponding to the first calculation formula will be canceled from the target business scenario, or the business of the target business scenario will no longer be affected by the calculation result corresponding to the first calculation formula.

[0110] In some embodiments, when the first calculation formula includes a field and the field is deleted in the project management system, for example, deleted in the field management page of the target work item, and / or deleted in the field management page of a work item that has a relationship with the target work item, the deleted field is replaced with preset placeholder information in the first calculation formula, and a prompt message is displayed to indicate that the field has been deleted.

[0111] When the field in the first calculation formula is deleted in the field management page, the calculation result corresponding to the first calculation formula in the target business scenario is cancelled, that is, the calculation result of the first calculation formula cannot be displayed in the details page or view of the target work item.

[0112] When a field in the first calculation formula is deleted in the field management page, the calculation result corresponding to the first calculation formula does not affect the business of the target business scenario, that is, the process cannot be blocked or advanced based on the calculation result of the first calculation formula.

[0113] In some embodiments, as shown in Figure 2C, a formula usage instructions control 136 is also displayed in the second window 13. When the formula usage instructions control 136 is triggered, it can jump to the corresponding formula usage instructions page or document, so that the user can view the instructions for use of the calculation formula, helping the user to quickly understand the use of the calculation formula.

[0114] In some embodiments, as shown in FIG2B , an advanced configuration control may also be displayed in the first window 12 for configuring whether the user is allowed to edit the first calculation formula. When the setting does not allow the user to edit, if the user wants to edit, a corresponding prompt message will be displayed to remind the user that the calculation formula cannot be edited.

[0115] In some embodiments, the target business scenario includes a flowchart of a target work item; the operation of adding the first calculation formula to the target business scenario in the project management system includes: adding the first calculation formula to the target node of the flowchart corresponding to the target work item; the business of affecting the target business scenario based on the calculation result corresponding to the first calculation formula includes: determining the calculation result of the first calculation formula as the exit condition of the target node, so as to block or advance the process corresponding to the flowchart based on the calculation result of the first calculation formula field.

[0116] When the target business scenario is a flowchart of a target work item, an edited first calculation formula can be added to the target node of the flowchart corresponding to the target work item, and the calculation result of the first calculation formula can be used as the exit condition of the target node. During the advancement of the process, the calculation data related to the target work item is changing dynamically, and the calculation result of the corresponding first calculation formula will also change dynamically. When the calculation result of the first calculation formula meets the exit condition of the target node, the process can be advanced. When the calculation result of the first calculation formula does not meet the exit condition of the target node, the process can be blocked, so that the process changes of the target work item can be affected according to the changes in the calculation data in the project management system.

[0117] In some embodiments, when performing conditional judgment, the first calculation formula may be added to the conditional judgment of the default value condition / required condition, and the conditional judgment may be performed based on the calculation result of the first calculation formula.

[0118] In some embodiments, the target business scenario includes a details page of a target work item; the operation of adding the first calculation formula to the target business scenario in the project management system includes: adding the first calculation formula to the details page of the target work item; displaying the calculation result corresponding to the first calculation formula in the target business scenario includes: displaying the calculation result of the first calculation formula in the details page.

[0119] When the target business scenario includes a details page for a target work item, an edited first calculation formula can be added to the details page of the target work item. When the calculation data changes dynamically, the calculation result of the corresponding first calculation formula will also change dynamically, and the calculation result corresponding to the first calculation formula displayed in the details page will also change accordingly, so that users can obtain a dynamically changing result display.

[0120] In this embodiment, as shown in FIG2F , the first calculation formula and its result can be displayed in a designated location on the detail page management page by dragging and dropping the first calculation formula, thereby achieving a layout arrangement of the first calculation formula and other fields. Once the setting is completed, the result of the first calculation formula can be displayed on the corresponding detail page.

[0121] In some embodiments, the target business scenario includes a process form for a target work item. When the target business scenario includes a process form for a target work item, a first calculation formula may be added to the process form for the target work item. When the calculation data changes dynamically, the calculation result of the corresponding first calculation formula will also change dynamically, and the calculation result corresponding to the first calculation formula displayed in the process form will also change accordingly, thereby allowing the user to obtain a dynamically changing result display.

[0122] In some embodiments, the target business scenario includes a view of a target work item; the operation of adding the first calculation formula to the target business scenario in the project management system includes: adding the first calculation formula to the target view of the target work item; and displaying the calculation result corresponding to the first calculation formula in the target business scenario includes: displaying the calculation result of the first calculation formula in the target view.

[0123] When the target business scenario includes a view of the target work item, a first calculation formula can be added to the target view of the target work item. When the calculation data changes dynamically, the calculation result of the corresponding first calculation formula will also change dynamically, and the calculation result corresponding to the first calculation formula displayed in the target view will also change accordingly, so that users can obtain a dynamically changing result display.

[0124] In this embodiment, the target work item may include multiple views of different types. A different first calculation formula may be added for each view, or the same first calculation formula may be added for all views. This embodiment does not impose any restrictions on this.

[0125] In this embodiment, as shown in FIG2G , the first calculation formula and its result can be displayed in a specified location in the target view by dragging the first calculation formula in the target view and setting the freeze state to achieve the display of the first calculation formula and its result in the target view. The result of the first calculation formula can be used as a condition for filtering, grouping, and sorting.

[0126] In some embodiments, the target business scenario includes a metric chart for the target work item; and the operation of adding the first calculation formula to the target business scenario in the project management system includes: adding the first calculation formula to the metric chart for the target work item. Displaying a calculation result corresponding to the first calculation formula in the target business scenario includes: using the calculation result of the first calculation formula as at least part of the display data for the metric chart for the target work item, or using the calculation result of the first calculation formula as calculation data information for a second calculation formula in the metric chart for the target work item, so as to obtain the calculation result of the second calculation formula in the metric chart for the target work item based on the calculation result of the first calculation formula.

[0127] When the target business scenario includes a metric chart for a target work item, a first calculation formula may be added to the target metric chart for the target work item, and the calculation result of the first calculation formula may be used as the display data for the target metric chart. Alternatively, when the target metric chart includes a second calculation formula, the calculation result of the first calculation formula may be used as the calculation data information for the second calculation formula of the target metric chart, so that when performing operations based on the second calculation formula, the calculation result of the second calculation formula obtained may be associated with the calculation result corresponding to the first calculation formula. In some embodiments, the target business scenario includes a task deliverable. The first calculation formula may be configured in the task deliverable, and the calculation result of the first calculation formula may be displayed in the task deliverable.

[0128] In some embodiments, when the target business scenario is the details page or view of the target work item, the first calculation formula can be used to calculate the sum of two numerical fields to obtain a new data field displayed in the details page and / or target view. For example, the first calculation formula "{cost one}+{cost two}" is obtained through the fields "cost one" and "cost two" and the operator "+", and the calculation result is "total cost". The calculation result type is a numeric type, and the calculation result is displayed in the details page and / or target view. When the values ​​of "cost one" and / or "cost two" in the calculation data change, the value of the calculation result "total cost" also changes accordingly.

[0129] In some embodiments, when the target business scenario is a view of a target work item, a first calculation formula can be used to calculate the defects associated with a requirement and display them in the target view, allowing users to easily find the requirement with the largest number of associated defects for high-priority remediation. In this case, the count() function can be used to count the defects associated with each requirement in the associated work item. The result of the first calculation formula is the number of associated defects, which is then displayed in the target view.

[0130] In some embodiments, when the target business scenario is a view of a target work item, the first calculation formula can be used to calculate the priority of the associated defects under all requirements and display them in the target view, allowing users to easily find the requirements with the largest number of associated defects with a defect priority of P0 for high-priority repair. In this embodiment, the function filter() can be used to find associated defects with a priority of P0, and then count() can be used to calculate, and then the defect data can be obtained as the calculation result, and then the defect data can be displayed in the target view list.

[0131] In some embodiments, when the target business scenario is a view of a target work item, the first calculation formula can be used to calculate the priorities of associated defects under uncompleted requirements and display them in the target view. This allows users to easily find the requirements with the largest number of associated defects and defect priorities of P0 for high-priority repairs. In this embodiment, the filter() function is used to find associated defects with a priority of P0: the empty() function is used to calculate the uncompleted requirements by calculating the "Completion Time" field to be empty, and the countif() function is used to calculate the number of associated requirements. The number of associated requirements is then displayed in the target view list.

[0132] In some embodiments, when the target business scenario is a view of a target work item, the required R&D manpower size can be calculated using the first calculation formula and displayed in the target view, thereby enabling sorting by required R&D manpower size. In this embodiment, the match() function is used to match development-related nodes, the filter() function is used to calculate the estimated score of the development node, and finally the sum() function is used to sum the results, resulting in the display of the target view list.

[0133] In some embodiments, when the target business scenario is the details page or view of a target work item, the first calculation formula can be used to obtain the node time and display it in the target view. For example, the start time of a node in the process can be obtained, such as the development start time, and displayed in the target view. In this embodiment, the start time of the target node can be calculated by using the end time of the node before the target node as the start time of the target node, or the earliest start time of each target node as the start time, and displayed in the details page or target view.

[0134] In some embodiments, when the target business scenario is a view of a target work item, a first calculation formula can be used to calculate the number of deferred nodes under a requirement. These nodes are then sorted in a table from highest to lowest and displayed in the target view to determine the requirement's deferred status. In this embodiment, the node's status is first determined to be completed; then, the node's actual end time is determined to be greater than the node's scheduled end time, taking into account the possibility that the node is not scheduled. The calculated deferred nodes are then displayed in the target view list.

[0135] Alternatively, the first calculation formula can be used to determine whether a node has been postponed. If the node has been postponed, the calculation result of the first calculation formula is "postponed", and the postponement status of the node is displayed as "postponed" in the details page or target view.

[0136] Alternatively, the first calculation formula may be used to output all postponed nodes in a table for easy viewing. In this embodiment, when it is determined that a certain node has been postponed, the node name of the node is displayed in the table as the calculation result.

[0137] In some embodiments, when the target business scenario is the details page or view of the target work item, the first calculation formula can be used to calculate the number of entries into a certain node and display it in the target view. In this embodiment, the node is first filtered for the embedded point design through the find() function: find({process node},each.{name}=="embedded point design"), and then the number of entries is obtained through the find() function: find({process node},each.{name}=="embedded point design").{node entry number}, and the obtained number of entries is displayed as the calculation result on the details page or target view list.

[0138] In some embodiments, field splicing can be achieved through a first calculation formula, and the data of multiple fields can be spliced ​​and displayed in the details page or target view through the join() function, for example, join([{priority},{name}],"-").

[0139] In some embodiments, when the target business scenario is a flowchart, the calculation result of the first calculation formula can be used to limit the flow of nodes. For example, the number of P0 bugs of OPEN or REOPEN in the requirement can be set to 0, and the node can be circulated through. The calculation formula is: if(count(filter({target work item_requirement},each.{priority}==P0&&(each.{current status}=="OPEN"||each.{current status}=="REOPEN")))==0,true,false).

[0140] In this embodiment, in the calculation result type setting area, set the type of calculation result to signal field; in the process, set the target node to automatic confirmation node; then click the node flow option to find the completion form configuration; in the pop-up interface, drag the field from the left to the form and set it to required; directly upgrade or create the requirement on the requirement details page to complete the configuration.

[0141] In some embodiments, the method also includes: in response to meeting a preset condition, recalculating the first calculation formula to obtain an updated calculation result; and displaying the updated calculation result corresponding to the first calculation formula in the target business scenario, or, affecting the business of the target business scenario based on the updated calculation result corresponding to the first calculation formula.

[0142] In this embodiment, when the preset conditions are met, the first calculation formula can be recalculated to obtain an updated calculation result, and the updated calculation result of the first calculation formula can be used in the target business scenario, or the updated calculation result of the first calculation formula can be used to affect the business of the target business scenario.

[0143] Among them, the preset conditions can be: the first calculation formula is modified, the calculation data corresponding to the calculation data information is changed, the flowchart of the target work item is modified, the details page or view of the target work item is entered, the page where the details page or view of the target work item is located is refreshed, etc. This embodiment does not impose any restrictions on this.

[0144] It should be noted that the method of the embodiments of the present disclosure can be performed by a single device, such as a computer or server. The method of the embodiments of the present disclosure can also be applied in a distributed scenario, where multiple devices cooperate to perform the method. In such a distributed scenario, one of the multiple devices may only perform one or more steps of the method of the embodiments of the present disclosure, and the multiple devices will interact with each other to complete the method.

[0145] It should be noted that the above description is limited to some embodiments of the present disclosure. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recited in the claims may be performed in an order different from that described in the above embodiments and still achieve the desired results. Furthermore, the processes depicted in the accompanying drawings do not necessarily require the specific order or sequential order shown to achieve the desired results. In certain embodiments, multitasking and parallel processing are also possible or may be advantageous.

[0146] Based on the same inventive concept, corresponding to any of the above-mentioned embodiments and methods, the present disclosure further provides a data processing device.

[0147] Referring to FIG3 , the apparatus includes:

[0148] an acquisition module 11 configured to: in response to a setting operation on a first calculation formula of a target work item, acquire calculation data information and calculation logic information of the first calculation formula, wherein the first calculation formula is associated with the target work item;

[0149] The calculation module 13 is configured to: obtain corresponding calculation data based on the calculation data information, and perform calculations on the obtained calculation data based on the calculation logic information to obtain a calculation result;

[0150] The adding module 15 is configured to: in response to the operation of adding the first calculation formula to the target business scenario in the project management system, display the calculation result corresponding to the first calculation formula in the target business scenario, or, based on the calculation result corresponding to the first calculation formula, affect the business of the target business scenario.

[0151] In some embodiments, the first calculation formula is attributed to the target work item;

[0152] and / or,

[0153] The calculation data corresponding to the calculation data information includes at least the data of the target work item.

[0154] In some embodiments, the calculation data corresponding to the calculation data information includes data of the target work item and data of other work items except the target work item.

[0155] In some embodiments, the other work items include: work items that have a relationship with the target work item.

[0156] In some embodiments, the acquisition module 11 is further configured to: in response to an editing operation on the first calculation formula, edit at least one of the field name, field type, calculation formula, and calculation result of the first calculation formula.

[0157] In some embodiments, the apparatus is further configured to: edit calculation data information and calculation logic information of the first calculation formula;

[0158] The device is further configured to: obtain a list of data to be selected;

[0159] In response to a selection operation on the list of data to be selected, obtaining target data in the list of data to be selected, so as to determine the calculated data information based on the target data;

[0160] The data in the list of data to be selected belongs to the target work item, or the data in the list of data to be selected belongs to the target work item and other designated work items.

[0161] In some embodiments, the device is further configured to: edit the type of the calculation result of the first calculation formula; the type of the calculation result of the first calculation formula includes at least one of a number, a date, a Boolean value, an object, a string, an array, rich text, and an icon.

[0162] In some embodiments, the device is further configured to: display preview information of the calculation result of the first calculation formula.

[0163] In some embodiments, the apparatus is further configured to: in response to receiving a modification operation on the first calculation formula, modify the first calculation formula;

[0164] In response to the type of the calculation result of the modified first calculation formula being the same as the type of the calculation result of the first calculation formula before the modification, displaying a confirmation control and generating the modified first calculation formula based on a confirmation operation on the confirmation control;

[0165] In response to the fact that the type of the calculation result of the modified first calculation formula is different from the type of the calculation result of the first calculation formula before the modification, the confirmation control is set to an untriggerable state and a first prompt message is displayed, wherein the first prompt message is used to indicate that the type of the calculation result of the first calculation formula is not allowed to be modified.

[0166] In some embodiments, the device is further configured to: in response to at least part of the calculation data information of the first calculation formula being deleted in the project management system, delete the at least part of the calculation data information in the first calculation formula and display placeholder information in the location of the at least part of the calculation data information.

[0167] In some embodiments, the device is further configured to: in response to at least part of the calculation data information of the first calculation formula being deleted in the project management system, cancel the display of the calculation result corresponding to the first calculation formula in the target business scenario, or the calculation result corresponding to the first calculation formula does not affect the business of the target business scenario.

[0168] In some embodiments, the target business scenario includes a flowchart of the target work item;

[0169] The adding module 15 is configured to: add the first calculation formula in the target node in the process corresponding to the target work item; and determine the calculation result of the first calculation formula as the exit condition of the target node, so as to block or advance the process corresponding to the flowchart based on the calculation result of the first calculation formula field.

[0170] In some embodiments, the target business scenario includes a details page of the target work item;

[0171] The adding module 15 is configured to: include: adding the first calculation formula to the details page of the target work item; and displaying the calculation result of the first calculation formula on the details page.

[0172] In some embodiments, the target business scenario includes a view of the target work item;

[0173] The adding module 15 is configured to: add the first calculation formula to the target view of the target work item; and display the calculation result of the first calculation formula in the target view.

[0174] In some embodiments, the target business scenario includes a metrics chart for the target work item;

[0175] The adding module 15 is configured to: add the first calculation formula to the metric chart of the target work item; and use the calculation result of the first calculation formula as at least part of the display data of the metric chart of the target work item, or use the calculation result of the first calculation formula as the calculation data information of the second calculation formula of the metric chart of the target work item, so as to obtain the calculation result of the second calculation formula of the metric chart of the target work item based on the calculation result of the first calculation formula.

[0176] In some embodiments, the apparatus is further configured to: in response to a preset condition being met, recalculate the first calculation formula to obtain an updated calculation result; and

[0177] The updated calculation result corresponding to the first calculation formula is displayed in the target business scenario, or the business of the target business scenario is affected based on the updated calculation result corresponding to the first calculation formula.

[0178] For the convenience of description, the above devices are described as being functionally divided into various modules. Of course, when implementing the present disclosure, the functions of each module can be implemented in the same or multiple software and / or hardware.

[0179] The apparatus of the above embodiment is used to implement the corresponding method in any of the above embodiments, and has the beneficial effects of the corresponding method embodiment, which will not be described in detail here.

[0180] Based on the same inventive concept, corresponding to any of the above-mentioned embodiments and methods, the present disclosure also provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the method described in any of the above embodiments when executing the program.

[0181] FIG4 shows a more specific schematic diagram of the hardware structure of an electronic device provided in this embodiment. The device may include: a processor 1010, a memory 1020, an input / output interface 1030, a communication interface 1040, and a bus 1050. The processor 1010, the memory 1020, the input / output interface 1030, and the communication interface 1040 are communicatively connected to each other within the device via the bus 1050.

[0182] The processor 1010 can be implemented using a general-purpose CPU (Central Processing Unit), a microprocessor, an application-specific integrated circuit (ASIC), or one or more integrated circuits, and is used to execute relevant programs to implement the technical solutions provided in the embodiments of this specification.

[0183] The memory 1020 can be implemented in the form of ROM (Read Only Memory), RAM (Random Access Memory), static storage devices, dynamic storage devices, etc. The memory 1020 can store an operating system and other application programs. When the technical solutions provided in the embodiments of this specification are implemented through software or firmware, the relevant program code is stored in the memory 1020 and is called and executed by the processor 1010.

[0184] The input / output interface 1030 is used to connect input / output modules to implement information input and output. The input / output modules can be configured as components within the device (not shown in the figure) or can be externally connected to the device to provide corresponding functions. Input devices may include a keyboard, mouse, touch screen, microphone, various sensors, etc., and output devices may include a display, speaker, vibrator, indicator light, etc.

[0185] The communication interface 1040 is used to connect to a communication module (not shown) to enable communication between the device and other devices. The communication module can communicate via a wired method (such as USB, network cable, etc.) or a wireless method (such as mobile network, WiFi, Bluetooth, etc.).

[0186] The bus 1050 comprises a path for transmitting information between the various components of the device (eg, the processor 1010 , the memory 1020 , the input / output interface 1030 , and the communication interface 1040 ).

[0187] It should be noted that although the above device only shows the processor 1010, the memory 1020, the input / output interface 1030, the communication interface 1040, and the bus 1050, in a specific implementation, the device may also include other components necessary for normal operation. In addition, it will be understood by those skilled in the art that the above device may only include the components necessary to implement the embodiments of this specification, and does not necessarily include all the components shown in the figure.

[0188] The electronic device of the above embodiment is used to implement the corresponding method in any of the above embodiments, and has the beneficial effects of the corresponding method embodiment, which will not be described in detail here.

[0189] Based on the same inventive concept, corresponding to any of the above-mentioned embodiments and methods, the present disclosure also provides a non-transitory computer-readable storage medium, wherein the non-transitory computer-readable storage medium stores computer instructions, and the computer instructions are used to enable the computer to execute the method described in any of the above embodiments.

[0190] The computer-readable media of this embodiment include permanent and non-permanent, removable and non-removable media that can be used to store information by any method or technology. The information can be computer-readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, read-only compact disc read-only memory (CD-ROM), digital versatile disc (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device.

[0191] The computer instructions stored in the storage medium of the above embodiment are used to enable the computer to execute the method described in any of the above embodiments, and have the beneficial effects of the corresponding method embodiments, which will not be repeated here.

[0192] Those skilled in the art should understand that the discussion of any of the above embodiments is merely illustrative and is not intended to imply that the scope of the present disclosure (including the claims) is limited to these examples. Within the scope of the present disclosure, the technical features in the above embodiments or different embodiments may be combined, the steps may be implemented in any order, and there are many other variations of the different aspects of the embodiments of the present disclosure as described above, which are not provided in detail for the sake of simplicity.

[0193] In addition, to simplify the description and discussion, and so as not to obscure the embodiments of the present disclosure, known power / ground connections to integrated circuit (IC) chips and other components may or may not be shown in the provided figures. In addition, devices may be shown in the form of block diagrams to avoid obscuring the embodiments of the present disclosure, and this also takes into account the fact that the details of the implementation of these block diagram devices are highly dependent on the platform on which the embodiments of the present disclosure are to be implemented (i.e., these details should be fully within the purview of those skilled in the art). Where specific details (e.g., circuits) are set forth to describe exemplary embodiments of the present disclosure, it will be apparent to those skilled in the art that the embodiments of the present disclosure may be implemented without these specific details or with variations in these specific details. Therefore, these descriptions should be considered illustrative rather than restrictive.

[0194] Although the present disclosure has been described in conjunction with specific embodiments thereof, many alternatives, modifications, and variations of these embodiments will be apparent to those skilled in the art based on the foregoing description. For example, other memory architectures (e.g., dynamic RAM (DRAM)) may use the embodiments discussed.

[0195] The embodiments of the present disclosure are intended to cover all such substitutions, modifications, and variations that fall within the broad scope of the appended claims. Therefore, any omissions, modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the embodiments of the present disclosure should be included in the scope of protection of the present disclosure.

Claims

1. A data processing method, the method is applied to a project management system, include: In response to a setting operation on a first calculation formula of a target work item, obtaining calculation data information and calculation logic information of the first calculation formula, wherein the first calculation formula is associated with the target work item; Based on the calculation data information, corresponding calculation data is acquired, and based on the calculation logic information, the acquired calculation data is operated to obtain a calculation result; In response to the operation of adding the first calculation formula to the target business scenario in the project management system, the calculation result corresponding to the first calculation formula is displayed in the target business scenario, or the business of the target business scenario is affected based on the calculation result corresponding to the first calculation formula.

2. The method according to claim 1, in, The first calculation formula belongs to the target work item; and / or, The calculation data corresponding to the calculation data information at least includes the data of the target work item.

3. The method according to claim 1, in, The calculation data corresponding to the calculation data information includes data of the target work item and data of other work items except the target work item.

4. The method according to claim 3, in, The other work items include: work items that have a relationship with the target work item.

5. The method according to claim 1, in, The setting operation of the first calculation formula of the target work item includes: In response to an edit operation on the first calculation formula, at least one of a field name, a field type, a calculation formula, and a calculation result of the first calculation formula is edited.

6. The method according to claim 5, in, Editing the calculation formula of the first calculation formula includes: editing calculation data information and calculation logic information of the first calculation formula; The editing of the calculation data information of the first calculation formula includes: Get the list of data to be selected; In response to a selection operation on the list of data to be selected, obtaining target data in the list of data to be selected, so as to determine the calculation data information based on the target data; The data in the list of data to be selected belongs to the target work item, or the data in the list of data to be selected belongs to the target work item and other designated work items.

7. The method according to claim 5, in, Editing the calculation result of the first calculation formula includes: Edit the type of the calculation result of the first calculation formula; The type of the calculation result of the first calculation formula includes at least one of a number, a date, a Boolean value, an object, a string, an array, rich text, and an icon.

8. The method according to claim 5, further comprising: include: The preview information of the calculation result of the first calculation formula is displayed.

9. The method according to claim 7, in, Also includes: In response to receiving a modification operation on the first calculation formula, modifying the first calculation formula; In response to the type of the calculation result of the modified first calculation formula being the same as the type of the calculation result of the first calculation formula before the modification, displaying a confirmation control and generating the modified first calculation formula based on a confirmation operation on the confirmation control; In response to the fact that the type of the calculation result of the modified first calculation formula is different from the type of the calculation result of the first calculation formula before the modification, the confirmation control is set to an untriggerable state and a first prompt message is displayed, wherein the first prompt message is used to indicate that the type of the calculation result of the first calculation formula is not allowed to be modified.

10. The method according to claim 1, further comprising: include: In response to at least part of the calculation data information of the first calculation formula being deleted in the project management system, at least part of the calculation data information is deleted in the first calculation formula and placeholder information is displayed at the location of at least part of the calculation data information.

11. The method according to claim 1, further comprising: include: In response to at least part of the calculation data information of the first calculation formula being deleted in the project management system, the calculation result corresponding to the first calculation formula in the target business scenario is canceled, or the calculation result corresponding to the first calculation formula does not affect the business of the target business scenario.

12. The method according to claim 1, in, The target business scenario includes a flowchart of the target work item; The operation of adding the first calculation formula to the target business scenario in the project management system includes: adding the first calculation formula to the target node of the flowchart corresponding to the target work item; The business of the target business scenario is affected by the calculation result corresponding to the first calculation formula, including: determining the calculation result of the first calculation formula as the exit condition of the target node, so as to block or advance the process corresponding to the flowchart based on the calculation result of the first calculation formula field.

13. The method according to claim 1, in, The target business scenario includes a details page of the target work item; The operation of adding the first calculation formula to the target business scenario in the project management system includes: adding the first calculation formula to the details page of the target work item; The displaying the calculation result corresponding to the first calculation formula in the target business scenario includes: displaying the calculation result of the first calculation formula in the details page.

14. The method according to claim 1, in, The target business scenario includes a view of the target work item; The operation of adding the first calculation formula to the target business scenario in the project management system includes: adding the first calculation formula to the target view of the target work item; The displaying the calculation result corresponding to the first calculation formula in the target business scenario includes: displaying the calculation result of the first calculation formula in the target view.

15. The method according to claim 1, in, The target business scenario includes a metric chart of the target work item; The operation of adding the first calculation formula to the target business scenario in the project management system includes: adding the first calculation formula to the metric chart of the target work item; The displaying of the calculation result corresponding to the first calculation formula in the target business scenario includes: using the calculation result of the first calculation formula as at least part of the display data of the metric chart of the target work item, or using the calculation result of the first calculation formula as the calculation data information of the second calculation formula of the metric chart of the target work item, so as to obtain the calculation result of the second calculation formula of the metric chart of the target work item based on the calculation result of the first calculation formula.

16. The method according to any one of claims 1 to 15, in, The method further includes: in response to satisfying a preset condition, recalculating the first calculation formula to obtain an updated calculation result; and An updated calculation result corresponding to the first calculation formula is displayed in the target business scenario, or a business of the target business scenario is affected based on the updated calculation result corresponding to the first calculation formula.

17. A data processing device, include: an acquisition module, configured to: in response to a setting operation on a first calculation formula of a target work item, acquire calculation data information and calculation logic information of the first calculation formula, wherein the first calculation formula is associated with the target work item; A calculation module is configured to: obtain corresponding calculation data based on the calculation data information, and calculate the obtained calculation data based on the calculation logic information to obtain a calculation result; The adding module is configured to: in response to the operation of adding the first calculation formula to the target business scenario in the project management system, display the calculation result corresponding to the first calculation formula in the target business scenario, or affect the business of the target business scenario based on the calculation result corresponding to the first calculation formula.

18. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the method according to any one of claims 1 to 16 when executing the program.

19. A non-transitory computer-readable storage medium storing computer instructions, wherein the computer instructions are used to cause the computer to execute the method of any one of claims 1 to 16.

Citation Information

Patent Citations

  • Configurable data calculation method, device and equipment and computer readable medium

    CN113569184A

  • Data updating method and device and computer readable storage medium

    CN113986323A

  • Cost calculation management method and device, electronic equipment, storage medium and product

    CN115660880A

  • Data processing method and device, electronic equipment and storage medium

    CN116579740A

  • Method and system for handling program, project and asset scheduling management

    US8738414B1