Maximo Open Forum

For SQL Server try this:

exists (select 1 from longdescription 
where workorder.workorderid = ldkey 
and ldownertable = 'WORKORDER' 
and ldtext like '%XXXX%')
and historyflag = 0 
and istask = 0 
and siteid = 'YYYY'

Replace XXXX with the text you search and YYYY with the siteid.

Please note that searching for longdescriptions is not very fast and should not be used frequently (not in start centers).

Don't include the word where, but try this:

Where WorkOrderID in

(Select LDKey From Maximo.LongDescription Where LDOwnerTable = 'WORKORDER' and lower(LDText) like '%[whatever you are searching for here in lowercase]%')

and replace [whatever you are searching for here in lowercase] with what you are looking to find.

Hi,

This works with a SQL Server backend.

EXISTS (
    SELECT 1
    FROM longdescription ld
    WHERE ld.ldownertable = 'WORKORDER'
      AND ld.ldownercol   = 'DESCRIPTION'  
      AND ld.ldkey        = workorder.workorderid
      AND ld.ldtext LIKE '%XXXX%'
)

NOTE: XXXX is your specific search criteria