Hi, I have an item list with a "date" column. I figured out that filtering (or even showing it in a customized date format in a data table) is tricky as the daty type of the column is actually nvarchar(1000). What I want to reach is to filter the data table based on a "date picker" field, but I don't manage to. Kind regards, Klaus
(...) At Webcon BPS, on the form's list of items, I have a checkbox field and a second field of dropdown(choose) type. The second filed - dropdown field retrieves data from a data base and allows for adding values outside of the database. The first filed - checkbox field determines whether the value in the second field is from the source or added externally. How can changing the value of the checkbox field aff (...)
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: Querying 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 li
Hello, I have a parent process with Item list. This item list is list of tasks. I can add positions to this list and I have a button to initialize this list as a tasks. In this list I have a title, responsible person, status of the task and section (it should be item list with attributes in the form?). When I add the position and put in all data (title, person responsible and section) I hit the
Hi, if a data row/ data table is based on a BPS internal view to configure, whether the names/translations of the columns should be used. The default value should be true. It's just a waste of time to not only provide the translations the first time but also to update these when the name/translation of the referenced column changes. Most of the time it's forgotten anyway. Best regards
I created process where I have got: 1. Parent process with Item list: a) description b) attachment 2. I start child process a) copy data + copy attachments b) i would like to populate the same in child item list with records correlated with coped attachments ... I did SQL source: [code="SQL"] SELECT e.DET_ID as 'ID wiersza dziecka', e.DET_WFDID as 'ID Elementu Detalu dzie
Hello, I'm trying to import user data from the import WF (1) into the employee WF (2) and route based on whether the user has an Active Directory account. Depending on whether the user has an Active Directory user or not, the user should either be sent to the blue path or to the purple path in WF (2). The issue is that the business rule in the 'Start a Sub Workflow (SQL)' actions, which chec
Hello, I am trying to update some form fields and columns in an item list after some actions. On my path i have configured a FOR EACH on my item list which is creating/composing JSON payload for my REST. (rows) However, I am encountering an InternalServerError (500) when attempting to save this data using REST service on path for my current instance. PATCH: api/data/v5.0/db/#{DBID}#/element
I have a process that creates 10 reports each month. After creating the initial reports, I would like to clone them automatically at the end of the month, only changing the reporting month. The user (author) updates the data and submits it for verification. I proposed the following procedure: 1. I created a BPS source that lists all 10 reports from the last month. 2. The BPS data source has c
(...) they are using application) and in case of next usage of application personal information could be filled out automatically based on what they filled out first time. Some data we don't have in our data base s so we can't just connect it to our data base . Kind regards, Jan
ORIGINAL SUBJECT WAS: Assistance Needed – Retrieve "Content as Base64" for All PDF-Attachments of an Instance Dear All, I am currently looking for a way to extract the "Content as Base64" for all attachments associated with a specific instance. My goal is to obtain a single text line in the following format: 'Base64 PDF 1', 'Base64 PDF 2', 'Base64 PDF 3'. -> The easiest way would be to us
hi, I would like to create a calculated column for a report with a list of items. This column, using SQL, should fetch data from another process. I want to map it based on the DET_Att23 ID for each row of the report:: select sum(DE.DET_Value2 - isnull(DE.DET_Value17, 0)) as nn from WFELEMENTS join WFELEMENTDETAILS DE on WFD_ID = DE.DET_WFDID where WFD_DTYPEID = '212' and DE.DET_WFCONID
Hi, I have a process that use API to send data to another system. I have a patch in WebCon to check status, based on the feedback, process moves to the next step or waits another hour on the timer. I want to change this. I found this option in WebCon API: Path that will be used by element PATH /api/data/v6.0/db/{dbId}/elements/{id} But my second system don't have a PATH method. Do yo