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
_______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
