Datatables Editor 2 - Serverside with Oracle-DB
Datatables Editor 2 - Serverside with Oracle-DB
Dear Alan,
I am using the latest version of Datatables together with the Editor PHP class (serverside). Unfortunately, the simplest filtering and SearchPane functionality are not working with the Oracle driver. In the SearchPane, all the counts return a 0, and filtering doesn't work in either the search bar or the SearchPane. However, when I switch the database in the Editor's config.php file to MySQL and keep the frontend and backend code unchanged, everything works perfectly.
It seems that the Oracle driver of the Editor is not functioning correctly. Could you please test this on your end? I need the serverside functionality as the data volumes are quite large.
Thank you very much, and best regards.
Christian
Replies
Hi Christian,
What version of Oracle are you using? Also, could you add
->debug(true)
just before the->process(...)
call and then show me the response from the server when the Ajax data is loaded?Thank you,
Allan
Hi Alan,
thank you for your quick response! We use a Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.21.0.0.0.
Here is a (shortened) json-output.
thanks,
christian
Hi Christian,
Thank you for that. The queries, I think, look okay. I need to update my Oracle environment here - it is rather out of date. I'll let you know what I find.
Allan
Thanks so much for your support!
Hi Alan, did you have already a chance to look at this?
Thank you,
Christian
Apologies, I haven't yet. I plan to this week.
Allan
Hi Alan, if you need any help with your analysis, I could offer to do a MS-Teams session, then we could work with my database?
thanks,
Christian
Hi Alan, I wanted to follow up and see if there are any updates regarding the oracle-db.
Additionally, I have a question: how can I set up case-insensitive search with the current serverside setup?
I call the Datatable with the search / caseInsensitive option:
search: {
caseInsensitive: true
},
I would appreciate any guidance you can provide.
Thanks and best regards,
Christian
I'm really sorry - I've not been able to get a clear bit of time to get my Oracle DB back up and running. I hope to have a slightly more clear plate soon.
Regarding the caseInsensitive parameter, our server-side libraries don't actually use that at this time. It is a client-side option only. It would be up to the server-side script to decide if the search performed should be case sensitive or not, and if so, how that would then be implemented. It looks like Oracle doesn't support ILIKE so you'd have to use one of the approaches suggested here.
Allan