Attribute filtering with integers in eZ Find 2?

Next topic

Author	Message
Jordan Hirsch	Monday 09 February 2009 6:04:40 am I have just read the latest documentation for eZ Find 2 (http://svn.ez.no/svn/extensions/ezfind/docs/ezfind_1.1_manual.pdf) and I see you can add attribute filters to an eZ Find search using facets, like so: fetch( ezfind, search, hash( query, 'eZ Systems', filter, array( 'car/in_stock:1', 'car/make:Alfa Romeo', 'car/model:8C' ) ) ) Is it possible to do more advanced filtering such as greater-than or less-than on integer fields using eZ Find? What would would the code look like? I am new to eZ Find and even newer to facets, so please forgive me if this is obvious, but I can't find it in the documentation. Thank you in advance for your help. Me: http://jordan.teamhirsch.com My blog: http://wiredformusic.blogspot.com My other company: http://thinkimprov.com eZ Certification: http://auth.ez.no/certification/verify/402488 eZ Award: http://ez.no/company/news/ez_awards_2007_prize_winners
Nicolas Pastorino	Friday 20 February 2009 2:22:43 am Hi Jordan, First, do not forget to check the latest stable version of eZ Find : * http://ez.no/company/news/ez_systems_releases_apache_solr_based_open_source_enterprise_search_solution_ez_find_2_0 * http://ez.no/doc/extensions/ez_find * http://ez.no/ezfind/download You can use a bunch of Solr query syntax bits in the 'filter' parameter of the fetch function, among them a range search, with finite or unfinite bounds. A code example would be : fetch( ezfind, search, hash( query, 'eZ Systems', filter, array( 'article/rating:[3 TO ]' ))) This would return all articles containing the words 'ez' and 'systems', for which the rating is higher than 3. You could inverse the filter by using the following syntax in place : [ TO 4] I hope it helped, Best Regards, -- Nicolas Pastorino Director Community - eZ Member of the Community Project Board eZ Publish Community on twitter: http://twitter.com/ezcommunity t : http://twitter.com/jeanvoye G+ : http://plus.tl/jeanvoye

Author

Message

Monday 09 February 2009 6:04:40 am

I have just read the latest documentation for eZ Find 2 (http://svn.ez.no/svn/extensions/ezfind/docs/ezfind_1.1_manual.pdf) and I see you can add attribute filters to an eZ Find search using facets, like so:

fetch( ezfind, search, 
    hash( query, 'eZ Systems',
        filter, array( 'car/in_stock:1',
                'car/make:Alfa Romeo',
                'car/model:8C' ) ) )

Is it possible to do more advanced filtering such as greater-than or less-than on integer fields using eZ Find? What would would the code look like? I am new to eZ Find and even newer to facets, so please forgive me if this is obvious, but I can't find it in the documentation.

Thank you in advance for your help.

Me: http://jordan.teamhirsch.com
My blog: http://wiredformusic.blogspot.com
My other company: http://thinkimprov.com
eZ Certification: http://auth.ez.no/certification/verify/402488
eZ Award: http://ez.no/company/news/ez_awards_2007_prize_winners

Nicolas Pastorino

Friday 20 February 2009 2:22:43 am

Hi Jordan,

First, do not forget to check the latest stable version of eZ Find :
* http://ez.no/company/news/ez_systems_releases_apache_solr_based_open_source_enterprise_search_solution_ez_find_2_0
* http://ez.no/doc/extensions/ez_find
* http://ez.no/ezfind/download

You can use a bunch of Solr query syntax bits in the 'filter' parameter of the fetch function, among them a range search, with finite or unfinite bounds. A code example would be :

fetch( ezfind, search,
   hash( query, 'eZ Systems',
       filter, array( 'article/rating:[3 TO *]' 
            )))

This would return all articles containing the words 'ez' and 'systems', for which the rating is higher than 3. You could inverse the filter by using the following syntax in place :

[* TO 4]

I hope it helped,
Best Regards,

--
Nicolas Pastorino
Director Community - eZ
Member of the Community Project Board

eZ Publish Community on twitter: http://twitter.com/ezcommunity

t : http://twitter.com/jeanvoye
G+ : http://plus.tl/jeanvoye

eZ debug

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

Main resources:

Total runtime	0.0240 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.0046	588.4063	151.2422
Module start 'layout'	0.0047	0.0051	739.6484	220.7500
Module start 'content'	0.0098	0.0127	960.3984	999.0391
Module end 'content'	0.0225	0.0015	1,959.4375	33.9922
Script end	0.0240		1,993.4297

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0026	10.9237	14	0.0002
Check MTime	0.0010	4.2277	14	0.0001
Mysql Total
Database connection	0.0007	2.8029	1	0.0007
Mysqli_queries	0.0035	14.5755	3	0.0012
Looping result	0.0000	0.0705	1	0.0000
Template Total	0.0012	4.8	1	0.0012
Template load	0.0009	3.6985	1	0.0009
Template processing	0.0003	1.1289	1	0.0003
Override
Cache load	0.0006	2.6659	1	0.0006
General
dbfile	0.0010	4.2883	8	0.0001
String conversion	0.0000	0.0278	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