How to create a search using DB connect and using the rising column query to ingest the same?

[Splunk4]

Hi Everyone,

I am trying to ingest the change related data from database using DB connect and using the rising column to ingest the same. I have specified the changerequestID as the rising column. Data has other fields as well such as creationtime,Lastmodifiedtime,Solvedtime etc.If a change is open then the entry in the database for column values such as LastModifiedtime,Solvedtime can be blank so in that case my query is if the these values get updated in the DB after sometime but since the entry before updating has already been ingested in splunk via rising column then will it get ingested in splunk?

Thanks

[richgalloway]

The column used as the Rising Column must change every time that row is modified.  If it does not change then Splunk will not read that row and the new data will not be indexed.