Data Processing Method, Apparatus, Electronic Device, and Storage Medium

Abstract

The present disclosure provides a data processing method, apparatus, electronic device, and storage medium. The method is applied to a project management system and includes: in response to a setting operation of a first calculation formula for a target work item, obtaining calculation data information and calculation logic information of the first calculation formula, where the first calculation formula is associated with the target work item; based on the calculation data information, obtaining corresponding calculation data, and performing an operation on the obtained calculation data based on the calculation logic information to obtain a calculation result; in response to an operation of adding the first calculation formula to a 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.

Description

Technical Field

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

[0002] Managing work tasks with a project management system is a common work management mode at present and is widely used in various industries. In a project management system, a user can manage based on work items. When managing work items, the user needs to obtain more information. Summary of the Invention

[0003] In view of this, an object of the present disclosure is to provide a data processing method, apparatus, electronic device, and storage medium.

[0004] Based on the above object, a first aspect of the present disclosure provides a data processing method, which is applied to a project management system and includes:

[0005] Responding to a setting operation of a first calculation formula for a target work item, obtaining calculation data information and calculation logic information of the first calculation formula, where the first calculation formula is associated with the target work item;

[0006] Based on the calculation data information, obtaining corresponding calculation data, and performing an operation on the obtained calculation data based on the calculation logic information to obtain a calculation result;

[0007] Responding to an operation of adding the first calculation formula to a target business scenario in the project management system, displaying a calculation result corresponding to the first calculation formula in the target business scenario, or affecting a business of the target business scenario based on the calculation result corresponding to the first calculation formula.

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

[0009] An obtaining module, configured to: respond to a setting operation of a first calculation formula for a target work item, and obtain calculation data information and calculation logic information of the first calculation formula, where the first calculation formula is associated with the target work item;

[0010] An operation module, configured to: based on the calculation data information, obtain corresponding calculation data, and perform an operation on the obtained calculation data based on the calculation logic information to obtain a calculation result;

[0011] An adding module is configured to: in response to an operation of adding the first calculation formula to a target business scenario in the project management system, display a 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.

[0012] A third aspect of the present disclosure provides an electronic device, including a memory, a processor, and a computer program stored on the memory and executable on the processor. When the processor executes the program, the method described in the first aspect is implemented.

[0013] A fourth aspect of the present disclosure provides a non-transitory computer-readable storage medium storing computer instructions for causing a computer to execute the method described in the first aspect.

[0014] As can be seen from the above, the data processing method, apparatus, electronic device, and storage medium provided by the present disclosure set a first calculation formula associated with a target work item in the project management system for the target work item in the project management system, and use the first calculation formula to perform operations on calculation data, so as 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 associated information of the target work item in more dimensions and at more levels in the target business scenario based on the calculation result, or use the calculation result to promote or block the process of the target work item in the target business scenario to meet more needs of users and improve the user experience. Description of the Drawings

[0015] In order to more clearly illustrate the technical solutions in the present disclosure or related technologies, the following will briefly introduce the drawings required for use in the embodiments or related technology descriptions. Obviously, the drawings in the following description are only embodiments of the present disclosure. For those of ordinary skill in the art, other drawings can be obtained based on these drawings without creative efforts.

[0016] Figure 1 The flowchart of an exemplary method provided by an embodiment of the present disclosure is shown.

[0017] Figure 2A The schematic diagram of an exemplary page according to an embodiment of the present disclosure is shown.

[0018] Figure 2B The schematic diagram of an exemplary page according to an embodiment of the present disclosure is shown.

[0019] Figure 2CShows a schematic diagram of an exemplary page according to an embodiment of the present disclosure.

[0020] Figure 2D Shows a schematic diagram of an exemplary page according to an embodiment of the present disclosure.

[0021] Figure 2E Shows a schematic diagram of an exemplary page according to an embodiment of the present disclosure.

[0022] Figure 2F Shows a schematic diagram of an exemplary page according to an embodiment of the present disclosure.

[0023] Figure 2G Shows a schematic diagram of an exemplary page according to an embodiment of the present disclosure.

[0024] Figure 3 Shows a schematic diagram of an exemplary device provided by an embodiment of the present disclosure.

[0025] Figure 4 Shows a schematic diagram of the hardware structure of an exemplary computer device provided by an embodiment of the present disclosure. Detailed implementation manners

[0026] To make the objectives, technical solutions and advantages of the present disclosure more clear and understandable, the present disclosure will be further described in detail below with reference to specific embodiments and the accompanying drawings.

