[Erp5-dev] Search text

[pavel lstiburek]

HI,
I an not the one who instal it, but it is local slapos, with
erp5_full_text_myisam_catalog<http://bsys2.dyndns.org:12001/erp5/portal_templates/6?ignore_layout:int=1&editable_mode:int=1&selection_name=business_template_selection&selection_index=0&reset:int=1>,
verzion 5.4.7. revision 4.
I run the script and i get results:

first good page:
SELECT DISTINCT
   catalog.path,   catalog.uid
FROM
             full_text AS related_child_address_SearchableText_1_full_text,
catalog AS catalog, catalog AS related_child_address_SearchableText_catalog

WHERE
  1 = 1
  AND (((`catalog`.`security_uid` IN (73, 74, 75, 76, 77, 78, 79, 80, 81,
82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93)
  OR `catalog`.`viewable_owner` = 'zope')
  AND `catalog`.`portal_type` = 'Person'
  AND `related_child_address_SearchableText_1_full_text`.`SearchableText`
LIKE '%praha 7%')
  AND (catalog.uid = related_child_address_SearchableText_catalog.parent_uid
AND related_child_address_SearchableText_catalog.portal_type = 'Address'
AND related_child_address_SearchableText_catalog.uid =
 related_child_address_SearchableText_1_full_text.uid))
LIMIT 1000

second bad page:

SELECT DISTINCT
   catalog.path,   catalog.uid    ,MATCH
(`related_child_address_SearchableText_1_full_text`.`SearchableText`)
AGAINST ('%praha 7%') AS `SearchableText`
FROM
             full_text AS
related_child_address_SearchableText_1_full_text, catalog AS catalog,
catalog AS related_child_address_SearchableText_catalog
WHERE
  1 = 1
  AND (((`catalog`.`security_uid` IN (73, 74, 75, 76, 77, 78, 79, 80,
81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93)
  OR `catalog`.`viewable_owner` = 'zope')
  AND `catalog`.`portal_type` = 'Person'
  AND MATCH (`related_child_address_SearchableText_1_full_text`.`SearchableText`)
AGAINST ('%praha 7%'))
  AND (catalog.uid = related_child_address_SearchableText_catalog.parent_uid
AND related_child_address_SearchableText_catalog.portal_type = 'Address'
AND related_child_address_SearchableText_catalog.uid =
related_child_address_SearchableText_1_full_text.uid))
LIMIT 1000


Is it possible to change some script to get the same result? or instal some
other fulltext business template to get better results?

Pavel Lstiburek
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20120630/4d84cc72/attachment.htm>