What should we interpret if we make the following definitions a sentence?

SELECT {OrderStatus}.[Label], COUNT({Order}.[Id]), '', '' , '' 

FROM {Order} INNER JOIN {OrderStatus} 

ON {Order}.[OrderStatusId] = {OrderStatus}.[Id] 

GROUP BY {OrderStatus}.[Label]

Hi Kusaka,

Not sure if i understand your question, but your SQL looks not like a proper SQL statement.

Try this

SELECT {OrderStatus}.[Label], COUNT({Order}.[Id]

FROM {Order} INNER JOIN {OrderStatus} 

ON {Order}.[OrderStatusId] = {OrderStatus}.[Id] 

GROUP BY {OrderStatus}.[Label]


You need a structure  for the output with a text and long integer attribute on your Advanced SQL.

Rrgards,

Daniel

Hi Kusaka Yui,

From the sql it seems that you are passing 5 column output from the query (in which for last three columns , you are passing empty string value )

{OrderStatus}.[Label],  COUNT({Order}.[Id]),  '', '' , '' 

I don't know what could be your purpose but in order to get the result, you need to define a structure with 5 attributes and use this type as your output.

Please find the sample image for reference.

Regards .