How to use facet with multiprice datatype?

Next topic

Author	Message
Nguyen Tien Hy	Friday 02 January 2009 1:49:28 am I have read ezfind_1.1_manual.pdf. I want to apply "a filter is specified by <class_identifier>/<class_attribute>[/<sub_structure]:<value>." to filter product objects (price attribute is multiprice datatype). How to do it? Question 1: Can I use "fetch( ezfind, search,hash( query, 'eZ Systems',filter, 'product/price/XXX:100000' ) )" ? Question 2: If yes, XXX = ??? Question 3: If not, could I write some code for ezmultiprice in php to solve it? Help me! Thanks!
Paul Borgermans	Thursday 08 January 2009 11:43:11 am Can you file a bug report in the ez find issue tracker? Thanks Paul eZ Publish, eZ Find, Solr expert consulting and training http://twitter.com/paulborgermans
Nguyen Tien Hy	Thursday 15 January 2009 7:59:43 pm I don't push a bug. I like to filter products by price range. I filtered objects of product class ProductA by using facet/filter. Price datatype of ProductA is ezprice. Everything OK. But when I filteredz objects of product class ProductB. Price datatype of ProductB is ezmultiprice, everything it not OK. I see in ezfind.ini as follows: " [SolrFieldMapSettings] # List of custom datatype mapping. eZ Publish datatype string is used # as key, and the value if the name of the class to use. # # Example: # CustomMap[eztext]=ezfSolrDocumentFieldText CustomMap[ezobjectrelation]=ezfSolrDocumentFieldObjectRelation CustomMap[ezobjectrelationlist]=ezfSolrDocumentFieldObjectRelation # Datatype to field type map. # # Example: DatatypeMap[eztext]=text DatatypeMap[ezboolean]=boolean DatatypeMap[ezdate]=date DatatypeMap[ezdatetime]=date DatatypeMap[ezfloat]=sfloat DatatypeMap[ezinteger]=sint <b>DatatypeMap[ezprice]=sfloat</b> DatatypeMap[eztime]=date # Default field type Default=text " <i>DatatypeMap[ezprice]=sfloat</i>. So <i>DatatypeMap[ezmultiprice]=???</i>. Some more php codes are needed? Help me! Thanks.
Nguyen Tien Hy	Thursday 12 March 2009 6:54:02 am I need to search my product objects that match the product price (multiprice datatype) in the range (from min_price to max_price). How to do that?
Paul Borgermans	Monday 16 March 2009 4:36:16 pm That is not possible right now, due to the (too simple) indexing of the multi-price datatype I crteated an enhancement issue for that Best regards Paul eZ Publish, eZ Find, Solr expert consulting and training http://twitter.com/paulborgermans
Mark Marsiglio	Monday 27 July 2009 8:50:41 pm Paul - can you comment on whether or not the ezfind fetch filter works with the price datatype? My guess is no based on the fact that the price datatype does not support search (is searchable is disabled). http://www.thinkcreative.com Turning Ideas Into Strategic Solutions

eZ debug

Timing:	Jan 18 2025 10:32:55
Script start
Timing:	Jan 18 2025 10:32:55
Module start 'layout'
Timing:	Jan 18 2025 10:32:55
Module start 'content'
Timing:	Jan 18 2025 10:32:55
Module end 'content'
Timing:	Jan 18 2025 10:32:55
Script end

Main resources:

Total runtime	0.4639 sec
Peak memory usage	4,096.0000 KB
Database Queries	70

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0065	588.0781	152.6406
Module start 'layout'	0.0065	0.0021	740.7188	39.4922
Module start 'content'	0.0086	0.4538	780.2109	621.1406
Module end 'content'	0.4625	0.0014	1,401.3516	16.1172
Script end	0.4638		1,417.4688

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	0.6888	16	0.0002
Check MTime	0.0013	0.2736	16	0.0001
Mysql Total
Database connection	0.0011	0.2449	1	0.0011
Mysqli_queries	0.4035	86.9951	70	0.0058
Looping result	0.0006	0.1278	68	0.0000
Template Total	0.4351	93.8	2	0.2175
Template load	0.0019	0.4161	2	0.0010
Template processing	0.4331	93.3720	2	0.2166
Template load and register function	0.0001	0.0282	1	0.0001
states
state_id_array	0.0008	0.1727	1	0.0008
state_identifier_array	0.0007	0.1569	2	0.0004
Override
Cache load	0.0017	0.3717	58	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0007	0.1541	3	0.0002
Fetch class attribute name	0.0009	0.1882	8	0.0001
XML
Image XML parsing	0.0010	0.2169	3	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0029	9	0.0000
General
dbfile	0.0009	0.1835	22	0.0000
String conversion	0.0000	0.0015	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
6	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
13	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
7	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
3	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: 31 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs