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=0 and MilestoneName<>'Completed' and IssueAssignedId= 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=0 and MilestoneName<>'Completed' and IssueAssignedId= and IssueId not in (select PrimaryIssueId from RelatedIssues where RelationType=0) and substring(dateneeded,1,10)>=curdate() order by Needed,Priority
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and IssueId not in (select PrimaryIssueId from RelatedIssues where RelationTy...' at line 1
|