Skip to main content
Question

Add logic to the Report rule setup


Forum|alt.badge.img+7
  • Sidekick (Employee)
  • 16 replies

For an APP10 customer, trying to set the logic to the report rule and raised the question.

 

In the report rules you can point to a variable in the XML  (example  [@UNIFORM_PAYMENT_ADVICE_REP/IDENTITYS/IDENTITY/COMM_METHOD])    is it possible to add logic to this?  Example I want to remove the first 7 characters of that variable.  I tried  [&select SUBSTR([@UNIFORM_PAYMENT_ADVICE_REP/IDENTITYS/IDENTITY/COMM_METHOD], 7) from dual]    but that didn’t work.   I just wanted to make sure its possible to do what we want.

Reasoning

The Comm Method variable   is   ‘E-Mail:  jackdoug@gmail.com ‘    in order to actual use it, we need to strip off  ‘E-Mail:’

 

THanks

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings