Topic
No replies
SystemAdmin
SystemAdmin
1632 Posts
ACCEPTED ANSWER

Pinned topic query over collection with case statement.

‏2013-03-15T19:57:15Z |
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);