Issue with odata after upgrade to version 19.2.44

[julio Avellaneda]

I upgraded a blazor wasm project from v19.1.69 to v19.2.44, and I found an issue with the odata and the autocomplete control, the url does not contain fields on the select when calling the endpoint

https://domain.com/odata/Customers?$count=true&$filter=contains(tolower(Name),%27po%27)&$select=&$skip=0&$top=30

If I rollback to v19.1.69 everything works fine.

[Ponmani Murugaiyan]

Hi julio, 

Thanks for contacting Syncfusion support. 

We able to replicate the reported issue in our end and we are validating on the same. We will update further details in 1 business days (July 6, 2021). We appreciate your patience until. 

Regards, 

Ponmani M 

[Ponmani Murugaiyan]

Hi Julio, 

Thanks for your patience. 

Query: “The request does not contain fields on the select with the Odata service.”  

  

We have considered the reported issue “Select Query is not updated properly in ODataV4Adaptor Request ” as bug in our end. The fix will be included in our next weekly patch release which is expected to be rolled out on or before 14th July 2021.       

  

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/26753/select-query-is-not-updated-properly-in-odatav4adaptor-request    

  

Till then we request you to resolve the reported issue with below workaround. We have extended the ODataV4Adaptor and overridden the OnSelect method to resolve the reported issue. Please find below code example.   

@using Syncfusion.Blazor.DropDowns;  

@using Syncfusion.Blazor.Data;  

  

<SfAutoComplete TValue="string" TItem="Order" Placeholder="Select a name" Query="@fieldQuery" Autofill="true">  

    <SfDataManager @ref="DM" Url=https://services.odata.org/V4/Northwind/Northwind.svc/Orders/ Adaptor="Adaptors.ODataV4Adaptor"></SfDataManager>  

    <AutoCompleteFieldSettings Value="ShipName"></AutoCompleteFieldSettings>  

</SfAutoComplete>  

  

@code{  

    public SfDataManager DM { get; set; }  

    public Query fieldQuery = new Query().Select(new List<string> { "ShipName" }).Take(10).RequiresCount();  

  

    public class CustomODataV4 : ODataV4Adaptor  

    {  

        public CustomODataV4(DataManager dataManager) : base(dataManager)  

        {  

  

        }  

        public override string OnSelect(List<string> selects)  

        {  

            selects = selects.Where(select => !select.Contains('.', StringComparison.Ordinal)).ToList();  

            return string.Join(",", selects);  

        }  

    }  

  

    protected override void OnAfterRender(bool firstRender)  

    {  

        base.OnAfterRender(firstRender);  

        if (DM != null)  

        {  

#pragma warning disable BL0005  

            DM.DataAdaptor = new CustomODataV4(DM);  

#pragma warning restore BL0005  

        }  

    }  

  

    public class Order  

    {  

        public int? OrderID { get; set; }  

        public string CustomerID { get; set; }  

        public DateTime? OrderDate { get; set; }  

        public double? Freight { get; set; }  

        public string ShipName { get; set; }  

    }  

}  

Please find the sample from below link: 

Sample: https://www.syncfusion.com/downloads/support/forum/166893/ze/AutoComplete_WASM-2022890341.zip   

   

Regards,  

Ponmani M 

[julio Avellaneda]

Hi Ponmani, thank you for your answer, I'll continue working with v19.1.69 until next release.

Thanks,

[Ponmani Murugaiyan]

Hi julio, 

Thanks for the update. We will let you know once the fix has been included in our end.  

Regards, 

Ponmani M 

[Ponmani Murugaiyan]

Hi Julio,  

We are glad to announce that our weekly patch release (v19.2.0.47) has been rolled out successfully and in this release, we have included the fix for issue “Select Query is not updated properly in ODataV4Adaptor Request”. So kindly update your NuGet (Syncfusion.Blazor) to our latest version to resolve the reported issue 

Please find the Nuget package and release notes from below 

Nuget: https://www.nuget.org/packages/Syncfusion.Blazor/  

Feedback: https://www.syncfusion.com/feedback/26753/  

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance.  

Regards, 

Ponmani M 

[julio Avellaneda]

Ponmani thank you, i already did the update and it works.

Regards,

[Berly Christopher]

Hi Julio, 

  

Most welcome. Please let us know if you need further assistance on this. 

  

Regards, 

Berly B.C