User Stories not showing up in Sprint Board but Epics do

[Colt Forsythe]

I've configured a Sprint with the new Scrum Board using a filter that captures "User Story" and Epic issuetypes. Only the Epics are showing up in the Planning Board.

I've also configured the columns. I've noticed I can't use the Simplified Greenhopper Workflow for this project. I think that is the problem. Also when I click on "View In Issue Navigator" for the Sprint I get

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"AO_60DB71_RAPIDVIEW" WHERE "NAME" = 'HLM UI'' at line 1

Most of the User Stories have a status of Open and are visible in the To Do column when I configure the columns under the Columns tab.

[Renjith Pillai]

Which version of GH? The latest is 6.1.3.1.

Goto Manage Filters and you can see the filter, it will be called as 'Filter for <<Project Name>>'

[Colt Forsythe]

That filter isn't the real filter. For example only issues of type User Story are displayed and you don't see that in the filter. If that was the filter being used I wouldn't have this problem. We'll upgrade to 6.1.3.1 shortly. The frustrating thing is we have one project working and we set up a basically identical one and it doesn't.

[Natalie Hobson]

The board displays the issues from the filter as long as their current status is associated with one of your columns (not "Done" column, however).

*edit - fixed as I was previously referring to Kanban and you are talking about Scrum, sorry

[Colt Forsythe]

I've deleted the board and reconfigured a new one and still have the same problem. It's very difficult to debug this problem becuase the "filter" you set isn't really what is being used by Greenhopper. If I could see what the real filter was that pulled in issues to the Backlog then I could undestand the problem. I can't believe how much time I've wasted of this.