private Worklog createWorklogWithAliasedIdColumn(final Issue issue, final Tuple tuple)
{
final Timestamp createdTimestamp = tuple.get(QWorklog.WORKLOG.created);
final Timestamp updatedTimestamp = tuple.get(QWorklog.WORKLOG.updated);
final Long roleLevel = tuple.get(QWorklog.WORKLOG.rolelevel);
final ProjectRole projectRole = roleLevel != null ?
queryDSLProjectRoleFactory.createProjectRole(tuple) : null;
final Timestamp startDate = tuple.get(QWorklog.WORKLOG.startdate);
return new WorklogImpl2(issue,
tuple.get(QWorklog.WORKLOG.id.as("WORKLOG_ID")),
tuple.get(QWorklog.WORKLOG.author),
tuple.get(QWorklog.WORKLOG.body),
startDate != null ? new Date(startDate.getTime()) : null,
tuple.get(QWorklog.WORKLOG.grouplevel),
roleLevel,
tuple.get(QWorklog.WORKLOG.timeworked),
tuple.get(QWorklog.WORKLOG.updateauthor),
createdTimestamp != null ? new Date(createdTimestamp.getTime()) : null,
updatedTimestamp != null ? new Date(updatedTimestamp.getTime()) : null,
projectRole);
}