How to filter in Rally for date_field = blank

[Ravishankar Sathyanarayana]

How do one filter in Rally for a date_field = blank?

For example, filter all features with Actual_Start_Date = blank

This kind of filter used to work as recently as few weeks ago but now says invalid filter.

Appreciate any help.

Thanks

[Mitch Goldman]

How about setting the filter for the date to be less than some ridiculously early date (ie, a date prior to your starting to use rally). That should capture the null value date as being less than a real date.

[Terry Ginzburg]

I noticed this last week as well. One use for saved views is to audit for missing fields, including missing dates. When the new UI was rolled out, at first it wasn't possible to filter on missing dates, but that was changed fairly soon after rollout. I'm not sure when it reverted back but this needs to be fixed.  Mitch's suggestion would work as a work-around but isn't intuitive and when using an audit view, it is best for the filters to represent what you're actually targeting, such as missing dates.

------------------------------
Terry Ginzburg
------------------------------

[Ravishankar Sathyanarayana]

Yes, this issue need to be fixed. Any idea how one can go about asking for this fix?. I am kind of new to this forum and any help to navigate is much appreciated.

Also, Mitch's suggestion does not seem to be working (at least for me). If I give a known low date (say 2015-01-01 which I know we didn't even have Rally in the organization), it does not list the items that are missing date

[Mitch Goldman]

@Ravishankar Sathyanarayana, just to clarify, you're setting the date filter as  less than​ 2015-01-01, right?

[Ravishankar Sathyanarayana]

@Mitch Goldman, yes I am setting it as less than 2015-01-01

In Portfolio Items | Features,  and in the filter,  Actual Start date < 2015-01-01 (date selected from the calendar dropdown)​. Nothing shows up as the result. I have at least one feature that does not have Actual Start Date populated

screenshots: 
showing at least one item exists with Actual Start Date empty

one with filter set to less than 2015-01-01

[Mitch Goldman]

I thought I had my filtering idea working when I posted that message, but I did not save my example and I cannot get it to work again, even in an old-UI custom app list.  Sorry about that.

[Andrea Schilde]

@Ravishankar Sathyanarayana @Mitch Goldman @Terry Ginzburg​​​

we released a fix for this issue today. Please make sure to refresh your browser before testing this out.

Best,

Andrea

------------------------------
Product Manager
Rally Software
------------------------------

[Ravishankar Sathyanarayana]

Thank you! @Andrea Schilde. I did a quick check and it appears to be working. ​

Have a great day!

- Ravishankar Sathyanarayana

[Amy Meyers]

thank you @Andrea Schilde

Amy K Meyers  |  Senior Product Manager

GLOBAL RISK, FINANCE TECHNOLOGY & TRANSFORMATION

American Express

O: 602-766-2982 |  E: [e-mail]

For Rally Assistance, create a case using this link:  https://jira.aexp.com/jira/browse/EPMO-8808

American Express made the following annotations

---

"This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you."


American Express a ajouté le commentaire suivant

Ce courrier et toute pièce jointe qu'il contient sont réservés au seul destinataire indiqué et peuvent contenir des renseignements confidentiels et privilégiés. Si vous n'êtes pas le destinataire prévu, toute divulgation, duplication, utilisation ou distribution du courrier ou de toute pièce jointe est interdite. Si vous avez reçu cette communication par erreur, veuillez nous en aviser par courrier et détruire immédiatement le courrier et les pièces jointes. Merci.

---