Delete items of list with no parents

Maxime.Schaller
Occasional Contributor

Delete items of list with no parents

Hello all,

I'm trying to delete items of a list that are not linked to a parent. Therefore i cannot use "the delete from list using selection" action.

Do you have any tips to achieve that ? The list is quite huge so it's difficult to do this clean-up manually.

Thanks for your help,

Maxime

1 ACCEPTED SOLUTION

Accepted Solutions
LipChean_Soh
Certified Master Anaplanner

Re: Delete items of list with no parents

Hi,

 

Another possibility is that these 3 lists have selective access turned on and you've granted yourself the R/W access to the Top Level Item from FIN1.

 

Members without parents can't be seen by you in the module though you can see them in the List as the workspace admin.

 

Thanks,

LipChean

View solution in original post

17 REPLIES 17
abhay.kanik
Regular Contributor

Re: Delete items of list with no parents

@Maxime.Schaller 

You can use delete from list using selection.

create a module with the list and a boolean line item and put the formula= isblank(parent(item(list)))

It will make true for all the items which does not have a parent and you can use that line item for your delete action.

 

Thanks

Abhay

 

Maxime.Schaller
Occasional Contributor

Re: Delete items of list with no parents

Hi Abhay,

Thanks for your reply.

When i create a module with this list i cannot see the list items with a blank parent so my delete condition is always false.

Regards,

Maxime

abhay.kanik
Regular Contributor

Re: Delete items of list with no parents

@Maxime.Schaller 

Are you using a subset of list in module?

I haven't seen what you are saying ever before. Please share SS if possible.

If an item in list and its used in module I am 100 percent sure that it will be there in module

 

 

LipChean_Soh
Certified Master Anaplanner

Re: Delete items of list with no parents

Hi @Maxime.Schaller 

 

LipChean_Soh_0-1623977476267.png

I have 2 lists with parent child relationship shown above.

 

LipChean_Soh_1-1623977507680.png

All members from L2 Account have parents, except X.

 

LipChean_Soh_2-1623977534429.png

LipChean_Soh_3-1623977543343.png

1. A system module is created, where the 'Delete?' line item checks if L2 Account has any parents.

 

LipChean_Soh_4-1623977618929.png   LipChean_Soh_5-1623977644394.png 

LipChean_Soh_6-1623977695802.png

 

Create and run the above action, and X (or any new L2 Account members in the future without parents) will be deleted.

 

Thanks,

LipChean

jimfeng5
Certified Master Anaplanner

Re: Delete items of list with no parents

Hi Maxime,
Please share screenshots if you can. I tried to mimic your problem but I have no issue with deleting action using a system module.

Jim
Maxime.Schaller
Occasional Contributor

Re: Delete items of list with no parents

Hi,

Thanks for all replies.

I forgot to mention that this is a numbered list, I dont know if that makes a difference.


See below the screen-shots:

The goal is to delete items of FIN3 numbered list

 

MaximeSchaller_0-1623998610158.png

 

Example of item with no parent in the list:

 

MaximeSchaller_1-1623998675131.png

 

Delete module:

 

MaximeSchaller_3-1623998757093.png

The result with the filter:

 

MaximeSchaller_4-1623998828452.png

 

Regards,

Maxime

 

 

 

 

LipChean_Soh
Certified Master Anaplanner

Re: Delete items of list with no parents

Hi @Maxime.Schaller 

 

At what part of the process are you stuck? 

It looks like you have all the elements needed.

 

Thanks,

LipChean

Maxime.Schaller
Occasional Contributor

Re: Delete items of list with no parents

Hi LipChean,

 

The delete module doesnt contain the items with no parent.

 

Example with this one:

 

MaximeSchaller_0-1623999258849.png

 

MaximeSchaller_1-1623999312424.png

 

Not sure if it's because of the numbered list ?

 

 

LipChean_Soh
Certified Master Anaplanner

Re: Delete items of list with no parents

Hi @Maxime.Schaller 

 

Can you show us the formula of 'FIN3 Parent Account#.NoParent?', i.e. the property in the 'FIN3 Parent Account#' list?

 

Thanks,

LipChean