Cannot create a custom HTML using a custom field to filter cards

[Anon Anon]

Hi,
I've reused https://github.com/paulmunro/Rally/blob/master/Rally%20-%20Defect%20and%20Story%20Print%20Cards.html and tried to slightly modify it.

My goal is to create a custom dashboard to be used for sprint reviews/demonstrations.

Until now, I was quite satisfied with the time I'd spent on this, but now I'm stuck: as requested by developers, as they'd like to exclude some US/DE or lesser value, I've added a boolean "demo" field, and am trying to filter those cards with an additional ' ( demo = "Yes" )' query.

That does not work, and I'm totally unable to understand  what's wrong (I've certainly missed something, but I don't know how to debug it).

This first version somehow worked fine: https://gist.github.com/Batmat/61db170f71d7069b7683 but without the "demo" custom field.

This second version, using the demo field, does only display US (user stories) but no more the defects: https://gist.github.com/Batmat/61db170f71d7069b7683/1bd3a8b192a9464e7825ce702e4657976d41b477

I've double-checked I've added the "demo" boolean custom field on both the User Story and Defect objects. 

I can't see where to look at now. Could you help me? Even some hint on how to debug this would certainly help.

Thanks a lot

[Anon Anon]

Hi Baptiste,
"Yes" or "No" values are not valid Boolean values. Use true or false. The UI shows "Yes" and "No" but a quick test directly in WS API will reveal that "Yes" or "No" cannot be parsed.
Please see this KnowledgeBase article (https://rallydev.force.com/answers?id=kA014000000PQak).



This one does not work(it returns all artifacts and ignores the query). Notice the warning:



 

[Anon Anon]

Thanks Nick. That helped.
FWIW, I guess that that page https://help.rallydev.com/fr/grid-queries and maybe also at least that one https://help.rallydev.com/fr/rally-data-source should be enriched with informations about "c_" prefixes from custom field and how to handle boolean in a query (that is, informations like 'c_theField = "true"' with double-quotes around true, and so on).

Those links above are indeed somehow the first one I've stumbled upon after a google search, so they should at least have some link to the right resource.

Thanks again.

[Anon Anon]

Baptiste,
You are most welcome, thank you for your feedback. I spoke to the user learning team that maintains the help documentation and conveyed those two items: query by Boolean field, and how to reference a custom field.