SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    Oct 2007
    Location
    TN, India
    Posts
    66
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Defect ID needs to be reseted.

    Hi,

    I want to have all the defects in a QC project wiped clean and start with the ID number "1".

    I created a new project for from a copy of the original project. I highlighted everything to copy over except the Defects module.

    However, when I created a new defect in the Defects module, it gave me a defect ID of "32" instead of "1".

    Could any one please help me in this issue.

    Thanks
    Vill
    Vill
    Cognizant

  2. #2
    Member
    Join Date
    Sep 2003
    Location
    Moscow city
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Defect ID needs to be reseted.

    Go to Site Admin and choose the project you use on the Site Project tab.
    Then go to SEQUENCES table in this project.
    Instead of "Select * From SEQUENCES" input the following:
    update sequences
    set SQ_SEQ_VALUE = 0
    where SQ_SEQ_NAME = 'BUG'

    Click "Execute SQL" button.
    Now you have defect_id counter for the chosen project started with 1.
    Vladislav Orlikov, CJSC "Quorum Telecom"
    Quality Assurance Department Director

  3. #3
    Member
    Join Date
    Oct 2007
    Location
    TN, India
    Posts
    66
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Defect ID needs to be reseted.

    Thanks Vladislav Orlikov, it works fine.
    Vill
    Cognizant

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 11.11%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 11:48 AM.

Copyright BetaSoft Inc.