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

Hey @Cpatel 

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

Cheers!

@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.

@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. 

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