Appending information to an index

I've connected to an Oracle databse via JDBC input. This is pretty new so I'm trying to figure out how to model this.

In the database there is a bug table, with rows of bugs that each have a unique ID. I want to make it so that logstash will periodically draw the bugs from the database and the user could search for bugs and view changes over time (opened, closed, reopened, etc).
I can't seem to make it so that the information will be appended to a document(or even creat a whole new document but only for those that changed). When i use the "action" parametre in elastcsearch ouput plugin it simply overwrites the existing document when using document_id or duplicate all the data without the id.

thank you very much,