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

Patent metadata

Field	Value
Publication number	US-9275033-B2
Application number	US-201113072631-A
Country	US
Kind code	B2
Filing date	Mar 25, 2011
Priority date	Mar 25, 2010
Publication date	Mar 1, 2016
Grant date	Mar 1, 2016

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.

First claim

The invention claimed is:

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.

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.

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.

Assignees

• Wong Simon
• Agrawal Sonali
• Salesforce Com Inc

Inventors

• Wong Simon
• Agrawal Sonali

Classifications

• G06F40/186 Primary

  Templates · CPC title

• G06F17/248 Primary

  Physics · mapped topic