Internal DataSources
Last updated
Last updated
Internal DataSources are used when you want to look up related objects in Salesforce to present data together.
For example, if the Lookup object is specified as Product2 and you want to display the unit price from a PricebookEntry, you can use an internal data source to look up the PricebookEntry that meets the criteria, and display the product and unit price together.
Define each property of the internal DataSource.
Map data retrieved from an internal DataSource to a Lookup or Line-item.
| Item | Description | Req. |
|---|---|---|
These are operations to map data imported via an internal DataSource to a Lookup or Line-item.
| Item | Description | Req. |
|---|---|---|
You want your Line-item Editor to show a list of products including their prices. You have set your Lookup object to be Product, but the unit prices are stored in the PricebookEntry object.
In the DataSource settings, specify the Source Object as PricebookEntry.
(optional) Use the Query Wizard to create conditions for the query (same as SOQL WHERE statement).
To match the PricebookEntry data to the Products, use the following settings:
Source Field: Product2Id
Target Field: Id
Key: true
Add an Action to configure a Lookup column to display the unit price together with the Product data.
Source Field: UnitPrice
Target Field: SBLDVirtual1 (Virtual fields reference)
Source Object
Specify the Salesforce objects that you want to source data from.
βοΈ
Query
Click the Wizard button to open the Build Query layout. You can use the Query Wizard to easily build queries by searching for the correct fields to use.
Active
Turns the DataSource on or off. It must be active to be used.
βοΈ
Evaluation Event
When adding a DataSource for the Line-item Editor, an Evaluation Event needs to be specified.
On Initialization: Executes when a new Line-item is added.
On Loading: Executes when the Line-item screen is loaded.
Before Save: Executes before a Line-item is saved.
These are operations to map data imported via an internal DataSource to a Lookup or Line-item.
βοΈ
Action Order
Specify the order that mappings are carried out.
βοΈ
Source Field
Specify the field to map from the internal DataSource object.
βοΈ
Target Field
Specify the Lookup or Line-item field to map to.
βοΈ
Key
If true, this mapping will define how to match records between the Lookup or Line-item objects and the DataSource object.
For example, if the Lookup is specified as Product2 and you import PricebookEntry as the DataSource, the key mapping would connect the field Product2Id from PricebookEntry (source field) and the field Id from Product2 (target field):
PriceBookEntry.Product2Id = Product2.Id
βοΈ
