Creating sql views on BPS_Content DB

0

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