Hi, I'm 1st Time user to Forum. 

 

I need to add the "ProjectDescription" column to the following queue statement, but have been unable to get it to work. This is the project description field you see when creating a new project or if you do an edit on Project Details tab. Thanks

 

 

SELECT projectdet.PROJECTID "Project id",
projectdet.TITLE "Title",

                                                                       <<<<<< PROJECT_DESCRIPTION
projecttypedef.PROJECTTYPENAME "Project Type",
projectprior.PRIORITYNAME "Priority",
projectowner.FIRST_NAME "Owner",
projectstatus.STATUSNAME "Status",
longtodate(c.Createdtime) "Created time",
c.comment "Project Comments" FROM ProjectDetails projectdet
LEFT JOIN ProjectTypeDefinition projecttypedef ON projectdet.PROJECTTYPEID=projecttypedef.PROJECTTYPEID
LEFT JOIN SDUser projectownerdet ON projectdet.OWNERID=projectownerdet.USERID
LEFT JOIN PriorityDefinition projectprior ON projectdet.PRIORITYID=projectprior.PRIORITYID
LEFT JOIN ProjectStatus projectstatus ON projectdet.STATUSID=projectstatus.STATUSID
LEFT JOIN AaaUser projectowner ON projectownerdet.USERID=projectowner.USER_ID
Left join projectcomments c on c.projectid = projectdet.projectid
LEFT JOIN AaaUser aau ON aau.USER_ID=c.Commentowner  where  c.Commentid = (SELECT MAX(c1.Commentid) FROM projectcomments c1 WHERE c1.PROJECTID=projectdet.PROJECTID)  AND((projectstatus.STATUSNAME = N'Open' COLLATE SQL_Latin1_General_CP1_CI_AS) OR (projectstatus.STATUSNAME LIKE N'%Onhold%' COLLATE SQL_Latin1_General_CP1_CI_AS)) ORDER BY 3, 4