# Problem with select query in InfluxDB client and Chronograf

**URL:** <https://community.influxdata.com/t/problem-with-select-query-in-influxdb-client-and-chronograf/12563>\
**Category:** InfluxDB 2\
**Created:** [January 9, 2020, 12:32pm UTC](https://community.influxdata.com/t/problem-with-select-query-in-influxdb-client-and-chronograf/12563 "2020-01-09T12:32:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sadanand](https://avatars.discourse-cdn.com/v4/letter/s/a88e57/32.png) [@sadanand](https://community.influxdata.com/u/sadanand)\
**Post date:** [January 9, 2020, 12:32pm UTC](https://community.influxdata.com/t/problem-with-select-query-in-influxdb-client-and-chronograf/12563/1 "2020-01-09T12:32:28Z")

</div>

Hi Team ,

1.I am getting error while running the influx query

Query :-“SELECT “message” FROM “server\_logs”.“autogen”.“sos\_logs” where “path”=‘C:\FTAM24\SOS\_logs\wrapper.log’ limit 10”

Error is coming like:-"ERR: error parsing query: found \F, expected identifier, string, number, bool at line 1, char 76  
"

Could you help me with this condition?.

2.Similar kind of error i am also getting in Chronograf GUI below mention details

Query:"SELECT “message” FROM “server\_logs”.“autogen”.“sos\_logs” WHERE time \> :dashboardTime: AND “path”=‘C:\FTAM24\SOS\_logs\wrapper.log’ "

Error i am getting like:-“Request failed with status code 400”

 ![Chronograf_error_Screenshot](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/2X/8/8569ae13599f705efe79e4284aefdd901c503880.png) ![InfluxClientScreenshot](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/2X/4/49ca6f7c4ff7566931bafa15eef69dad07bb0a20.png)

---

<div class="post-metadata">

**Author:** ![Pooh](https://avatars.discourse-cdn.com/v4/letter/p/f05b48/32.png) [@Pooh](https://community.influxdata.com/u/Pooh)\
**Post date:** [January 9, 2020, 12:49pm UTC](https://community.influxdata.com/t/problem-with-select-query-in-influxdb-client-and-chronograf/12563/2 "2020-01-09T12:49:14Z")

</div>

> Hi Team ,
> 
> 1.I am getting error while running the influx query
> 
> Query :-“SELECT “message” FROM “server\_logs”.“autogen”.“sos\_logs” where  
> “path”=‘C:\FTAM24\SOS\_logs\wrapper.log’ limit 10”
> 
> Error is coming like:-"ERR: error parsing query: found \F, expected  
> identifier, string, number, bool at line 1, char 76 "

Have you tried escaping the backslash characters in the query, such as:

SELECT “message” FROM “server\_logs”.“autogen”.“sos\_logs” where “path”=‘C:  
\FTAM24\SOS\_logs\wrapper.log’ limit 10

> 2.Similar kind of error i am also getting in Chronograf GUI below mention  
> details
> 
> Query:"SELECT “message” FROM “server\_logs”.“autogen”.“sos\_logs” WHERE time
> 
> > :dashboardTime: AND “path”=‘C:\FTAM24\SOS\_logs\wrapper.log’ "
> 
> Error i am getting like:-“Request failed with status code 400”

My guess is the same solution will work for both problems.

Regards,

Antony.

---

<div class="post-metadata">

**Author:** ![sadanand](https://avatars.discourse-cdn.com/v4/letter/s/a88e57/32.png) [@sadanand](https://community.influxdata.com/u/sadanand)\
**Post date:** [January 10, 2020, 5:41am UTC](https://community.influxdata.com/t/problem-with-select-query-in-influxdb-client-and-chronograf/12563/3 "2020-01-10T05:41:09Z")

</div>

Hi Antony,

our “path” tag column contain the value “C:\FTAM24\SOS\_logs\wrapper.log”.

How I can change the original value of “path” tag column while running in influx query .

if I will escaping the backslash characters from the “path” tag column value definitely, I will not get the proper result.

Could you help me with one sample example?

---

<div class="post-metadata">

**Author:** ![sadanand](https://avatars.discourse-cdn.com/v4/letter/s/a88e57/32.png) [@sadanand](https://community.influxdata.com/u/sadanand)\
**Post date:** [January 10, 2020, 9:07am UTC](https://community.influxdata.com/t/problem-with-select-query-in-influxdb-client-and-chronograf/12563/4 "2020-01-10T09:07:26Z")

</div>

Hi Team ,

i got the solution for the above issues,

Thanks a lots!!

 ![image](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/2X/1/14d27174b03a142c47484f12169e19da84b1f2a3.png)