I am building a tile to show any projects opened in the last two weeks. Is there any way to do this in a tile? I am using a fixed date now but this will need to be manually updated every week. Any ideas appreciated.
I am building a tile to show any projects opened in the last two weeks. Is there any way to do this in a tile? I am using a fixed date now but this will need to be manually updated every week. Any ideas appreciated.
This may need to be a custom table report instead where you write/paste in SQL code that would restrict what data shows up on the report.
In addition to voting on this idea you may also search for all requests about “Portfolio Definition” and see if there are others that resonate with you.
That would be appreciated
Robin
SELECT CONVERT(nvarchar(10),proj_inf.entry_date,101 ) AS creation_Date ,proj.short_Name AS work_ID ,
'<a title="' + strut.description + '" href="froot]/PLP/EntityLandingPage.aspx?pt=PROJECT&scode=' + proj_inf.planning_code+ '">' + strut.description+ '</a>' AS projName
FROM ip.project_info proj_inf
INNER JOIN ip.planning_entity proj ON proj.planning_code = proj_inf.planning_code
INNER JOIN ip.structure strut ON strut.structure_code = proj_inf.planning_code
WHERE proj_inf.entry_date >= getdate()-30
ORDER BY proj_inf.entry_date
DESC
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.