remove tags which are no longer useful
Moderators: Developer, Contributor
-
- Posts: 60
- Joined: 03 Jan 2018, 15:39
- Location: Toronto, Canada
Re: remove tags which are no longer useful
Thank you for the information.
-
- Posts: 60
- Joined: 03 Jan 2018, 15:39
- Location: Toronto, Canada
Re: remove tags which are no longer useful
YES, those tags (id list) not attached to any issue :
SELECT distinct id FROM MANTIS_TAG_TABLE A LEFT JOIN MANTIS_BUG_TAG_TABLE B ON A.ID=B.TAG_ID WHERE B.TAG_ID IS NULL
Thank you!
SELECT distinct id FROM MANTIS_TAG_TABLE A LEFT JOIN MANTIS_BUG_TAG_TABLE B ON A.ID=B.TAG_ID WHERE B.TAG_ID IS NULL
Thank you!