[0027] It should be noted that, unless otherwise defined, the technical terms or scientific terms used in the embodiments of the present disclosure should be of the ordinary meanings understood by those of ordinary skill in the field to which the present disclosure belongs. The "first", "second" and similar terms used in the embodiments of the present disclosure do not denote any order, quantity or importance, but are only used to distinguish different components. The terms such as "include" or "comprise" mean that the elements or items appearing before this word cover the elements or items listed after this word and their equivalents, without excluding other elements or items. The terms such as "connect" or "couple" are not limited to physical or mechanical connections, but may include electrical connections, whether direct or indirect. The terms such as "upper", "lower", "left" and "right" are only used to represent relative positional relationships, and when the absolute position of the object being described changes, the relative positional relationship may also change accordingly.

[0028] It should be understood that the "several" mentioned herein refers to one or more, and "multiple" refers to two or more. "And / or" describes the association relationship of associated objects and indicates that there can be three relationships. For example, A and / or B can represent: A exists alone, A and B exist simultaneously, and B exists alone. The character " / " generally represents an "or" relationship between the associated objects before and after.

[0029] First, a brief introduction to the nouns in the project management system involved in the embodiments of the present application is given:

[0030] A project is a temporary endeavor to complete a unique product or service. "Temporary" means that the plan has a definite start date and end date, and "unique" means that the final result of the project is not repeated.

[0031] A work item refers to a collaborative work matter of a team, and can also be a collection of matters disassembled from a project. It can include requirements, defects, versions, etc.

[0032] Requirements refer to the software functions required by users to solve a certain problem / achieve a certain goal, which helps team members track specific detailed problems.

[0033] A node is a phase segmentation point of requirements, which is composed of standard task matters of requirements.

[0034] A defect refers to non - compliance with the initially defined business requirements.

[0035] A form is a page that carries fields.

[0036] A process is the basic steps of the life cycle of a matter, which is composed of process nodes and execution methods in an orderly manner.

[0037] A node flow disassembles a work item into specific executable tasks and concatenates them into a directed process.

[0038] A status flow concatenates the phases of a work item to form transformation rules.

[0039] Views include tables, kanbans, Gantt charts, personnel schedules, views, workbenches, etc.

[0040] Metrics is a continuous quantitative process of data definition, collection, and analysis for software development projects, processes, and their products, such as requirement throughput, quality, cycle, and human effort estimation, etc.

[0041] Metric charts include bar charts, line charts, area charts, pie charts, bar graphs, funnel charts, metric cards, data tables, pivot tables, combined charts, burn - down charts, etc.

[0042] As Figure 1 shown, the embodiments of the present disclosure provide a data processing method, which is applied to a project management system and includes:

[0043] Step S101, in response to a setting operation of a first calculation formula for a target work item, obtain the calculation data information and calculation logic information of the first calculation formula, where the first calculation formula is associated with the target work item.

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

[0045] Among them, 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 representing calculation logic such as operators and functions. A calculation formula can be composed of calculation data and calculation logic. The calculation data is operated through the calculation logic to obtain the calculation result of the calculation formula.

[0046] In this embodiment, a calculation formula can be set for the target work item, for example, the first calculation formula is set; or, multiple calculation formulas can also be set for the target work item. Each calculation formula can be for different calculation data information, and / or each calculation formula can have different calculation logic information. In this way, when calculating the calculation data using the calculation formula, different data information can be obtained.

[0047] Step S103: Based on the calculation data information, obtain the corresponding calculation data, and perform an operation on the obtained calculation data based on the calculation logic information to obtain a calculation result.

[0048] In this embodiment, the calculation object of the first calculation formula, that is, the calculation data corresponding to the calculation data information, can be determined based on the calculation data information. Then, an operation is performed on the calculation data based on the calculation logic information of the first calculation formula, that is, the operators and functions included in the first calculation formula are used to perform an operation on the calculation data, thereby obtaining a calculation result. Since the first calculation formula is associated with the target work item, the obtained calculation result is also correspondingly associated with the target work item.

[0049] In this embodiment, in the project management system, a first calculation formula associated with the target work item in the project management system is set, and the calculation data information and the calculation logic information of the first calculation formula are obtained based on the first calculation formula. The calculation data is determined through the calculation data information, and then the calculation data is operated using the calculation logic information, thereby obtaining a calculation result associated with the target work item. That is, the calculation data can be operated using the first calculation formula to obtain a calculation result associated with the target work item in the project management system, so as to obtain more associated information with the target work item based on the calculation result.

[0050] In some embodiments, Figure 1 The method further includes:

[0051] Step S105, 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.

[0052] In some embodiments, the project management system may include multiple business scenarios, such as process management scenarios, page management scenarios, view management scenarios, etc. Among them, the process management scenario includes scenarios such as processes, node flows, and state flows; the page management scenario includes forms, detail page forms, node transfer forms, state transfer forms, etc.; the view management scenario includes tables, dashboards, Gantt charts, personnel schedules, views, workbenches, etc.

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

[0054] Alternatively, the first calculation formula can also be added to the process management scenario to affect the processes in the process management scenario based on the calculation result of the first calculation formula. For example, perform node control on processes, node flows, state flows, etc. to achieve blocking or advancement of processes, node flows, and state flows.

