Simons Scalextric Cars Data Reporting

Report filtering on one column

Press the Filter button to generate your results

Topic	Code	Make	Model	Colour
SimonsScalextricCarsCatalog00001	C698	Unknown	Team Avon Tyres	Yellow
SimonsScalextricCarsCatalog00002	C2810	Lamborghini	Gallardo	Yellow
SimonsScalextricCarsCatalog00003	C2871	Porsche	997 GT3 RS	Orange
SimonsScalextricCarsCatalog00004	C2871	Porsche	997 GT3 RS	Black
SimonsScalextricCarsCatalog00005	C126	Lotus	Team Lotus 77	Black
SimonsScalextricCarsCatalog00006	C137	Ligier	JS 11	Blue
SimonsScalextricCarsCatalog00007	C3019	Mini	Cooper	Blue
SimonsScalextricCarsCatalog00008	C3019	Mini	One	Red

Report filtering on multiple columns with AND

Uses a semi-colon to separate two parameters in a single %SEARCH%

Press the Filter button to get a set of results

Topic	Code	Make	Model	Colour
			AND
SimonsScalextricCarsCatalog00001	C698	Unknown	Team Avon Tyres	Yellow
SimonsScalextricCarsCatalog00002	C2810	Lamborghini	Gallardo	Yellow
SimonsScalextricCarsCatalog00003	C2871	Porsche	997 GT3 RS	Orange
SimonsScalextricCarsCatalog00004	C2871	Porsche	997 GT3 RS	Black
SimonsScalextricCarsCatalog00005	C126	Lotus	Team Lotus 77	Black
SimonsScalextricCarsCatalog00006	C137	Ligier	JS 11	Blue
SimonsScalextricCarsCatalog00007	C3019	Mini	Cooper	Blue
SimonsScalextricCarsCatalog00008	C3019	Mini	One	Red

Report filtering on multiple columns with OR

Uses a | to separate two parameters in a single %SEARCH% - round brackets are added for readability

Press the Filter button to get a set of results

Topic	Code	Make	Model	Colour
			OR
SimonsScalextricCarsCatalog00001	C698	Unknown	Team Avon Tyres	Yellow
SimonsScalextricCarsCatalog00002	C2810	Lamborghini	Gallardo	Yellow
SimonsScalextricCarsCatalog00003	C2871	Porsche	997 GT3 RS	Orange
SimonsScalextricCarsCatalog00004	C2871	Porsche	997 GT3 RS	Black
SimonsScalextricCarsCatalog00005	C126	Lotus	Team Lotus 77	Black
SimonsScalextricCarsCatalog00006	C137	Ligier	JS 11	Blue
SimonsScalextricCarsCatalog00007	C3019	Mini	Cooper	Blue
SimonsScalextricCarsCatalog00008	C3019	Mini	One	Red

Report filtering on multiple columns combining AND with OR

Combines the above in two %SEARCH% - round brackets are added for readability

Press the Filter button to get a set of results

Topic	Code	Make	Model	Colour
			AND
	OR		AND

Could not perform search. Error was: Unmatched ( in regex; marked by <-- HERE in m/( <-- HERE META:FIELD.*?SimonsScalextricCarsMake.*?/

Needs further work

-- SimonLatham - 26 May 2009

---

This topic: Sandbox > WikiUsers > SimonLatham > SimonLathamSandbox > TestingReportingOnFormFieldsUsingFilters > SimonsScalextricCarsDataReporting
Topic revision: 27 May 2009, SimonLatham

---