Kentico does not touch any dummy cache keys when changes occur for data submitted via forms.

I'd suggest debugging your cache keys. There's a good chance you're key is too generic and simply caching the whole "leads" table when it should cache a different dataset.

Maybe caching is not needed on the custom tables, maybe you simply need to only get the form data that's been updated over the last "X" hours and run through the leads/action tables based on that database of updated/inserted form data. Then there's no need to even deal with the caching issues.

Just adding link to documentation on debugging cache :-)

Juraj, I will check out the 'debugging' cache link. Brenden, we have to pull back the entire table. Our dealers need to query the data, so pulling back the past hour would not do. However I believe you are suggesting (if I understand correctly), when pulling back the recent submissions you would not have the caching issues otherwise experienced.

Ok Tom, you didn't mention anything initially about an additional query the sales people needed to perform. How does this relate to the insert and update action in the custom tables?

This was an inhouse built Leads Management process. So leads are downloaded hourly from the company's contact us, request quote, download forms, etc., into the leads management table. With each download a history entry is created. Then on the front facing the dealer can view leads within their territories assigned to them by management. We have created filters to narrow the search when the data is brought back for a search (to update the leads, and set status; assigned, won, dead, etc.). So with re-engagement by a client / customer. The dealers need to view updated comments (the past comments are in the history or action tab to view). However the new comments are not showing up unless the Kentico cache is cleared...or after a period of time and returning to a fresh browser. The data is there...just that the cache is not clearing. Just wanted to give some further background on the issue/ project it is used on. Thanks.

Just verify if you are caching the table items multiple times using a different Key.

Ashish, how would you go about confirming this ("Just verify if you are caching the table items multiple times using a different Key."). Thanks.

If possible, please your code where you are caching the items.

Like I first stated, debug your cache keys using Kentico.