search by price range howto

Author Message

fabio bongiovanni

Tuesday 13 September 2005 5:07:35 am

Hello and thanks in advice

I have to implement a search by price range.

Looking in the ez docs,forum,etc..... i can't find
any way to do it via search engine.
Also i can't define the price field as searchable in the content class.

Is there any kind of workaround to do it?

Fabio Bongiovanni

fabio bongiovanni

Thursday 15 September 2005 7:41:56 am

COuld someone explain why ez can't search over float?

Thanks in advice

Fabio

Mazen Alsibai

Friday 16 September 2005 11:24:16 am

Hi:
i can lead you to another way to do the search,
maybe the attribute filter way is a good idea to do the search

Mikhail Chekanov

Saturday 17 September 2005 7:24:18 am

fabio, this is possible :)
http://ez.no/community/contribs/hacks/search_and_order_by_float_or_price_datatype_fields

--
mike
#6595551

fabio bongiovanni

Monday 19 September 2005 2:28:21 am

THanks a lot for your help, this is really a good comuunity, where a newbe can really find some help.

Thanks a lot to all. !:-)))

i will try with the hacks

fabio bongiovanni

Monday 19 September 2005 2:31:17 am

I'm pretty happy with the proposed idea, but just for my personal knowledge, could someone explain me why searching over floats is an issue??

Regards Fabio

Fabio Favaro

Thursday 06 October 2005 5:39:36 am

Hello,
i have the same problem.
I have applied the modifies suggest in http://ez.no/community/contribs/h...er_by_float_or_price_datatype_fields
but i don't have the possible of enable the product attributes ezprice datatype.
Any suggestions ?
Thanks in advice.

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 31 2025 01:33:06
Script start
Timing: Jan 31 2025 01:33:06
Module start 'layout'
Timing: Jan 31 2025 01:33:06
Module start 'content'
Timing: Jan 31 2025 01:33:06
Module end 'content'
Timing: Jan 31 2025 01:33:06
Script end

Main resources:

Total runtime0.0225 sec
Peak memory usage6,144.0000 KB
Database Queries3

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0045 588.1328151.2109
Module start 'layout' 0.00450.0030 739.3438220.6875
Module start 'content' 0.00750.0131 960.03131,001.6797
Module end 'content' 0.02060.0018 1,961.710933.9922
Script end 0.0224  1,995.7031 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.002611.7697140.0002
Check MTime0.00104.5999140.0001
Mysql Total
Database connection0.00062.821510.0006
Mysqli_queries0.00167.125330.0005
Looping result0.00000.057310.0000
Template Total0.00135.710.0013
Template load0.00104.366410.0010
Template processing0.00031.330610.0003
Override
Cache load0.00072.937110.0007
General
dbfile0.00115.054080.0001
String conversion0.00000.036140.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0003 secs