Knowledgebase
Is there a way in Projetex to retrieve a list of projects where my freelancers are included in the "Freelance Team"?
Posted by Alexey Sokolov (AIT) on 28 October 2014 02:16 PM

This information can be extracted using Custom Queries. You can find the required query code below. This query shows a list of freelancers which are in freelance teams for your projects. To run the query, go to Projetex Server Administrator > Corporate Settings > Queries, click the New button and insert the code below into the Query section. Then specify a name for this query and click OK.

SELECT r2.res_name, p3.proj_name, p3.proj_numb, c10.client_name
FROM resources r2, pteam p4, projects p3, clients c10
WHERE p4.proj_id=p3.proj_id AND p4.res_id=r2.res_id AND p3.client_id=c10.client_id
ORDER BY r2.res_name

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).