I am attempting to implement a calendar that queries a variety of tables depending on the combination of parameters passed.
I’ve been trying to do something like
foreach ($queries as $sql){
$scheduler->render_sql($sql, …);
}
But it appears that the render_sql command terminates the stream upon execution, so only one of the queries gets to go.
What’s a better way to do this? (I know of one: multi-source load from js - but I wanted to see if a php solution is possible.)
Kate
Unfortunately there is no simple solution on connector level, you can
a) create view in database which will combine all sql queries and use such view with render_table
or
b) drop connector and create custom server side code ( its quite simple for data loading - just form necessary xml stream )
or
c) we can provide an updated version of connectors, which can use sql queries with union command, so you will be able to construct a single complex sql query and use it for data loading.
Thank you!
I have implemented the client side solution, so for the moment, I am happy. I imagine that supporting UNION queries would be a nice touch in a future release.