Automatically making changes in a document in a content management system based on a change by a user to other content in the document

An article of manufacture comprising:

• (A) a content management system comprising:
• a dynamic inclusion rule that specifies at least one relationship between a data source in a document stored in a repository managed by the content management system and a data target in the document and that specifies a corresponding query to the repository to execute when the data source in the document changes;
• and
• a dynamic inclusion mechanism that monitors the document for changes to the data source specified in the dynamic inclusion rule, and when the data source in the document is changed, and when all parameters for the query are available to execute the query, the dynamic inclusion mechanism automatically executes the query in a background process, wherein the query includes at least one parameter corresponding to the changed data source, the query returning a query result and the dynamic inclusion mechanism automatically inserting a link to the query result at the data target in the document, and when not all parameters for the query are available to execute the query, the dynamic inclusion mechanism determines from a successful query database that stores successful queries for elements in the repository a plurality of related queries and presents a list of the related queries to a user who selects one of the related queries for execution, wherein the dynamic inclusion mechanism executes the selected query and automatically inserts into the document a link to the results of executing the selected query at the data target in the document;
• and
• (B) non-transitory computer-readable media bearing the content management system.

An apparatus comprising:

• at least one processor;
• a memory coupled to the at least one processor;
• a repository residing in the memory that includes a document that includes a plurality of elements;
• and
• a content management system residing in the memory and executed by the at least one processor, the content management system comprising:
• a dynamic inclusion rule that specifies at least one relationship between a data source in the document and a data target in the document and that specifies a corresponding query to the repository to execute when the data source in the document changes;
• and
• a dynamic inclusion mechanism that performs the steps of:
• detecting a change by a user to a data source in the document referenced in a selected one of the dynamic inclusion rules;
• in response to detecting the change by the user, performing the steps of:
• populating the query in the selected dynamic inclusion rule, wherein the query includes at least one parameter corresponding to the changed data source;
• when the populated query is sufficiently populated to allow execution of the populated query, performing the steps of:
• executing the populated query;
• when executing the populated query returns only a first query result, inserting at the data target in the document a link to the first query result;
• when executing the populated query returns a plurality of query results, performing the steps of:
• presenting a list of multiple query results to the user;
• allowing the user to select a second query result from the list;
• and
• inserting at the data target in the document a link to the second query result;
• when the populated query is not sufficiently populated to allow execution of the populated query, performing the steps of:
• searching a successful query database for similar successful queries;
• ranking the similar successful queries based on frequency of use of each successful query in the successful query database;
• populating the similar successful queries with parameters from document elements;
• presenting a list of populated successful queries to the user;
• the user selecting from the list a selected query to execute;
• executing the selected query to return a third query result;
• and
• inserting at the data target in the document a link to the third query result.