ExecuteSQLit sql=
select CategoryName as Category,concat('' , cast(IssueId as char(4)), '') as Id, substring(StartDate,1,10) as Start, substring(DateNeeded,1,10) as Needed,concat('' , IssueTitle , '') as Title,MilestoneName as MileStone,PriorityName as Priority, LevelOfEffort as LOE , round((datediff(greatest(EndDate,CurDate()),CurDate())/datediff(EndDate,StartDate))*LevelOfEffort) as Unused ,AssignedDisplayName as Name from IssuesView where projectid=11 and MilestoneName<>'Completed' and -1=-1 and IssueId not in (select PrimaryIssueId from RelatedIssues where RelationType=0) and substring(dateneeded,1,10)' ,cast(IssueId as char(4)), '') as Issue, substring(StartDate,1,10) as Start, substring(DateNeeded,1,10) as Needed,IssueTitle as Title,MilestoneName as MileStone,PriorityName as Priority, LevelOfEffort as LOE , round((datediff(greatest(EndDate,CurDate()),CurDate())/datediff(EndDate,StartDate))*LevelOfEffort) as Unused ,AssignedDisplayName as Name from IssuesView where projectid=11 and MilestoneName<>'Completed' and -1=-1 and IssueId not in (select PrimaryIssueId from RelatedIssues where RelationType=0) and substring(dateneeded,1,10)>=curdate() order by Needed,Priority
Table 'WordNote.RelatedIssues' doesn't exist
|