Home > Forum > Database > Creating sql views on BPS_Content DB

Creating sql views on BPS_Content DB
0

MVP

Hi Bartek,

let me quote a response I got from a support request for this:
"
ZGL/4299/2021:
Hello,

Due to some security restrictions, there is no possibility to execute specific functions directly in the Designer Studio.

As a workaround, please create a SQL view in SQL Management Studio. Put that query inside it. Then, there will be no problem with the form field configuration. Simply create a data source that refers to created SQL view.
"

In my case I needed to use the ROW_Number function and the necessary "order by" broke the creation of the SQL statement which is send to the SQL server.

Best regards,
Daniel

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings