search button

[Stefano Capobianco]

Hi, in my grid i've enabled the toolbar with the search button:

<EjsGrid TValue="Title" AllowPaging="true" Query="@GridQuery" Toolbar="@Tool" GridLines="GridLine.Both" EnableAltRow="true">

    <EjsDataManager Url="https://localhost:44319/Titles/Gets" Adaptor="Adaptors.WebApiAdaptor"></EjsDataManager>

    <GridSearchSettings Fields="@SpecificCols" IgnoreCase="true" Operator="Operator.Contains"></GridSearchSettings>

    <GridEvents CommandClicked="OnCommandClicked" TValue="Title"></GridEvents>

    <GridPageSettings PageSize="5" PageSizes="true"></GridPageSettings>

    <GridColumns>

        <GridColumn Field=@nameof(Title.Id) HeaderText="Title Id" TextAlign="TextAlign.Center" Width="10" Visible="false"></GridColumn>

        <GridColumn Field=@nameof(Title.TitleAbbreviated) HeaderText="Abbreviazione" TextAlign="TextAlign.Center" Width="10"></GridColumn>

        <GridColumn Field=@nameof(Title.TitleName) HeaderText="Titolo" TextAlign="TextAlign.Center" Width="10" AllowSearching="true"></GridColumn>

        <GridColumn HeaderText="Azioni" TextAlign="TextAlign.Center" Width="10">

            <GridCommandColumns>

                <GridCommandColumn ButtonOption="@(new CommandButtonOptions() { IconCss = "e-icons e-edit", CssClass = "e-flat", Content = "Edit" })"></GridCommandColumn>

                <GridCommandColumn ButtonOption="@(new CommandButtonOptions() { IconCss = "e-icons e-delete", CssClass = "e-flat", Content = "Delete" })"></GridCommandColumn>

            </GridCommandColumns>

        </GridColumn>

    </GridColumns>

</EjsGrid>

and there are the declaration inside code section

    public Query GridQuery { get; set; }

    public string[] SpecificCols = (new string[] { "TitleName" });

    public List<string> Tool = (new List<string>() { "Search", "Print" });

When i press the search button start the request to remote controller but in the querystring i've nothing about filter and if i need to add query parameter how can i handle search request ?

This is my remote controller

        [HttpGet]

        public async Task<IActionResult> Gets()

        {

            var queryString = Request.Query;

            

            string showDeleted = (queryString.TryGetValue("TitleDeleted", out StringValues TitleDeleted)) ? TitleDeleted[0] : null;

            

            if (queryString.Keys.Contains("$inlinecount"))

            {

                int skip = (queryString.TryGetValue("$skip", out StringValues Skip)) ? Convert.ToInt32(Skip[0]) : 0;

                int take = (queryString.TryGetValue("$top", out StringValues Take)) ? Convert.ToInt32(Take[0]) : 0;

                

                var titles = await _mediator.Send(new QueryTitles(skip, take, showDeleted));

                return new OkObjectResult(new { Items = _mapper.Map<IEnumerable<Title>>(titles), Count = await _mediator.Send(new QueryTitlesCount(showDeleted)) });

            }

            else

            {

                var titles = await _mediator.Send(new QueryTitles(0, 0, showDeleted));

                return new OkObjectResult(_mapper.Map<IEnumerable<Title>>(titles));

            }

 

        }

Thanks in advance

Stefano

[Renjith Singh Rajendran]

Hi Stefano, 

Thanks for contacting Syncfusion support. 

We have confirmed this as a defect and logged a defect report for the same. Thank you for taking the time to report this issue “Search predicates are not generated in $filter query in WebApiAdaptor” 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 bi-weekly release which is expected to be rolled out on or before March 11, 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.  

Feedback Link : https://www.syncfusion.com/feedback/11943/search-predicates-are-not-generated-in-filter-query-in-webapiadaptor 

 

Once the release is rolled out, you will get the search action query in the “Request.Query”. Please handle the search query($filter) in your WebApi service, based on the “Request.Query” you get from the request. 

 

        [HttpGet] 

        public object Get() 

        { 

            IQueryable<Projekte> data = db.GetAllProjektes().AsQueryable(); 

            var count = data.Count(); 

            var queryString = Request.Query;                  //Based on this request query, handle the search action. 

            string search = queryString["$filter"];          //get the search query here      

            ... 

       } 

 

 

