Method Community

Method:CRM

 

Method Community » Method:Classic » Method:Classic General Q&A » SQL overrides on grid fields

SQL overrides on grid fields

Last post 09-22-2015 1:58 PM by jsenick. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 07-18-2013 4:37 AM

    • andy
    • Top 50 Contributor
    • Joined on 12-10-2012
    • Liverpool, UK
    • Posts 139

    SQL overrides on grid fields

    Reply Contact

    Is there any written documentation on implementing SQL overrides within grids?

    I am working with a grid based on the Customer table. I have the Contacts field in the grid. I have the following override script...

    '<b>' + ISNULL(viewCustomer.Contact,'') + '</b><br />' + '<i>'  + viewCustomer.FullName + '</i><br />' + ISNULL(viewCustomer.CompanyName,'')

    ...and the following filter fields...

    Contact,FullName,CompanyName

    I keep getting 'Error Generating Grid'.

    Thanks.


    Andrew Cliff
    Systems Manager
    CS Consult

  • 07-18-2013 3:20 PM In reply to

    Re: SQL overrides on grid fields

    Answer
    Reply Contact

    Andy, 

    We don't have any written documentation. However, you can take a look at how our stock Customer List screen works to get an idea of how you can implement something similar. The image below is from the Advanced Properties of the Name field in the Contacts grid. Hope this helps. 

    Jason 

    Need more help? Ask us about Method consulting services

    Jason Masina
    Community Support Specialist
    Method Integration Inc.
    Toll Free: 1.888.925.6238
    Local and overseas: 416.847.0400
    Fax: 416.640.6027
    E-mail: j.masina@methodintegration.com

  • 09-22-2015 1:58 PM In reply to

    • jsenick
    • Top 150 Contributor
    • Joined on 03-29-2013
    • Jamestown, NY USA
    • Posts 35

    Re: SQL overrides on grid fields

    Reply Contact

    Using viewaccCustomer.fieldName was the answer you needed as discovered by MikeH and confirmed by MethodGreg.  I just found this golden nugget of info.

    James

    James Senick
    JamestownStamp.com
Page 1 of 1 (3 items)