Anyone have any suggestions around getting a Rich Text field into the By filter on a report? I need to pull in Product Name from our SFDC side but it is s Rich Text field and as I understand it, there is a limitation on filtering by rich text fields. Any thoughts?
I need to pull in deployment percentages within the report by product, so I am stuck since the product name is a text field.
Thanks for any advice!
Best answer by darkknight
We had a similar challenge...ended up having to create a custom MDA table, create a duplicate field in that table as a String, build a rule to copy the data from the Rich Text value into the new field. Then leverage that table in Data Designer to merge the data with the original table. Clunky, but works….
I would LOVE a more efficient workaround, but since DD doesn’t allow you to filter the text fields either, that’s the only workaround I know. Hoping someone brilliant out there will blow our minds