I have this SQL analytics query configured:
SELECT Activities.name AS Name, TimeEntries.duration.startedAt, TimeEntries.duration.stoppedAt, TimeEntries.activityId
INNER JOIN Activities ON TimeEntries.activityId=Activities.id
Problem is that I do not get the duration.startedAt and duration.stoppedAt column.
If i call them with TimeEntries.* they are visible:
How do I include only the column names with dots in them ?