Is there any work around that allows (Rich text area) in filter field in reporting.

If you create a transform task from the survey dataset, you should be able to add a filter for Comment != NULL. 

With Data Designer you should be able to make the output into a Report for a Dashboard item.

@john_apple 

Thanks for the input, Could you please put little more focus on ‘If you create a transform task from the survey dataset, you should be able to add a filter for Comment != NULL. ’ Or any link which specifies the task please?

~Thanks

Hi @imran1184  - 

We are still using Survey 1.0, so comments are stored as a TextArea, which can then be filtered in a Transform task.

But - I noticed that when using the object in MDA for Survey 2.0 (NPS Survey Response), the comment is  stored as RichText which then cannot be filtered in a Transform task nor can it filtered using Criteria on an Action in Rules Engine. You also can’t use Case Expression to mark responses that have comments as there are no operators available for the Comment field.

Maybe look at the flattened survey? For Survey 1.0, the comment field on the flattened survey object is just text so it can be filtered from the initial dataset task rather than through a Transform. Not sure if the same holds true for Survey 2.0 since we haven’t migrated yet.

@john_apple we definitely look at this problem, priority will be increased based on more number of customers interest. 

@All, please up-vote here to increase the priority. 

I hope this can be fixed soon! I need to filter accounts that have changed status from live to terminated for example, so I need to filter for old and new values in account history. Since it’s a text field I’m not able to pull this in the filter. In the past I had use length of text and then filtered on the length, but it’s not intuitive for other users reading my rules. My other option would be to write this in sql and import the dataset this way, but it’s annoying to go this longer route for such simple datasets.

Salesforce allows filtering in reports on text fields but limits it to 1000 characters thus restricting the resource strain that this causes...perhaps this is something Gainsight could also do?

I came across a need to apply filters on a rich text Summary field we use on our C360 layout today, so being able to use filters on these fields in reports would be very helpful for us 

Hi All,

Thanks for posting this!

Unfortunately, its not possible for us to implement it the way Salesforce does since the way they implemented rich text was quite different and unique to support their usecases. I will discuss the feasibility/viability of this option with our internal teammates, but I am not very optimistic on this request making it to the roadmap. 

Hi All,
Could you let me know if filtering on rich text fields is possible for displaying only values that are NOT NULL.
If not, is there a workaround available?

I’d also like to be able to filter on Rich Text Fields, even just being able to show those with content vs Null values would be really useful.

As an example, we have a Rich Text Field ‘Summary’ for each client, we want to be able to quickly identify for which clients this is blank.