Is is possible to “hide” a column of data from a chart… I know this sounds dumb, but I was given a Stored Procedure with wich to generate a chart from our SQL Admin, and unfortunately he is giving me one too many columns of information back. I know the best and ultimate solution is to have him fix his stored procedure, but his boss moved him to a new project and it will be a while til he will be able to fix the stored procedure.
So I just need to hide one column of data, is it possible??
one thing you can do is to take the dataset that gets returned from the stored procedure and then write a script that runs thru that dataset and generates a new dataset that doesnt include that column. here is a quick example of taking a query that has 3 columns and dropping one of the columns and creating a new dataset.
ds = system.db.runQuery("SELECT devicename, displayname,unitid FROM devices")
newDS = 
headers = ["devicename", "displayname"]
for row in ds:
devicename = row
displayname = row
event.source.parent.getComponent('Table').data = system.dataset.toDataSet(headers, newDS)