A more complex Search: How?

Previous topic

Developer

Next topic

Author	Message
PaoloMellerio kk	Monday 29 December 2003 4:55:16 am Hi, I've created a specific class for apartments which i must show on my site; among the others, in this class I've the Attribute "Area" (id:163), "Rooms" (id:164) and "Bathrooms" (id:165). The question is: is there a way to create a search engine which works in accordance with the values of these Attributes? That is to say it is possible to use a form to specify one value for the attribute "Area", one for the attribute "Rooms" and one for the attribute "Bathrooms ", and the search engine shows me the apartments which have "more or equal" the Area value specified in the form AND "more or equal" the number of Rooms value specified in the form AND "more or equal" the number of Bathrooms value specified in the form? In other words, is it possible to create a search on a class based on the values of three (or more) attribute_id of this class? If yes, HOW? THX in Advice Paolo Mellerio (Clikka!com) Paolo Mellerio http://www.clikka.com
Marco Zinn	Monday 29 December 2003 8:40:52 am oh-oh... I think, you will to code a (search) extension for that. While it should be easy to match for ONE attribute, i think, ez is not prepared to search for multiple attributes including logical operator handling ("more than"). I think, the search engine is trimmed for textual searches and does not know about the order of numbers. The Template operator (http://ez.no/developer/ez_publish_3/documentation/customization/components/search/search_operator) defintly is not prepared to do this, but maybe the ezPublish classes (ezSearch::search) are able to help you. In any case, i think, you need some PHP coding for that. Marco http://www.hyperroad-design.com
Peter Szmulik	Monday 29 December 2003 3:17:26 pm Hi Paolo I'm trying to understand this myself for a similar need. My example would be similar to this: http://uk.pricerunner.com/computing/computers/laptops/browse Most of the attributes in the example are simple true/not true, but processor speed is not. I belive they solved this by saying processor speed between e.g. 900 and 1200MHz which means that this info (in one form or another) would need to be stored as an attribute in the object (presumably together with the actual speed to be displayed for the user). I would be very grateful if someone could verify that this would not be totally wrong in eZ Publish :-) Best Regards & Happy New Year to everyone! Peter

Author

Message

PaoloMellerio kk

Monday 29 December 2003 4:55:16 am

Hi,

I've created a specific class for apartments which i must show on my site; among the others, in this class I've the Attribute "Area" (id:163), "Rooms" (id:164) and "Bathrooms" (id:165). The question is: is there a way to create a search engine which works in accordance with the values of these Attributes? That is to say it is possible to use a form to specify one value for the attribute "Area", one for the attribute "Rooms" and one for the attribute "Bathrooms ", and the search engine shows me the apartments which have "more or equal" the Area value specified in the form AND "more or equal" the number of Rooms value specified in the form AND "more or equal" the number of Bathrooms value specified in the form? In other words, is it possible to create a search on a class based on the values of three (or more) attribute_id of this class?

If yes, HOW?

THX in Advice

Paolo Mellerio (Clikka!com)

Paolo Mellerio
http://www.clikka.com

Marco Zinn

Monday 29 December 2003 8:40:52 am

oh-oh...
I think, you will to code a (search) extension for that.
While it should be easy to match for ONE attribute, i think, ez is not prepared to search for multiple attributes including logical operator handling ("more than"). I think, the search engine is trimmed for textual searches and does not know about the order of numbers.
The Template operator (http://ez.no/developer/ez_publish_3/documentation/customization/components/search/search_operator) defintly is not prepared to do this, but maybe the ezPublish classes (ezSearch::search) are able to help you. In any case, i think, you need some PHP coding for that.

Marco
http://www.hyperroad-design.com

Peter Szmulik

Monday 29 December 2003 3:17:26 pm

Hi Paolo

I'm trying to understand this myself for a similar need. My example would be similar to this:
http://uk.pricerunner.com/computing/computers/laptops/browse

Most of the attributes in the example are simple true/not true, but processor speed is not. I belive they solved this by saying processor speed between e.g. 900 and 1200MHz which means that this info (in one form or another) would need to be stored as an attribute in the object (presumably together with the actual speed to be displayed for the user).

I would be very grateful if someone could verify that this would not be totally wrong in eZ Publish :-)

Best Regards & Happy New Year to everyone!
Peter

eZ debug

Timing:	Jan 30 2025 22:27:35
Script start
Timing:	Jan 30 2025 22:27:35
Module start 'layout'
Timing:	Jan 30 2025 22:27:35
Module start 'content'
Timing:	Jan 30 2025 22:27:35
Module end 'content'
Timing:	Jan 30 2025 22:27:35
Script end

Main resources:

Total runtime	0.0224 sec
Peak memory usage	6,144.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0054	588.1328	151.2109
Module start 'layout'	0.0054	0.0038	739.3438	220.6875
Module start 'content'	0.0092	0.0116	960.0313	997.7891
Module end 'content'	0.0208	0.0015	1,957.8203	33.9922
Script end	0.0223		1,991.8125

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0024	10.6738	14	0.0002
Check MTime	0.0010	4.3953	14	0.0001
Mysql Total
Database connection	0.0008	3.5018	1	0.0008
Mysqli_queries	0.0026	11.8201	3	0.0009
Looping result	0.0000	0.0896	1	0.0000
Template Total	0.0011	4.8	1	0.0011
Template load	0.0008	3.5647	1	0.0008
Template processing	0.0003	1.1857	1	0.0003
Override
Cache load	0.0005	2.3971	1	0.0005
General
dbfile	0.0002	0.9981	8	0.0000
String conversion	0.0000	0.0405	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	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs