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
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
