Keyword search logic

Author Message

Tony Wood

Thursday 25 September 2003 7:59:12 am

Could we have a feature where you can turn on left str logic on a class.
i.e if you enter a keyword as "cloud" the keyword search system should also find "clouds".

It could be as simple as matching the first part of a word or maybe in time some fuzzy logic routine.

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future

Alex Jones

Thursday 25 September 2003 8:28:52 am

Partial Word matching and wildcards would be immensely helpful! There is a lot of pressure for me to install an engine that provides these capabilities, but I would prefer to use the one built into eZ publish.

Alex

Alex
[ bald_technologist on the IRC channel (irc.freenode.net): #eZpublish ]

<i>When in doubt, clear the cache.</i>

Paul Forsyth

Thursday 25 September 2003 8:36:27 am

Does sql support wildcards when searching for a match? Im no expert with sql (mysql/postsql) so not sure if allowing a '*' through will have the desired effect.

There is a bug report for some of this:

http://ez.no/developer/ez_publish_3/bug_reports/search_wildcard_searches_dont_work

It sounds like it should work in 3.2...

paul

suse erdbeer

Friday 03 September 2004 9:56:38 am

hello everybody,
I'm a newcomer and need to know how the MySQL search logic works in general. Are there informations in the www? Have trouble to find something..

Thanks a lot!
suse

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

Main resources:

Total runtime0.4968 sec
Peak memory usage4,096.0000 KB
Database Queries64

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0058 587.9063152.6250
Module start 'layout' 0.00580.0030 740.531339.4297
Module start 'content' 0.00880.4866 779.9609617.6328
Module end 'content' 0.49540.0014 1,397.593812.1875
Script end 0.4968  1,409.7813 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00330.6705160.0002
Check MTime0.00140.2872160.0001
Mysql Total
Database connection0.00110.219010.0011
Mysqli_queries0.446089.7669640.0070
Looping result0.00060.1121620.0000
Template Total0.462593.120.2312
Template load0.00190.378020.0009
Template processing0.460692.703020.2303
Template load and register function0.00010.022410.0001
states
state_id_array0.00090.180810.0009
state_identifier_array0.00100.206120.0005
Override
Cache load0.00150.3023220.0001
Sytem overhead
Fetch class attribute can translate value0.00090.187040.0002
Fetch class attribute name0.00130.258560.0002
XML
Image XML parsing0.00100.208740.0003
class_abstraction
Instantiating content class attribute0.00000.002060.0000
General
dbfile0.00080.1682220.0000
String conversion0.00000.001240.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
2content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
4content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
3content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
5content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 16
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs