Best strategy for creating complex view forms

1

Hi Radzen,

I need to create a view form that shows a lot of related information to a record.

For example, a [Student Attendance] record is related to a [Student Class] record which is related to a [Class] and a [Term]. The [Class] is related to a [Course] which is related to a [Department]… you get the picture.

Suppose I want a View Form for the [Student Attendance] (not sure why I would want that, but that’s an illustration) that shows all the details of a particular [Student Attendance] record:

  • Attendance.DateTime
  • Attendance.Class.Course.Name
  • Attendance.Class.Course.Department.Name
  • Attendance.Term.Name
  • etc…

Using a Form with Disabled fields is not a good option because the inheritance chain is too long.

What would be your advice for such a scenario?

Thanks

2

Hi
You could create a View with all this information on

3

I would do it like this:

  1. Get the desired entity and $expand all related entities as needed. For example:
    32
    Screen Shot 2018-07-27 at 10.54.32.png1792×1078 65.2 KB
  2. Add a few Row and Column components to define some structure and use Label componentss to display the data. Set the Text property of the labels to ${product.ProductName} or ${product.Category.CategoryName}.

After that things should look like this:

45
Screen Shot 2018-07-27 at 10.57.45.png3270×1846 439 KB

Would something like this work for your case?

4

I was mentally stuck on using getRecordByRecordID when populating a form… Your solution is straightforward, thanks!

5

To be honest using getRecordByRecordID should have worked too if it had the $expand parameter exposed. I am logging that in the TODO list.

6

This would be a nice little improvement… It’s got my vote :yum:

7

Any news on exposing the $expand parameter in getRecordByRecordID?

8

Hi @semafox,

We will do our best to provide it soon, in the meantime you can use getRecordsXXX with $filter by id and $expand to return collection of one record.

Best Regards,
Vladimir

9

Hey @semafox,

Radzen 2.11.0 was just released with $expand query parameter support added for getByXXX, updateXXX and createXXX methods.

Best Regards,
Vladimir