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 <locha...@wso2.com> 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 > Dev@wso2.org > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- *Supun Sethunga* Software Engineer WSO2, Inc. http://wso2.com/ lean | enterprise | middleware Mobile : +94 716546324
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