[0055] 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. 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 more dimensions and at more levels in the target business scenario based on the calculation result. Or, use the calculation result to promote or block the process of the target work item in the target business scenario to meet more user needs and improve the user experience. In some embodiments, the first calculation formula belongs to the target work item, that is, the data for implementing the calculation logic information of the first calculation formula belongs to the target work item. Among them, the data for implementing the calculation logic information of the first calculation formula can be fields, and these fields can be fields in the target work item.

[0056] 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 on the calculation data based on the calculation logic information of the first calculation formula is also the calculation result of the target work item.

[0057] Optionally, the calculation data corresponding to the calculation data information may further include a date, a constant, etc., that is, in this embodiment, the calculation data corresponding to the calculation data information includes a date, a constant, and the data of the target work item, so as to obtain a calculation result related to the cycle and value of the target work item.

[0058] When the target work item is a requirement and the target business scenario is to determine the size of the requirement, when the R & D manpower scale is greater than a preset value, it can be determined that the requirement is a large requirement; when the R & D manpower scale is less than the preset value, it can be determined that the requirement is a small requirement. At this time, the first calculation formula can be determined in the first calculation formula through data (field: estimation score of the R & D node), functions (conditional function if(), summation function sum(), filtering function filter(), matching function match()), and a preset value:

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

[0060] Among them, the calculation logic information of the first calculation formula is: if the estimation score of the development node is greater than the preset value, the calculation result is a large requirement; if the estimation score of the development node is less than or equal to the preset value, the calculation result is a small requirement. Calculate the calculation data in the requirement work item based on the calculation logic information of the above first calculation formula, so as to obtain a calculation result of a large requirement or a small requirement, which is the calculation result related to the value of the target work item.

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

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

[0063] Among them, the calculation logic information of the first calculation formula is as follows: find the node first start time of two nodes through the find() function; then use workdaysBetween() to calculate the working days as the calculation result. If you want to include non-working days, you can use the daysBetween() function to calculate the natural days as the calculation result.

[0064] 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 except 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 if necessary, the data of other work items can also be introduced, and the combined data of the data of the target work item and the data of other work items is used as the calculation data, and the combined data of the data of the target work item and the data of other work items is calculated based on the calculation logic information of the first calculation formula, so as to achieve cross-work item data calculation and obtain more data results.

[0065] 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 except the target work item. Among them, the other work items include: work items related to the target work item.

[0066] Here, the relationship between work items is also a term / concept in the project management system. For example, "version associated with requirements" is a relationship between work items. Through this relationship, the work items associated with both ends can be obtained. Or, you can first determine a requirement, and then based on this requirement and the relationship of "version associated with requirements", obtain the version related to this requirement.

[0067] In some embodiments, the setting operation of the first calculation formula for 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.

[0068] In this embodiment, the first calculation formula can be edited by a user with preset permissions in the project management system. The user with preset permissions can be an administrator or a user in the project management system who needs to set or view the target business scenario. This embodiment does not limit this. Among them, the administrator can be the system administrator of the project management system or the administrator of the target work item in the project management system. The user who needs to set or view the target business scenario can be a user who manages the process, node flow, or status flow of the target business scenario, or a user who needs to view the corresponding data in forms, detail page forms, node transfer forms, status transfer forms, as well as tables, dashboards, Gantt charts, personnel schedules, views, and workbenches. This embodiment does not limit this.

[0069] 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.

[0070] 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. The field can include different types of fields, such as numbers, dates, booleans, objects, strings, arrays, rich texts, icons, etc. When the content of the field is a date, the data format of the date can be accurate to the year, half-year, bi-monthly, 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 the user input), integer, decimal (the decimal places can be further set after selecting this item, supporting 1 digit, 2 digits, etc.), percentage (the percentage decimal places can be further set after selecting this item, supporting 1 digit, 2 digits, etc.). In this embodiment, the data format of each field can be set on the field management page of the project management system to apply the data to the first calculation formula.

[0071] The calculation logic information can include symbols representing calculation logic such as functions and operators.

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

[0073] The operator can include >, <, ==, @, etc.

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

[0075] In some embodiments, the calculation data information for editing the first calculation formula includes:

[0076] Step S201, obtain a list of candidate data.

[0077] Step S203, in response to a selection operation on the list of candidate data, obtain target data in the list of candidate data, so as to determine the calculation data information based on the target data;

[0078] Wherein, the data in the list of candidate data belongs to the target work item, or the data in the list of candidate data belongs to the target work item and other specified work items.

