cancel
Showing results for 
Search instead for 
Did you mean: 

Looking for ideas: mass-delete qualified links

Former Member
0 Kudos

Hello SDNers!

I'm looking for an innovative idea on how to mass-delete qualified links. I want to delete all the qualified links to a specific non-qualifier from many records at once. Idealy the scenario would be to search on a specific qualifier, and be able to select all records and delete that qualified value from them. Data Manager can't do this, obviously.

The closest I managed to get was to delete all the values in the qualified link using an import, but that's not enough, I need to delete the links completely.

Before I turn to the APIs, anyone has an idea?

Thanks

Alon

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Please follow the steps below:

1. Export the repository schema.

2. Delete the Qualified table or Qualifiers from the main repository.

3. Import the schema file on the existing repository by selecting Import Repository Schema option.

4. It will display the comparison chart between the two repositories,select the Qualified table name or the Qualifiers that you have deleted from the original repository.

Though the approach is bit vague but it works

Reward if found useful

Regards,

Jitesh Talreja

Former Member
0 Kudos

Hi,

This is a nice idea indeed, though I don't think it'll solve my issue -- this will only let me completely remove the field, since the exported schema won't contain the actual record form the qualified table, which is what i'm looking to delete...

I will try this anyway, and thanks!

Alon

Former Member
0 Kudos

Alon,

You should be able to accomplish this with an export and import.

1. Select the qualified record you want to delete using the search parameters

2. Export out the records with this qualified field - it should only export out the qualified record that you have selected in your search parameter

3. Import this file with the Import Manager

4. Map the qualified table name in the source to the destination

5. Right click on the destination field name and select "Select Qualified Update > Update"

6. A new dialog box will appear

7. For new links select "Skip"

8. For existing links scroll down and select "Delete"

9. When the file imports it should delete all instances of that qualified record

That was a quick explanation. Let me know if you need more detail.

Regards,

Tim

Former Member
0 Kudos

Tim, this sounds like something that would work, great idea! I'll test it as soon as I can.

Thanks,

Alon

Former Member
0 Kudos

Hi Alon,

Did it work? Any workarounds?

Thanks

Shailendra

Answers (0)