Back to results
US 2023/0409818 A1Published application
Database model which provides management of custom fields and methods and apparatus therfor
AssigneeAsana, Inc.
InventorsEric Seth Pelz, Gregory Heath Slovacek, Rosario John Aquino, Jacqueline Frances Bavaro, Nicholas William Fassler
Life of this patent
Estimating the term…
Abstract
A data model for managing custom fields for tasks in projects. The custom fields can be defined and shared across an organization, and are always unique. Each type of custom field is an object that is subclass of a generic object. Other objects define attributes of the custom fields and assign values to the attributes. The data model allows the custom fields to be preserved and managed across multiple projects and users.
Claims20
A system configured to manage custom fields of task objects, the system comprising:
- non-transitory electronic storage storing:
- a task object for a task managed by a project management environment, the task object including a unique task ID for the task;
- and
- a first object specifying metadata for a custom field, the metadata specifying a definition of the custom field, the first object having a unique first object ID;
- and
- one or more physical processors configured by computer-readable instructions to:
- define a second object by performing a join between the first object and the task object, wherein the join defines the second object such that the second object includes i) a value of the custom field for the task in accordance with the definition of the custom field as applied to the task object, ii) the unique task ID so that the value of the custom field specified in the second object is associated with the task, and iii) the unique first object ID so that the value of the custom field specified in the second object is associated with the definition of the custom field specified by the metadata of the first object;
- and
- effectuate presentation of the value for the custom field for the task in a user interface of the project management environment by accessing the second object and retrieving the value from the second object, wherein the second object is accessed to present the value for the custom field for the task based on the unique task ID included in the second object being associated with the task, and the unique first object ID included in the second object being associated with the custom field.
6 more elements
A method to manage custom fields of tasks, the method comprising:
- obtaining a task object for a task managed by a project management environment, the task object including a unique task ID for the task;
- obtaining a first object specifying metadata for a custom field, the metadata specifying a definition of the custom field, the first object having a unique first object ID;
- defining a second object by performing a join between the first object and the task object, wherein the join defines the second object such that the second object includes i) a value of the custom field for the task in accordance with the definition of the custom field as applied to the task object, ii) the unique task ID so that the value of the custom field specified in the second object is associated with the task, and iii) the unique first object ID so that the value of the custom field specified in the second object is associated with the definition of the custom field specified by the metadata of the first object;
- and
- effectuating presentation of the value for the custom field for the task in a user interface of the project management environment by accessing the second object and retrieving the value from the second object, wherein the second object is accessed to present the value for the custom field for the task based on the unique task ID included in the second object being associated with the task, and the unique first object ID included in the second object being associated with the custom field.
2 more elements
Dependencies are inferred from the claim text.