Please get back to us if you need further assistance. 

Regards, 

Renjith Singh Rajendran. 

[Stefano Capobianco]

Hi, thanks for your answer. 

It's possible to know if a temporary fixing for this problem was planned or it's necessary to wait for the update ?

Stefano

[Renjith Singh Rajendran]

Hi Stefano, 

Thanks for your update. 

Workaround is currently not possible for this issue. We believe you need this fix urgently hence we have created a custom nuget patch to resolve this issue. Please download the patch from the link below, 

Custom Nuget patch : https://www.syncfusion.com/downloads/support/directtrac/general/ze/nugetcustom1042313022 

 

We suggest you to clear the nuget cache and install the provided custom nuget from the above link in your application to resolve this problem. Please use this custom nuget patch till the March 11, 2020, release is rolled out. 

Please get back to us if you need further assistance. 

Regards, 

Renjith Singh Rajendran. 

[Stefano Capobianco]

Thanks for the patch, now the $filter query string parameter appear inside the webapi controller.

Little question: using this custom patch it's impossible to use the new package release (17.4.0.49) right ?

Thanks

Stefano

[Renjith Singh Rajendran]

Hi Stefano, 

Thanks for your update. 

Yes, in our latest version 17.4.0.49, the fix in the custom nuget patch will not be available. So, for your convenience, we have prepared the patch with our latest version 17.4.0.49. Please use the custom nuget patch from the link below, 

Custom Nuget Patch : https://www.syncfusion.com/downloads/support/directtrac/general/ze/Nuget-1273823975 

 

Please get back to us if you need further assistance. 

Regards, 

Renjith Singh Rajendran. 

[Abdul Qadir Ahmed Abbasi]

Hi Syncfusion Team,

I hope you will find this in your best. I am working with "ODataV4Adaptor" + "SfGrid" in my Blazor app and found the same bug. I have "18.4.0.47"  version installed. I am able to see the "$search" in HttpContext.Request.Query , but it is not translated to "$filter". You are requested to kindly get back to me on this ASAP.

Kind Regards,

Abdul Qadir Ahmed Abbasi

[Vignesh Natarajan]

Hi Abdul,  

 

Thanks for contacting Syncfusion support.  

 

Query: “ am working with "ODataV4Adaptor" + "SfGrid" in my Blazor app and found the same bug. I have "18.4.0.47"  version installed. I am able to see the "$search" in HttpContext.Request.Query , but it is not translated to "$filter" 

 

We have analyzed the reported query and we understand that you are facing difficulties while performing search operation in Grid using ODataV4 adaptor. We would like to inform you that we have provided support to perform search operation in ODataV4 using $filter query in our 18.3.0.52 version patch release. 

 

Please find the release notes regarding the same from below  

 

https://blazor.syncfusion.com/documentation/release-notes/18.3.52/?type=all#grid    

 

To enable search operation in OData, we suggest you enable the EnableODataSearchFallback option in SfDataManager component using the OnAfterRender lifecycle event. Please use the below code in your application to perform search operations in Grid using $filter query string. 

 

<SfGrid TValue="Order" @ref="GridInstance" AllowPaging="true" Toolbar=@ToolbarItems AllowFiltering="true"> 

    <SfDataManager @ref="dm" Url="http://localhost:64956/odata/books" Adaptor="Adaptors.ODataV4Adaptor"></SfDataManager> 

. . . . .  

</SfGrid> 

  

@code{ 

    SfGrid<Order> GridInstance; 

    public SfDataManager dm{ get; set; } 

  

    protected override void OnAfterRender(bool firstRender) 

    { 

        base.OnAfterRender(firstRender); 

        (dm.DataAdaptor as ODataV4Adaptor).Options.EnableODataSearchFallback = true; 

    } 

 

 

Limitation: Please find the following limitations applied for implementing this feature in your application. 

 

1.  The contains operator will be applied only for string typed column
2. The equal operator will only be applied for all other data types.

 

Please get back to us if you have further queries.  

 

Regards,
Vignesh Natarajan