Filters defined in View have null values

2 posts, 0 answers
  1. Vesselin Obreshkov
    Vesselin Obreshkov avatar
    81 posts
    Member since:
    Jan 2010

    Posted 27 Jun 2012 Link to this post

    When defining filter in my views using the new helpers, the filter values come back null. Here is one example (I have few other very similar grids all producing the exact same result for me).

    In this example, I am giving the filter a value coming from the ViewBag.StatusID, however hard-coding a specific value (1) produces the same null value.

    View

    @(Html.Kendo().Grid<Mobooka.Models.Campaign>()
    	.Name("CampaignsGrid")
    	.Columns(columns =>
    	{
    		columns.Bound(o => o.CampaignID).Title("ID").Width(80);
    		columns.Bound(o => o.Offer.OfferName).Title("Offer");
    		columns.Bound(o => o.Offer.Advertiser.Company.CompanyName).Title("Advertiser").Width(180);
    		columns.Bound(o => o.Status.StatusName).Title("Status").Width(100);
    	})
    	.DataSource(dataSource => dataSource
    		.Ajax()
    		.Read(read => read.Action("GetCampaigns""Home"))
    		.Filter(filter => filter.Add(f => f.StatusID).Equals(ViewBag.StatusID))
    .PageSize(25) .ServerOperation(true) ) .Filterable(filtering => filtering .Enabled(true) ) .Pageable(paging => paging .Enabled(true) .Info(true) .PageSizes(false) .Refresh(true) ) .Scrollable(scrolling => scrolling .Enabled(true) .Height(560) .Virtual(true) ) .Sortable(sorting => sorting .Enabled(true) .AllowUnsort(true) .SortMode(GridSortMode.SingleColumn) ) )

    Controller

    public ActionResult Index()
    {
    	ViewBag.StatusID = (int)Enumerations.Status.Pending; 
    	return View();
    }
    ...
    public JsonResult GetCampaigns([DataSourceRequestDataSourceRequest request)
    {
    	IEnumerable<Campaign> campaigns = db.Campaigns....;
    	return new JsonNetResult(campaigns.ToDataSourceResult(request));
    }

    Request

    1. Request URL:
      http://dashboard.mobooka.local/Admin/Home/GetCampaigns
    2. Request Method:
      POST
    3. Status Code:
      500 Internal Server Error
    4. Request Headersview source
      1. Accept:
        */*
      2. Accept-Charset:
        ISO-8859-1,utf-8;q=0.7,*;q=0.3
      3. Accept-Encoding:
        gzip,deflate,sdch
      4. Accept-Language:
        en-US,en;q=0.8
      5. Cache-Control:
        max-age=0
      6. Connection:
        keep-alive
      7. Content-Length:
        55
      8. Content-Type:
        application/x-www-form-urlencoded
      9. Cookie:
        ASP.NET_SessionId=nrwg2rrgsl1mpskv4yd40na0; .MOBOOKAXAUTH=F8959A12603B131542EB99BCA073D828E64DB8EAA2BF0832D9C12107ED7D453AA9344DEE6AF10ADC966E1C1E50C517378805C2A50D12447FDCEDE5BFB6D69852444068BA6FAE7EFB5B198516494F4223D3221681FF0859D795FDDA70092F184F9C403A49B18BA57BF9F7F248A623F06E40915409CDAA83303B34536978E15A747FA3A47DE6A1D6932845ACDA4461ADC98A05F0EB; MOBOOKASESSION=Name=Mobooka&Type=Employee&A=0&E=7&P=0&U=21; .ASPXROLES=qK_xf5Puh7ahlJTQbCqrdo9FbtqU1d8cQFTVb-CRXFaFk8I1TtnjXrhJMmgwWFii2c24xHu2RAODRoKTCmFc8q0DP9nTavMKWK1XAwbEwtaGeHlg3SHcIjMS8UETV4lu8nOLlc2B6Ke1uUzxKqimbH2WrQN-NvKn212PpnBv6Tw4qeIgGShmK3YMXWjwj_HQzOHx_sjw6fuUOa8RtS-sFZUa6dE-XQyJguHLAlQibYl7DWTCvrSn4Lao7VImcKku9ql_eu6iFVal0kYxnR7e7K5ixOLayyiioUIb7ocwC_xMwPTxc8bAtKe2FTDJbTXSUqrcPu-n4EsffvtjjMgRfQ9ERw7j24hTYPE97fuwO-3YUxYLF5sb9LEM4Flpdf7ppDRelxCJw-1SO84nvQ9pCmX_AfPpdVTGQ1vCrGUkq2TjAD_7Q2c9n9OZhVLlbguEKO52xqcoZ0jOCRtABa8iBv73qBEOcFhd6ju66cV2VJwpPUSzY5dedqxWcQmMS0vKaSPhRALNdJwIJS4IK0w_PsSbU4Tz035EftcE7vb80HJVKS4U0
      10. Host:
        dashboard.mobooka.local
      11. Origin:
        http://dashboard.mobooka.local
      12. Referer:
        http://dashboard.mobooka.local/Admin/Home
      13. User-Agent:
        Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.56 Safari/536.5
      14. X-Requested-With:
        XMLHttpRequest
    5. Form Dataview URL encoded
      1. sort:
      2. page:
        1
      3. pageSize:
        25
      4. group:
      5. filter:
        StatusID~eq~null
    6. Response Headersview source
      1. Cache-Control:
        private
      2. Content-Length:
        8506
      3. Content-Type:
        text/html; charset=utf-8
      4. Date:
        Wed, 27 Jun 2012 17:45:11 GMT
      5. Server:
        Microsoft-IIS/7.5
      6. X-AspNet-Version:
        4.0.30319
      7. X-Powered-By:
        ASP.NET
  2. Rosen
    Admin
    Rosen avatar
    3234 posts

    Posted 28 Jun 2012 Link to this post

    Hi Vesselin,

    Looking at the code you have pasted it appears that you are calling the Object's Equals method instead the appropriate IsEqualTo. Please modify the code and see if there is a change in the behavior.

    All the best,
    Rosen
    the Telerik team
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
  3. UI for ASP.NET MVC is VS 2017 Ready
Back to Top