Yes. It can be any special character*. *But we use : to match a field to a value. Like,
<FieldName> : <FieldValue> On Thu, Mar 24, 2016 at 12:03 PM, Damith Wickramasinghe <dami...@wso2.com> wrote: > 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 <%2B94728671315>* > > -- Gimantha Bandara Software Engineer WSO2. Inc : http://wso2.com Mobile : +94714961919
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
