var query = ej.Query()
.from("contact")
.select("last_name","first_name")
.where("last_name", "equal" , "Yuan");
Queries |
Response | |
“What is the purpose of the Grid query property”?
|
The purpose of the Grid query is to communicate with the grid dataSource and returns the desired output based on the query provided. Using grid query we can perform various operation like filtering, searching etc.
We can also pass an additional parameter to an controller action, use the query API. In this sample we pass the parameter in addParams property using query API.
For more information refer the below document,
| |
“Alternatively just using a query directly, not bound to a Grid”
|
We checked in our sample with the mentioned query and we can able to render the specific column in the grid.
Find the code example and sample:
To find out the root cause of the issue, Share the following details
1. Code example of a Grid.
2. If you face any script error in the sample, Share the stackrace of an issue.
3. Essential Studio Version details.
4. If possible, replicate the issue in the attached sample.
| |
“However when using grid filtering it adds tolower to the request”
|
The purpose of adding is tolower on the request is to avoid the case-sensitive while searching the results. When we search with Capital letters or small letters it will return the same result in the server.
For more information please refer the below link
| |
“Is it just limit the initial data that the Grid loads?”
|
If you bind more number of data in grid, we suggest you to use OnDemand Paging feature of ejGrid. The OnDemand paging feature is used to get records of the particular page from the server-side.
To achieve OnDemand paging, we suggest you to bind the remote data and enable paging in the grid.
|
$("#Grid").ejGrid({
dataSource: dataManger,
allowPaging: true,
allowFiltering: true,
actionBegin : "begin",
columns: [
------------------------------------
]
});
});
function begin(args) {
if (args.requestType == "filtering") {
args.filterCollection[0].matchcase = true;
}
}
|