You are here:
Load Attachments to Display Object
Create and configure a list object to load the attachments. Add the list object to the Display business object and also add a datasource for the attachments.
Required Editions
Available in: Lightning Experience Available in: Enterprise and Unlimited Editions where Consumer Goods Cloud is enabled |
| User Permissions Needed | |
|---|---|
| To add and configure list object | Developer, Customizer |
-
To create a list object for attachments, in Visual Studio Code based Modeler,
run
sf mdl addand enter these details? Select the resource you want to add. listobject ? Specify a name for the listobject: DisplayAttachment ? Select the module to which listobject 'DisplayAttachment' should be added. MyDisplay -
In DsLoMyDisplayAttachment_sf.datasource.xml, configure
the datasource details as shown in this code snippet.
<DataSource name="DsLoMyDisplayAttachment" backendSystem="sf" businessObjectClass="LoMyDisplayAttachment" external="false" editableEntity="SF_File" schemaVersion="2.0" readOnly="true"> <Attributes> <Attribute name="attachmentBlobPKey" table="SF_File" column="Id" /> <Attribute name="pKey" table="SF_FileLink" column="Id" /> <Attribute name="mediaPath" table="SF_File" column="VersionData" /> <Attribute name="description" table="SF_File" column="Description" /> <DerivedAttribute name="type" value="replace(SF_File.PathOnClient, rtrim(SF_File.PathOnClient, replace(SF_File.PathOnClient, '.', '')), '')" /> <DerivedAttribute name="fileType" value="replace(PathOnClient, rtrim(PathOnClient, replace(PathOnClient, '.', '')), '')" /> <Attribute name="fileName" table="SF_File" column="PathOnClient" /> </Attributes> <Entities> <Entity name="SF_File" alias="" idAttribute="Id" /> <Entity name="SF_FileLink" alias=""> <Join Type="inner"> <SimpleJoin> <Condition leftSideValue="SF_FileLink.FileId" comparator="eq" rightSideType="Attribute" rightSideValue="SF_File.Id" /> </SimpleJoin> </Join> </Entity> </Entities> <QueryCondition><![CDATA[ SF_FileLink.ParentId = #display#]]> </QueryCondition> <OrderCriteria> <OrderCriterion entity="SF_File" attribute="Relative_Position__c <> 0" direction="DESC" /> <OrderCriterion entity="SF_File" attribute="Relative_Position__c" direction="ASC" /> </OrderCriteria> <Parameters> <Parameter name="display" type="TEXT" /> </Parameters> </DataSource> -
To configure the list object, in
LiMyDisplayAttachment.listitem.xml, add these simple
properties:
The simple properties in this code snippet map specific attributes from the data source to properties in the application, including file keys, media paths, descriptions, types, and file names. Each property is linked to a corresponding data source property for accurate data retrieval.
<SimpleProperty name="pKey" type="DomPKey" dataSourceProperty="pKey" /> <SimpleProperty name="attachmentBlobPKey" type="DomPKey" dataSourceProperty="attachmentBlobPKey" /> <SimpleProperty name="mediaPath" type="DomBlob" dataSourceProperty="mediaPath" blobTable="PrmAttachmentBlob" blobPKeyField="attachmentBlobPKey" /> <SimpleProperty name="description" type="DomText" dataSourceProperty="description" /> <SimpleProperty name="type" type="DomFileType" dataSourceProperty="type" /> <SimpleProperty name="fileName" type="DomFileName" dataSourceProperty="fileName" /> -
To add the list object to the BoDisplays business object, in
BoMyDisplay.businessobject.xml, configure the list object under the ListObject
node.
The ListObjects section defines the loAttachment list object that uses the LoMyDisplayAttachment class and maps the pKey from the data source to the display list property. This ensures that the attachments correctly appear in the list.
<ListObjects> <ListObject name="loAttachment" objectClass="LoMyDisplayAttachment" dataSourceProperty="pKey" listProperty="display" /> </ListObjects> - Save all the contracts.
