BAQ Replicate HDCase.CurrentMilestone

Justin_Grant · December 3, 2024, 9:42pm

I need to derive the current milestone in a BAQ for a dashboard for open cases and tasks. I’m not seeing a clear definition of how that’s defined in field help or otherwise

mackenziem · December 3, 2024, 11:31pm

What information are you looking for? A Case Number, Current MileStone and if the Case is Open?

Justin_Grant · December 4, 2024, 1:10am

I need this in my BAQ. Someone suggested referencing HDCase.ActiveTaskID

Justin_Grant · December 4, 2024, 7:35pm

I think I have the answer. Not sure if anyone can confirm or deny. It seems I can reliably join HDCase to the active task in the Task table with the following criteria.
I can then use the Task Description for my current milestone for my baq results

Anyone else see that?