[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

Posts: 8 | Registered: November 10, 2015

Rajesh Singh Negi

Gold 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: 58 | Location: India | Registered: June 01, 2018

Ignored post by Rajesh Singh Negi posted

Show Post

FHCole04

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: 8 | Registered: November 10, 2015

Ignored post by FHCole04 posted