Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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.

in BI Publisher Learning Center

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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