search results

(...) s required to provide Id and name. Quite often the name is known, but not the id. As picker fields are usually based on datasources, it would by great, when the api would be extended with methods to query datasources. There should be at least two methods: 1) getting a list of all available datasources (overall / by application) 2) query a datasource with a filter. To make it easier, the filter shou (...)

(...) d 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 ON {WFCONCOL:1858} = G.COS_BpsID JOIN UsersCal as A ON G.COS_BpsID = A.UCL_BpsID where WFD_ID = '{WFD_I (...)

Hi all, i thought it might be a good idea to share useful queries that should be reusable for any of us as they are. Although I personally find the built in Workflow-History very useful and really like it for admin-purposes, it might be some kind of an detail-overkill for common users. In order to give users a more simple look of what happened so far in the workflow, I created a datasource tha

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

(...) ndpoints'. In my case it's the following: When I click on the sign in button (1) the server will read the configured endpoint (2) and redirect the popup to the page (3). Unfortunately, the provided query parameters are stripped from the URL and only the path and hash remains. My request is to change the logic that the query parameters are kept. Sample PowerShells script: $uri = new-object System.Ur (...)

(...) Hi, I have a following problem. I've created a data table form field that downloads data from SQL query . In that SQL query I have a following where clause, which compares a date from Oracle table to a date from a form field that is completed by an user (it is "user's date"): "where table1.date = User's date: date acc. browser settings(text)" and it doesn't work because of different date format (...)

(...) Hi all! We want to add some rows to an item list with 'Change item lists values' action. The SQL query should take a JSON array (which is perfectly valid) from UI element and return a table for adding new rows to this item list. Unfortunately this does not work. There seems to be some parsing on Webcon side, which eliminates all elements in the JSON array, apart from the separator, which resul (...)

(...) Hi. Is there a way to query the Active Directory only for the department column and add this as a datasource. What I'm seaking is a list of all departments we have in the company. Kind regards Klaus

(...) Hello folks, We have used constants which contain SQL queries for calculated report collumns a couple of times already, so this does work. But i now have a query which works perfectly when added into the calculated collumn directly, but no longer works when stored in a constant. (img attached) Through logs we found that he has a problem seemingly with strings, but we found no way to baypass tha (...)

(...) Hello, Does anyone can help me, why in WEBCON SQL query apostrophe is replace with quotation mark? On the form, I have an attribute with value: '2339226', '2504286'. In action "Change items lists value", I used an SQL query whith this attribute, but query preview returned "2339226", "2504286". Regards

(...) Webcon ver 2021.1.5.315 I found a bug in business rules with parameter and SQL query . When type is text and value start by '0' then rule cut first char.

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-c

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

(...) Hi, I want to use the action - Send a custom email and get email addresses from a Dictionary. I checked "Selecting addresses by SQL/CAML query " and as Data source: i chose my Dictionary When i write a SQL query it doesn't filter. It shows all columns and rows. In my workflow i have a choice field Vendor name (from a Dictionary - it contains Vendor Name, Vendor Email). When i pick that vendor, (...)

(...) troubles using OPENJSON to parse a nested JSON response from a REST API: Following the solution posted at https://alterpaths.com/json-nested-collection-handling-in-webcon-bps/ but I cannot get the query to work in Webcon. When copying the whole query from the Show window into SQL Studio it works just as expected, but in WebCon Designer studio the following error occurs (see screenshot). Any id (...)

(...) lation seems to be the same (the same users etc.). Is there any option/installation parameter that causes the execution of TEST SQL may be different than the rest of the environments? Test server query execution: declare @cookie************************************** varbinary(8000); execute as user = 'bps_user' with cookie into @cookie**************************************; begin try exec (...)

(...) Hi, Sorry for my lack of knowledge but I've just installed WEBCON 2 days ago. Please help! I want to add in a item list rows from a SQL database but: query ing data is ok. I want to select a product name based on that query (from a Choice field) and get the correspondent price from the query ... Also my query is based on another field as a filter When I change the value of that filter, the list of (...)

(...) Hello Community, is it possible to check whether a value exists in a sharepoint list before I create a new entry via workflow action? What's the best way to do it? Can I use a data connection to query for a certain value in a business rule? Thanks!

(...) Designer Studio it is possible to check the use of a single connection or data source in the context of all processes. Is it possible to get such a list for all connections and sources using an sql query ?

(...) HI I need by sql query to outline the list of the appliacation that we have and a workflows to a choice field. How can I do if the app is on Main_Db and we have apps on Main_db and main_db2?