Are Stored Procedures supported with Smart View?
Lewis asked 11 months ago
Answers
Patrick Roth Staff answered 11 months ago
SmartView doesn’t allow you to create any new reports – it just executes the “out of the box” GP SmartLists and then any you build with SmartList Builder.
From that standpoint, while SLB does let us use SQL in a query, you can’t validate an exec proc statement due to how it validates the SQL (to make sure you don’t have drop table or delete table, etc statements).
So no, I don’t see this as possible in either SV or SLB unless you possibly can get proc executed within a view.
From that standpoint, while SLB does let us use SQL in a query, you can’t validate an exec proc statement due to how it validates the SQL (to make sure you don’t have drop table or delete table, etc statements).
So no, I don’t see this as possible in either SV or SLB unless you possibly can get proc executed within a view.