Using Relations with Nested JSON as DataSource

Stimulsoft BI Server discussion
MichalCh
Posts: 17
Joined: Fri Sep 22, 2017 7:37 am

Using Relations with Nested JSON as DataSource

Post by MichalCh »

Hello,

I'm sorry if it's not the right place to post such a question.

I'm trying to do a relations within JSON file in Designer but unfortunately only the first record "get's parsed".

Could you please tell me what am I doing wrong in here? I'm passing screenshot as well as .mrt and .json (datasource) files.

I'm connecting results.individualDetails (parent) with results_individualDetails.relationId (this is the variable which was added automatically by stimulsoft)

Cheers
Attachments
GTM-Profiles.JSON
(32.11 KiB) Downloaded 432 times
empList.mrt
(30.51 KiB) Downloaded 411 times
Screenshot_191.png
Screenshot_191.png (71.74 KiB) Viewed 13013 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Using Relations with Nested JSON as DataSource

Post by HighAley »

Hello.

The parent columns should have unique values.
Please, check the attached report template.

Thank you.
Attachments
empList_modified.mrt
(34.18 KiB) Downloaded 448 times
MichalCh
Posts: 17
Joined: Fri Sep 22, 2017 7:37 am

Re: Using Relations with Nested JSON as DataSource

Post by MichalCh »

Hello,

I've had such a situation as well. The ids are the same in such a relation.

I've found the issue. The RelationID generated by the Stimulsoft Designer 2017.1.11 [WinForms] are always "0"s that's why the first value is copied.

If I open the JS version of the Designer the values are being populated correctly.

Cheers
Attachments
Screenshot_200.png
Screenshot_200.png (39.99 KiB) Viewed 13001 times
tayar
Posts: 30
Joined: Tue Sep 26, 2017 9:22 am

Re: Using Relations with Nested JSON as DataSource

Post by tayar »

I have another question. Is there any way to present a JSON in a normal hierarchical structure?
The alternative option would be to use `Data from Business Objects` or `Data from user Sources`. Do you have any other suggestion how the data can be presented hierarchically? The current representation is very misleading for the customers and adds a lot of extra work requirements.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Using Relations with Nested JSON as DataSource

Post by HighAley »

Hello.

Unfortunately, it's impossible to get the hierarchical structure of the JSON in the Dictionary.

Thank you.
tayar
Posts: 30
Joined: Tue Sep 26, 2017 9:22 am

Re: Using Relations with Nested JSON as DataSource

Post by tayar »

Hello,
If we are not concentrating on JSON, are there any other hierarchical structure possible?
Otherwise, is it possible to create all required links automatically while importing a JSON with hierarchical structure?
It is very annoying to force a user to recreate manually the information which is anyway known to the system by the time of the import.

Thanks
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Using Relations with Nested JSON as DataSource

Post by HighAley »

Hello.

Sorry for the delay with answer.
You could use Actions - Synchronize in the Dictionary.
This action adds all relations.

Thank you.
tayar
Posts: 30
Joined: Tue Sep 26, 2017 9:22 am

Re: Using Relations with Nested JSON as DataSource

Post by tayar »

HighAley wrote: You could use Actions - Synchronize in the Dictionary.
This action adds all relations.
Unfortunately, the Action menu appears to be only in the WPF version. we are using Web (.NET ) version.
Is there any chance to get it there?
Edward
Posts: 2913
Joined: Fri Jun 09, 2006 4:02 am

Re: Using Relations with Nested JSON as DataSource

Post by Edward »

Hi Tayar,

That is not a problem. If you are able to connect to your data in the Designer.WinForms.exe then just open the mrt report template there, then connect to your data and then use the above-mentioned menu item.

Thank you,
Edward
tayar
Posts: 30
Joined: Tue Sep 26, 2017 9:22 am

Re: Using Relations with Nested JSON as DataSource

Post by tayar »

Edward wrote: That is not a problem. If you are able to connect to your data in the Designer.WinForms.exe then just open the mrt report template there, then connect to your data and then use the above-mentioned menu item.
Edward
Hi Edward,
It is not a problem for me as a developer. But it is a huge problem for the customers. The customers of the cloud application do not have any desktop designer and won't have an access to the raw mrt files. Additionally, they should not have any idea about these details of internal implementation.
So I would really appreciate having a real solution and not an ugly workaround.

Thanks
Post Reply