Skip to main content
Question

Update of coverage_start_dt and end_dt of product_pm

  • January 17, 2025
  • 4 replies
  • 36 views

Forum|alt.badge.img+2

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.

4 replies

Forum|alt.badge.img+9
  • Hero (Employee)
  • 96 replies
  • January 20, 2025

Hi ​@RTTPAAKDE ,

You are correct if you update anything via sql, FSM will not know that the change was made and none of the business logic or business rules will get triggered. 

Have you tried to use a mass update xml or to add a mass update button to the contract screen? Also don’t forget that once you modify the contracts end dates you will need to post the contracts again.

Regards,

Morris 


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Customer)
  • 8 replies
  • January 21, 2025

Hi ​@Morris,

Thank you for suggestion! I will try using Mass update XML as you recommended.
Additionally, Do you know which business rules will get triggered and create slots in  PM Schedules when covergae_end_dt is changed? Is this a standard business rule or a custom implementation specific to the customer?

Thank you in advance for help.

Regards,
Akshay.


Forum|alt.badge.img+9
  • Hero (Employee)
  • 96 replies
  • January 23, 2025

Hi ​@RTTPAAKDE 

I don’t know if there are any BRs that do that vs general policy within FSM. I believe it is policy.

 

Regards,

Morris


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Customer)
  • 8 replies
  • February 4, 2025

Hi ​@Morris 

Mass update XML works fine and Thanks for insight!

Regards,
Akshay


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings