search results

(...) ar function), all rows (table valued) Parameters: Name: Input Description: The complete text with the line break character. When this is saved a function scalar/table valued is created and the bps_user gains execution permissions. CREATE FUNCTION dbo.GetTextPartEN(@input NVARCHAR(MAX)) RETURNS NVARCHAR(MAX) AS BEGIN RETURN CASE WHEN CHARINDEX(CHAR(10), @input) > 0 (...)

(...) : I have a data table to get the data of subworkflows and the base 64 encoded values of their attached images. This data table is used to create a word document. The standard SQL connection uses the bps_user which neither can read data from a separate database nor is the user allowed to read the attachment file table: "The SELECT permission was denied on the object 'WFAttachmentFiles', database 'BPS_1f (...)

Hi all, I have installed WEBCON BPS and created a Test user in System settings → BPS users and groups list. I assigned this Test user various permissions in Global privileges. However, after logging out from the admin account, I am always redirected to the admin login URL, where I can log in only with the default Admin account

Hello, Can anyone help me with this SQL filter. The problem is that the SQL filter returns all rows, instead of filtering only those that meet the warehouse condition. No matter how I change it, it returns all records from the data source I am attaching a screenshot of the configuration: - WFD_AttChoose2 is a field of type Person in the "warehouse" dictionary In the advance configurat