08-08-2014 09:19 AM
Hi Everyone,
I am having lots of fun with the custom mail merge routines in SLX 8.1 Web client. I have finally managed to get it to pull back custom fields just containing basic text. Which doesn't sound like much, but I have lots of bruises on my head as a result of this.
To save my walls, has anyone got an example of how to retreive a field from a table using this method.
I have tried using this :
oService.GetSingleValue("DESCRIPTION", "OPPORTUNITY", "OPPORTUNITYID", id);
but to no avail.
Any pointers would be a great help.
Cheers
Paul
08-08-2014 09:38 AM
The call you're making looks correct. I would confirm that the OpportuntiyId you're passing is correct. You can also watch the SQL execute in SLX Profiler to see if you have any errors or if no records are being returned (usually because of security joins).
Thanks
Mike
08-08-2014 09:39 AM
Thanks Mike.
WIll have a fun Monday debugging