A query abaixo mostra o histórico de transferência de uma tarefa (task) especificada através do neoId pela cláusula where.
select tasklog2_.action as acao, — 1 = Transferência
task0_.neoId as idTarefa,
tasklog2_.dateLog as dataEvento,
tasklog2_.description as motivoTransf,
neouser3_.fullName as comQuemEstava,
neouser4_.fullName as quemTransferiu
from Task task0_
inner join Task_logs logs1_ on task0_.neoId=logs1_.Task_neoId
inner join TaskLog tasklog2_ on logs1_.logs_neoId=tasklog2_.neoId
inner join NeoUser neouser3_ on tasklog2_.owner_neoId=neouser3_.neoId
inner join SecurityEntity neouser3_1_ on neouser3_.neoId=neouser3_1_.neoId
inner join NeoUser neouser4_ on tasklog2_.user_neoId=neouser4_.neoId
inner join SecurityEntity neouser4_1_ on neouser4_.neoId=neouser4_1_.neoId
where tasklog2_.action=0 and task0_.neoId=1698575