Complex Multiple Field Search

Previous topic

Developer

Next topic

Author	Message
Willie Seabrook	Sunday 12 October 2003 10:54:50 pm Hi, What would be the best way to provide the following functionality on my website: I have quite a complex class that has many fields. Many of these fields are multi selectable enums. In my search page I have a form that matches field by field the input of the class. The search results need to return all objects that match the specified input. You can be as specific (every field) or as vague (no fields = return all objects) as you want to be in the search. Many fields are multiple selects so for example. Select all widgets with title: Test enumfield: One, Two or Three (multi select) The first problem in accomplishing this is the fact that the attribute filter doesn't work in the latest version (see http://www.ez.no/developer/ez_publish_3/forum/general/attribute_filter_doesnt_work) The second is that ezenv appears to not be able to handle array environment variables ie urlblabla/content/view/777?enumField=One&enumField=Two&enumField=Three just returns Three as its result. ezsearch does not also come anywhere near to accomplishing the sort of functionality I need. What would be the best way to approach this problem? Regards, Willie
Eirik Alfstad Johansen	Monday 13 October 2003 1:11:15 am Hi Willie, Regarding the handling of array variables, try adding a [] after the var name, like this: urlblabla/content/view/777?enumField[]=One&enumField[]=Two&enumField[]=Three I don't know if that will make it work, but at least then you are specifing array variables and not overriding existing variables. Sincerely, Eirik Johansen Netmaking AS http://www.netmaking.no/ Sincerely, Eirik Alfstad Johansen http://www.netmaking.no/
Willie Seabrook	Monday 13 October 2003 3:48:01 pm The form data is submitted via http post so I have no control over that I think... unless i specify the variable on the multi select box to be enumField[] instead? That wouldn't make any difference would it?

Author

Message

Willie Seabrook

Sunday 12 October 2003 10:54:50 pm

Hi,

What would be the best way to provide the following functionality on my website:

I have quite a complex class that has many fields. Many of these fields are multi selectable enums.

In my search page I have a form that matches field by field the input of the class.

The search results need to return all objects that match the specified input. You can be as specific (every field) or as vague (no fields = return all objects) as you want to be in the search.

Many fields are multiple selects so for example. Select all widgets with

title: Test
enumfield: One, Two or Three (multi select)

The first problem in accomplishing this is the fact that the attribute filter doesn't work in the latest version
(see http://www.ez.no/developer/ez_publish_3/forum/general/attribute_filter_doesnt_work)

The second is that ezenv appears to not be able to handle array environment variables ie

urlblabla/content/view/777?enumField=One&enumField=Two&enumField=Three

just returns Three as its result.

ezsearch does not also come anywhere near to accomplishing the sort of functionality I need. What would be the best way to approach this problem?

Regards,
Willie

Eirik Alfstad Johansen

Monday 13 October 2003 1:11:15 am

Hi Willie,

Regarding the handling of array variables, try adding a [] after the var name, like this:

urlblabla/content/view/777?enumField[]=One&enumField[]=Two&enumField[]=Three

I don't know if that will make it work, but at least then you are specifing array variables and not overriding existing variables.

Sincerely,

Eirik Johansen
Netmaking AS

http://www.netmaking.no/

Sincerely,

Eirik Alfstad Johansen
http://www.netmaking.no/

Willie Seabrook

Monday 13 October 2003 3:48:01 pm

The form data is submitted via http post so I have no control over that I think... unless i specify the variable on the multi select box to be enumField[] instead? That wouldn't make any difference would it?

eZ debug

Timing:	Jan 18 2025 22:32:51
Script start
Timing:	Jan 18 2025 22:32:51
Module start 'layout'
Timing:	Jan 18 2025 22:32:51
Module start 'content'
Timing:	Jan 18 2025 22:32:52
Module end 'content'
Timing:	Jan 18 2025 22:32:52
Script end

Main resources:

Total runtime	1.7490 sec
Peak memory usage	4,096.0000 KB
Database Queries	57

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0078	589.3438	152.6250
Module start 'layout'	0.0078	0.0040	741.9688	39.4453
Module start 'content'	0.0118	1.7358	781.4141	535.7500
Module end 'content'	1.7476	0.0014	1,317.1641	12.4766
Script end	1.7490		1,329.6406

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.1937	16	0.0002
Check MTime	0.0014	0.0823	16	0.0001
Mysql Total
Database connection	0.0012	0.0700	1	0.0012
Mysqli_queries	1.6759	95.8217	57	0.0294
Looping result	0.0005	0.0310	55	0.0000
Template Total	1.7102	97.8	2	0.8551
Template load	0.0023	0.1316	2	0.0012
Template processing	1.7079	97.6477	2	0.8539
Template load and register function	0.0003	0.0164	1	0.0003
states
state_id_array	0.0007	0.0424	1	0.0007
state_identifier_array	0.0017	0.0992	2	0.0009
Override
Cache load	0.0019	0.1101	31	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0010	0.0563	2	0.0005
Fetch class attribute name	0.0011	0.0655	4	0.0003
XML
Image XML parsing	0.0010	0.0591	2	0.0005
class_abstraction
Instantiating content class attribute	0.0000	0.0006	4	0.0000
General
dbfile	0.0008	0.0471	16	0.0001
String conversion	0.0000	0.0004	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
7	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
4	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 17 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs