Hierarchy nodes derived based on parent/child foreign key and/or range values on parent node

摘要

Nodes of a tree are dynamically generated. A user may specify that a node should have a separate child node for each unique value that occurs in a particular column of a relational table. A user may specify that a node should have a separate child node for each range of values in a user-specified set of ranges. Child nodes of a particular node may be dynamically determined and displayed by querying one or more relational tables for records that satisfy all of the criteria that are implied by that particular node and that particular node's parents. As a result of the foregoing techniques, users are not forced to create a tree node-by-node; instead, users can specify criteria based on which a whole level of nodes should be created, and a whole level of nodes may be added to a tree based on those criteria.

主权项

1. A computer-implemented method comprising steps of:
receiving user-specified criteria comprising a first column of a first database table stored in a database, and a set of user-specified ranges comprising two or more user-specified ranges for values of the first column; in response to receiving the user-specified criteria, adding, to a tree structure, a first new subtree comprising a first set of nodes, wherein each node in the first set of nodes corresponds to a particular user-specified range of the set of user-specified ranges for the first column; displaying the tree structure with the first new subtree; after displaying the tree structure with the first new subtree, receiving additional user input identifying a user-selected node of the first set of nodes that corresponds to a particular range of the set of user-specified ranges; in response to receiving the additional user input identifying the user-selected node after displaying the tree structure with the first new subtree, identifying records in the database that match the particular range corresponding to the user-selected node, generating a second set of nodes based on a set of second field values for a second column of the identified records, and adding, to the tree structure, a second new subtree that descends from the user-selected node, the second new subtree comprising the second set of nodes; after adding the second new subtree to the tree structure, displaying, in the tree structure, the second new subtree; wherein the hierarchical parent-child relationship between the second set of nodes and the user-selected node of the first set of nodes is not generated or stored before the additional user input identifying the user-selected node is received; wherein the steps are performed by one or more computing devices.