We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Sort and Filter by nested objects ( alpha => alpha.beta.bataName )

I have the following grid, and i am wondering if it is possible to sort or filter by objects nested in objects. The second coloum i define is what i am trying to sort and filter by with no luck. i get no results back at all.
*** VIEW
@(Html.EJ().DataManager("FlatData").URL(Url.Action("GlobalDataSource", "Home", null, Request.Url.Scheme)).Adaptor(AdaptorType.UrlAdaptor))
@(Html.EJ().Grid("Grid")
   .DataManagerID("FlatData")
   .AllowPaging()
   .AllowSorting()
   .AllowMultiSorting()
   .AllowFiltering()
   .AllowSearching()
   .ContextMenuSettings(contextMenu =>
   {
       contextMenu.EnableContextMenu();
    })
  .Columns(c =>
  {
    c.Field(f => f.ID).Width("7%").Add();
    c.Field(f => f.Company.CompanyName).Width("15%").Add();
    c.Field(f => f.TicketDisplayID).Width("15%").Add();
    c.Field(f => f.CreateDate).Width("10%").Add();
    c.Field(f => f.ClosedDate).Width("10%").Add();
    c.Field(f => f.ServiceItem).Width("10%").Add();
    c.Field(f => f.Desc).Width("13%").Add();
    c.Field(f => f.RespPartyResolutionTypeId).Width("10%").Add();
    c.Field(f => f.Parent).Width("10%").Add();
   })
  .SortSettings(sort => sort.SortedColumns(col => col.Field("ID").Direction(SortOrder.Descending).Add()))
  .PageSettings(p => p.PageSize(30).EnableQueryString())
  .ClientSideEvents(e => e
  .Create("create")
  .ActionComplete("onComplete")
  .ActionBegin("actionBegin")
))

**** CONTROLLER
public ActionResult GlobalDataSource(Syncfusion.JavaScript.DataManager dm)
{
 IEnumerable data = db.GlobalTicketInfo; 
 Syncfusion.JavaScript.DataSources.DataOperations operation = new Syncfusion.JavaScript.DataSources.DataOperations();
 if (dm.Sorted != null && dm.Sorted.Count > 0)
 {
    data = operation.PerformSorting(data, dm.Sorted);
 }
 if (dm.Where != null && dm.Where.Count > 0)
 {
    data = operation.PerformWhereFilter(data, dm.Where, dm.Where[0].Operator);
 }
 int count = data.AsQueryable().Count();
 if (dm.Skip != 0)
 {
    data = operation.PerformSkip(data, dm.Skip);
 }

 if (dm.Take != 0)
 {
    data = operation.PerformTake(data, dm.Take);
 }
 return Json(new { result = data, count = count }, JsonRequestBehavior.AllowGet);
}

5 Replies

VA Venkatesh Ayothi Raman Syncfusion Team December 21, 2016 12:53 PM UTC

Hi Diamond, 

As you have posted the same query in another forum. So, we request you to follow with the forum #127948 for the further updates for the reported query.  
 
Regards, 
Venkatesh Ayothiraman.

 



DI Diamond December 21, 2016 02:14 PM UTC

i made this thread so that the tags would be correct with the technology that i was using.
Thank you


VA Venkatesh Ayothi Raman Syncfusion Team December 22, 2016 04:15 AM UTC

Hi Diamond, 
Sorry for the inconvenience caused. 
We have wrongly updated the Forum id in previous update instead of Forum #127952.  
 
Regards, 
Venkatesh Ayothiraman.


DI Diamond December 22, 2016 04:14 PM UTC

This seems like an incident that multiple people must have ran into. Especially when entity makes it so easy to attack relational objects to other objects.
I am wondering what the standard work around for this problem is. I imagine that some has had to solve this problem before. 
Thank you for any workarounds that you are able to give me.

Diamond Wartenbee


KV Karthikeyan Viswanathan Syncfusion Team December 28, 2016 07:06 AM UTC

Hi Diamond, 

you have posted the same query in Incident #169600 . So, we request you to follow that Incident for the further updates. 
 
Regards, 
Karthikeyan V. 


Loader.
Up arrow icon