issue create bug - General Support

Forums

Search Home All Forums

Home

Support

General Support

issue create bug

9/1/2010 4:41 PM

Davin Dubeau

bugnetproject.com
Joined: 3/2/2006

Posts: 1425

Re: issue create bug Modified By Davin Dubeau on 9/1/2010 4:43:46 PM

Open Microsoft SQL Server Management Studio on your database server or local machine and connect to the database.
Right click on the database and select new query
Paste the code below
Execute the query.

	ALTER PROCEDURE [dbo].[BugNet_ProjectMilestones_GetMilestonesByProjectId]
@ProjectId INT,
@MilestoneCompleted bit
AS
SELECT * FROM BugNet_ProjectMilestones WHERE ProjectId = @ProjectId AND 
MilestoneCompleted = (CASE WHEN  @MilestoneCompleted = 1 THEN MilestoneCompleted ELSE @MilestoneCompleted END) ORDER BY SortOrder ASC
GO

Davin Dubeau

9/1/2010 9:16 PM

Vistalogix

Joined: 4/3/2009

Posts: 9

Re: issue create bug

You rock! That fixed it - thanks!!!

Page 4 of 4

Forum Policy

These Discussion Forums are dedicated to the discussion of the BugNET issue tracker.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising.
2. No Flaming or Trolling.
3. No Profanity, Racism, or Prejudice.
4. Site Moderators have the final word on approving/removing a thread or post or comment.
5. English language posting only, please.