Unanswered questions

Hi everyone,I’m reaching out to ask whether anyone has experienced changes to system settings that caused OData queries to be limited to 50,000 rows.I recently ran into this issue in my environment—unexpectedly hitting a 50,000 row limit—despite previously being able to retrieve full datasets. After opening a support case, Customer Service resolved the issue on their end, but I still don’t have clarity on: Why it occurred in the first place, What was changed to fix it, And whether it could happen again. I’d be really interested to hear if anyone else has encountered similar behaviour and, if so, what you learned from your communications with Planview and/or what measures you’ve put in place to ensure continuity of complete OData retrieval.Thanks in advance for any insight the community can share!

Hi, I need some help with setting up a report for on Clarizen. I want a report that shows all the deliverables that my team members worked on in the last quarter with the work, budgeted work, actual effort and work variance fields. could anyone help me with that?

We have a group that would like to have a version of the My Active Lifecycle Steps tile that includes a column for Project Manager and one for Business Sponsor in addition to the current column that shows the person/role responsible for the step. Is this possible? Any guidance on how to do this would be greatly appreciated. Thanks!!Robin 

I’m interested to explore adding skills to our resource pools (ideally driven from information hosted in our central resource/training database, but not critical), exploiting the skills criteria for Requirements & Allocation but to also report on any skills hotspots through PowerBI reporting.Information on the best way to configure and use the Skills in Portfolios seems very limited - does anyone have experience of this and any best practice they can share?

Managing dual languages using login environment language is supported only for standard fields.Unfortunately this functionality is not available for custom fields.For international companies that use multiple languages such as French/English, how do you manage this issue? Thanks in advance.

For the creation of iframes to display Power BI reports in AdaptiveWork, I want to embed an iframe at the project level and another at the portfolio level. However, I would like to apply dynamic filters based on the project (or portfolio) I am viewing, so the report filters the data automatically. How can I pass parameters from AdaptiveWork to Power BI for automatic filtering? Thanks in advance !

Hi AllRecently taken over Planview for my area and having a little bit of an odd issue.So we are trying to add some new columns to one of the Work Portfolio tiles and one is giving me some grief.Been able to add an alternate structure and a long text column without issue but trying to add a text field we have that has a 200 character limit is displayed a column with the right name but not pulling through any data into it.Notes I had been left behind say using the same code as long text would work but is clearly not doing it and wondering what the code needs to be.The attribute is as follows Code my instructions advise me to use is below which generates the column with the attribute name but showing any of the data in the attribute on the screens it has been entered on.(SELECT lt.line_text FROM [DBPATH]long_text lt WHERE lt.key1 = 'msd_approved_by' AND lt.key2 = cri.cri_code) AS Approved_By_Other

When selecting a risk to delete you are presented with the option to unlink or delete. When deleted, should the risk appear in the Recycle Bin? We couldn't find deleted risks reported by a PM in our Production Recycle Bin and when testing in our Sandbox the deleted risk also did not appear in the Recycle Bin. Is this expected behaviour?

We are evaluating the most cost effective way to manage our licenses so are currently defining an archive process based mostly on lack of use.  I’d also like to downgrade a Portfolio-R/W license to a View Only license if I could tell if the user has not made any data updates in the past three months or so.   Does anyone know a way to do this?We are also considering alternative solutions like report subscriptions to keep licensing costs down and wonder if others have pursued this or any other solutions?Thanks!