[0079] When editing the calculation data information of the first calculation formula, the user can obtain a list of candidate data. Among them, the data belonging to the target work item can be displayed in the list of candidate data. The data belonging to the target work item can be information such as fields belonging to the target work item, that is, the fields in the target work item are displayed in the list of candidate data, so that when the user edits the calculation data information of the first calculation formula, the user can select the fields of the target work item, so that when obtaining the calculation result of the first calculation formula, a calculation result associated with the target work item can be obtained.

[0080] Alternatively, the data belonging to the target work item and other specified work items can also be displayed in the list of candidate data. In some embodiments, it can be a work item having a relationship with the target work item. That is, the fields in the target work item and the fields in the work item having a relationship with the target work item can be displayed in the list of candidate data at the same time, so that when the user edits the calculation data information of the first calculation formula, the user can select both the fields of the target work item and the fields in the work item having a relationship with the target work item, so that when obtaining the calculation result of the first calculation formula, a calculation result having an association relationship with both the target work item and the work item having a relationship with the target work item can be obtained.

[0081] 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 number, date, boolean value, object, string, array, rich text, and icon.

[0082] Among them, when the type of the calculation result of the first calculation formula is a number, integers, percentages, decimals (number of decimal places), etc. can be set; when the type of the calculation result is a date, it can be set to be accurate to year, half-year, bi-monthly, month, week, day, hour, minute, second, etc.; when the type of the calculation result is a boolean value, the display field type selection can be set, and it can be defaulted to a switch and cannot be modified; when the type of the calculation result is an object, personnel, work items, or others can be set; when the type of the calculation result is a string, single-line text or multi-line text can be set; when the type of the calculation result is an array, multiple-choice personnel, multiple-choice related work items, or multiple-choice strings can be set; when the type of the calculation result is an icon or rich text, the type of the icon or rich text can be set.

[0083] 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 emoji, 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 "not passed", 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 "not completed", 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, a progress of 100% is displayed as ten solid small balls "●●●●●●●●●●", a progress of 50% is displayed as five consecutive solid small balls and five consecutive hollow small balls "●●●●●○○○○○", and a progress of 75% is displayed as seven consecutive solid small balls, one semi-solid and semi-hollow small ball, and two hollow small balls "●●●●●●● ○○", and this embodiment does not limit this.

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

[0085] 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 can also be displayed, which can help the user check whether the editing of the first calculation formula is correct.

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

[0087] After the first window is displayed, information such as the field name, field type, calculation formula, calculation result, etc. of the first calculation formula can be set through settings operations on this first window.

[0088] In some embodiments, as Figure 2A shown, when the new field control in the field management page for the target work item is triggered, window 11 can be displayed in the field management page, and optional field types can be displayed in window 11.

[0089] When the field type selected by the user for creation is a calculation formula, as Figure 2B shown, the first window 12 can be displayed, and information such as the field name, field type, calculation formula, etc. of the field can be set in the first window 12. Since the field type has been selected as a calculation formula in window 11, the field type is default displayed as a calculation formula in window 12.

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

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

[0092] Among them, the corresponding fields can be displayed in the list of candidate data 132, and the user can directly select the corresponding fields from the list of candidate data 132 and display them in the formula editing area 131 through a selection operation; alternatively, the user can also directly input the required fields in the formula editing area 131. At the same time, the user can directly input functions and operators in the formula editing area 131, and can also input constants, dates, etc. This embodiment does not limit this.

[0093] In this embodiment, error checking can be performed based on the function operation method and supported parameter types to achieve real-time checking and error guidance during the editing process of the calculation formula. And, a prompter is supported after inputting a function. When inputting data of the array / object data type, a drop-down box can be automatically opened in the calculation formula for selection. For example, as Figure 2D shown, when "priority == " is input, the options "P0, P1, P2, pending" 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.

[0094] As Figure 2CAs shown, the type of the calculation result of the first calculation formula can also be set in the calculation result type setting area 134. Among them, the type of the calculation result of the calculation formula field includes at least one of the types of number, date, boolean value, object, string, array, rich text, and icon.

[0095] As Figure 2C shown, the second window 13 further includes a field information display area 133. When any field in the candidate data list 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 the relevant information of the selected field when editing the calculation formula of the first calculation formula. Among them, the field information of the selected field may include information such as field name, field type, and field description.

[0096] As Figure 2C shown, the second window 13 further includes a calculation result preview area 135. In the calculation result preview area 135, the preview information of the calculation result of the first calculation formula can be displayed, so as to help the user check whether the editing of the first calculation formula is correct.

[0097] 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.

[0098] In some embodiments, after the first calculation formula is created, the first calculation formula can also be modified, including:

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

[0100] 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, display the confirmation control and generate the modified first calculation formula based on the confirmation operation on the confirmation control.

[0101] Step S305, in response to the type of the calculation result of the modified first calculation formula being different from the type of the calculation result of the first calculation formula before modification, set the confirmation control to an inoperable state and display a first prompt message, where 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.

