Few questions about serverside and SearchPanes
Few questions about serverside and SearchPanes
michalcabala
Posts: 2Questions: 1Answers: 0
Hello everybody,
excuse my poor english and that I'm not a "pure" programmer/developer. I have very basic knowledge of PHP/MySQL and Javascript.
First, I'm kindly asking you to point me right direction and I'll first try to do what I need 
If I will not succeed, i will ask further.
I'm working on web app for warehouse. I have a few datatables, but some is required (?) to be with serverside processing (live data loading, max. 5000 rows)
So my questions are mainly about the serverside and SearchPanes.
I have table with serverside processing with the JSON output with Editor libraries and SearchPanes extension with options loaded from server side script. Everything works pretty fine for me so far. My questions are:
- It is possible to render options with HTML in Searchpanes like in client-side processing (bolder text, etc.)?
- According to question 1.,plus join two columns/fields to one (for example Last name + First Name, Logo + Supplier name etc.) and have this joined in one SearchPane.
- Possibility to replace NULL values in JSON output to another value, for example "Not set". Fields returning "null" in database are INTEGER.
Thank you in advance for your help!
I will support this software in near future! 
This question has an accepted answers - jump to answer
Answers
It would be worth looking at the client-side processing, and seeing what the performance is like. For 5k rows, it should be reasonable quick - we generally recommend server-side processing for over 10-15k records. Doing that would resolve your first two issues, as both would be trickier with the server-side approach.
For the empty values, take a look at
searchPanes.emptyMessage(example here),Colin
OK, I'll try the performance with client-side processing. Then I will ask further if thre is some other things.
Many many thanks for your answer.