WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question

search results

for sql

(...) Hey, now all 4 databases (Config,Content,Content_Arch,Content_Att ) are on the same MS sql server. Do you have plans to give opportunities to host each DB in deddicated server? For example - to have 4 MS sql Server , 1 for each BPS database.

(...) t, but as a separate workflow elements. I want to implement Asset Management workflow, but need to enter into the system few thousand items (PC's, servers etc.), which are currently stored in another sql database.

(...) nformation as a data row in the child. But I need to alert the responsible on the child flow so they are aware that the field was changed. I'm not sure how to play with versions or IsChanged (using sql command) to created an execution action for this and I don't want to add another field so they can enter the final date. Does anyone have any ideas? Thank you!

(...) Hi everyone, I have problem with adding multiple attachments. When I use action "Add attachment", I can add only one attachment (picture1). When I use the same action, but the sql query returns more the one attachment - the action doesn't work (and it doesn't matter if the ID's of attchments are in the one row or many rows). Thank you for your time :)

(...) e idea structured, I'm facing some questions in regards to: - How can I initialize dynamically the item list with an information from an integer form field? Didn't find anything in the options using sql query - Is it possible to translate the number of months as text field, example, from today until end of year, we have September/October/November/December, or at least, have in each row the month nu (...)

(...) web browser tells an error: HTTP Error 502.5 - ANCM Out-Of-Process Startup Failure Investigating this I started the file "" within path "" manually and received the error dump added below. The sql user can connect with the password given and all rights within sql server are appropriate. What looks strange is the attempt to reach the server through Named Pipes. This is not configured. D (...)

(...) search from 1 process. In this process I am using a list position(list items). In my report column I will use column only from this list items. I don't have any problem with prepare the source - sql query, but I have problem with present it in portal, how to do it ? I could use Reporting Services but maybe there is some other things in webcon site?

(...) gest these alternatives: 1) An administrator needs to define Person P as substitute for Person A in the period given. 2) If the substitutions are stored in the database and can be retreived with an sql statement, I think of an automated workflow that will shift the tasks based on the substitution information. Is there any other approach you have created or that can be configured? Thank you fo (...)

(...) Hi, In the logs, we are seeing the following error: "Dynamic operations can only be performed in homogenous AppDomain" Since the error started appearing, some form fields that get data from sql query stopped working. What could be the issue and solution? Thanks in advance Mark

(...) tomer number, valid from, valid to and so on All these fields have been added to these different processes without using global fields, but atually have the same meaning, which makes reporting and sql queries over these different processes somehow difficult. Is it possible to convert these fields to global fields, regarding the aspect that we already have several thousand instances in the custo (...)

(...) be reflected on my side. I've tried two approaches: - Copying the value into another field, timeout after 7 days, copying again the field to have the status refreshed - Use of Datarow field with sql command in the control field I have some issues here: - Timeout with the change value is giving me errors because there can be times where the field is only filled in on the system step - Dataro (...)

(...) am wondering if it is possible (with Webcon Standard actions) to replace privileges on certain workflow elements in different processes. Selection of workflow elements in different processes with sql would be easy, but I did not find a Webcon action which actually replaces permissions, which also includes removal of odd users, who should not have access any longer. Users can also switch roles (...)

(...) anonymize his data some other way? I tried with GDPR actions but "Author" is a system field and I didn't find a way to do it. Is there a built in action that could do this? Do I need to resort to sql and would that even be wise? Thanks in advance

(...) After upgrading the program to version 2022.1.4, the system informs that it is in maintenance mode. I thought the update went fine. sql Server, IIS and WebCon process works correctly. What else should I check? How to "turn off" maintenenace mode?

(...) Hello, it would be nice to have an option of inserting a "CAML command" similarly as it is done with "sql command". It would help in setting conditions and checking the outputs of sharepoint actions.

(...) .com/posts/post/approval-process-on-the-item-list-with-row-blocking/138 in order to block rows. I've managed to give access to items list only users mentioned in one of the columns of item list using sql against BPS Users list (see picture attached) , but all rows are available to everyone from this column, not only one row per one user. What am I doing wrong?

(...) I've got following fields: 1. Choice field with connection to MS sql table - name of the supplier. 2. Text fields like address, postal code filled based on the value chosen in choice field from point 1. 3. Another choice field with bank account numbers - another MS sql table filter by ID value from choice field in point 1. Two qestions: 1. By clicking 'x' in supplier name choice field I'd like (...)

(...) Hello, is there a possibility to use existing SOLR as Data Source? I had an idea to show users sql grid, which would show similar items found in database, based on text typed in regular TextInput field. That lead me to Levenshtein Distance algorithm, which might be slow in sql , but i've found that such a thing is already implemented in SOLR (https://stackoverflow.com/questions/1752301/how-to-conf (...)

(...) Hi all! We want to execute a JSON query on a path (actually it is some business rule containing sql query) and send these results to an external endpoint (REST service). The problem is that the query does not reflect current changes in form, since this happens on save. This should be related to database transaction and current values which are not persisted at this moment. Is there even a (...)

(...) After upgrade to version 2022.1.4.174 I get errors on some querries that use . Error occurs when querying another database directly or using join, etc from sql COMMAND or choose field querry. I found that this is related to change described in https://community.webcon.com/download/changelog/117?q=cf05b90, associated with using bps_user on sql COMMANDS. Is there any way to deal with it at sql serv (...)