|
|
Pending Items by User
ExecuteSQLit sql=
select concat('',AssignedDisplayName,'') as AssignedTo , count(IssueId) as Frequency from IssuesView where ProjectId=11 and MilestoneName<>'completed' and issueid not in (select primaryissueid from RelatedIssues where RelationType=0) and instr(IssueTitle,'support')=0 group by AssignedDisplayName union select concat('All')as AssignedTo , count(IssueId) as Frequency from IssuesView where ProjectId=11 and MilestoneName<>'completed' and issueid not in (select primaryissueid from RelatedIssues where RelationType=0) and instr(IssueTitle,'support')=0 order by AssignedTo
Table 'WordNote.RelatedIssues' doesn't exist
|
| |