Is it possible to run kRunCacheManager from execution step for only current request?
Requirement is, executing update statement from execution step which is updating table component data. But after executing the step I am not seeing the updated data immediately on the request. Hence added another execution step which is clearing table component cache. Once table component cache clear execution step I can see the updated data in my request. But the only disadvantage with this step is , it clears the cache of all table components available on all the requests in the system and performance will degrade.
Looking for a solution so that it clears only current requests table component cache.
We are also updating various parameters via execution steps and all the updated immediately without running the kRunCacheManager.sh with another execution step. You can try updating the parameters as shown below:
UPDATE kcrt_request_details SET parameter1 = '' visible_parameter1 ='', last_update_date = SYSDATE WHERE request_id = id and batch_number = 6;
UPDATE kcrt_requests SET entity_last_update_date = SYSDATE WHERE request_id = id;