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

Jul 20, 2022 8:51AM

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

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

Howdy, Stranger!