search results

(...) lculated columns (https://community.webcon.com/posts/post/using-calculated-columns/196/3) but that's not my case. What I would like to do is join the items from the report to a table in a different database (on the same server) or to an existing MSSQL data source. In many processes I have a global field with the unique identifier. I would like to use this key for a 1:1 join. I can show the join results (...)

(...) on, where I get the data from my xml-file. In my code I implemented something but the file path is static at the moment and compares the file names. Normally every read in file gets an ID in the database but I don't know how to access this data. Has anyone experience with this and know what the best way it is to implement this? The code excerpt from me is in the attachment below. Thank yo (...)

(...) We are implementing a solution of Master Data Management and are trying to use Webcon as a User interface with all the logic behind forms. The database is prepared in MS SQL with different tables. The challenge we are having is to update entries with foreing keys. Scenario: Table 1: Country has one column (apart from ID) – 'Country' Table 2: City has two columns 'Country ID' (Choice column from table Cou (...)

(...) as A ON G.COS_BpsID = A.UCL_BpsID where WFD_ID = '{WFD_ID}' I actually want to get the UCL_LicenseType (Integer denoted license type) associated with the user, I've changed the form field to ID, database ID/ Name and it retrieves an error all the time. Does anyone tried this before? Thank you all

(...) Hello all, Does anyone configured an Item List to be initialized with a SQL query that will query from another database ? In this case I want to query from an Oracle DB and initialize the columns with the columns from the query: select milestone as {DCNCOL:185}, milestone_date as {DCNCOL:186}, amount as {DCNCOL:187}, currency_code as {DCNCOL:188}, amount_euro as {DCNCOL:189} from PL_Invoicing (...)

(...) s://developer.webcon.com/2021/resources/online-documentation-sdk/html/2c254e06-3ac3-3a82-7c44-dae3d829d1e4.htm) Does anyone know where these logs are located (log file on file system or a specific database table)?

(...) checked will be Customer Name and Address (because a customer name can have more than one address). I was trying to follow the query below but I'm not sure on how to add the dictionary there (in the database documentation I have, I don't find alias for a dictionary=) if exists ( select 1 from WFElementDetails where DET_WFDID={WFD_ID} and DET_WFCONID={WFCON:1726} and isnull({DCNCOL:121}, '') = '' (...)

(...) cal machine. The cerificate is showing in IIS, certmgr (Personal -> Certificates), but is not selectable in Webcon BPS installation. We cancelled setup and tried new installation (after dropping all database s), then the IIS creation page was not even showing. At the end of the day, we are left with an unusable Webcon BPS installation with no IIS site created. Can anyone tell me how to overcome this iss (...)

(...) hod, password, ...)? Documentation is not very clear about this. 2.) How can we create the application pool & website after installation, without having to uninstall everything (Webcon BPS, dropping database s, ...)? Many thanks in advance & best regards, Nik

(...) 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 (...)

(...) Dear All, When I try to submit quantity of labels with barcodes to be printed from field I get an error (attached). Same situation when I use definition of database field (i.e. {WFD_AttInt1}). This field is integer. When entering manually a digit there is no issue. Any workaround? :) Kind regards.

(...) Hello, Is there any way I can see deleted instances ? Somewhere in the database ? Or anywhere ? Best regards, Laurentiu

(...) account and testing the script. I see the following error in event viewer. PowerShell Error Message=WCF Service can be executed on registered account only. Valid PortalAppPoolIdentity username from database is empty. Source=WebCon.WorkFlow.Service StackTrace= at WebCon.WorkFlow.Service.WCFService.WCFService.ValidatePortalAccount(Int32 dbId) at WebCon.WorkFlow.Service.WCFService.WCFService.PowerShel (...)

(...) y of presenting documents list. The report shows a list of documents from specified document flow definition. Unfortunately, the report runs very slow, even though there are not many documents in the database yet (about 40), and the users have to wait until the page refreshes. Are there any parameters that I can verify and set to make it run more smoothly? Anything to observe in the database ?

(...) can't find any issue in my configuration. I have an Item List field type with some fields in it: type, subtype, value, start-date, finish-date. My configuration is set to automaticly take value from database and place it on 'value' when I pick 'subtype' from dropdown. I am using the target field option, because 'subtype' is a picker. Everything works fine until I delete some element from the list and the (...)

(...) Hello, Our client recently had a problem and it was necessary to bring down the 2 VMs: 1. One machine that had Webcon installed 2. One machine that had the database installed Our client had a snapshot of the database machine and they restored it on a previous date. For each machine we kept the same IP and the same name. Now we have 2 machines: 1. One machine that has a freshly installed Webcon connecte (...)

(...) - the manual said, it is not required (even though recommended). Now i cannot log into the Webcon BPS Designer Studio. Do you have an idea, how to setup the Windows authentication Connection to the database afterwards - without integrated authentication? Thank you for your help.

(...) Hi there, as far as I know there is no official support for Azure SQL for the WEBCON BPS database s today. If we implement WEBCON BPS in a customer's own Azure tenant as their private cloud, it would be smart to use Azure SQL, because of the integrated HA features, scalability and low maintenance effort. WEBCON BPS is very well integrated with Microsoft technology and has great integrations with Microsoft (...)

(...) pal "BPS_readonly" does not exist, this type of principal cannot be impersonated, or you do not have permission. the BPS_readonly account exists in DB\Security\Logins and has access to the Content database . How to fix it?

(...) ged it back. I there another way to change this without reinstalling it? 2) Which account creates these sites? the application pool account (see image)? Does it have to have special rights on the SP database s after the installation?