.NET Core project call to .NET API isn't paging
I'm working on filtering based on your previous provided answer. When I type enter after entering a value in the field, the spinner spins indefinitely and I get the following error:
Here is the code you provided as I put it in the server side:
if (filter != "" && filter != null)
{
var newfiltersplits = filter;
var filtersplits = newfiltersplits.Split('(', ')', ' ');
var filterfield = filtersplits[1];
var filtervalue = filtersplits[3];
if (filtersplits.Length != 5)
{
filterfield = filter.Split('(', ')', '\'')[3];
filtervalue = filter.Split('(', ')', '\'')[5];
}
System.Diagnostics.Debug.WriteLine(filtervalue);
switch (filterfield)
{
case "TabName":
I'm getting a bit different query string with different array values. The image "screenshot of grid filter columns.jpg" shows what happens when I type "dfdfd" in the TabName column filtering. I've also included the error I get when I hit enter after entering a value in a filter field. I've broken the query string based on your code above to show you the positions of the array and their respective indices, and I've also included the entire filter par:
$filter=(startswith(tolower(TabName),%27dfdfd%27))%20and%20((LastModifiedOnDate%20gt%20datetime%27null%27)%20and%20(LastModifiedOnDate%20lt%20datetime%27null%27))
- Please share the issue replicating sample
- Share complete grid rendering code or replicate the issue in the above sample.
It's still giving error after looking through your example.The only difference from the other example I linked to above is the way you manipulate the data with the filter. I've provided theController, Controller Action method (isolated from the controller) and front-end SF EJ2 markup code.
PageViewController:
public object Get()
{
int skip = Convert.ToInt32(HttpContext.Current.Request.QueryString["$skip"].ToString());
int take = Convert.ToInt32(HttpContext.Current.Request.QueryString["$top"].ToString());
//var skip = queryString["$skip"]; // paging
//int take = Convert.ToInt32(queryString["$top"].ToString());
string filter = HttpContext.Current.Request.QueryString["$filter"];
var tab = new DashboardActions();
var retTabs = tab.PageViews(skip, take, filter);
return retTabs;
}
Here is the PageViews method shown at the end of the controller code above (I've left out my using context statement for security):
if (filter != null)
{
var newfiltersplits = filter;
var filtersplits = newfiltersplits.Split('(', ')', ' ');
var filterfield = filtersplits[1];
var filtervalue = filtersplits[3];
if (filtersplits.Length != 5)
{
filterfield = filter.Split('(', ')', '\'')[3];
filtervalue = filter.Split('(', ')', '\'')[5];
}
System.Diagnostics.Debug.WriteLine(filtervalue);
switch (filterfield)
{
case "TabName":
var recentPages = (from t in context.Tabs
where t.TabName.ToLower().StartsWith(filtervalue.ToString())
select t)
.Take(20)
.ToList();
return take != 0 ? new
{
Items = recentPages.Skip(skip).Take(take).ToList(),
Count = recentPages.Count()
} : new { result = recentPages, count = recentPages.Count() };
}
}
else
{
var recentPages = (from t in context.Tabs
select t)
.Take(20)
.ToList();
return take != 0 ? new results
{
result = recentPages.Skip(skip).Take(take).ToList(),
count = recentPages.Count()
} : new results { result = recentPages, count = recentPages.Count() };
}
}
And here is the front-end markup:
<ejs-grid id="Grid" allowPaging="true" allowFiltering="true">
<e-grid-pageSettings pageCount="3" pageSizes="true" pageSize="10"></e-grid-pageSettings>
<e-data-manager url="api.url.private" crossdomain="true"
adaptor="WebApiAdaptor"></e-data-manager>
<e-grid-columns>
<e-grid-column field="TabName" headerText="TabName" textAlign="Right" width="160"></e-grid-column>
<e-grid-column field="LastModifiedOnDate" headerText="LastModifiedOnDate" width="170"></e-grid-column>
<e-grid-column field="CreatedOnDate" headerText="CreatedOnDate" textAlign="Right" width="170"></e-grid-column>
</e-grid-columns>
</ejs-grid>
You'll notice I took the data access code out of the controller to follow best practices. I also was serializing the return object to JSON, but you're example didn't do that so I tried to see if that would work, but to no avail. Here is the response I get when I hit enter after entering a filter value (spinning circle in middle):