[0102] In this embodiment, the first calculation formula that has been successfully created can be modified. As Figure 2EAs shown, the first calculation formula created successfully will be displayed as a field on the field management page. When the first calculation formula is triggered, field information such as the field name, field type, and calculation formula of the first calculation formula can be displayed on the field management page, and a modify formula control for implementing the modification of the calculation formula is also displayed. When the user triggers the modify formula control, a modification page for the first calculation formula can be displayed, and the formula of the first calculation formula can be modified.

[0103] 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 modification, a confirmation control is displayed in the modification window of the first calculation formula. After triggering the confirmation control, the modification of the first calculation formula is completed; 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 modification, this modification is not allowed. At this time, the confirmation control is set to an untouchable 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.

[0104] 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, deleting the at least part of the calculation data information in the first calculation formula and displaying placeholder information at the position where the at least part of the calculation data information is located. 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 placeholder information is displayed at the position where the data in the first calculation formula is deleted, so that the user can know that there is deleted data in the first calculation formula.

[0105] 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.

[0106] In this embodiment, when at least part of the calculation data information of the first calculation formula is deleted in the project management system, the first calculation formula will no longer include the deleted data, and thus the calculation result of the first calculation formula cannot be obtained. If the first calculation formula has been added to the target business scenario in the project management system, the display of the calculation result corresponding to the first calculation formula in the target business scenario is canceled, or the business of the target business scenario will no longer be affected based on the calculation result corresponding to the first calculation formula.

[0107] In some embodiments, when a field is included in the first calculation formula 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 the work item related to the target work item, the deleted field is replaced with preset placeholder information in the first calculation formula at this time, and a prompt message is displayed to prompt that the field has been deleted.

[0108] 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 not displayed, that is, the calculation result of the first calculation formula cannot be displayed on the details page or view of the target work item.

[0109] When the 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.

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

[0111] In some embodiments, as Figure 2B shown, an advanced configuration control can also be displayed in the first window 12, which is used to configure whether to allow the user to edit the first calculation formula. When it is set that the user is not allowed to edit, if the user wants to edit, a corresponding prompt message will be displayed to prompt that the user cannot edit the calculation formula.

[0112] In some embodiments, 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 impact of the business of 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.

[0113] When the target business scenario is the flowchart of the target work item, the 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 is used as the exit condition of the target node. During the process of process advancement, the calculation data related to the target work item changes dynamically, and the calculation result of the corresponding first calculation formula also changes 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 change of the target work item can be affected according to the change of the calculation data in the project management system.

[0114] In some embodiments, when making a conditional judgment, the first calculation formula can be added to the conditional judgment of the default value condition / required condition, and the conditional judgment is based on the calculation result of the first calculation formula.

[0115] In some embodiments, the target business scenario includes the detail 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 detail page of the target work item; the display of 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 detail page.

[0116] When the target business scenario includes the detail page of the target work item, the edited first calculation formula can be added to the detail page of the target work item. When the calculation data changes dynamically, the calculation result of the corresponding first calculation formula also changes dynamically, and the calculation result corresponding to the first calculation formula displayed in the detail page also changes accordingly, so that the user can obtain the dynamically changing result display.

[0117] In this embodiment, as Figure 2F shown, the first calculation formula and its calculation result can be displayed at the specified position by dragging the first calculation formula on the detail page management page, so as to realize the layout arrangement of the first calculation formula and other fields. After the setting is completed, the calculation result of the first calculation formula can be displayed in the corresponding detail page.

[0118] In some embodiments, the target business scenario includes the process form of the target work item. When the target business scenario includes the process form of the target work item, the first calculation formula can be added to the process form of the target work item. When the calculation data changes dynamically, the calculation result of the corresponding first calculation formula also changes dynamically, and the calculation result corresponding to the first calculation formula displayed in the process form also changes accordingly, so that the user can obtain the dynamically changing result display.

[0119] 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 in the target view of the target work item; the operation of 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.

[0120] When the target business scenario includes a view of a target work item, the 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 also changes dynamically, and the calculation result corresponding to the first calculation formula displayed in the target view also changes accordingly, so that the user can obtain a dynamically changing result display.

[0121] In this embodiment, the target work item can include multiple different types of views. Different first calculation formulas can be added to each view respectively, or the same first calculation formula can be added to all views. This embodiment does not limit this.

[0122] In this embodiment, as Figure 2G shown, the first calculation formula and its calculation result can be displayed at a specified position in the target view by dragging the first calculation formula in the target view, and freezing can be set, so as to realize the display of the first calculation formula and its calculation result in the target view. The calculation result of the first calculation formula supports being used as a condition for filtering, grouping, and sorting.

[0123] In some embodiments, 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 in the metric chart of the target work item. The operation of displaying 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.

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

