Deleting registered tag lists

From PTAGISWiki

The PTAGIS Web Portal does not allow you to delete a registered tag list if it is being used in an existing query. You can tell which registered tag lists are used in queries by looking at the last column in the table (# queries used in) on the My Registered Tags page. To free up a registered tag list for deletion, you either need to delete the query in which it is used, or remove that tag list as a filter from the query.

If you have a lot of saved queries or registered tag list, you may not remember which query is using which tag list. The best way to determine this is to find the Tag Group ID for the registered tag list in question:

• Go to the My Registered Tags page and locate the tag list you want to delete.

• Hover your mouse over the tag list name and look at the status bar of your browser. It will display the URL of the Registered Tag List and reveal the Tag Group ID.

In the image above the part of the URL highlighted in yellow displays the Tag Group ID; it says groups=6028. You will need to make note of the number that is displayed for the tag list in which you are interested.

• Go to the My Queries page and hover your mouse over each query that might be using the registered tag list in question. A tool tip will display part of the SQL code for the query. You are looking for a phrase that includes the words "WHERE tag_group_id = " a number.

Once you have located the query, either edit it to remove the registered tag list as a filter on the Tag ID field, or delete the query entirely. Continue this until all queries that use the registered tag list have been edited or deleted.

• To remove the tag list as a filter, select the query and click the Edit button.
• In the Query Builder click the Filter link in the left pane.
• You should see the Registered Tag List referenced in the Restriction column next to the Tag ID field.
• Click the change button to open the Filter Modification window for Tag ID.
• While holding the CTRL key down, click the registered tag list(s) you wish to remove from the query. It should no longer be highlighted in blue. Click OK.

• You should now see that the Registered Tag List is no longer referenced in the Restriction column.