Hi,
I have many places with multiple products linked to each place (with product_id and model_id) Each product_id has a fixed Product_PM coverage end date (ex 31.12.2024). This end date prevents users from creating new tasks or inspections if it is earlier than the current date.
Manually modifying the coverage end date automatically updates the new slots in PM schedules. But with sql update query it changes the coverage end date value but not updating slots in PM schedules.
Problem: I need to update the coverage end date for 1,000 product_id’s across 1,000 places.
It would be greta help if any one has solution or suggestion how to solve this.
Thanks and Regards,
Akshay.