Comparing HTML fields

[BKash]

Hello, I have to create a report that compares two HTML type field one on the current record and other on the referenced record. Unfortunately, is different from condition is not available for filter for HTML type fields. Can anyone help me with this requirement?

[Ahmmed Ali]

Hello @BKash 

HTML field does not provide the same as/different from condition as it will be very difficult to process for large data. You can create a script include and query the table to get required records, do the comparison and the return the sys ids. Then use that script include in condition builder of the report as "sys id is one of javascript: yourScriptIncludeCall()".

Thank you,

Ali

[Ankur Bawiskar]

@BKash 

not a good idea to compare 2 HTML fields.

Data in HTML field is having html tags and might contain some other info such as links, images etc

If my response helped please mark it correct and close the thread so that it benefits future readers.