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:
- I use postgres and scheduler in dynamic mode.
- I use scheduler connector with few options
PS: little question, how to get version number of my connector?
Thank you.
- 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 =)