Does anyone know what table is Line (Line_Num) is located in?

Question

Howdy,Does anyone know what table the Line # (Line_num) attribute is in? I cannot find it under the Field_info table

Thbutler · Accepted Answer

I know it can be found in the Project_View table/view. You might want to check the database schema guidehttps://success.planview.com/Planview_Portfolios/Analytics_and_Reporting/Database_Schema_Guide

Haydn · Answer

This is the SQL code I use:SELECT pe.ppl_code                            AS ppl_code, (SELECT Description FROM ip.structure with (nolock) WHERE structure_code = pe.ppl_code)         AS Program_Description, pe.planning_code                          AS planning_code, (SELECT Description FROM ip.structure with (nolock) WHERE structure_code = pe.planning_code)       AS Line_Description, (ROW_NUMBER() OVER(PARTITION BY pe.ppl_code ORDER BY smap.map_code))             AS Line_NbrFROM ip.planning_entity AS pe with (nolock) JOIN IP.structure_map smap with (nolock) ON pe.planning_code = smap.structure_codeWHERE pe.ppl_code is not null

Planview Customer Community

Login with SSO

Planview Customer Community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded