AnsweredAssumed Answered

Help with execute sql

Question asked by rgordon on Jan 30, 2017
Latest reply on Jan 30, 2017 by rgordon

I have a check box field with five values (apples, bananas, grapes, pears and oranges) and  a class field with 3 values (101, 102, and 103). Multiple fruit can be selected but only 1 class can be selected. I know how to do an execute sql to get the count of one fruit but I'm having trouble getting the total count of all fruit in one execute sql statement. Ideally it would be nice to be able to also return an array with class by fruit.  I can get the results I want with multiple execute Sql statement but would prefer to do it with one. Any help with this would be greatly appreciated.