# Logstash-input-jdbc append where clause?
**URL:** https://discuss.elastic.co/t/logstash-input-jdbc-append-where-clause/135442
**Category:** Logstash
**Created:** [June 12, 2018, 12:08am UTC](https://discuss.elastic.co/t/logstash-input-jdbc-append-where-clause/135442 "2018-06-12T00:08:58Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@dmongit](https://discuss.elastic.co/u/dmongit)
#### Post date: [June 12, 2018, 12:08am UTC](https://discuss.elastic.co/t/logstash-input-jdbc-append-where-clause/135442/1 "2018-06-12T00:08:58Z")
I want to reuse some query files. I'm using jdbc statement\_filepath for a logstash input that is NOT on a schedule. I have another jdbc input with statement\_filepath with a very similar query that IS on a schedule. In fact, the queries are the same, except the scheduled input has a where clause on it.
Is there a way to append a where clause to my statement\_filepath? Since the first, not scheduled, query retrieves all data, I didn't want to use a post query filter (unless I had to).
The only thing that comes to mind is creating a new file from a base file and add that new query file to my docker container. That could work, but seems dirty if the ELK world already has it resolved.
I'm using mysql-connector-java-5.1.46 for my driver library if that matters.
Thanks!
---
### Author:  [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [June 12, 2018, 6:07am UTC](https://discuss.elastic.co/t/logstash-input-jdbc-append-where-clause/135442/2 "2018-06-12T06:07:02Z")
> Is there a way to append a where clause to my statement\_filepath?
No, not from within Logstash.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 10, 2018, 6:11am UTC](https://discuss.elastic.co/t/logstash-input-jdbc-append-where-clause/135442/3 "2018-07-10T06:11:02Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.