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 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.