Problem while using Search Builder

IICS Aldrine

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

allan

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

IICS Aldrine

@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.

IICS Aldrine

@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'
}
]
});

allan

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