attribute_filter on xmltext and text fields?

«

Previous topic

|

|

Next topic

»

Author	Message
Gabriel Ambuehl	Friday 07 October 2005 5:17:15 am Is there a way to do a fetch like attribute_filter(textfield, like, "some keyword") on text fields and xml text fields? Or do I need to write my own filter? Thanks anyway! Visit http://triligon.org
Paul Borgermans	Friday 07 October 2005 6:43:30 am Yes, My patch landed in the core since 3.6: http://pubsvn.ez.no/nextgen/stable/3.6/doc/features/3.6/content_tree_enhanced_filters.txt -paul eZ Publish, eZ Find, Solr expert consulting and training http://twitter.com/paulborgermans
Hans Melis	Friday 07 October 2005 8:33:32 am The 'like' operator indeed exists since 3.6, but the eztext and ezxmltext datatypes unfortunately don't support attribute filtering. There wouldn't be a problem to implement it if the content of the datatypes contains less than 256 characters. In case there are more characters, some truncating is needed which is kind of pointless for those datatypes (the database field for string attribute filtering is a VARCHAR(255) in mysql and pgsql). I think it's possible to implement what you want using extended attribute filtering. Just do an sql LIKE operation on the data_text field for the datatypes. Hans http://blog.hansmelis.be
Gabriel Ambuehl	Friday 07 October 2005 8:45:13 am Yes, it works like a charm for text line but I was wondering about the two "long string" types, mostly. I'll likely write an extended attribute filter some time (or maybe see if I can hack the core and submit it as patch), but for the time being, I'll likely be able to get away without it ;) Visit http://triligon.org
Paul Borgermans	Friday 07 October 2005 11:20:12 am For longer text fields, why not use the search as a fetch function? The like operator may slow things a lot in this case? -paul eZ Publish, eZ Find, Solr expert consulting and training http://twitter.com/paulborgermans
Gabriel Ambuehl	Friday 07 October 2005 11:55:14 am I was thinking about that. And also just using a custom join on the search table. Haven't made up my mind yet ;) Visit http://triligon.org

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 20 2025 17:41:23
Script start
Timing:	Jan 20 2025 17:41:23
Module start 'layout'
Timing:	Jan 20 2025 17:41:23
Module start 'content'
Timing:	Jan 20 2025 17:41:23
Module end 'content'
Timing:	Jan 20 2025 17:41:23
Script end

Main resources:

Total runtime	0.0165 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0060	589.5703	151.2266
Module start 'layout'	0.0061	0.0030	740.7969	36.6797
Module start 'content'	0.0090	0.0058	777.4766	94.0938
Module end 'content'	0.0148	0.0016	871.5703	37.9922
Script end	0.0165		909.5625

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0026	15.9850	14	0.0002
Check MTime	0.0011	6.8057	14	0.0001
Mysql Total
Database connection	0.0009	5.7100	1	0.0009
Mysqli_queries	0.0029	17.4143	3	0.0010
Looping result	0.0000	0.0910	1	0.0000
Template Total	0.0012	7.2	1	0.0012
Template load	0.0009	5.5223	1	0.0009
Template processing	0.0003	1.6588	1	0.0003
Override
Cache load	0.0006	3.7970	1	0.0006
General
dbfile	0.0012	7.0454	8	0.0001
String conversion	0.0000	0.0520	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