Database

Using CTE Tables in attribute configuration

0 2

Is it possible to use CTE Tables in sql commands in the attribute configuration? If yes, could someone show me an example?

Attachments saving in a different place

0 8

Hi, I have a project where I can't save attachment in a webcon database storage(becouse of company policies). I am looking for a solution to store attachments on network drive. Is there possibility to change localization of attachment ? May be some workaround? Some action, rule, ect? I thought about action which will create a folder on shared drive and webcon form will show information to user where to store attachment. But I don't know how to achieve this:/ Any idea?

SQL Query to get the User Cal in a workflow

0 3

Hi all! I need to create an email alert that will be triggered if a Task Assignment Workflow is created for a specific user. My goal is to check if that user is a User Cal (has a Webcon licence) and if not send me an email so I can give the user the access required. I've created a Send custom email and I'm trying to define the execution rule that will be checking the previous statement. My query is the following: SELECT UCL_BpsID FROM WFElements JOIN CacheOrganizationStructure as G O (...)

Database Name in Designer Studio

0 2

Hi all, i hope you are well. We have moved our PROD-Environments Databases to a different SQL Server last night. Except from some annoying trouble with Sharepoint and the Webcon solutions we managed to get everything running smoothly again. We uninstalled everything except from SOLR, and installed it again. The old databases are offline. Currently there is still an alias configured, that routes traffic that might go to the old SQL-Server to the new one, which is okay, but nothing we want to (...)

Experience with updated Database Compatibility Level

1 4

Hello everyone, did someone update the database compatibility level from the default 'SQL Server 2008 (100)' to a newer one and can share their experience? I really would like to make use of those "new" functions instead of using hard to read workarounds. Best regards, Daniel