Hi Gimantha, Great. One question. Does it can be any special character. ?
Regards, Damith. On Thu, Mar 24, 2016 at 11:49 AM, Gimantha Bandara <giman...@wso2.com> wrote: > Hi Damith, > > If the "roles" field contains comma separated values, you can simply > search for the specific role using the following query > > "roles : role1" > > > Lucene has an analysis process which takes place before indexing. So the > field values will be tokenized into terms(Text fields are split removing > special characters) , stop words.. etc. In your case, the whole string > "role1, role2, role3" will be tokenized into "role1", "role2" and "role3". > So you can perform a usual search query as I mentioned above. > > On Thu, Mar 24, 2016 at 11:35 AM, Damith Wickramasinghe <dami...@wso2.com> > wrote: > >> Hi all, >> >> I have a column which contains roles as a comma separated string. eg:- >> role1,role2,role3 >> >> I need to find records which matches to specific role. As I checked >> theres no String contains function. But there is wildcard support[1]. To be >> able to work for my usecase wildcard should be of type *role1*. But leading >> wild cards are not supported. But as per the [2] Lucene 2.1, they can be >> enabled by calling QueryParser.setAllowLeadingWildcard( true ). May I >> know whether there is a configuration in DAS to enable this. Also even this >> can be achieved I think this will be an expensive operation. If so is there >> a best way to achieve this? eg:-custom UDF >> >> [1]http://www.lucenetutorial.com/lucene-query-syntax.html >> [2]https://wiki.apache.org/lucene-java/LuceneFAQ >> >> Thanks, >> Damith. >> >> -- >> Software Engineer >> WSO2 Inc.; http://wso2.com >> <http://www.google.com/url?q=http%3A%2F%2Fwso2.com&sa=D&sntz=1&usg=AFQjCNEZvyc0uMD1HhBaEGCBxs6e9fBObg> >> lean.enterprise.middleware >> >> mobile: *+94728671315 <%2B94728671315>* >> >> > > > -- > Gimantha Bandara > Software Engineer > WSO2. Inc : http://wso2.com > Mobile : +94714961919 > -- Software Engineer WSO2 Inc.; http://wso2.com <http://www.google.com/url?q=http%3A%2F%2Fwso2.com&sa=D&sntz=1&usg=AFQjCNEZvyc0uMD1HhBaEGCBxs6e9fBObg> lean.enterprise.middleware mobile: *+94728671315*
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev