Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] Filter value with "&"
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Filter value with "&"
 Login/Join
 
Member
posted
I tried to create a filter in DM V768 like T2.VALUE_NAME = 'GROSS_INCOME_&_INTEREST'
but got an error when I tried to run it. Any ideas?

hc_review_stg type Oracle Existing target
Issuing PREPARE
0 ERROR AT OR NEAR LINE 76 IN PROCEDURE fct_tt_r_020
(FOC295) A VALUE IS MISSING FOR: &_INTEREST
Finished

This message has been edited. Last edited by: Kerry,
 
Posts: 18 | Location: Canada | Registered: October 24, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
Can you change the filter value to 'GROSS_INCOME_&|_INTEREST'


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6072 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
Nice job! It works. Thanks.
 
Posts: 18 | Location: Canada | Registered: October 24, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] Filter value with "&"

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.