How to get the notes query.

How to get the notes query.

Hello and sorry in advance i'm a very very new user and without much knowledge about servicedesk or the query system. (I'm from spain so english is not my first language)

I have this actual query, but it's missing the notes from the tickets:

I need to get all the notes that contain the word ("reclam"), is there any way to do this?

right now it gets everything that has the word reclam in it, that is description, category (everything) "as you can see in the .png file"



SELECT 
   WOH.WORKORDERID
  ,WOHD.HISTORYID
  ,WOHD.HISTORYDIFFID      
      ,WOHD.COLUMNNAME
  ,WO.TITLE
      ,WOHD.PREV_VALUE
      ,WOHD.CURRENT_VALUE   
      ,dateadd(s, convert(bigint, CREATEDTIME) / 1000 + 60*60, convert(datetime, '19700101')) AS Fecha,
      
  
  FROM [servicedesk].[dbo].[WorkOrderHistoryDiff] AS WOHD LEFT OUTER JOIN
  dbo.WorkOrderHistory AS WOH ON WOHD.HISTORYID = WOH.HISTORYID LEFT OUTER JOIN
  dbo.WorkOrder AS WO ON WOH.WORKORDERID = WO.WORKORDERID
WHERE WOHD.CURRENT_VALUE LIKE '%Reclam%'
 AND dateadd(s, convert(bigint, CREATEDTIME) / 1000 + 60*60, convert(datetime, '19700101')) BETWEEN convert(datetime, '20191101') AND convert(datetime, '20191115')


Thank you very much for your help.

                New to ADSelfService Plus?