Skip to content
+1-888-319-3663

COMMUNITY FORUM

Are Stored Procedures supported with Smart View?

Lewis asked 4 months ago
Answers
Patrick Roth Staff answered 4 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.

If you would like to submit an answer or comment, please sign in to the eOne portal.