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  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Filtering by Keyword
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Filtering by Keyword
 Login/Join
 
Member
posted
Hi there,

I am trying to build a report with parameter that contains keywords. And would like to filter a table column. For example, in my report i am displaying account and comments columns. And i have a parameter called keywords that contains 2 lines 'A VETERAN' and 'AN EMPLOYEE'. How would I create the filter so that the reports gets filtered by what keywords were selected?

In SQL, i could do something like: WHERE Comments LIKE '%A VETERAN%' OR '%AN EMPLOYEE%'.

I tried something like this and it did not work. I got an error, "(FOC028) USE INCLUDES/EXCLUDES TEST TO RETRIEVE PARENT RECORDS ONLY".

WHERE Comments INCLUDES &Keywords.(OR(, |FORMAT=A100)).Keywords:.;


Thank you
Glen

This message has been edited. Last edited by:
FP Mod Chuck,
 
Posts: 15 | Registered: January 24, 2020Reply With QuoteReport This Post
Virtuoso
posted Hide Post
WHERE Comments CONTAINS &Keywords.(OR(, |FORMAT=A100)).Keywords:.;


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2392 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Guru
posted Hide Post
This works for me so you should be able to run with LIKE unless it doesn't like SPACES
[CODE
TABLE FILE CAR
SUM SALES
BY COUNTRY
WHERE COUNTRY LIKE '%J%' OR '%Y%'
END
[/CODE]


-********************
Sandbox: 8206.10
Dev: 8201M
Prod:8009
-********************
 
Posts: 289 | Location: Houston,TX | Registered: June 11, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Filtering by Keyword

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