Dear Community Members,
When you login to CA PPM (Clarity PPM), do you see that pesky untrusted site warning? Learn why in today's Q&A. We'll also delve into an MSP XML Parsing Trick and provide a couple queries you can use if you're looking for a Parent Task.
Please feel free to comment on any alternative answers you've found. At Rego, we always love your input.
Learn with Rego | Q&A
1. "Untrusted Site" Warnings Logging into Clarity
2. TIP: MSP XML Parsing Trick
3. Query to Find Parent Task
Why do I get an "untrusted site" warning when I try to login to Clarity?
If any of you need to debug MSP XML files, I found a trick by accident after trying to parse a 2000000 + row file by hand, looking for tasks with problems in their names. (This was a plan with 15000+ tasks. . . .)OWB was designed to open the MSP XML file format, even before the XML version of the driver was created. And OWB was kind enough to tell me exactly what I needed to search for in Notepad++, so we could figure out what character was causing the error. Very helpful. In my case, it was the copyright symbol.
Anyone have a simple query to find the parent task of a task?
SELECT p.prid task_id, p.prname task_name, q.prid parent_task_id, q.prname parent_task_name, I.code Investment_IdFROM prtask p LEFT JOIN prtask q ON p.prprojectid = q.prprojectid AND p.wbs_parseq = q.prwbssequenceLEFT JOIN inv_investments I on I.id = p.prprojectid--WHERE p.prwbslevel <> 1
SELECT INVI.ID, INVI.CODE, INVI.NAME, T.PRID, T.PRNAME, T.PRWBSSEQUENCE, T.WBS_PARSEQ, (SELECT PT.PRNAME FROM PRTASK PT WHERE PT.PRPROJECTID = T.PRPROJECTID AND PT.PRWBSSEQUENCE = T.WBS_PARSEQ AND PT.PRWBSSEQUENCE < T.PRWBSSEQUENCE AND PT.WBS_NNBSEQ >= T.WBS_NNBSEQ) PARENT_TASKFROM INV_INVESTMENTS INVIJOIN PRTASK T ON INVI.ID = T.PRPROJECTIDWHERE 1=1ORDER BY INVI.NAME, T.PRWBSSEQUENCE