+ Start a Discussion
Kripa Sindhu SinghKripa Sindhu Singh 

I want to search sum numbers in a XLSX sheet which is attached with the chatter files

HI,
I was working with case object in the service cloud, where when a email is sent on the help email address configured with the Service model a case is created 
Hence the attachments are also added with them, For these attachments to enable preview and Search on the content i wrote a trigger which adds these attachments in the Chatter File 

The trigger is:

trigger AttachFileToCaseFeed on Attachment (after insert) {     
    ID caseId;   
    list<FeedItem> listOfFeedFiles = new List<FeedItem>();   
    if(Trigger.isBefore){ 
        for(Attachment attachment : trigger.new){ 
           string checkIfCase = string.valueof(attachment.ParentId); 
           if(checkIfCase.startsWith('500')||checkIfCase.startsWith('02s')){  
                caseId = attachment.ParentId; 
                system.debug('Parent ID'+ caseId);
                FeedItem post = new FeedItem(); 
                post.ParentId = caseId; //eg. Opportunity id, custom object id.. 
                post.Body = 'Attachment added'; 
                post.Type = 'ContentPost'; 
                post.ContentData = attachment.body;  
                post.ContentFileName = attachment.Name; 
                post.Title = attachment.Name; 
                listOfFeedFiles.add(post);           
           } 
        } 
    } 
    if(listOfFeedFiles!=null){ 
        insert listOfFeedFiles;  
    }    
}

This trigger is working fine and i can search values on the incomming attachments but the issue is 
comming when i try to search some numeric values which are present in xlsx file in a cloumn.

It do not work with it where as on the same file the text values are search 

for example if I search 25452656554 there is no result.

but with TEST8456589, 887687, i search and this value is stored as reloadTEST8456589 in the same file on any other column, it populate the search result for the documents.

Hence my question is why i can't perform search on numeric column, 
Any Body has any Idea.

Urgent Help Needed.