Hi I'm using query database on my mysql database table. I'm able to perform a simple query like "select * from table_name" successfully.
I want to fetch records on incremental basis, i.e i want to pull the newest record every time the processor runs. But the processor doesn't store any state from "view state". Also i want to mention that my table's first column is a alphanumeric code eg. AL0031.
Can you please suggest me a way to fetch records incrementally from my mysql DB table.