Oracle Publisher Code for Service Request Activity (All) Report Template

The following table describes the code that Oracle Publisher uses for the Service Request Activity (All) report template. You can view this code if you use Oracle Publisher Desktop to open the Service Request Activity (All) report template. For more information about this code, see the Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher available on Oracle Technology Network (http://www.oracle.com/technetwork/indexes/documentation/index.html) or Designing and Publishing Pixel-Perfect Reports in Oracle Analytics Server available at https://docs.oracle.com/en/middleware/bi/analytics-server/design-publish/index.html. For more information about integration objects, see How Siebel Reports Uses Integration Objects.

Syntax	Oracle Publisher Code	Description
If	<?if://ssServiceRequest?>	An IF condition that determines if service request record exist, do not exist, or are not displayed.
for-eachgroup: ssServiceRequest	<?for-each- group:ssServiceRequest; position()?>	The start of a group section that iterates for each record in the Service Request data set.
ssSrNumber ssAccount ssStatus	<?ssSrNumber?> <?ssAccount?> <?ssStatus?	Field mappings.
If	<?if://ssCreated?>	If condition that does not display the ssCreated field if null.
ssCreated	<?format- date:psfn:totext(ssCreated, "yyyy-MM-dd'T'HH:mm:ss", "MM/dd/yyyy hh:mm:ss"); 'SHORT_TIME'?>	Field formatting.
End	<?end if?>	End of if condition.
ssSeverity ssDescription	<?ssSeverity?> <?ssDescription?>	Field mappings.
If	<?if://ssClosedDate?>	If condition that does not display the ssClosedDate field if null.
ssClosedDate	<?format- date:psfn:totext(ssClosedDa te,"yyyy-MM-dd'T'HH:mm:ss", "MM/dd/yyyy hh:mm:ss"); 'SHORT_TIME'?>	Field formatting.
End	<?end if?>	End of if condition.
ssPriority ssCustomerRefNumber ssOwner	<?ssPriority?> <?ssCustomerRefNumber?> <?ssOwner?>	Field mappings.
for-each:current-group()	<?for-each:current- group()?>	Start of a group section, iterating for each record in the current group (for example, Service Request).
If	<?if:current-group()// ssAction?>	An IF condition that determines if action records exist, do not exist, or are not displayed.
for-each:ssAction	<?for-each:ssAction?>	Beginning of the repeating element group for Action.
If	<?if://ssCreated?>	If condition that does not display the ssCreated field if null.
ssCreated	<?format- date:psfn:totext(ssCreated, "yyyy-MM-dd'T'HH:mm:ss", "MM/dd/yyyy hh:mm:ss"); 'SHORT_TIME'?>	Field formatting.
End	<?end if?>	End of if condition.
ssCreatedByN ssOwnedBy sssStatussType ssDescription	<?ssCreatedByName?> <?ssOwnedBy?> <?ssType?> <?ssStatus?> <?ssDescription?>	Field mappings.
end for-each:ssAction	<?end for-each?>	End of the repeating element group for Action.
End if	<?end if?>	The end of the if condition
end for-each	<?end for-each?>	End of current-group() repeating group section.
page break	<?split-by-page-break:?>	Page break after the end of the group section.
end for-each-group: ssServiceRequest	<?end for-each-group?>	End of Service Request group section.
End	<?end if?>	End statement that ends a subroutine.
If	<?if:not(// ssServiceRequest)?>	If condition that prints "No Data Found" in the report if there are no records.
End	<?end if?>	End if statement for the condition in the first row.