I am performing a query that seems to work some of the time and not others.

By intuition and process of elimination it looks like the CommentBody field from CaseComments does not get returned when CommentBody contains any carriage returns or paragraph markers.

The SOQL I am using is:

SELECT Id, ParentId, IsPublished, CommentBody, CreatedById, CreatedDate, SystemModstamp, LastModifiedDate, LastModifiedById, IsDeleted FROM CaseComment WHERE ParentId = '500D000000Dxjfm'

This particular case works well as it has multiple comments some one single line that display fine and others on multiple lines which don't. I have tested this with the simplest output code I could to eliminate any post processing errors.

Has anyone had this problem? can anyone explain it? Anyone know of a workaround or if there is a case submitted for this with the Salesforce dev team.

Background:

Our support processes require us to have 2 people assigned to eah case, an owner and an assignee. The owner is responsible for the resolution of the case and chasing up assignees whist the assignees are required to perform individual tasks to resolve a case (eg a software release).

General Problem:

Salesforce will send out notifications happily to case owners but I need activity notifications to also go to assignees too. I have created a new custom field called assigned_to__c which is a lookup(User) field. I would like to set up notifications using a workflow rule however this can only be done using the specific email field type.

Workaround:

My solution was to setup a separate hidden field assigned_to_email__c which would be autopopulated with the email of the user specified in the assigned_to__c field.

Questions:

I have not yet had to use formulas, cross object or otherwise so I have a couple of questions

1. I am not sure how best to approach this, should I use the formula to populate the field automatically or should I use a forumla in a workflow rule to do it

2. What syntax do I need to use to reference the User specified in assigned_to__c? Can anyone provide me with an example, idealy with a brief explanation as I expect I will have to do similar operations for other processes I am developing.

Thanks

I am performing a query that seems to work some of the time and not others.

By intuition and process of elimination it looks like the CommentBody field from CaseComments does not get returned when CommentBody contains any carriage returns or paragraph markers.

The SOQL I am using is:

SELECT Id, ParentId, IsPublished, CommentBody, CreatedById, CreatedDate, SystemModstamp, LastModifiedDate, LastModifiedById, IsDeleted FROM CaseComment WHERE ParentId = '500D000000Dxjfm'

This particular case works well as it has multiple comments some one single line that display fine and others on multiple lines which don't. I have tested this with the simplest output code I could to eliminate any post processing errors.

Has anyone had this problem? can anyone explain it? Anyone know of a workaround or if there is a case submitted for this with the Salesforce dev team.

Background:

Our support processes require us to have 2 people assigned to eah case, an owner and an assignee. The owner is responsible for the resolution of the case and chasing up assignees whist the assignees are required to perform individual tasks to resolve a case (eg a software release).

General Problem:

Salesforce will send out notifications happily to case owners but I need activity notifications to also go to assignees too. I have created a new custom field called assigned_to__c which is a lookup(User) field. I would like to set up notifications using a workflow rule however this can only be done using the specific email field type.

Workaround:

My solution was to setup a separate hidden field assigned_to_email__c which would be autopopulated with the email of the user specified in the assigned_to__c field.

Questions:

I have not yet had to use formulas, cross object or otherwise so I have a couple of questions

1. I am not sure how best to approach this, should I use the formula to populate the field automatically or should I use a forumla in a workflow rule to do it

2. What syntax do I need to use to reference the User specified in assigned_to__c? Can anyone provide me with an example, idealy with a brief explanation as I expect I will have to do similar operations for other processes I am developing.

Thanks