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

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

Question
17
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!