On-demand database service system, method and computer program product for generating a custom report

A non-transitory machine-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, cause the one or more processors to carry out the steps of:

• receiving a request for a report on database contents of an on-demand database service, the request indicating a previously defined report template storing an identification of:
• a primary object, a child object to the primary object, and one of an inner join operation and an outer join operation;
• performing the one of the inner join operation and the outer join operation identified from the previously defined report template on the primary object and the child object identified from the previously defined report template, to generate the report;
• and outputting the report;
• wherein at least one of the primary object and the child object includes a custom object;
• wherein the identification of the outer join operation includes a plurality of keys to indexes of one of the primary object and the child object;
• determining whether to use the keys to query the one of the primary object and the child object or to use a user defined filter to query the one of the primary object and the child object;
• wherein the determining is based on a total number of the keys;
• wherein the plurality of keys are a subset of a larger number of keys, the subset of keys corresponding to information of the report to be output.

An apparatus, comprising:

• a processor;
• and
• one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out the steps of:
• receiving a request for a report on database contents of an on-demand database service, the request indicating a previously defined report template storing an identification of:
• a primary object, a child object to the primary object, and one of an inner join operation and an outer join operation;
• performing the one of the inner join operation and the outer join operation identified from the previously defined report template on the primary object and the child object identified from the previously defined report template, to generate the report;
• and
• outputting the report;
• wherein at least one of the primary object and the child object includes a custom object;
• wherein the identification of the outer join operation includes a plurality of keys to indexes of one of the primary object and the child object;
• determining whether to use the keys to query the one of the primary object and the child object or to use a user defined filter to query the one of the primary object and the child object;
• wherein the determining is based on a total number of the keys;
• wherein the plurality of keys are a subset of a larger number of keys, the subset of keys corresponding to information of the report to be output.

A method for transmitting code for use in a multi-tenant database system on a transmission medium, the method comprising:

• transmitting code, utilizing a processor, for receiving a request for a report on database contents of an on-demand database service, the request indicating a previously defined report template storing an identification of:
• a primary object, a child object to the primary object, and one of an inner join operation and an outer join operation;
• transmitting code for performing the one of the inner join operation and the outer join operation identified from the previously defined report template on the primary object and the child object identified from the previously defined report template, to generate the report;
• and
• transmitting code for outputting the report;
• wherein at least one of the primary object and the child object includes a custom object;
• wherein the identification of the outer join operation includes a plurality of keys to indexes of one of the primary object and the child object;
• determining whether to use the keys to query the one of the primary object and the child object or to use a user defined filter to query the one of the primary object and the child object;
• wherein the determining is based on a total number of the keys;
• wherein the plurality of keys are a subset of a larger number of keys, the subset of keys corresponding to information of the report to be output.