Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
<?for-each:G_INV_INV?><?if xdofx:substr(FLEX_TYPE_INV,20,6)='101000'?> IF statement doing nothing. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

<?for-each:G_INV_INV?><?if xdofx:substr(FLEX_TYPE_INV,20,6)='101000'?> IF statement doing nothing.

Question
1
Views
0
Comments

I have a column FLEX_TYPE_INV in my rtf template, there are many data Groups being used here. One of them is G_INV_INV which has the column FLEX_TYPE_INV. I only want a row to appear if the column has sub string '101000' value in it.

the column has the value like '22001-000000-00000-101000-00000-0000-00000-000000-000000'

it is not happening. no error though.

Also i have one more condition <?for-each:G_INVOICE?><?if:C_AMT_DUE_REM_INV !=0?>

this one works perfectly fine, it skips the row where it finds 0

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!