This is a migrated thread and some comments may be shown as answers.

Grid schema collection property

2 Answers 97 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Jesse
Top achievements
Rank 1
Jesse asked on 08 Oct 2012, 02:19 PM
My model has a property that is a collection.  The collection can have any number of codes.  eg CPT, Rev, ...  If CPT is present in the collection I would like its code to be put in a CPT column and the same for any other codes.

Here is an example of my json from my WebAPI.
{
Data: [
  {
     ServiceId: 1,
     BillingCode: "123456789",
     Description: "Broken Arm",
     ChargeAmount: 2.15,
     Department: null,
     Codes: [
         {
         CodeType: "CPT",
         CodeNumber: "1234"
         },
         {
         CodeType: "Rev",
         CodeNumber: "5555"
         }
    ]
  },
  {
    ServiceId: 2,
    BillingCode: "2",
    Description: "Broken Leg",
    ChargeAmount: 4.5,
    Department: null,
    Codes: [
       {
       CodeType: "HCPC",
       CodeNumber: "4543"
       }
    ]
  }
  ],
 Count: 2
}

I would like the columns to be:
Billing Code | Description | Charge Amount | Department | CPT | Rev | HCPC

        dataSource: new kendo.data.DataSource(
            {
                transport: {
                    read: "api/Codes"
                },
                pageSize: 5,
                serverPaging: true,
                schema:
                    {
                        data: "Data",
                        total: "Count"
                    }
            }),

Is what I have so far and I can get everything filled in except the codes.

2 Answers, 1 is accepted

Sort by
0
Alexander Valchev
Telerik team
answered on 11 Oct 2012, 08:27 AM
Hi Jesse,

I am afraid that what you would like to achieve is not supported out of the box. The DataSource is designed to operate with flat data which is why the "Codes" are not displayed. Please bind the grid to a flat data structure and let me know if the problem still persists.

Kind regards,
Alexander Valchev
the Telerik team
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
0
Jesse
Top achievements
Rank 1
answered on 11 Oct 2012, 04:37 PM
I ended up doing something like this.
{
           title: "CPT",
            template: '# $.each(Codes, function(data) { # #if(this.CodeType === "CPT") {# #= this.CodeNumber # # }}); #'
        }, {
            title: "Rev",
            template: '# $.each(Codes, function(data) { # #if(this.CodeType === "Rev") {# #= this.CodeNumber # # }}); #'
        }, {
            title: "HCPC",
            template: '# $.each(Codes, function(data) { # #if(this.CodeType === "HCPC") {# #= this.CodeNumber # # }}); #'
        },

However doing this means the grid will not allow you to filter those columns and this is also hard coded and does not allow for user generated code types.

Thank you for your help.
Tags
Grid
Asked by
Jesse
Top achievements
Rank 1
Answers by
Alexander Valchev
Telerik team
Jesse
Top achievements
Rank 1
Share this question
or