Resolvables

[VicAl]

OK I have an easy one for some of you. What's the best field to filter out Resolvables? I'm trying to write an Issue Filter that only displays Issues that DON'T have a Resolvable. However, I'm not seeing the correct results when I use the Has Resolvables or the Resolving Object ID fields. Is there a better field to use? I called the WF Support line but of course no Tech is available to get on the phone now (a trend over the last 6 months). So I have to wait for a callback, which usually means an email from them tomorrow. But I'm working on something I wanted to knock out today if possible. Your help is much appreciated. Vic Alejandro Denver Water

[Doug_Den_Hoed__AtAppStore]

Hi Vic, I would use ISBLANK(resolvingObjectID), but if that returns the incorrect results, log a ticket, and try variations of ISBLANK({resolvingObject}.{name}) in search of The Right Answer.

[VicAl]

Hi Doug, Thanks. Yeah that's what I tried on that field. I did already log a ticket, just waiting for them to get back to me. Vic Alejandro, PMP, CSM | IT Program Manager Denver Water | t: (303-628-7262) | c: (303-319-6473) "http://www.denverwater.org/"> http://www.denverwater.org INTEGRITY | VISION | PASSION | EXCELLENCE | RESPECT

[Doug_Den_Hoed__AtAppStore]

Sounds buggy, Vic; good call. I think there’s also a resolvablesObjectType; perhaps using ISBLANK on it instead would be more reliable. Regards, Doug

[Dr_DougWi]

If I understood the problem correctly, the following works correctly. I just tested this in an issues report knowing that only one resolving record existed on the issue population I used. The record came up fine out of the collection of 60+ issue records. One thing I did was to add a few resolving fields to the view on the report to see which of the fields would be most reliable. The Resolving Object ID field was it. Another thing I did was add the Resolving Object ID field as a prompt so I could see if the prompt would work similarly to the filter. It did for this case. Thanks for the mental distraction this afternoon. Doug Williams

[VicAl]

Hi Doug, Thanks. Yeah I did the same exact thing. It might be something with my data or something. If you see the screen shot you'll notice there is a Has Resolvables as False, yet there is a Resolving Object and ID. Then a little further down there's one with a Has Resolvables as True, yet the Resolvable Object ID is blank. So this one wasn't displaying properly. Workfront actually did call me back earlier (pleasant surprise) and I walked them through a screen share. He thought it was odd too and is taking it offline to investigate. In the meantime this combination seems to work: Has Resolvables – False AND Resolvable Object ID - Is Blank I tried to use OR at first but it didn't work. So we'll see what they say (if there's a bug or if I have a data issue or something). Thanks for looking at it gang. It at least confirmed I was on the right path and not going crazy �� . Vic Alejandro, PMP, CSM | IT Program Manager Denver Water | t: (303-628-7262) | c: (303-319-6473) "http://www.denverwater.org/"> http://www.denverwater.org INTEGRITY | VISION | PASSION | EXCELLENCE | RESPECT

[Dr_DougWi]

As I have learned... AVOID using this Has Resolvables - False Always use this Resolvable Object ID - Is Blank No need to ask me why, as I just use what works instead of what should work in my head. Doug Williams

[VicAl]

Yeah "Has Resolvables" is a dirty liar �� Vic Alejandro, PMP, CSM | IT Program Manager Denver Water | t: (303-628-7262) | c: (303-319-6473) "http://www.denverwater.org/"> http://www.denverwater.org INTEGRITY | VISION | PASSION | EXCELLENCE | RESPECT

[Doug_Den_Hoed__AtAppStore]

I wonder, Vic... Perhaps your Issue HAD a resolvable (hence hasResolvables = True at that time), but later and independently, the Resolving Object was then deleted, so the guid and its row was removed from that Oracle table, a trigger fired to clear the guid from any objects that referenced it (hence resolvingObjectID null at that point)...but the trigger wasn't quite thorough enough to also update the hasResolvables to false). Just a theory, of course, but easy enough to test, if you're so inclined. And either way, does not disturb Dugger's sound advice. Regards, Doug

[VicAl]

Hi DDH (instead of calling everyone Doug �� ), Sound theory. But in this instance the True is actually correct. There ARE two resolvables on this Issue. So in this example it's the Resolving Object ID being blank that is incorrect. That's why it's weird. I haven't been able to show either field as being reliable. Vic Alejandro, PMP, CSM | IT Program Manager Denver Water | t: (303-628-7262) | c: (303-319-6473) "http://www.denverwater.org/"> http://www.denverwater.org INTEGRITY | VISION | PASSION | EXCELLENCE | RESPECT

[VicAl]

OK so here's what WF Support came back with. It makes sense (in a confusing sort of way). I hope I don't make this worse, but here goes: Basically there's a difference between Resolving Object vs Resolvable. Think master/servant (Tech terms, not people terms �� ). I've attached their screen shot with explanation, but essentially I think it can be summarized as such: Resolvable Object = Servant object whose Status is driven by the Resolving (Master) Object. Resolving Object = Master object whose Status drives the Status of the Resolvable (Servant) Object. So if your Issue/Task Has Resolvables it is the Master that controls the status of those Resolvables. Your Status field is unlocked and controls the servant object status. If your Issue/Task has a Resolving Object , your Issue/Task is the Servant to that Resolving Object. Your Status field is locked and controlled by the master object status. So in the example below: Test Case UAT1 – has a Resolving Object (that object controls the fate of Test Case UAT1). The Status of Test Case UAT 1 is locked. The status of the resolving object will drive this status. But it has no Resolvables because it doesn't drive the Status of another object. Test Case U1 – is the Resolving Object for another object and therefore Has Resolvables. But no other object Resolves it, so there is no Resolving Object. In other words, the Status of Test Case U1 is unlocked and will drive the status of the other object(s). Vic Alejandro, PMP, CSM | IT Program Manager Denver Water | t: (303-628-7262) | c: (303-319-6473) "http://www.denverwater.org/"> http://www.denverwater.org INTEGRITY | VISION | PASSION | EXCELLENCE | RESPECT

[Doug_Den_Hoed__AtAppStore]

Well! I'm glad we got that Resolved, Vic. Thanks! Regards, Doug

[Dr_DougWi]

This works well for help desk or service desk approaches where one or more items could be connected to an issue. Thanks for allowing the doug team to help on this one, Doug Williams