Hi!
I'm triying to get all the worklogs in a project and an issuetype, but it looks like impossible... I don't understand how 'UPDATEDFROM' field works... I'm using this query with a JQL+SQL addon (h2):
SELECT T1.ID AS "IDREG",T2.KEY, T1.AUTHOR AS "EDITOR",T1.TIMESPENT AS "TIEMPO TRABAJADO(SEG)", T1.UPDATEDON AS "FECHA", T3.VALUE AS "ASIGNATURA", t1.updatedfrom
FROM ISSUEWORKLOGS AS T1
INNER JOIN
ISSUES AS T2 ON T1.ISSUEID = T2.ID
INNER JOIN
ISSUECUSTOMFIELDVALUES AS T3 ON T1.ISSUEID = T3.ISSUEID
WHERE
UPDATEDFROM = ?????? AND PROJECTID = 10500 AND TYPEID = 10292 AND CUSTOMFIELDID = 10216
I'm using UPDATEDFROM = CURRENT_DATE-30, but the problem is that there is a lot of worklogs with UPDATEDFROM = 'NULL' i'm not finding...
Its impossible to get all worklogs in a list for a specific month?Like all the hours this user log in december.
If any can help, please :)
