Answers

• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  March 2017

  Hi Sunil,

  The server-side processing libraries in Editor, and the demo script from DataTables, do not support GROUP BY I'm afraid.

  However, the Editor libraries do support WHERE conditions.

  Regards,
  Allan
• Sunilgoel Posts: 48Questions: 19Answers: 0

  March 2017 edited March 2017

  Hi Allan,
  can you send me example in non-editor server-side processing where i can see how to use "where conditions"

  Regards.
  Sunil
• Sunilgoel Posts: 48Questions: 19Answers: 0

  March 2017

  Hi Allan,
  I am waiting answer from you. I have two question.

  I am using Non-editor mode of DataTables.

  1. Can i use SQL script in server-side script.
  2. if answer of Point 1 is NO then how can i use "where" clause.

  Regards.
  Sunil
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  March 2017

  Hi Sunil,

  The WHERE conditions documentation that I linked to above will work for both server-side processing and client-side processing. The Editor PHP libraries dynamically adapt for each case.

  Allan