Focal Point
[SOLVED] Page Designer - Filter Options

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1237081496

August 19, 2020, 03:15 PM
FHCole04
[SOLVED] Page Designer - Filter Options
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
August 19, 2020, 09:09 PM
Rajesh Singh Negi
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
August 21, 2020, 01:16 PM
FHCole04
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
August 21, 2020, 09:30 PM
Rajesh Singh Negi
Happy to help.... Smiler


Webfocus 8.x
Windows
PDF,HTML,XLSX