To define the structure for advanced SQL

Rank: #895

Solved

Question

How to define the structure for below advanced SQL?

I have tried to define its structure as below.

Structure1
- Cases (type Case entitiy)
- name (type Text)

But failed. Please advise.

SELECT {Cases}.*, {User}.Name
FROM {Cases} 
INNER JOIN {User} ON [CreatedBy] = {User}.[Id]
WHERE [CreatedDt] BETWEEN  @FromDate AND @ToDate

on 2020-11-25

Rank: #68

Solution

Hello Jessica,

The structure can look like this:

Please, share the error message to confirm that the error is related to the structure.

on 2020-11-25

Rank: #70

Hi Jessica,

Instead of having a single structure, add one output for the Cases entity and one of a structure with a single attribute of type Text:

In the example I create a text structure to use and your Output Entities / Structures should look like this.

Hope it helps.

Regards,
João

on 2020-11-25

Rank: #68

Solution

Hello Jessica,

The structure can look like this:

Please, share the error message to confirm that the error is related to the structure.

on 2020-11-25

Rank: #895

Thank. It works

on 2020-11-26