[0125] In some embodiments, when the target business scenario is the details page or view of the target work item, the sum of two numerical fields can be calculated using the first calculation formula, and a new data field is obtained and displayed in the details page and / or the target view. For example, through the fields "Cost One", "Cost Two" and the operator "+", the first calculation formula "{Cost One}+{Cost Two}" is obtained, and the calculation result is "Total Cost", and the calculation result type is a numeric type. The calculation result is displayed in the details page and / or the 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.

[0126] In some embodiments, when the target business scenario is the view of the target work item, the defects associated with a certain requirement can be calculated using the first calculation formula and displayed in the target view, so that users can easily find the requirement with the largest number of associated defects for high-priority repair. At this time, the function count() can be used to count the defects associated with each requirement in the associated work items, and the calculation result of the first calculation formula is the number of associated defects, and the number of associated defects is displayed in the target view.

[0127] In some embodiments, when the target business scenario is the view of the target work item, the priority of the associated defects can be calculated using the first calculation formula for all requirements and displayed in the target view, so that users can easily find which requirements have 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 the associated defects with a priority equal to P0, then calculate through count(), and then obtain the defect data as the calculation result, and then display the defect data in the target view list.

[0128] In some embodiments, when the target business scenario is the view of the target work item, the first calculation formula can be used to calculate the priority of the associated defects under the uncompleted requirements and display it in the target view. This enables users to conveniently find the associated defects and identify the requirements with the largest number of defects having a priority of P0 for high-priority repair. In this embodiment, the associated defects with a priority equal to P0 are found through the function filter(); the uncompleted requirements are calculated by determining that the field "completion time" is empty through the function empty(); the quantity is calculated through countif(), and the calculation result is the number of associated requirements, which is displayed in the target view list.

[0129] In some embodiments, when the target business scenario is the view of the target work item, the first calculation formula can be used to calculate the R & D human resource scale of the requirements and display it in the target view, so as to sort by the R & D human resource scale of the requirements. In this embodiment, the match() function is used to match the nodes related to development, then the filter() function is used to calculate the estimated scores of the development nodes, and finally the sum() function is used to sum, and the calculation result is displayed in the target view list.

[0130] 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 obtain the node time and display it in the target view. For example, the start time of a certain node in the process can be obtained, such as obtaining the start time of development and displaying it in the target view. In this embodiment, the end time of the previous node of the target node can be used as the start time of the target node, or the earliest start times of each target node can be used as the start time to calculate the start time of the target node, which is then displayed in the details page or the target view.

[0131] In some embodiments, when the target business scenario is the view of the target work item, the first calculation formula can be used to calculate how many delayed nodes there are under a requirement, and after sorting from high to low in a table, it is displayed in the target view to judge the requirement delay situation. In this embodiment, first, it is judged whether the node status of the node is completed; then it is judged whether the actual end time of the node is greater than the scheduled end time of the node, where the situation where the node has no schedule needs to be considered; thus, the calculation result of the delayed nodes is displayed in the target view list.

[0132] Alternatively, the first calculation formula can also be used to judge whether a certain node is delayed. If the node has been delayed, the calculation result of the first calculation formula is "delayed", and the delay status of the node is displayed as "delayed" in the details page or the target view.

[0133] Alternatively, the first calculation formula can also be used to output all the delayed nodes on a table for viewing. In this embodiment, when it is judged that a certain node has been delayed, the node name of that node is used as the calculation result and displayed in the table.

[0134] In some embodiments, when the target business scenario is the details page or view of a target work item, the entry times of a certain node can be calculated using a first calculation formula and displayed in the target view. In this embodiment, first, the find() function is used to filter the nodes for buried point design: find({process node}, each.{name} == "buried point design"), and then the find() function is used to obtain the entry times: find({process node}, each.{name} == "buried point design").{node entry times}, and the obtained entry times are used as the calculation result and displayed in the details page or the target view list.

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

[0136] In some embodiments, when the target business scenario is a flowchart, the calculation result of the first calculation formula can be used to restrict the flow of nodes. For example, it can be set that the number of P0 BUGs in the requirements for OPEN or REOPEN is 0 before the node can flow through. The calculation formula is: if(count(filter({target work item _ requirements}, each.{priority} == P0 && (each.{current status} == "OPEN" || each.{current status} == "REOPEN"))) == 0, true, false).

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

[0138] In some embodiments, the method further 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.

[0139] In this embodiment, when the preset condition is met, the first calculation formula can be recalculated to obtain an updated calculation result, and in the target business scenario, the updated calculation result of the first calculation formula, or, use the updated calculation result of the first calculation formula to affect the business of the target business scenario.

[0140] Among them, the preset conditions may be: the first calculation formula is modified, the calculation data corresponding to the calculation data information changes, the flowchart of the target work item is modified, entering the details page or view of the target work item, the page where the details page or view of the target work item is located is refreshed, etc. This embodiment does not limit this.

