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

All comments

abhay.kanik

@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

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

@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

I have 2 lists with parent child relationship shown above.

All members from L2 Account have parents, except X.

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

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

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

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

Example of item with no parent in the list:

Delete module:

The result with the filter:

Regards,

Maxime

At what part of the process are you stuck?

It looks like you have all the elements needed.

Thanks,

LipChean

Hi LipChean,

The delete module doesnt contain the items with no parent.

Example with this one:

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

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

Thanks,

LipChean

I dont use this property for the moment, it was just for try.

The end of the delete module looks like this:

Nothing after the last parent...

Assuming module 'DM24 Delete - FIN3 Parent Account' applies 'FIN3 Parent Account#' as the list, AND if you can't see '236881 - DKK - NAT - 7650' in 'DM24 Delete - FIN3 Parent Account', could it be that '236881 - DKK - NAT - 7650' is not a member of 'FIN3 Parent Account#'?

Could '236881 - DKK - NAT - 7650' be a member of FIN4 or FIN5?

Thanks,

LipChean

I can see it after the main parent:

But not in the delete, which is strange...

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

Hi LipChean,

The first parent list has selective access indeed... So you're right.

I could remove the selective access but that could be dangerous. Otherwise i'll go with the manual approach...

I'm glad we solved the main issue, i.e. why you can see the list member in the admin page, but not in the module.

Let's move on to the next topic.

If your objective is to delete the list member without a parent, the previous steps discussed still works though you cannot see/verify the list members in a module before performing the deletion step.

If the previous step is too risky, then you'll need to take another step back, and ask yourself why there are members without parents. Could a validation be done before these FIN3 members are created? During the validation, if some FIN4 members really do not have parents, can they be assigned to a technical parent, e.g. Dummy Parent.

Thanks,

LipChean