dynamic data source?


https://www.nevron.com/Forum/Topic5576.aspx
Print Topic | Close Window

By Erin Marie Rhodes - 13 Years Ago

I have a very large Oracle database I'd like to generate charts from. I'd like to create a Sharepoint page that displays a chart, where the X axis is a given date range, provided by the user somehow. Is there a way to get data from another page component (an entry field), and customize the SQL query on-the fly? Is there a code example to do this?

Thanks,
John
By Nevron Support - 12 Years Ago
Hi Erin,

In the upcoming version of SPVision, all aspects of data source connections will be specifiable with expressions too. Because in these expressions you will be able to use the Parameters variabables, you can actually create dynamic queries that are driven by user defined parameters (either through the JS extensions that we have released, or though the new parameters that can consume SP Web Part filters). So this requirement of yours will be fully forefilled. Expressions will also be exposed to all chart and gauge boolean ,numeric and enum properties, which will make the SPVision webparts incredibly diverse.