Hello,

I need to run a report that pulls all the Project Numbers and their Description out of our vault. I have not been able to write a query that has actually worked since I'm so new with this stuff. I've copied the code I've written in below.

@[ListAllProjects]

§Name [All currently defined Projects]

§Company [SolidWorks]

§Description

[This query will list all Project numbers and their description.]

§Version [1.1]

§Arguments

[

]

§Sql

[

SELECT P.Name as 'Project Name', W.Description as 'Project Description', P.Name as 'Project Number'

FROM Projects P, Projects P

WHERE W.InitialTransitionID = T.TransitionID And

      W.WorkflowID != 1                                  /* Only include real WF  */

]

/*******************                        ********************/

Can anyone help me out?

Thanks, Andrew