This will show a simple way to remove the <!-- RICH TEXT --> tags from the Long Description field on a work order.  This solution is best suited for use with the Legacy Clients, or for a read-only use of the Long Description field with the HTML5 client.  That is because any edits that are done in DataSplice using this method will remove Maximo's rich text formatting for the field that was edited.  If you are using the HTML5 client to view the Long Description field, then a better solution is to use DataSplice's WYSIWYG editor as a Validation Style on the Long Description field.


An example of this in the Legacy client is below:



DataSplice 4 / DataSplice 5, Oracle

  1. Using the Admin Client, navigate to the Work Orders view
  2. Edit the BaseSqlSelect so that the database will remove the <!-- RICH TEXT --> tags for us when it is selecting the ldtext field
  3. Locate the sub-query that selects the ldtext field, it will look like this:
    (select ldtext from longdescription where ldkey = wo.workorderid and ldownertable = 'WORKORDER' and ldownercol = 'DESCRIPTION') ldtext, 
  4. Change it to look like this (modifications in bold):

    (select regexp_replace(ldtext,'<(.|\n)+?>', '') from longdescription where ldkey = wo.workorderid and ldownertable = 'WORKORDER' and ldownercol = 'DESCRIPTION') ldtext, 

  5. Save the view


DataSplice 4 / DataSplice 5, SQL Server

  1. Using the Admin Client, navigate to the Work Orders view
  2. Edit the BaseSqlSelect so that the database will remove the <!-- RICH TEXT --> tags for us when it is selecting the ldtext field
  3. Locate the sub-query that selects the ldtext field, it will look like this:
    (select ldtext from longdescription where ldkey = wo.workorderid and ldownertable = 'WORKORDER' and ldownercol = 'DESCRIPTION') ldtext, 
  4. Change it to look like this (modifications in bold):

    (select replace( cast(ldtext as varchar(8000)), '<!-- RICH TEXT -->', '') from longdescription where ldkey = wo.workorderid and ldownertable = 'WORKORDER' and ldownercol = 'DESCRIPTION') as ldtext,

  5. Save the view


Note: these query changes may adversely impact the performance of this query if there are a high number of Work Orders.  In these situations where this is a problem, there are other viable options that can be discussed and implemented on the database side.


Note:  If you wish to disable Rich Text from Maximo, you can follow this IBM support document.  http://www-01.ibm.com/support/docview.wss?uid=swg21655937


For additional assistance please email support@datasplice.com and we'd be happy to help!