Page 1 of 2
Using Relations with Nested JSON as DataSource
Posted: Mon Nov 13, 2017 9:05 am
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
Re: Using Relations with Nested JSON as DataSource
Posted: Tue Nov 14, 2017 8:25 am
by HighAley
Hello.
The parent columns should have unique values.
Please, check the attached report template.
Thank you.
Re: Using Relations with Nested JSON as DataSource
Posted: Tue Nov 14, 2017 9:20 am
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
Re: Using Relations with Nested JSON as DataSource
Posted: Tue Nov 14, 2017 9:30 am
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.
Re: Using Relations with Nested JSON as DataSource
Posted: Thu Nov 16, 2017 10:36 am
by HighAley
Hello.
Unfortunately, it's impossible to get the hierarchical structure of the JSON in the Dictionary.
Thank you.
Re: Using Relations with Nested JSON as DataSource
Posted: Thu Nov 16, 2017 10:56 am
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
Re: Using Relations with Nested JSON as DataSource
Posted: Tue Nov 21, 2017 10:03 am
by HighAley
Hello.
Sorry for the delay with answer.
You could use Actions - Synchronize in the Dictionary.
This action adds all relations.
Thank you.
Re: Using Relations with Nested JSON as DataSource
Posted: Tue Nov 21, 2017 10:20 am
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?
Re: Using Relations with Nested JSON as DataSource
Posted: Wed Nov 22, 2017 5:13 am
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
Re: Using Relations with Nested JSON as DataSource
Posted: Wed Nov 22, 2017 8:49 am
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