Pinned topicquery over collection with case statement.

‏2013-03-15T19:57:15Z
|Tags:

Answered question
This question has been answered.

Unanswered question
This question has not been answered yet.

I am able to run this statement but it seems to only query through the first object in the List. I have also tried this using an inline method and get the same results. Could someone take a look?, is this a problem with my sql or a limitation of pureQuery API? or misunderstanding the API?
@Select(sql = " select case when rd.itemNameFixed = 1 then 1 else 0 end from ?1 as rd " )
Integer isDataToChart(List<WaferPassDetails> inMem);
as an inline method....
String sql = " select case when rd.itemNameFixed = 1 then 1 else 0 end from ?1.com.ibm.fdc.metrics.pq.WaferPassDetails as rd ";
Data data = DataFactory.getData();
Integer total = data.queryFirst(sql, Integer.class, wpdList);