Method Community

We are attempting to build a query for an SQL override grid field that could return more than one result, i.e. query Item FullName to determine associated open sales order line items, returning the sales order refnumber. Problem is, all we can do currently is display the most recent, or MAX sales order refnumber. What I would like to do is to present a comma-separated list of values. In MySQL, this would be accomplished using GROUP_CONCAT to present a list of comma-separated values. 

How can this be accomplished in Method, if at all?

Hi FW,

Unfortunately, this isn’t possible using an SQL override, as they only allow 1 value to be returned. Your only alternative would be to build an action set to loop through the table and build a list. Then store the list in a custom field and display it on your grid.

Sorry for the inconvenience.

-Audisho

Not possible, okay, but WHY?

Hi FW,

As I said, the query throws an error if more than one value is returned per field.

-Audisho

To clarify: Why would you limit us to one result, severly impacting potential functionality that would broadly increase our ability to provide useful grid data?

Not: Why will a function not complete when it results in error.