We'd like to select cards based on a SQL-like "contains" approach so we can grab groups of cards based on some common sub-string that is contained in a field.

SELECT 'iteration', count(*) WHERE 'story status' contains 'open'

We have a “Story” card type with a “Story Type” property. The Story Type property is a managed text list of “User Story”, “Refactoring” and “Defect”, with assigned Reporting colors of green, yellow and red respectively. The color choice is meant to call attention to Refactorings and Defects, in particular if we have an inordinate amount of them on a regular basis. To further comprehend this data we’ve added a pie chart to the Overview page as follows: {{ pie-chart data: SELECT 'Story Type', Count(*) WHERE Type = Story }} The issue is the colors for the pie slices are a canned bright red for user stories, and bright green for defects—exactly the opposite of what we wanted. It would be nice if the pie colors for charts made over a property with assigned Reporting colors used those colors. Also perhaps a parameter syntax similar to the “series” of data-series-chart could be introduced that would allow further customization… {{ pie-chart data: SELECT 'Story Type', Count(*) WHERE Type = Story sectors: - data-point: User Story label: Stories color: green - data-point: Refactoring label: Refactorings color: yellow - data-point: Defect label: Bugs color: #990000 }} A property value not caught by the sector declarations could revert to the existing behavior of auto picking a color.

Hi,

Currently, the list view is restricted to 25 cards per page (and the number is not configurable). Is it possible to make this number configurable. Also there should be an option to list all the cards.

Thanks

Anshul