Siebel Business Process & Functionality (MOSC)

MOSC Banner

Siebel BIP Reports

Hello,

I have this requirement in Siebel BIP reports.

There are three parameters which will be input by user while running report.

$StartDate      Date     Required

$EndDate       Date     Required

$SolId            Text      Not Required

I have below code in my rtf which is working.

<?for-each-group:contact[UBIAccOpenCanonical >= (psfn:totext($StartDate,"yyyy-MM-dd","MM/dd/yyyy")) and UBIAccOpenCanonical <= (psfn:totext($EndDate,"yyyy-MM-dd","MM/dd/yyyy")) and UBISolIdBIP=$SolId];./UBIBranchBIP?>

Issue is when $SolId is passed it gives records correctly.

But when it is not passed and sent blank then no record is returned. My $SolId is non required so in this case it should return me all the records from database without filtering.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center