{soql-reporter}
Plugin: Salesforce.com Confluence Plugin, from version 2.0
Allows reporting of SalesForce.com Objects using SOQL
Description
 | This macro requires a valid license to be installed to work, to obtain a quote for a license or request an evaluation license, please contact.info@customware.net This macro requires the Reporting Plugin version 3.2.0 or higher to be installed to work. |
This reporter will obtain data from SalesForce.com from a SOQL query.
The data is obtained using the configured SalesForce.com connection (see: SalesForce.com Confluence Plugin Installation for details on how to set up/modify this connection)
Usage
{soql-reporter:query=<SOQL query>}
{xxx-sort:prefix:subkey|order=[ascending, descending]}
{xxx-filter:prefix:subkey|extra parameters go here}
{soql-reporter}
Parameters
| Name | Required | Default | Description |
|---|---|---|---|
| query | | N/A
| The SOQL query to execute in SalesForce, the result of the query will be made available to the [SalesForce.com Supplier]. |
Examples
{report-table}
{soql-reporter:query=SELECT Account.Name, Name,Amount,StageName From Opportunity}
{soql-reporter}
{report-column:title=Account}{report-info:sf:Account.Name}{report-column}
{report-column:title=Opportunity}{report-info:sf:Name}{report-column}
{report-column:title=Amount}{report-info:sf:Amount}{report-column}
{report-column:title=Stage Name}{report-info:sf:StageName}{report-column}
{report-table}
Displays a table with a list of all of the Opportunities, grouped by account, with the opportunity amount and name of the stage of the opportunity.
See Also
- [SalesForce.com Supplier]
Discussions