Method:Classic General Q&A

Re: SQL Override with > 1 Result

furrywombat — Wed, 03 Jun 2015 20:45:05 GMT

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.

Re: SQL Override with > 1 Result

Method_Audisho — Wed, 03 Jun 2015 20:34:19 GMT

Hi FW,

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

-Audisho

Re: SQL Override with > 1 Result

furrywombat — Wed, 03 Jun 2015 20:21:45 GMT

Not possible, okay, but WHY?

Re: SQL Override with > 1 Result

Method_Audisho — Wed, 03 Jun 2015 20:03:07 GMT

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

SQL Override with > 1 Result

furrywombat — Wed, 03 Jun 2015 16:55:07 GMT

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?