Grid Foreign Column with Grid Datasource as ExpandoObject

[Isaias Chalvatzoglou]

Good Day

In my Blazor Server Application I have a Grid which I load JSON data dynamically to it (with ExpandoObject).

I have a GridForeignColumn in my Grid. When I am trying to edit a row it raises the following error:

When I 'm trying to use an Edit Template inside my Foreign Column it raises the following error:

Foreign column's datasource has static data (loaded from a list).

An other question is if I can load Foreign column's data dynamically with ExpandoObject.

I 've attached a sample project.

Attachment: SfGrid_ForeignColumn_32c78f9c.7z

[Jeevakanth Palaniappan]

Hi Isaias, 

Greetings from Syncfusion support 

Query 1 : Editing for Expando object not working when grid has Foreignkeycolumn 

 

We have validated your query and we are able to reproduce the reported issue at our end. So we have considered it as a bug and logged the defect report “Editing for Expando object not working when grid has Foreignkeycolumn” for the same. Thank you for taking the time to report this issue and helping us improve our product. At Syncfusion, we are committed to fixing all validated defects (subject to technological feasibility and Product Development Life Cycle ) and including the defect fix in our upcoming patch release which is expected to be rolled out by the mid of November 2020. 

    

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.    

https://www.syncfusion.com/feedback/18766/editing-for-expando-object-not-working-when-grid-has-foreignkeycolumn  

Query 2: When I 'm trying to use an Edit Template inside my Foreign Column it raises the following error 

 

Currently we are validating the reported problem. We will update the further details in two business days. Until then we appreciate your patience. 

 

Regards, 

Jeevakanth SP. 

[Erick]

Hello,

I'm having the same problem. Whenever I try to use EditTemplate or Template inside GridForeignColumn I get the error:

Index.razor(37,17): error RZ9996: Unrecognized child content inside component 'GridForeignColumn'. The component 'GridForeignColumn' accepts child content through the following top-level items: 'ChildContent', 'EditTemplate', 'FilterTemplate', 'HeaderTemplate', 'Template', 'FilterItemTemplate'.

This is the following code snippet:

            <GridForeignColumn Field=@nameof(People.PictureId) HeaderText="Imagen" TValue="PictureBinary" ForeignKeyField="Id" ForeignKeyValue="BinaryData" AutoFit="true">

<SfDataManager Headers=@HeaderData Url=@($"{apiURL}/picturebinary") Adaptor="Adaptors.ODataV4Adaptor" CrossDomain="true"></SfDataManager>

<Template>

@{}

</Template>

</GridForeignColumn>

Is there any temporary solution while the correction patch is published?

I need to display/load an image in a foreign table (all via OData)

Thanks,

Erick

[Jeevakanth Palaniappan]

Hi Isaias/Erick, 

Sorry for the delay in getting back to you. 

Query 1: When I 'm trying to use an Edit Template inside my Foreign Column it raises the following error  

We have validated your query and we have considered it as a bug and logged the defect report “Need to handle edit template for Foreignkeycolumns when grid has expando binding” for the same. Thank you for taking the time to report this issue and helping us improve our product. At Syncfusion, we are committed to fixing all validated defects (subject to technological feasibility and Product Development Life Cycle ) and including the defect fix in our upcoming the Patch release which is expected to be rolled out by the mid of December 2020. 

 

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link. 

https://www.syncfusion.com/feedback/19594/need-to-handle-edit-template-for-foreignkeycolumns-when-grid-has-expando-binding  

Until then we appreciate your patience. 

Query 2: Unrecognized child content inside component 'GridForeignColumn'. 

We suggest you to use the below code to resolve your issue. 

        <GridForeignColumn TValue="EmployeeData" Field=@nameof(Order.EmployeeID) HeaderText="Employee Name" ForeignKeyValue="FirstName" Width="150"> 

            <Template> 

                <div> 

                    <span>check</span> 

                </div> 

            </Template> 

            <ChildContent> 

                <Syncfusion.Blazor.Data.SfDataManager Url="https://js.syncfusion.com/demos/ejServices/Wcf/Northwind.svc/Employees" CrossDomain="true" Adaptor="Adaptors.ODataAdaptor"> 

                </Syncfusion.Blazor.Data.SfDataManager>                 

            </ChildContent> 

        </GridForeignColumn> 

Please get back to us if you need further assistance. 

Regards, 

Jeevakanth SP.