System, method and computer program product for creating an object within a system, utilizing a template

• US 9,275,033 B2
• Filed: 03/25/2011
• Issued: 03/01/2016
• Est. Priority Date: 03/25/2010
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Wong, Simon, Agrawal, Sonali
• Primary Examiner(s): Ehichioya, Fred I
• Assistant Examiner(s): Mobin, Hasanul
• Application Number:
  US13/072,631
• Publication Number:
  US 20110238707A1
• Time in Patent Office: 1,803 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 40/186 Templates

Abstract

In accordance with embodiments, there are provided mechanisms and methods for creating an object within a system, utilizing a template. These mechanisms and methods for creating an object within a system, utilizing a template can enable increased efficiency, resource and time savings, more intuitive object creation, etc.

Claims

1. A computer program product, comprising a non-transitory machine-readable storage medium having a computer readable program code embodied therein, the computer readable program code adapted to be executed to implement a method for creating an object within a system, utilizing a template, the method comprising:

providing a database system shared by multiple customers, wherein the database system stores standard tables each accessible to and shared by the multiple customers and custom tables each specific to and accessible by a particular one of the customers;

storing, by the database system, a template for a standard table, the template having standard fields and standard features, and a framework of the template implementing at least a search query feature, a reporting feature, apex triggers, and Visualforce;

receiving, by the database system, a request to create a new standard table within the database system from the template;

in response to the request, creating automatically, by the database system, at least;

the new standard table from the template by including in the new standard table the standard fields and standard features of the template and by implementing in the new standard table at least the search query feature, the reporting feature, the apex triggers, and the Visualforce, and

a subclass for the new standard table which handles at least loading of the new standard table and saving of the new standard table within the database system;

storing, in the database system, the created standard table and the created subclass using the database system; and

making, by the database system, the stored standard table available for use by the multiple customers via the subclass, including;

when a search query is received through the stored standard table by one of the customers, executing by the database system the search query to return to the customer results of the execution of the search query; and

when a request for a report is received through the stored standard table by one of the customers, executing by the database system the report to return to the customer a result of the execution of the report.

2. The computer program product of claim 1, wherein the database system includes a multi-tenant on-demand database system.

3. The computer program product of claim 1, wherein the standard table includes an identifier.

4. The computer program product of claim 1, wherein the standard table includes a distinct key prefix.

5. The computer program product of claim 1, wherein the standard table is stored in a database of the database system once it is created.

6. The computer program product of claim 1, wherein one or more of the standard fields of the created standard table are initialized utilizing metadata.

9. The computer program product of claim 6, wherein the one or more of the standard fields are initialized by activating the one or more standard fields utilizing the metadata.

7. A method, comprising:

providing a database system shared by multiple customers, wherein the database system stores standard tables each accessible to and shared by the multiple customers and custom tables each specific to and accessible by a particular one of the customers;

storing, by the database system, a template for a standard table, the template having standard fields and standard features, and a framework of the template implementing at least a search query feature, a reporting feature, apex triggers, and Visualforce;

receiving, by the database system, a request to create a new standard table within the database system from the template;

in response to the request, creating automatically, by the database system, at least;

the new standard table from the template by including in the new standard table the standard fields and standard features of the template and by implementing in the new standard table at least the search query feature, the reporting feature, the apex triggers, and the Visualforce, and

a subclass for the new standard table which handles at least loading of the new standard table and saving of the new standard table within the database system;

storing, in the database system, the created standard table and the created subclass using the database system; and

making, by the database system, the stored standard table available for use by the multiple customers via the subclass, including;

when a search query is received through the stored standard table by one of the customers, executing by the database system the search query to return to the customer results of the execution of the search query, and

when a request for a report is received through the stored standard table by one of the customers, executing by the database system the report to return to the customer a result of the execution of the report.

8. An apparatus, comprising:

a database system shared by multiple customers, wherein the database system stores standard tables each accessible to and shared by the multiple customers and custom tables each specific to and accessible by a particular one of the customers; and

a processor of the database system for;

storing, by the database system, a template for a standard table, the template having standard fields and standard features, and a framework of the template implementing at least a search query feature, a reporting feature, apex triggers, and Visualforce;

receiving, by the database system, a request to create a new standard table within the database system from the template;

in response to the request, creating automatically, by the database system, at least;

the new standard table from the template by including in the new standard table the standard fields and standard features of the template and by implementing in the new standard table at least the search query feature, the reporting feature, the apex triggers, and the Visualforce, and

a subclass for the new standard table which handles at least loading of the new standard table and saving of the new standard table within the database system;

storing, in the database system, the created standard table and the created subclass using the database system; and

making, by the database system, the stored standard table available for use by the multiple customers via the subclass, including;

when a search query is received through the stored standard table by one of the customers, executing by the database system the search query to return to the customer results of the execution of the search query, and

when a request for a report is received through the stored standard table by one of the customers, executing by the database system the report to return to the customer a result of the execution of the report.