Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
INSTR in IF Condition or Conditional Row display with INSTR in XML Publisher
Summary
INSTR in IF Condition or Conditional Row display with INSTR in XML PublisherContent
Hi,
I have below requirement.
The report picks data based on specific date criteria on Due date, which categorizes the Order Status as "Past Due", "Today", "Today+1" .. Today + 9
For example based on data consider the variable ORDER_STATUS holds the string "Past Due, Today, Today + 5'
Now requirement is
<?IF INSTR(ORDER_STATUS, 'Today +6 ') = 0 ?> ( which means, if the search string DOES NOT exist in the source string, then display record in RTF template)
Display record
<?end if?>
Appreciate quick help! Thank you!
- Ram