Table 8. Code That Oracle BI Publisher Uses for the Service Request Activity (All) Report Template
|
|
|
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(ssClosedDate,"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" at the bottom of the report if there are no records. |
End |
<?end if?>
|
End if statement for above condition. |