Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to deleting multiple individual information #509

Open
summerghw opened this issue Apr 8, 2021 · 2 comments
Open

How to deleting multiple individual information #509

summerghw opened this issue Apr 8, 2021 · 2 comments

Comments

@summerghw
Copy link

summerghw commented Apr 8, 2021

Hi, I need to update my local LOVD instance, but now i can only delete individual one by one by click the "Delete individual entry" menu. Is there any way to delete multiple individuals information?

@ifokkema
Copy link
Member

Hi, thank you for your suggestion! Unfortunately, we don't have this option now, but I totally understand how this would be very useful. I'll leave this issue open until I have time to implement it.

For now, unfortunately, the only way is one by one through LOVD, or delete the selection through the MySQL database directly. Deleting the Individuals will also automatically remove the Phenotype entries and the Screening entries, but it will leave the Variant entries "orphaned", without a related entry. So what I usually do in these cases is first to identify the variants related to these Individuals, then delete the VariantOnGenome entries (which automatically removes the VariantOnTranscript entries, too), and then delete the Individual entries. You'll probably want to create a backup of your database before performing actions directly in MySQL.

@summerghw
Copy link
Author

thank you for reply, I will try this way.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants