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

search results

for validation

(...) check the correctness of the entered data – mostly to make sure that an incorrect value doesn’t cause issues further down the workflow. WEBCON BPS gives access to multiple avenues of form validation: RegEx, ‘Validate form’ action, and the one we will be taking a closer look at– setting up a form rule on the path. This article describes the use of this functionality.   (...)

(...) Is there a reason behind 100 characters regex limitation? I was trying to use a regex for validation of Romanian personal identification numbers (CNP) and I got the following error attached. I think this limit should be increased a little.

Yes, please! And if possible not only in the Formfield configuration, but also in the OCR-Templates.

(...) I have a requirement to create dictionary to enter form name, Step name, no.of business days. Form name and step name combination need to be unique and a validation error message should show if the user tries to post a entry with the same form and step combination that already exists in the dictionary. I have 3 different forms with different steps in a flow. I entered 1st entry as form1, Step1 and 1 day, (...)

Hi kaluser, the choose value in the database contains the id as well as the name. Therefore the where condition will always be false if you compare only the name. The functions are below, but you can also select the correct one from the objects tab in the expression editor. dbo.ClearWFElemIDAdv(WFD_AttChoose1) dbo.ClearWFElemAdv(WFD_AttChoose1) I would opt for the Id instead of the name.

I have replaced as you have suggested but still not working. Please advice.

Hi kaluser, it think you would see the issue, if you would display the results of the inner select without the AttChoose conditions. These four values would be part of the selected columns. I just noticed another potential issue. What you want to do is: Check whether another workflow, using the same form type, (77 Dictionary), uses the values of the current element in a choose column:

Thank you So much Daniel. It is working. Attached the updated query.

Daniel, I need add one more condition now. There is another column WFD_Attchoose2 should also be considered now. Because for few dictionary entries WFD_Attchoose2 (Subform) stays empty or NULL, for few records there will be value. Earlier query is working when WFD_Attchoose2 is null but when There is value in the WFD_Attchoose2, I am having issues. I listed various scenarios where the query

Modified as below but not working: SELECT CASE WHEN NOT EXISTS ( If WFD_Attchoose2 IS NULL ( Select WFD_ATTchoose1,WFD_ATTChoose4 from Wfelements where WFD_DTYPEID='77' AND WFD_ID '4353' AND dbo.ClearWFElemIDAdv(WFD_AttChoose1)='9' AND dbo.ClearWFElemIDAdv(WFD_AttChoose4)='10' ) Else ( Select WFD_ATTchoose1, WFD_ATTchoose2,WFD_ATTChoose4 from Wfelements where WFD_DTYPEI

Hi kaluser, if I understand it correctly the workflow can only be saved if the combination of all three columns hasn't been used in another workflow. But in this case I don't understand why is a problem. Scenario7: Form2 Subform1(value exists) step1- not able to save - It is an issue Or should the scenario 7 be Form___1___ Subform1(value exists) step1- not able to save - It is an issue

Thanks Daniel. You mean as below. I modified as below but not working: SELECT CASE WHEN NOT EXISTS ( ( Select WFD_ATTchoose1,WFD_Attchoose2,WFD_ATTChoose4 from Wfelements where WFD_DTYPEID='77' AND WFD_ID '4360' AND dbo.ClearWFElemIDAdv(WFD_AttChoose1)='9' AND isnull(dbo.ClearWFElemAdv(WFD_AttChoose2),'') = '15' AND dbo.ClearWFElemIDAdv(WFD_AttChoose4)='10' )) THEN 1

Hi kaluser, it seems that I can't help without seeing the data. This would be my approach in your case check... which data is returned by the inner select statement? Which data is returned without the AttChoose conditions? when does the statement fail Include the WFD_ID as well as the DTYPE just in case. Best regards, Daniel

I appreciate all your help Daniel. Attached the modified code which is working now.

(...) Hello all, Does anyone configured a validation rule and/or control field where you need to check if the lines added in a item list were already added in another instance? I have a process for overtime registration and I want to block the user to add a new instance with dates that were already added for the same person in webcon. I've created a control field but now all the processes are moved to canc (...)

Hi Andreia, I haven't tested it nor have I verified the syntax of the statement but it should be something like: select currentElementRows.DET_ID, otherElementRows.DET_ID from WFElementDetails currentElementRows join WFElementDetails otherElementRows on -- setup the conditions for the same rows currentElementRows.DET_WFCONID = otherElementRows.DET_WFCONID and currentElementRows.DET_C

(...) Hi Guys, I use MailApproval on some paths in our application. Now I have the somewhat unusual behavior that an acceptance via MailApproval is rejected with a validation error. If I carry out the acceptance in the same process (same instance) in the application, it works. The option “Form field validation” is checked on the paths. If i deselect, it works. This is what MailApproval returns: ########## (...)

Hi Gerd, I'd try looking at default values, and form rules, which might fill the form. If the form is opened in the browser this might fill some data, which maybe isn't filled when the path is used from MailApprove.

Hello, I have a big problem. I have an order form, e.g. for a contractor, and I have created a data source that shows all the orders of this contractor. Additionally, Kontrahnet has a monthly order limit entered in the field I need the system to check whether the limit has not been exceeded during the next order. Please help me how to do this