[0141] It should be noted that the method of the embodiments of the present disclosure can be executed by a single device, such as a computer or a server. The method of this embodiment can also be applied to a distributed scenario and completed by multiple devices cooperating with each other. In such a distributed scenario, one of the multiple devices can only execute one or more steps of the method of the embodiments of the present disclosure, and these multiple devices will interact with each other to complete the described method.

[0142] It should be noted that some embodiments of the present disclosure are described above. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recited in the claims can be performed in a different order than in the above embodiments and still achieve the desired result. Additionally, the processes depicted in the figures do not necessarily require the particular order or sequential order shown to achieve the desired result. In certain embodiments, multitasking and parallel processing are also possible or may be advantageous.

[0143] Based on the same inventive concept, corresponding to the method of any of the above embodiments, the present disclosure also provides a data processing device.

[0144] Referring to Figure 3 , the device includes:

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

[0146] An operation module 13, configured to: based on the calculation data information, acquire the corresponding calculation data, and perform an operation on the acquired calculation data based on the calculation logic information to obtain a calculation result;

[0147] An addition module 15, configured to: in response to an operation of adding the first calculation formula to a 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.

[0148] In some embodiments, the first calculation formula belongs to the target work item;

[0149] and / or,

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

[0151] 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.

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

[0153] In some embodiments, the obtaining 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.

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

[0155] The device is further configured to: obtain a list of candidate data;

[0156] In response to a selection operation on the list of candidate data, obtain the target data in the list of candidate data to determine the calculation data information based on the target data;

[0157] Wherein, the data in the list of candidate data belongs to the target work item, or the data in the list of candidate data belongs to the target work item and other specified work items.

[0158] 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 number, date, boolean, object, string, array, rich text, and icon.

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

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

[0161] If 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 modification, then display a confirmation control and generate the modified first calculation formula based on the confirmation operation on the confirmation control;

[0162] If 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, then set the confirmation control to an untouchable state and display a first prompt message, where 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.

[0163] In some embodiments, the device is further configured to: in response to at least part of the calculation data information in 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 at the position where the at least part of the calculation data information is located.

[0164] In some embodiments, the device is further configured to: in response to at least part of the calculation data information in 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.

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

[0166] The adding module 15 is configured to: add the first calculation formula to a target node in a 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 promote the process corresponding to the flowchart based on the calculation result of the first calculation formula field.

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

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

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

[0170] 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.

[0171] In some embodiments, the target business scenario includes a metric chart of the target work item;

[0172] 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.

[0173] In some embodiments, the device is further configured to: in response to meeting a preset condition, recalculate the first calculation formula to obtain an updated calculation result; and

[0174] display the updated 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 updated calculation result corresponding to the first calculation formula.

[0175] For convenience of description, when describing the above device, various modules are described separately according to their functions. Of course, when implementing the present disclosure, the functions of each module can be implemented in one or more software and / or hardware.

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

[0177] Based on the same inventive concept, corresponding to the method in any of the above embodiments, the present disclosure further provides an electronic device, including a memory, a processor, and a computer program stored on the memory and executable on the processor. When the processor executes the program, it implements the method in any of the above embodiments.

[0178] Figure 4 FIG. shows a more specific schematic diagram of the hardware structure of the 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. Among them, the processor 1010, the memory 1020, the input / output interface 1030, and the communication interface 1040 are communicatively connected to each other inside the device through the bus 1050.

[0179] The processor 1010 can be implemented in the form of a general-purpose CPU (Central Processing Unit), a microprocessor, an Application Specific Integrated Circuit (ASIC), or one or more integrated circuits, etc., and is used to execute relevant programs to implement the technical solutions provided in the embodiments of this specification.

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

[0181] The input / output interface 1030 is used to connect to an input / output module to achieve information input and output. The input / output module can be configured as a component in the device (not shown in the figure) or can be externally connected to the device to provide corresponding functions. Among them, the input device can include a keyboard, a mouse, a touch screen, a microphone, various sensors, etc., and the output device can include a display, a speaker, a vibrator, an indicator light, etc.

[0182] The communication interface 1040 is used to connect to a communication module (not shown in the figure) to achieve communication interaction between this device and other devices. Among them, the communication module can achieve communication through a wired method (such as USB, network cable, etc.) or can also achieve communication through a wireless method (such as a mobile network, WIFI, Bluetooth, etc.).

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

[0184] 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 the specific implementation process, this device may also include other components necessary for normal operation. In addition, those skilled in the art can understand that the above device may also only include the components necessary to implement the solutions of the embodiments of this specification and does not necessarily include all the components shown in the figure.

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

[0186] Based on the same inventive concept, corresponding to the method of any of the above embodiments, the present disclosure also provides a non-transitory computer-readable storage medium storing computer instructions for causing the computer to execute the method described in any of the above embodiments.

