Method:Classic General Q&A

Re: Custom SQL

SMcGovern — Fri, 02 Dec 2011 16:31:15 GMT

Thanks Michael. That did the trick!

Re: Custom SQL

Method_Michael — Fri, 02 Dec 2011 16:07:05 GMT

Shawn,

The way you have it setup is correct you may just want to replace Terms with ISNULL(Terms, '').

The step you are probably missing is adding Terms to the Activity table as a linked field from Entity

-Michael

Custom SQL

SMcGovern — Fri, 02 Dec 2011 00:11:24 GMT

This is my first post. I have been working on some customization and have hit a issue that I can seem to get around. The powers that be want the Mobile Activity Screen to show the Customer's Terms next to the Customer on this screen. Below is the Custom SQL statement that is stock with the Mobile Screen with the exception that I added the location for TERMS in the statement.

(CASE WHEN [Entity] IS NULL THEN '' ELSE '<b>' + [Entity] +TERMS + '</b><br/>' END) + ISNULL(ActivityType, '') + ', ' + ISNULL(ActivityStatus, '') + ', ' + ISNULL(ActivityPriority, '')

Any help would be greatly appreciated!!!

Thanks,

Shawn McGovern