Forum

The forum is a free service supported by community members. Please consider opening a support ticket if you need timely help.

PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 17 May 2024 08:43 AM by  Kamil Maciaszek
Creating sales promotion in database and refreshing RevIndex.
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages


New Member


Posts:50
New Member


--
15 May 2024 11:21 AM

    Our DNN+RevIndex setup is integrated with our custom software solution. There is a business process where on certain circumstances new Sales Promotion with XSLT rule is created and inserted into dbo.Revindex_Storefront_SalesPromotion table.

    Created rule doesn't work unless we invoke manually Configuration->General->Clear cache. After Clear cache the promotion rule works.

    What should we do to 'refresh' Revindex data to apply newly created SalesPromotion?

    Is there a way to invoke 'Clear cache' programatically through some API/stored procedure on SQLServer/TaskScheduler?

    0


    Veteran Member


    Posts:2963
    Veteran Member


    --
    15 May 2024 10:59 PM

    Hi,

    Using the Task scheduler you can call the Storefront .NET to clear cache. Please note this is an unsupported feature but would work.

    new Revindex.Business.Revindex.Revindex.Storefront.SalesPromotionController().ClearCache(0);

    where 0 is the portal ID.

     

    0


    New Member


    Posts:50
    New Member


    --
    17 May 2024 08:43 AM
    Thank you! It works.
    0
    You are not authorized to post a reply.