Link to report
https://iawmqy-dev7.fa.ocs.oraclecloud.com/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=%2FCustom%2FIncentive%20Compensation%2FGlobal%20SCP%20Governance%20Solution%2FDirect-MPA%20Screen-PPH%2FScreensMashupRpt.xdo&path=%2Fshared%2FCustom%2FIncentive%20Compensation%2FGlobal%20SCP%20Governance%20Solution%2FDirect-MPA%20Screen-PPH%2FScreensMashupRpt.xdo]
https://iawmqy-dev7.fa.ocs.oraclecloud.com/xmlpserver/Custom/Incentive Compensation/Global SCP Governance Solution/Direct-MPA Screen-PPH/ScreensMashupRpt.xdo?_xmode=4&Id={Id_Value}
// 1. Define base environment (Hardcoded for stability in Mashup URLs)
def host = "iawmqy-dev7.fa.ocs.oraclecloud.com"
def protocol = "https://"
// 2. Define the Report Path
def reportPath = "/xmlpserver/Custom/Incentive%20Compensation/Global%20SCP%20Governance%20Solution/PPHScreenMashUp/ScreensMashupRpt.xdo"
// 3. Get Field Value safely
def batchValue = Id?.toString()
// 4. Construct URL WITHOUT _xf parameter
// This allows the report to pick up its own default format (e.g., PDF, HTML, or Excel)
if (batchValue != null) {
return "${protocol}${host}${reportPath}?_xmode=4&_xautorun=true&id=${batchValue}"
} else {
return "${protocol}${host}${reportPath}?_xmode=4&_xautorun=true"
}
// 1. Define base environment
def host = "iawmqy-dev7.fa.ocs.oraclecloud.com"
def protocol = "https://"
// 2. Define the Report Path (Ensure no trailing slash before xmlpserver)
def reportPath = "/xmlpserver/Custom/Incentive%20Compensation/Global%20SCP%20Governance%20Solution/PPHScreenMashUp/ScreensMashupRpt.xdo"
// 3. Get Field Value safely
// Ensure 'Id' matches your field API name exactly (e.g., ParticipantId_c)
def batchValue = Id?.toString()
// 4. Construct URL
// Added _xmode=4 (Document Only) and _xautorun=true (Execute immediately)
if (batchValue != null) {
return "${protocol}${host}${reportPath}?_xmode=4&_xautorun=true&id=${batchValue}"
} else {
// Return report without ID filter or a default message
return "${protocol}${host}${reportPath}?_xmode=4&_xautorun=true"
}
new path
/shared/Custom/Incentive Compensation/Global SCP Governance Solution/Direct-MPA Screen-PPH/ScreensMashupRpt.xdo Paremeter = id
Comments
Post a Comment