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

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

Question
18
Views
0
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics

Summary

INSTR in IF Condition or Conditional Row display with INSTR in XML Publisher

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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