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     [SOLVED] Page Designer - Filter Options
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Page Designer - Filter Options
 Login/Join
 
Member
posted
How do you change a drop down control from Multi-select to Single-select in Page Designer.

Currently when PD creates the filter bar dropdowns are defaulting to Multi-select and I need it to do single select.

This message has been edited. Last edited by: FP Mod Chuck,


WF 8.2.06 Windows/Linux
 
Posts: 6 | Registered: November 10, 2015Reply With QuoteReport This Post
Silver Member
posted Hide Post
quote:
FHCole04


1. If you are trying to create custom dropdown filter then try below code:

-SET &TEST = &TEST.('TEST1','TEST2','TEST3','TEST4','TEST5','TEST6','TEST7',).Test Dropdown:.QUOTEDSTRING;

2. If you are creating filter from Synonym values:

-SET &CNTRY= &COUNTRY.(FIND CAR1.ORIGIN.COUNTRY IN CAR1|FORMAT=A10).Country:.QUOTEDSTRING;

3. If you want to directly have filter on a table file request try like this :

TABLE FILE CAR1
BY CAR1.ORIGIN.COUNTRY
BY CAR1.COMP.CAR
BY CAR1.CARREC.MODEL
WHERE CAR1.ORIGIN.COUNTRY EQ &COUNTRY.(FIND CAR1.ORIGIN.COUNTRY IN CAR1|FORMAT=A10).Country:.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,
$
ENDSTYLE
END


Let me know if this works or you need something else.


Webfocus 8.x
Windows
PDF,HTML,XLSX
 
Posts: 44 | Location: India | Registered: June 01, 2018Reply With QuoteReport This Post
Member
posted Hide Post
Thanks for the reply Rajesh. This works great.

I had to remove the OR from my find and add the QuotedString to the end.


WF 8.2.06 Windows/Linux
 
Posts: 6 | Registered: November 10, 2015Reply With QuoteReport This Post
Silver Member
posted Hide Post
Happy to help.... Smiler


Webfocus 8.x
Windows
PDF,HTML,XLSX
 
Posts: 44 | Location: India | Registered: June 01, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Page Designer - Filter Options

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