Rally Software

  • 1.  Portfolio Item Query: (Owner.UserName = {user}) doesn't work

    Posted Sep 13, 2018 09:20 AM

    Hi,

    Looks like {user} works for user stories, tasks & defects, but not for Features. 

    Can you please help me with this query? 



  • 2.  Re: Portfolio Item Query: (Owner.UserName = {user}) doesn't work
    Best Answer

    Posted Sep 13, 2018 09:24 AM

    Olga,

     

    I just tested ( Owner = {user} ) in a Custom List set to the Feature Portfolio Item and it worked just fine.  Does it make any difference if you use this query?

     

    Michael



  • 3.  Re: Portfolio Item Query: (Owner.UserName = {user}) doesn't work

    Posted Sep 13, 2018 09:31 AM

    Thanks, Michael. Just tried and getting the same error: Could not read: could not read all instances of class com.f4tech.slm.domain.Artifact for class Artifact

    BTW... it works when i use my userID instead of {user}. 



  • 4.  Re: Portfolio Item Query: (Owner.UserName = {user}) doesn't work

    Broadcom Employee
    Posted Sep 13, 2018 01:39 PM

    Hi Olga,

     

    Which app are you using?



  • 5.  Re: Portfolio Item Query: (Owner.UserName = {user}) doesn't work

    Broadcom Employee
    Posted Sep 13, 2018 01:54 PM

    Agree with David. 

     

    'Owner' is a field that belongs to a few artifacts and I believe it may be that you didn't specify which type of artifact you are requesting. So, please also include a screen shot of your app's settings if you can.

     

    Thanks.

    Sagi



  • 6.  Re: Portfolio Item Query: (Owner.UserName = {user}) doesn't work

    Posted Sep 13, 2018 02:21 PM

    I'm using Custom List With Deep Export . Type: Portfolio Item Feature. Query: ( Owner = {user})

    When I change the query to (Owner = olga.lilke@ge.com) - it works.



  • 7.  Re: Portfolio Item Query: (Owner.UserName = {user}) doesn't work

    Broadcom Employee
    Posted Sep 13, 2018 06:41 PM

    Hi Olga,

     

    I did a little research on this one and that functionality may not be possible with that app.

     

    With most of our Core apps, when we encounter the {user} variable, we transform that variable into a user OID.  So the query that is issued to the API looks like this:

    query=(Owner = "/user/190200030006")

     

    The Custom List with Deep Export app does not seem to perform this transform and so the query looks like this:

    query=(Owner = "{user}")



  • 8.  Re: Portfolio Item Query: (Owner.UserName = {user}) doesn't work

    Posted Sep 14, 2018 11:16 AM

    I changed the app to Custom List and now the query works fine.  Thanks for your help



  • 9.  Re: Portfolio Item Query: (Owner.UserName = {user}) doesn't work

    Broadcom Employee
    Posted Sep 20, 2018 12:37 PM

    Hi  OlgaLilke1360310 DavidLeDeaux Sagi_Gabay

    Recently I having trouble using {user} with the custom list. 

    I was surprised to find another option in Help:

     

    (Owner = "currentuser")

     

    Just now I plugged this into the Deep Export app, and it worked there too!



  • 10.  Re: Portfolio Item Query: (Owner.UserName = {user}) doesn't work

    Broadcom Employee
    Posted Sep 20, 2018 12:39 PM

    That's awesome!  Thanks for adding that tip