ExecuteSQL Summaries

Discussion created by TimAnderson on Oct 21, 2012
Latest reply on Oct 25, 2012 by TimAnderson

Hi All,


I have been playing with fql for a while, using plugins before FM12, but now have come up with something that, from my reading, may not be possible! before I spend (waste?) any more time can anyone tell me if the below is possible.


In the table I am looking at there are 3 fields I am interested in, ImageID, imagesize and quantity.


I want to summarise the data such that I get something like below. I want to use the results in a webviewer so cannot take into another table and process. I am returning the html tags in the result, but am leaving them out here for clarity.


Image 1

10x8 3

6x4 1


Image 2

10x8 1

6x4 2


Image 3

6x4 2


I think I am going to have to find some way of processing the results of the ExecuteSQL to get this, unless someone with a great deal more knowledge of SQL than me (Ok, that will not be difficult!) can tell me otherwise.