Or you can use _correlation_date:15-02-2016 if you have indexed correlation_date as STRING. (note that I have used "_" in front of "correlation_date". Every field which is indexed as STRING has_<field>. This is to facilitate the exact string search.
On Tue, Feb 16, 2016 at 9:47 PM, Gimantha Bandara <[email protected]> wrote: > Hi Gayan, > > I think you will have to escape the "-" in the correlation_date. Can you > try the same query with "-" escaped? > > Thanks, > > On Tue, Feb 16, 2016 at 9:26 PM, Gayan Dhanushka <[email protected]> wrote: > >> Hi all, >> >> I am using [1] to retrieve some data from an event store. I have all the >> required fields indexed in it. I am trying to query with multiple >> attributed as per following curl command which seems to be not working. >> >> *curl -X POST -H "Content-Type: application/json" -H "Authorization: >> Basic YWRtaW46YWRtaW4=" -v https://172.17.0.1:9448/analytics/search >> <https://172.17.0.1:9448/analytics/search> -d >> '{"tableName":"ORG_TFL_GOV_ERROR_CODES", >> "query":"error_name:GLB_Java_Parse_Exception AND >> correlation_date:15-02-2016", "start":0, "count":3}' -k* >> >> *response* >> >> [ >> { >> "id":"11eb5c96-7753-e62f-bcdd-df440859299e", >> "tableName":"ORG_TFL_GOV_ERROR_CODES", >> "timestamp":1.455543492647E12, >> "values":{ >> "_version":"1.0.0", >> "error_name":"GLB_Java_Parse_Exception", >> "error_code":"TDS-Java-ParseException-1005", >> "correlation_date":"*15-02-2016*", >> "file_name":"001_247703b0a218_2013-09-19-00_00_02_65.99001", >> "file_type":"122", >> "correlation_timestamp":1.455543492648E12 >> } >> }, >> { >> "id":"bedd3b97-8ce7-ee6f-8485-1168199ca648", >> "tableName":"ORG_TFL_GOV_ERROR_CODES", >> "timestamp":1.455621910429E12, >> "values":{ >> "_version":"1.0.0", >> "error_name":"GLB_Java_Parse_Exception", >> "error_code":"GLB_Java_Parse_Exception", >> "correlation_date":"*16-02-2016*", >> "file_name":"001_247703b0a218_2013-09-18-00_00_01_65.99001", >> "error_desc":"Java Parse Exception Returned by the following >> class : class org.tfl.gov.MessageBuilder", >> "file_type":"HEALTHCHECK", >> "correlation_timestamp":1.455621910429E12 >> } >> }, >> { >> "id":"c2f7488a-ea9c-f224-fc28-79ea0669813b", >> "tableName":"ORG_TFL_GOV_ERROR_CODES", >> "timestamp":1.455459013158E12, >> "values":{ >> "_version":"1.0.0", >> "error_name":"GLB_Java_Parse_Exception", >> "error_code":"TDS-Java-ParseException-1005", >> "correlation_date":"*01-01-2016*", >> "file_name":"xyz", >> "file_type":"HEALTHCHECK", >> "correlation_timestamp":1.451685333E12 >> } >> } >> ] >> >> Please note that even though I am using correlation_date:15-02-2016 in >> the query I have received results for other dates as well. >> >> Can someone explain this. What am I doing wrong in here ? >> >> >> [1] >> https://docs.wso2.com/display/DAS300/Retrieving+All+Records+Matching+the+Given+Search+Query+via+REST+API >> >> -- >> Gayan Dhanuska >> Software Engineer >> http://wso2.com/ >> Lean Enterprise Middleware >> >> Mobile >> 071 666 2327 >> >> Office >> Tel : 94 11 214 5345 >> Fax : 94 11 214 5300 >> >> Twitter : https://twitter.com/gayanlggd >> > > > > -- > Gimantha Bandara > Software Engineer > WSO2. Inc : http://wso2.com > Mobile : +94714961919 > -- Gimantha Bandara Software Engineer WSO2. Inc : http://wso2.com Mobile : +94714961919
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
