Rally Software

  • 1.  How to query a custom text field for blank values

    Posted Jun 19, 2014 01:27 PM
    On the User Story object (aka Hierarchical Requirement), we've added a custom field for our technical writer to capture customer facing release notes. We'd like to create a page with a Custom Grid that shows which stories have release notes and which ones are still require them by checking if the release notes text field is blank.

    According to the General Query Examples (https://help.rallydev.com/grid-queries?basehost=https://rally1.rallydev.com) document, I should be able to do this using a filter like:
    (c_ReleaseNotes = "")

    This query, however, always results in the custom grid returning no records, even when the release notes field is cleared out manually. I've tried the suggested syntax on another text field, the Notes field, and it appears to work as intended.

    Is there a unique syntax for checking if a field is blank for custom fields vs. the Rally default fields?


  • 2.  Re: How to query a custom text field for blank values

    Posted Jun 19, 2014 04:49 PM
    Nate, we just tested this several different ways, and found the same thing - the custom grid shows "There is nothing to display" when we query for empty values. 

    It seems other text fields do let us query for empty values, but not custom text fields.  There is now a defect created for this very issue, DE19415.  I am escalating this post to a case which I will associate to the defect to elevate its importance.  You will be notified once our Engineering team has fixed the defect. 

    I apologize for any inconvenience this has caused you, and thank you very much for reporting it!


  • 3.  Re: How to query a custom text field for blank values

    Posted Dec 10, 2014 08:45 PM
    Is this issue resolved yet? Our entire organization (EBSCO) is blocked currently due to the same observation.


  • 4.  Re: How to query a custom text field for blank values

    Posted Dec 11, 2014 10:02 AM
    Hi Dipankar, please submit a case and reference this defect # so that we can get you added to the open defect.  Thank you!

    DE15858 - Querying for NULL on a custom text field does not return any results