redundant instance deletion

tkilshaw

Object Account has reference attribute to a Task called NextContact, a unidirectional peer 1to1 relation.

Account also has reference attribute Tasks, a bidirectional 1tomany peer relation to Tasks.

When a new Account is created a new Task is also made and set in NextContact and Tasks.

Because Tasks can exist independantly from Accounts the relations must be peer.

If the user clicks the Cancel key on the Account form, before the account is created, I am left with a redundant Task record.

How can this be found and deleted?

thanks,

Terry

greg

Hi Terry,

If my experience is of any help, I ran into similar problem with PurchaseOrder and OrderItem objects. I added a time stamp to OrderItem and a reference attribute MyOrder. Then I scheduled this process:

rule1: FIND ItemOrder WHERE ItemOrder.MyOrder IS UNDEFINED AND DAY_DIFFERENCE(CURRENT_DATE,ItemOrder.TimeStamp)>=1

rule 2: DELETE ItemOrder

works fine

tkilshaw

Thanks Greg. How often do you run that process?

Seems like the language needs better support for this kind of thing.

Terry

greg

I run it every night. I also find and cull some other unattached objects.