How - t o create a Full Text Index on ERP5<br/>author: Rafael Monnerat Al t e r Compatibility Table Go to /instance_name / p o r t a l _ c a t a l o g / e r p 5 _ m y s q l ( in ZMI) and acess and run ( test) the Z SQL Method 'z0_drop_compatibility'. This DROP the compatibility table on mysql. In same folder, modify the Z SQL Method 'z_create_compatibility'. Add the index and alter the Table Type. The new end of file will be:<br/>KEY `review_state ` (`review_state ` ) , FULLTEXT(`SerachableText ` ) } TYPE=MyISAM<br/><br/>Run ( test) the ZSQLMethod to create the table.<br/><br/>Edit catalog properties Go to /instance_name / p o r t a l _ c a t a l o g / e r p 5 _ m y s q l ( in ZMI ) and edit the properties ( properties tab ). With CRTL press, mark these options:<br/><br/>s q l_ c a t a l o g _ o b j e c t _ l i s t s q l_ s e a r c h _ t a b l e s s q l_ c a t a l o g _ f u l l_ t e x t _ s e a r c h _ k e y s<br/><br/>z_c a t a l o g _ c o m p a t i b i l i t y _li s t co m p a t i b i li t y Se r a c h a b l e T e x t co m p a t i b i li t y .Se a r c h a b l e T e x t<br/><br/>Now the ERP5 use the compatibility table to catalog all objects too.<br/><br/>Add Full Text Search to Portal T h e normal portal Search Box don't do the full text Search. The portal needs a new Z SQL Method. This is just a simple and pratical example. Cr e a t e ZSQL Method In portal_catalog contents, create a Z SQL METHOD with name 'FTSearch' and argument 'SearchableText'. The code is:<br/><br/>SELECT catalog.path, catalog.uid, catalog.title, catalog.portal_type, catalog.description FROM compatibility , catalog WHERE compatibility.uid = catalog.uid AND MATCH (`SearchableText ` ) AGAINST (&lt;dtml - s q l v a r expr=&quot;SearchableText&quot; type=&quot;string&quot;&gt;)<br/><br/><br/>Doing search and show the results In folder portal_skin / c u s t o m add a ZPT with name 'ftsearch_results_tem p l a t e ' and the code: &lt; h t m l metal:use - m a c r o = &quot; c o n t e x t / m a i n _ t e m p l a t e / m a c r o s / m a s t e r &quot; &gt; &lt;body &gt; &lt; m e t a l : s l o t metal:fill- sl o t = &quot; h e a d e r &quot; i18n:domain = &quot; c m f _ d e f a u l t &quot; &gt; &lt; h 1 i18n:translate = &quot; &quot; &gt; S e a r c h Results &lt; / h 1 &gt; &lt; / m e t a l: sl o t &gt; &lt; d i v class = &quot; D e s k t o p &quot; &gt; &lt; m e t a l : s l o t metal:fill- sl o t = &quot; m a i n &quot; i18n:domain = &quot; c m f _ d e f a u l t &quot; &gt; &lt; t a b l e class = &quot; S e a r c h R e s u l t s &quot; tal:define = &quot; b a t c h python:here.portal_catalog.FTSearch(SearchableText = r e q u e s t . S e a r c h a b l e T e x t )&quot; &gt; &lt;thead &gt; &lt;tr &gt; &lt;th i18n:translate = &quot; &quot; &gt; T i t l e &lt; / t h &gt; &lt;th i18n:translate = &quot; &quot; &gt; T y p e &lt; / t h &gt; &lt;/tr&gt; &lt;/thead &gt; &lt;tbo d y tal:repeat = &quot; i t e m batch&quot;&gt; &lt;tr &gt; &lt;td &gt; &lt;a href = &quot; &quot; tal:attributes = &quot; h r e f python:item[0]&quot;&gt; &lt;span tal:condition = &quot; p y t h o n : i t e m [ 2 ] &quot; tal:replace = &quot; p y t h o n : i t e m [ 2 ]&quot; &gt; T i t l e &lt; / s p a n &gt; &lt;span tal:condition = &quot; n o t : p y t h o n : i t e m [ 2 ]&quot; tal:omit - t a g = &quot; &quot; i18n:translate = &quot; &quot; &gt; ( N o title)&lt; / s p a n &gt; &lt;/a&gt; &lt;/td&gt; &lt;td tal:content = &quot; p y t h o n : i t e m [ 3 ] &quot; i18n:translate = &quot; &quot; &gt; T y p e &lt; / t d &gt; &lt;/tr&gt; &lt;tr &gt; &lt;td &gt; &amp; n b s p ; &lt; / t d &gt; &lt;td colspan = &quot; 3 &quot; &gt; &lt;em tal:condition = &quot; p y t h o n : i t e m [ 4 ]&quot; tal:content = &quot; p y t h o n : i t e m [ 4 ] &quot; &gt; D e s c r i p t i o n &lt; / e m &gt; &lt; e m tal:condition = &quot; p y t h o n : n o t ( i t e m [ 4 ] )&quot; i18n:translate = &quot; &quot; &gt; ( N o description)&lt; / e m &gt; &lt; / t d &gt; &lt;/tr&gt; &lt;/tbody&gt; &lt; / t a ble &gt; &lt; / m e t a l: sl o t &gt; &lt; / div &gt; &lt;/body &gt; &lt;/html &gt;<br/><br/><br/>Alter navagation_box T o finish alter the navegation_box in portal_skin / e r p 5 _ h t m l _ s t y l e . Put on line 177 the new method:<br/>title=&quot;Search&quot; alt=&quot;Search&quot; name=&quot; tsearch_results_template:method f &quot;<br/><br/>O n l y the button do the search, if you press enter you don't do the execute these metho d . About the Mysql FULLTEXT index you cam find more information on reference guide on mysql site. I'm use the default config, but you can modify to improve y o u r search.<br/><br/>AB OU T Au t h o r : Rafael Monnerat M ai l : rmonnerat@gmail.com We b S i t e : http: / / m o n n e r a t . o b j e c t i s . n e t ( In portuguese) Do c u m e n t source ( .odt ) on my website ( erp5 section ). Mail me for any question or use the lists!