Problem while using Search Builder
Problem while using Search Builder
IICS Aldrine
Posts: 5Questions: 2Answers: 0
http://test.evbgroup.biz/users/employee/test.php
Hello I'm new and using Search Builder. When I'm search using it doesn't work. I'm using Serverside. Please click the link to see. Hope someone can help me.
Here is the response of AJAX:
{draw: 1, recordsTotal: 2, recordsFiltered: 2, data: [,…]}
data: [,…]
0: ["1", "EMPLOYEE, ONE", "DEPARTMENT ONE", "2022/08/18 17:00", "2022/08/18 19:00", "PENDING", "UNPAID"]
0: "1"
1: "EMPLOYEE, ONE"
2: "DEPARTMENT ONE"
3: "2022/08/18 17:00"
4: "2022/08/18 19:00"
5: "PENDING"
6: "UNPAID"
1: ["2", "EMPLOYEE, TWO", "DEPARTMENT TWO", "2022/08/18 10:00", "2022/08/18 11:00", "PENDING", ""]
0: "2"
1: "EMPLOYEE, TWO"
2: "DEPARTMENT TWO"
3: "2022/08/18 10:00"
4: "2022/08/18 11:00"
5: "PENDING"
6: ""
draw: 1
recordsFiltered: 2
recordsTotal: 2
Answers
What are you using for your server-side processing script? Our Editor PHP libraries support SearchBuilder, but the SSP class that is used for the plain DataTables demos does not. Or perhaps you are using something else?
Allan
@allan , I'm not using ssp.class.php. Should I use it? Is it the reason why my Searchbuilder is not working?
I'm just using basic php codes for getting the data from database.
@allan , update: I tried to use ssp.class.php it's also not working.
var table = $('#example1').DataTable({
"dom": "QBfrtip",
"processing": true,
"serverSide": true,
"ajax": "../../query/employee/getData.php",
"columns": [
{
data: "overtime_id",
searchBuilderType: 'string'
},
{
data: "employee_name",
searchBuilderType: 'string'
},
{
data: "department",
searchBuilderType: 'string'
},
{
data: "start_time",
searchBuilderType: 'string'
},
{
data: "end_time",
searchBuilderType: 'string'
},
{
data: "status",
searchBuilderType: 'string'
}
]
});
Like I said, the SSP class does not support SearchBuilder with server-side processing. You should not use it if you need server-side processing. Only our Editor libraries support server-side processing with SearchBuilder (out of the software we publish).
If you are using your own libraries, this part of the manual details what needs to be implemented to support it.
Allan