Project workspace custom lists add issues and risk

All replies

• 

  

  0

  Sign in to vote

  Hi Taj,

  Custom lists do not have the "link" options, since they are not stored in one of the 4 Project Server tables so cannot be linked to Project Server objects like project tasks.

  As I just said, whereas out-of-the-box risks and issues list are, custom lists are not stored in Project Server tables, so you'll have to go directly in the Sharepoint content database.

  See example below:

  • http://sharepointtaskmaster.blogspot.ca/2011/08/make-report-by-reporting-service-with.html

  Hope this helps.

  ---

  Guillaume Rouyre - MBA, MCP, MCTS

  Monday, April 28, 2014 2:18 PM
• 

  

  0

  Sign in to vote

  hello,

  See answers below:

  1: Yes you can add the link option (Related Items), for custom lists you will need to add this site column, see the link below: http://www.learningsharepoint.com/2012/09/14/sharepoint-2013-related-items-site-column/ Fully test this on a non production farm first.

  2: As detail above, the data for custom lists for custom colunms on the Issues or Risks lists is not available in the ProjectWebApp database, this is only stored in the SP content database. It is not supported to query the SP content database directly with T-SQL. To get the data in a report use the web services or SP list data source. http://nearbaseline.com.au/blog/2010/02/reporting-workspace-lists-directly-from-sharepoint/. Alternatively, use a 3rd party tool to get all the custom SP list data into a database you can query directly with T-SQL - much easier! See the following products:

  CPS's ReportLink: http://www.cps.co.uk/What-We-Do/Pages/SharePoint-ReportLink.aspx & http://pwmather.wordpress.com/2012/08/22/sharepoint-2007-2010-and-projectserver-2007-2010-bi-reporting-made-easy-sp2010-ps2010-businessintelligence-sql/

  IPMO's data miner: http://www.ipmo.com.au/productivity-tools/

  Paul

  *Disclaimer - I work for CPS.

  ---

  Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

  • Marked as answer by PWMatherMVP Tuesday, May 27, 2014 6:40 AM

  Monday, April 28, 2014 11:39 PM
• 

  

  0

  Sign in to vote

  Hi Paul,

  Thanks for your response, i tried with the option, but when we add an item it is  not showing the item belong to which list e.g issues , risks etc. Please find the below screen, it is possible to show that.

   

  I also notice there is a column 'Related Issues' available Add column from site columns  which satisfy my requirement, is it possible to create a similar column for "Related Risks"

  ---

  Thanks in advance, Taj

  
  

  • Edited by arun_2014 Wednesday, April 30, 2014 8:11 AM

  Wednesday, April 30, 2014 8:11 AM
• 

  

  0

  Sign in to vote

  Hello,

  No you can only see the item name using out of the box functionality - I guess you could do something in code to show the associated list somehow.

  Paul

  ---

  Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

  • Proposed as answer by Guillaume Rouyre [MBA, MVP, MCC]MVP Friday, May 2, 2014 12:21 PM

  Friday, May 2, 2014 10:42 AM
• 

  

  0

  Sign in to vote

  Hi All,

  To get the custom list item which is created in project workspace, I am trying to check the content database, I could not find which table the items is stored. All the example showing how to get it from the list URL, since I need to get the list item or all the projects, I need the database table name.

    

  ---

  Thanks in advance, Taj

  
  

  • Edited by arun_2014 Tuesday, May 6, 2014 12:44 PM

  Tuesday, May 6, 2014 12:44 PM
• 

  

  1

  Sign in to vote

  Hello,

  It is not supported to query the SharePoint content database directly with T-SQL, you will invalidate your support and potentially cause issues on the farm. You will need to use APIs or UI to get the data.

  Paul

  ---

  Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

  Tuesday, May 6, 2014 12:59 PM
• 

  

  0

  Sign in to vote

  Hi Paul,

  I have checked your below post and I have some qry

  http://pwmather.wordpress.com/tag/ssrs/

  1. We are using SQL Server 2008 R2 , whether Microsoft® OData Source for Microsoft SQL Server 2008 R2 available ?

  2. Using this method is it possible get workspace custom list data

  2. Once this configured, whether it synchronize the data automatically

   

  ---

  Thanks in advance, Taj

  
  
  

  • Edited by arun_2014 Tuesday, May 6, 2014 2:30 PM

  Tuesday, May 6, 2014 2:28 PM
• 

  

  0

  Sign in to vote

  Hello,

  answers below:

  1: No - SQL 2012 or 2014 only

  2: Not directly but you can code it: http://nearbaseline.com/blog/2014/04/project-site-custom-list-reporting-using-ssis-odata-connector/

  3: sync is done on a schedule you define via a SQL job.

  Paul

  ---

  Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

  • Marked as answer by PWMatherMVP Tuesday, May 27, 2014 6:40 AM

  Tuesday, May 6, 2014 4:10 PM