Problem with render_complex_sql()

Hello!

I use java connector for dhtmlxScheduler.

c.render_complex_sql("SELECT name from tableA WHERE dept = (SELECT dept FROM tableB where name = 'John')", "contact_id","name,surname,age,address", "extra1, extra2");

generate following SQL code:
SELECT SELECT name from tableA WHERE dept = (SELECT dept FROM tableB where name = ‘John’) FROM WHERE name < ‘2013-04-09’ AND surname > ‘2013-04-08’

after playing with render_complex_sql(), I suspect that function just surround my sql by “SELECT” and “FROM” clause.

render_complex_sql( sqlString, arg2, arg3) → “SELECT sqlString FROM WHERE …”

I use complex postgres sql with subselect query, so render_sql doesn’t work.
Please help me to understand how to work render_complex_sql()
or give me any hint how to point FROM clause.

I will double-check, but it seems do not have such effect locally.
Are you using dynamical loading or forced filtering in addition to render_complex_sql ?
This type of init can be used only for plain data loading ( even dynamical loading will not work, as it requires query modification, which is forbidden in case of render_complex_sql )

Hello, Stanislav!
Thank you for response and sorry for my late answer!

Yes, I use dynamic loading.
On client side:

scheduler.setLoadMode("day"); // Set dynamic load per day

additional info:

  1. I use postgres and scheduler in dynamic mode.
  2. I use scheduler connector with few options

PS: little question, how to get version number of my connector?

Thank you.

  1. I use postgres and scheduler in dynamic mode.

Which means render_complex_sql will be not usable.
If you need to have a complex logic for data collecting, which can’t be achieved with render_sql, you can use custom logic to fetch collection of objects and use render_array

Hello Stanislav!

Thank you for idea!
Going to dive connector’s API =)