Skip to main content
Question

Is it possible to bulk change work order/work task to status 'Work Done'

  • October 17, 2023
  • 5 replies
  • 128 views

Forum|alt.badge.img+7
  • Sidekick (Partner)
  • 12 replies

We are bulk importing work order/work task for the purpose of historical data. These are completed orders that client wishes to load into the system for reference purpose. Is there a way/process to auto set the status of these imported orders to “WORK DONE”?

 

5 replies

Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • 1183 replies
  • October 18, 2023

Hey @Cpatel 

If you import the records, why not import with the desired status?

Cheers!


Forum|alt.badge.img+7
  • Author
  • Sidekick (Partner)
  • 12 replies
  • October 18, 2023

@Shneor Cheshin unable to do so. when adding the view 1 we dont get the OBJSTATE or STATE attribute. 2 when i tried to add the col manually, it did not update the status.


Forum|alt.badge.img+10
  • Hero (Employee)
  • 109 replies
  • October 23, 2023

@Cpatel

What table are the records getting imported into?

Based on your answer  you  might be able to  use a simple business rule to update the field. 


Forum|alt.badge.img+7
  • Author
  • Sidekick (Partner)
  • 12 replies
  • October 24, 2023

@Morris  the table i am trying to update is the Jt_Task table for the cloud application. 

 


Forum|alt.badge.img+1
  • Do Gooder (Partner)
  • 2 replies
  • October 14, 2025

Hi ​@Cpatel,

I’m facing a same kind of an issue. I want to change header status to ‘Closed’ in Sales Quotation. OBJSTATE field is not available in source mapping. Were you able to fix this?

\Pasan.