Method:Classic General Q&A

Re: Excluding deleted Work Orders from grid

Method_Michael — Thu, 06 Oct 2011 18:18:52 GMT

JKM@SA-

I don't think there is much documentation on this at the moment but this is something that would be included in the Knowledge Base project we are working (More details on it will be released soon).

-Michael

Re: Excluding deleted Work Orders from grid

JKM@SA — Thu, 06 Oct 2011 14:33:55 GMT

Ok. How/Where would a new user find this information? How would a new user learn the proper way to delete these records?

Re: Excluding deleted Work Orders from grid

Method_Michael — Wed, 05 Oct 2011 21:36:12 GMT

JKM@SA-

If you delete the series it will delete all unmodified Work Orders, but anything that has already been modified or saved will have to be individually deleted.

-Michael

Re: Excluding deleted Work Orders from grid

JKM@SA — Wed, 05 Oct 2011 17:58:12 GMT

That was it - the occurrences were deleted but the series record was not. If I have a series work order with 3 occurrences, should I be deleting all 3 occurrences and the series record (i.e. 4 deletions) or will deleting just the series record delete the occurrences associated with it?

Re: Excluding deleted Work Orders from grid

Method_Michael — Wed, 05 Oct 2011 17:36:52 GMT

JKM@SA-

Another possible scenario is that if you may have deleted an occurance instead of the series or you deleted the series but the already modified occurances were left behind.(The RecurrenceType field will display the type of Work Order)

The only other thing I can suggest is scheduling some paid consulting time to go over this.

-Michael

Re: Excluding deleted Work Orders from grid

JKM@SA — Wed, 05 Oct 2011 16:37:34 GMT

The deleted records that I am seeing are definitely Work Orders.

Re: Excluding deleted Work Orders from grid

Method_Michael — Tue, 04 Oct 2011 20:25:43 GMT

JKM@SA-

Could it be that you are not filtering the grid by Activity Type = Work Order so that it only shows Work Orders?

The Work Order grid has some filters on it already so it could be that these records are not meeting any of the filters so are not showing on the standard WO grid.

-Michael

Re: Excluding deleted Work Orders from grid

JKM@SA — Tue, 04 Oct 2011 19:58:38 GMT

The work orders have been deleted using the delete button on the Existing Work Orders grid. I cannot pull them up on that grid but I can pull them up on a new grid based on the activity table.

Re: Excluding deleted Work Orders from grid

Method_Michael — Tue, 04 Oct 2011 18:55:07 GMT

JKM@SA-

Are you maybe cancelling the Work Orders instead of actually deleting them? If thats the case you can apply a filter to the grid to not show any Work Orders(Activities) with an Activity Status of 'Cancelled'

-Michael

Re: Excluding deleted Work Orders from grid

JKM@SA — Tue, 04 Oct 2011 18:15:22 GMT

It is based off of the Activity table.

Re: Excluding deleted Work Orders from grid

Method_Michael — Tue, 04 Oct 2011 16:21:35 GMT

JKM@SA,

What table is the grid based off of? If the record is deleted it should not show up in the grid.

-Michael

Excluding deleted Work Orders from grid

JKM@SA — Tue, 04 Oct 2011 15:52:11 GMT

How do you exclude deleted records from a grid created from scratch? I have created a grid with Work Order information and the deleted records are showing up.