How to update POWL cache in the feeder class

[former_member99563]

Hi All,

I need to update POWL cache in the feeder class, While user removing the selected entries we will synchronize it to DB directly. But I have no idea how to update the POWL cache, Do you know any method to implement it?

Thank you very much!

Julia

[NeeleshJ]

Hi Julia,

You can refresh the powl cache by calling the method REFRESH_ALL_QUERIES() of class CL_POWL_COLLECTOR_HELPER with following parameters:

1. application Id

2. boolean flag iv_dismiss_cache as true.

or if you want to do it for specific query use the other method delete_cached_results() of this class.

Regards,

Neel

[yesrajkumar]

Hi,

Try to use the below program that will help in refreshing the POWL cache.

u2022 POWL_WLOAD - refresh POWL cache when changing POWERLIST logic during a session & define refresh interval for cached queries, set flag, Discard old cached results.

Thanks,

Rajkumar.S

[Former Member]

Hi,

In the Handle_Action method of your POWL feeder class there is an exporting param named as E_DO_REFRESH, try setting this to TRUE.

In the description of this param it says " trigger a complete query refresh ".

Hope this helps

Regards

Manas Dua

[former_member99563]

Hi Manas Dua,

Thanks you very much for your help. But there will be lots of data in the result, considering the performance, it's better just update the cache.

Best regards

Julia

[ChrisPaine]

Hi Julia,

does not the "complete query refresh" use the same instance of the POWL handler that you are currently working with?

Could you not just set up class attributes in the handler to hold all the data in cache yourself - update this local cache, and serve this back to any requests to refresh? Perhaps another attribute to ensure that if the user actually clicks refresh it does do a full DB refresh..

Cheers,

Chris

[Former Member]

Hi,

In your method Handle_Action changing C_RESULT_TAB is nothing but a sort of local cache which sends the data to be displayed in POWL.

Can you try deleting the selected row ( can be fetched from c_selected ) from this C_RESULT_TAB parameter.

I guess this should do the trick.

Also when you change C_RESULT_TAB, then do remember to set the parameter E_RESULT_LINES_CHANGED as true.

Regards

Manas Dua