Not a programmer either but you may have to use server side software or programming to do it.

One way is for you create a separate webpage/app which runs the server procedure and link that into Omniscope. Possibly you might be able to embed that same underlying html page code into the content view.


http://www.databasejournal.com/features/mssql/article.php/3589021/Executing-SQL-Stored-Procedures-from-inside-a-Web-Application-Part-1.htm

Anyone can provide the content view source code of a working example?

Enrico,

The Content View allows you to execute server-side JS including Omniscope formulas, to allow you to build the page content dynamically from the data loaded into Omniscope. It does not allow you to execute database queries directly; it is not equivalent to JSP/PHP/ColdFusion etc.

You can write custom SQL inside a database source block in DataManager, and can load the query results table into Omniscope whereupon you can then "query" it using formula functions within the Content View.

Steve

Here's an example of JS scripting server-side within the Content View:
http://forums.visokio.com/discussion/1072/content-view-custom-scripting-2.7-/p1

Here's the tutorial on database sources:
http://tc.visokio.com/videos/?name=DataManagerDatabaseTable&title=Database+table&lang=gb

Steve,

thanks for your replies. What are you suggesting is the most logical and obvious way to read data from SQL in Omniscope (we're already doing it from some years now).

My idea about executing store procedures directly from Content View was about making updates on SQL tables inserting values read directly from Omniscope.

Thanks anyway.

Understood.

Note, we will be exploring other ways of writing changes to databases in the near future, and when we have something you can try we'll get in touch.