Column names in Web API DS

SquaredUp Cloud
1

Hi

I have this SQL analytics query configured:

SELECT Activities.name AS Name, TimeEntries.duration.startedAt, TimeEntries.duration.stoppedAt, TimeEntries.activityId
FROM TimeEntries
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:
image

How do I include only the column names with dots in them ?

KR
Nick

2

Hi Nick, try adding square brackets, e.g. TimeEntries.[duration.startedAt] instead of TimeEntries.duration.startedAt.

Andy

1 Like