16
Views
3
Comments
Solved
To define the structure for advanced SQL
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
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.

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

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.

Rank: #895

Thank. It works