Update RuleGroup.lastModifiedDate whenever rules are added, updated, or archived

[ravilodhi]

What is the motivation for adding/enhancing this feature?

Currently, every time the ATP rule group executes, it generates a complete CSV containing all eligible products. It does not take into account whether a product has been modified since the last execution or whether the rules have changed since the last run. This results in the CSV being generated with the same data repeatedly, even when there are no changes.

To address this, consider the following approach:

If the rule group has been modified (e.g., new rules are added, existing rules are updated, or archived) since the last successful execution, process all products.
If the rule group has not been modified, only fetch products that have been updated since the last successful rule group execution. Use the updatedDatetime from the Product Solr document for this purpose.

What are the acceptance criteria?

RuleGroup.lastModifiedDate is updating correctly whenever rules are added, updated, or archived.

• ...

Can you complete this feature request by yourself?

• YES
• NO

Additional information