Filter Foreign key column foreignkeyField is Guid errror invalid Cast from 'System.String' to System.Guid

[Patricio Venegas B]

When filtering by a column of type lookup gives me the conversion error.

from string to guid  

<ejs-grid id="Grid" dataBound="dataBound" allowTextWrap="true" allowPaging="true" allowSorting="true" allowFiltering="true" toolbar="@(new List<string>() {"Search" })" load="onLoad">

                                <e-grid-filterSettings type="CheckBox" mode="OnEnter" showFilterBarStatus="true"></e-grid-filterSettings>

                                <e-data-manager url="Grid?handler=SetdataGrid" adaptor="UrlAdaptor"></e-data-manager>

                                <e-grid-editSettings allowAdding="true" allowDeleting="true" allowEditing="true" mode="Dialog"></e-grid-editSettings>

                                <e-grid-pagesettings pageCount="8"></e-grid-pagesettings>

                                <e-grid-columns>         

                                    <e-grid-column field="Id" headerText="ID" isPrimaryKey="true"  textAlign="Right" visible="false" width="120" ></e-grid-column>

                                    <e-grid-column field="Title" headerText="Title" textAlign="Left" width="200"></e-grid-column>

                                    <e-grid-column field="Description" headerText="Description" width="200" textAlign="Left"></e-grid-column>

                                    <e-grid-column field="Created" headerText="Created" allowEditing="false" type="date" format="yMMMd" width="150"></e-grid-column>

                                    <e-grid-column field="Unit" foreignKeyField="IdUnit" editType="dropdownedit"  foreignKeyValue="Unit1" dataSource="@ViewBag.unit" headerText="Unidad" width="150"></e-grid-column>

                                </e-grid-columns>

                            </ejs-grid>

[Venkatesh Ayothi Raman]

Hi Patricio, 

Thanks for contacting Syncfusion support. 

We have considered this “Exception thrown when converting String typed values to Guid in URLAdaptor” as an issue, and logged a defect report for the same. The fix for the issue will be available in our September 5,2018 patch release. 

Until then we appreciate your patience. 

Regards, 

Venkatesh Ayothiraman. 

[Patricio Venegas B]

the problem continues

[Venkatesh Ayothi Raman]

Hi Patricio, 

We are sorry for the inconvenience caused. 

This issue has been fixed internally. But due to the NuGet package is not published online, the fix is not yet released. This fix is expected to be available in our Volume 3, 2018 Beta release, which is scheduled to be rolled out on September 10, 2018, tentatively. 

We will update you once the release is rolled out. Until then we appreciate your patience. 

 

Regards, 

Venkatesh Ayothiraman. 

[Patricio Venegas B]

unfortunately after updating to the latest version 16.3.21 the problem continues.

[Venkatesh Ayothi Raman]

Hi Patricio, 

We have analyzed the reported query. We could not reproduce the mentioned issue after updated to the latest version(Volume 3, 2018) “v.16.3.21”. We have created a sample performing filtering with the Guid values in Grid for your convenience. Please download the sample from the link below, 

Sample : http://www.syncfusion.com/downloads/support/directtrac/general/ze/EJ2-dotnet-core2124093565 

 

We would like to inform that the Syncfusion nuget package name has been changed from “Syncfusion.EJ2” to “Syncfusion.EJ2.AspNet.Core”. So we suggest you to install the latest version(v.16.3.0.21) of our nuget to overcome this issue. Please refer the screenshot below, 

 

Please get back to us if you need further assistance. 

Regards, 

Venkatesh Ayothiraman.