Rally Software

 View Only
  • 1.  Excel Add-in Query Error

    Posted Aug 06, 2018 11:23 AM

    Hello I am running into this error

    when I am running the below query using the Excel add-in

    Columns: EmailAddress,FirstName,LastName,TeamMemberships,TeamMemberships.Product7wordsorless

    Product7wordsorless is a custom field which has the attribute type of String

    At first I thought the error was occuring because of the attribute type since TeamMemberships.Descriptions runs without error but I created a Product field with the attribute type of Text (same type as Description) and the same query error occurs. 

    Does the add-in not support subfields that are custom fields?


    Has anyone run into this error before and know of any solutions?

  • 2.  Re: Excel Add-in Query Error

    Broadcom Employee
    Posted Aug 06, 2018 03:53 PM

    Hi Ryan,


    Yes, this is a limitation of the current Excel add-in. See it being discussed here:

    Creating Custom field and extracting it via Excel plugin 


    I also just tested your scenario and indeed the custom fields aren't working on the TeamMembership (or the Project object in general) regardless of their type (I tested both Strings, Texts and Drop-Downs).


    We are currently working on a new version of the Excel add-in. I will discuss with Engineering if this can be made available in that next version.