Monday, November 19, 2007

Big Gotta in Flex/AIR

So you have a datagrid in Flex (or AIR) and you got a nice little query that is delivered to the application via a ColdFusion CFC and in your Flex app, you've got a text field that triggers a filter function on the arraycollection. Nothing special, one of the first things that many CF developers learn how to do in Flex.

While I was working on a demo application the other day I built this out, just to discover that my filter functions weren't working. Stranger yet, the filter functions worked perfectly when datasource was a xml file with the same data. After hours or cursing, blog reading, etc., I figured out what the issue was. For whatever reason, when you have a query that uses GROUP BY Flex filter functions do not work. In the end I made a view out of the query and the filter functions work perfectly now.

Fun stuff.

No comments: