If I'm not mistaken, SQL Server can perform fulltext queries using wildcards with prefixes with something like:
Select column from table where contains (column, '"string*"'); From: [email protected] [mailto:[email protected]] On Behalf Of Alain Escaffre Sent: lunes, 07 de junio de 2010 18:15 To: Alberto Chaparro Terleira Cc: [email protected] Subject: Re: [Ecm] ECM FULLTEXT QUERIES Hi, Full-text field query syntax doesn't accept wildcard character such as % in standard. Yet, some underlying full-text engine accept it, such as Oracle. In that case, it would be required an evolution to "expose" the feature in NXQL syntax. Regarding SQL Server, I don't see such feature in SQL Server full text documentation (http://msdn.microsoft.com/en-us/library/ms142571.aspx) Regards Alain On Mon, Jun 7, 2010 at 5:40 PM, Alberto Chaparro Terleira <[email protected]> wrote: Hi friends, I have a NUXEO 5.3.1 with MS SQL 2005, is it possible this kind of query in MS SQL: SELECT * FROM Document WHERE ecm:fulltext LIKE '%tes%'? This query doesn't return results. Otherwise, if I execute this: SELECT * FROM Document WHERE ecm:fulltext = 'test', it runs correctly. Is it not possible to use % character with ecm:fulltext field? Thank you in advance. Alberto Chaparro Terleira Atos Origin Technological Solutions TELF: 91 126 72 92 T [email protected] ------------------------------------------------------------------ This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Atos Origin group liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted. Este mensaje y los ficheros adjuntos pueden contener informacion confidencial destinada solamente a la(s) persona(s) mencionadas anteriormente pueden estar protegidos por secreto profesional. Si usted recibe este correo electronico por error, gracias por informar inmediatamente al remitente y destruir el mensaje. Al no estar asegurada la integridad de este mensaje sobre la red, Atos Origin no se hace responsable por su contenido. Su contenido no constituye ningun compromiso para el grupo Atos Origin, salvo ratificacion escrita por ambas partes. Aunque se esfuerza al maximo por mantener su red libre de virus, el emisor no puede garantizar nada al respecto y no sera responsable de cualesquiera danos que puedan resultar de una transmision de virus. ------------------------------------------------------------------ _______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm -- Alain Escaffre, Avant-vente / Presales (c) +33629370451 Skype : alain_escaffre Nuxeo, Paris - Boston http://www.nuxeo.com ------------------------------------------------------------------ This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Atos Origin group liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted. Este mensaje y los ficheros adjuntos pueden contener informacion confidencial destinada solamente a la(s) persona(s) mencionadas anteriormente pueden estar protegidos por secreto profesional. Si usted recibe este correo electronico por error, gracias por informar inmediatamente al remitente y destruir el mensaje. Al no estar asegurada la integridad de este mensaje sobre la red, Atos Origin no se hace responsable por su contenido. Su contenido no constituye ningun compromiso para el grupo Atos Origin, salvo ratificacion escrita por ambas partes. Aunque se esfuerza al maximo por mantener su red libre de virus, el emisor no puede garantizar nada al respecto y no sera responsable de cualesquiera danos que puedan resultar de una transmision de virus. ------------------------------------------------------------------
_______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
