Method Community

Method:CRM

 

Method Community » Method:Classic » Method:Classic General Q&A » GROUP_CONCAT in SQL Override?

GROUP_CONCAT in SQL Override?

Last post 03-24-2015 10:26 AM by Method_Justin. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next

  • 03-23-2015 9:02 PM

    GROUP_CONCAT in SQL Override?

    Reply Contact

    GROUP_CONCAT: Can't seem to make this work on SQL override field. Is GROUP_CONCAT a restricted function for the override fields?

  • 03-24-2015 9:46 AM In reply to

    Re: GROUP_CONCAT in SQL Override?

    Answer
    Reply Contact

    Hi furrywombat,

    That function doesn't seem to be available through SQL overrides. It may be possible to emulate, however I'm not sure how that would be accomplished, and doing so isn't recommended.

    - Justin

    Justin Henderiks
    Technical Sales Specialist
    Method Integration Inc.
    Toll Free: 1.888.925.6238
    Local and overseas: 416.847.0400
    Fax: 416.640.6027
    E-mail: j.henderiks@method.me

  • 03-24-2015 9:52 AM In reply to

    Re: GROUP_CONCAT in SQL Override?

    Reply Contact

    Justin, any idea why? This would be a very useful SQL function to access. Can you give me a list of all available SQL functions in Method, or at least a list of restricted ones?

  • 03-24-2015 10:26 AM In reply to

    Re: GROUP_CONCAT in SQL Override?

    Reply Contact

    Hi furrywombat,

    There's currently no documentation regarding the functions available for SQL overrides. I'll see if this is something we can put together documentation for going forward.

    - Justin

    Justin Henderiks
    Technical Sales Specialist
    Method Integration Inc.
    Toll Free: 1.888.925.6238
    Local and overseas: 416.847.0400
    Fax: 416.640.6027
    E-mail: j.henderiks@method.me
Page 1 of 1 (4 items)