Hi, That is the expected behavior. In Lucene analysis process, the words like "will", "be", "as", "a" [1] or any special characters will be removed.
- time: [1422247320 TO 1482554520] AND webappName: "a" - time: [1422247320 TO 1482554520] AND webappName: "A" - time: [1422247320 TO 1482554520] AND webappName: "%" - time: [1422247320 TO 1482554520] AND webappName: "*" - time: [1422247320 TO 1482554520] AND webappName: "$" So all of the above queries will give zero records. You can prefix the underscore to any STRING field if you want to search for those special characters and stop words. That underscore prefixed field is indexed without removing the stop words. [1] On Wed, Apr 6, 2016 at 4:36 PM, Lochana Ranaweera <[email protected]> wrote: > Hi Supun, > > Yes, I can use that as a workaround. > > Thanks. > > On Wed, Apr 6, 2016 at 3:34 PM, Supun Sethunga <[email protected]> wrote: > >> Yes, noticed the same. Lucene query results the entire row set for >> particular cases (for certain single characters like: "a", "A" etc) as you >> have mentioned. Guess you can use *_webappName *as a workaround? >> >> @Gimantha: Is this an expected behavior? mind having a look? :) >> >> Thanks, >> Supun >> >> On Wed, Apr 6, 2016 at 3:02 PM, Lochana Ranaweera <[email protected]> >> wrote: >> >>> Hi Supun, >>> >>> It works with the query *time: [1422247320 TO 1482554520] AND >>> _webappName: "/" *in this example. Please note that there are no >>> webappNames with part of them matching ' / ', but still the search results >>> in entire set of records for the query *time: [1422247320 TO >>> 1482554520] AND webappName: "/" *(without the underscore-prefix). >>> >>> Thank you. >>> >>> On Wed, Apr 6, 2016 at 2:29 PM, Supun Sethunga <[email protected]> wrote: >>> >>>> Hi Lochana, >>>> >>>> Can you try with "time: [1422247320 TO 1482554520] AND *_webappName* >>>> :<any_value>" (note the underscore). "webappName" with >>>> underscore-prefix means to match the entire word, while just the " >>>> webappName"says to match any part of the word. >>>> >>>> Regards, >>>> Supun >>>> >>>> On Wed, Apr 6, 2016 at 1:58 PM, Lochana Ranaweera <[email protected]> >>>> wrote: >>>> >>>>> Hi all, >>>>> >>>>> I'm using the data explorer of the WSO2 DAS to search for records by a >>>>> query. The table is as follows: >>>>> >>>>> >>>>> >>>>> >>>>> In this table the column 'webappName' is of type STRING and it is >>>>> declared as a FACET field in order to search for webapps by the name. >>>>> >>>>> A list of records corresponding to the 'examples' webapp can be >>>>> inquired using the given query; *time: [1422247320 TO 1482554520] AND >>>>> webappName: "examples"*. However, the result for the query, *time: >>>>> [1422247320 TO 1482554520] AND webappName: "/"*, is the entire set of >>>>> records in the table, but not the records corresponding to webapp ' / ' in >>>>> the given time range. >>>>> >>>>> The following queries too resulted in the entire set of records in the >>>>> table: >>>>> >>>>> - time: [1422247320 TO 1482554520] AND webappName: "a" >>>>> - time: [1422247320 TO 1482554520] AND webappName: "A" >>>>> - time: [1422247320 TO 1482554520] AND webappName: "%" >>>>> - time: [1422247320 TO 1482554520] AND webappName: "*" >>>>> - time: [1422247320 TO 1482554520] AND webappName: "$" >>>>> >>>>> All the records in the given table satisfy the time range in the >>>>> queries. Except in the query, *time: [1422247320 TO 1482554520] AND >>>>> webappName: "examples"*,it seems the condition joined by the 'AND' is >>>>> ignored when webapp name takes the form " / " ," a ", " A ", " $ " , " * >>>>> " >>>>> or " %" . >>>>> >>>>> Appreciate your feedback on this matter. >>>>> >>>>> Regards, >>>>> -- >>>>> Lochana Ranaweera >>>>> Intern Software Engineer >>>>> WSO2 Inc: http://wso2.com >>>>> Blog: https://lochanaranaweera.wordpress.com/ >>>>> Mobile: +94716487055 <http://tel%2B716487055> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Dev mailing list >>>>> [email protected] >>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>> >>>>> >>>> >>>> >>>> -- >>>> *Supun Sethunga* >>>> Software Engineer >>>> WSO2, Inc. >>>> http://wso2.com/ >>>> lean | enterprise | middleware >>>> Mobile : +94 716546324 >>>> >>> >>> >>> >>> -- >>> Lochana Ranaweera >>> Intern Software Engineer >>> WSO2 Inc: http://wso2.com >>> Blog: https://lochanaranaweera.wordpress.com/ >>> Mobile: +94716487055 <http://tel%2B716487055> >>> >>> >> >> >> -- >> *Supun Sethunga* >> Software Engineer >> WSO2, Inc. >> http://wso2.com/ >> lean | enterprise | middleware >> Mobile : +94 716546324 >> > > > > -- > Lochana Ranaweera > Intern Software Engineer > WSO2 Inc: http://wso2.com > Blog: https://lochanaranaweera.wordpress.com/ > Mobile: +94716487055 <http://tel%2B716487055> > > -- Gimantha Bandara Software Engineer WSO2. Inc : http://wso2.com Mobile : +94714961919
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
