Using Relations with Nested JSON as DataSource
Using Relations with Nested JSON as DataSource
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
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 533 times
-
- empList.mrt
- (30.51 KiB) Downloaded 519 times
-
- Screenshot_191.png (71.74 KiB) Viewed 13944 times
Re: Using Relations with Nested JSON as DataSource
Hello.
The parent columns should have unique values.
Please, check the attached report template.
Thank you.
The parent columns should have unique values.
Please, check the attached report template.
Thank you.
- Attachments
-
- empList_modified.mrt
- (34.18 KiB) Downloaded 548 times
Re: Using Relations with Nested JSON as DataSource
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
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 (39.99 KiB) Viewed 13932 times
Re: Using Relations with Nested JSON as DataSource
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.
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
Hello.
Unfortunately, it's impossible to get the hierarchical structure of the JSON in the Dictionary.
Thank you.
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
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
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
Hello.
Sorry for the delay with answer.
You could use Actions - Synchronize in the Dictionary.
This action adds all relations.
Thank you.
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
Unfortunately, the Action menu appears to be only in the WPF version. we are using Web (.NET ) version.HighAley wrote: You could use Actions - Synchronize in the Dictionary.
This action adds all relations.
Is there any chance to get it there?
Re: Using Relations with Nested JSON as DataSource
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
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
Hi Edward,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
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