TimAnderson

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.

 

 

Thanks

 

Tim

Outcomes