[0187] The computer-readable medium of this embodiment includes permanent and non-permanent, removable and non-removable media, and information storage can be implemented 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 technologies, compact disc read-only memory (CD-ROM), digital versatile disc (DVD) or other optical storage, magnetic cassette tapes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information accessible by a computing device.

[0188] The computer instructions stored in the storage medium of the above embodiment are used to cause 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 elaborated here.

[0189] Those of ordinary skill in the art should understand that the discussion of any of the above embodiments is only exemplary and is not intended to imply that the scope of the present disclosure (including the claims) is limited to these examples; under the concept of the present disclosure, the technical features in the above embodiments or different embodiments can also be combined, the steps can be implemented in any order, and there are many other variations in different aspects of the embodiments of the present disclosure as described above, which are not provided in detail for the sake of brevity.

[0190] Additionally, for simplicity of explanation and discussion, and so as not to make the embodiments of the present disclosure difficult to understand, well-known power / ground connections to integrated circuit (IC) chips and other components may or may not be shown in the provided drawings. Further, the devices may be shown in block diagram form in order to avoid making the embodiments of the present disclosure difficult to understand, and this also takes into account the fact that details regarding 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 understanding of those skilled in the art). In cases 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 practiced without these specific details or with variations of these specific details. Accordingly, these descriptions should be regarded as illustrative rather than restrictive.

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

[0192] Embodiments of the present disclosure are intended to cover all such alternatives, modifications, and variations that fall within the broad scope of the appended claims. Accordingly, any omissions, modifications, equivalent substitutions, improvements, etc., made within the spirit and principle of the embodiments of the present disclosure shall be included within the protection scope of the present disclosure.

Claims

1. A data processing method, which is applied to a project management system and includes: In response to a setting operation of a first calculation formula for a target work item, obtaining calculation data information and calculation logic information of the first calculation formula, where the first calculation formula is associated with the target work item, and the work item is a collection of items disassembled from a project, including at least one of requirements, defects, and versions; Based on the calculation data information, obtaining corresponding calculation data, and performing an operation on the obtained calculation data based on the calculation logic information to obtain a calculation result; In response to an operation of adding the first calculation formula to a 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.

2. The method according to claim 1, wherein 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, wherein, 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.

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

5. The method according to claim 1, wherein The setting operation of the first calculation formula for 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.

6. The method according to claim 5, wherein, Editing the calculation formula of the first calculation formula includes: editing the 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: Obtaining a list of candidate data; In response to a selection operation on the list of candidate data, obtaining target data in the list of candidate data to determine the calculation data information based on the target data; Wherein, the data in the list of candidate data belongs to the target work item, or the data in the list of candidate data belongs to the target work item and other specified work items.

7. The method according to claim 5, wherein, 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.

8. The method according to claim 5, further including: Displaying preview information of the calculation result of the first calculation formula.

9. The method according to claim 7, wherein, It further includes: In response to receiving a modification operation on the first calculation formula, modifying the first calculation formula; If 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 modification, displaying a confirmation control and generating the modified first calculation formula based on the confirmation operation on the confirmation control. If 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 a non-triggerable state and a first prompt message is displayed, where 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 comprises: If at least part of the calculation data information of the first calculation formula is deleted in the project management system, the at least part of the calculation data information is deleted in the first calculation formula and placeholder information is displayed at the position where the at least part of the calculation data information is located.

11. The method according to claim 1, further comprising: If at least part of the calculation data information of the first calculation formula is deleted in the project management system, the calculation result corresponding to the first calculation formula in the target business scenario is cancelled from being displayed, 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, wherein The target business scenario includes the flow 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 target node of the flow chart corresponding to the target work item; The situation where the business of the target business scenario is affected based on the calculation result corresponding to the first calculation formula includes: determining the calculation result of the first calculation formula as the quasi-out condition of the target node, so as to block or promote the process corresponding to the flow chart based on the calculation result of the first calculation formula field.

13. The method according to claim 1, wherein The target business scenario includes the detail 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 detail page of the target work item; The display of 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 detail page.

14. The method according to claim 1, wherein, The target business scenario includes the 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 display of 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, wherein The target business scenario includes the 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; Displaying 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-15, wherein, The method further includes: recalculating the first calculation formula in response to meeting a preset condition 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.

17. A data processing device, comprising: an acquisition module configured to: in response to a setting operation of a first calculation formula for a target work item, acquire the calculation data information and calculation logic information of the first calculation formula, the first calculation formula being associated with the target work item, and the work item being a collection of items disassembled from a project, including at least one of requirements, defects, and versions; an operation module configured to: based on the calculation data information, acquire corresponding calculation data, and perform operations on the acquired calculation data based on the calculation logic information to obtain a calculation result; an addition module configured to: in response to an operation of adding the first calculation formula to a target business scenario in a 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 on the memory and executable on the processor, where 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 for causing a computer to execute the method according to any one of claims 1 to 16.

Images