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