User defined SQL Table Functions as data sources

[eswezey]

I have written a monstrous SQL Table Function that has many inputs and has the potential to take 10-15 minutes to return a data set with no input specified, or just a few seconds with inputs.

Can such a thing be defined as a data source? And if so, how?

Or, would it be necessary to create a scheduled program that populates a summary file with all the data and use the summary file as the source?

Thanks.
Erin

[robert.swanson]

Perhaps you could try using vvIn_virtual to pass a default value into your function when one isn't explicitly set by a filter or app variable in your app.