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.
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.