Starting URL Instance and Editability rules

0 4

Hello all, I have a process that can be started either from a Parent workflow or in the workflow, using a menu option (creating a sub-task). In the start step, I have editability rules, if the user is creating a sub-task, some fields can be edited, but if the task has come from another process, those fields cannot be changed. In the URL, I'm passing the ID when the user creates a sub-task to a field in order to use it as editability parameter. However, although the field has information o (...)

How to block the possibility of choosing current day while after 9.00 A.M

0 2

Hello there :) I have yet another problem, regarding the form validation. I've attached the rules that I've applied. What I want to do is I want to block the occurence of choosing current day while it's after 9.00 A.M. Otherwise If the day is <> than Today() then the result is TRUE, which means, you are able to go further. Best Regards, Igor

Error when executing Menu button action

9

Hi Folks, whenever I try to execute [Menu button] action, which should open a hyperlink, I get an error: "Error in Menu button action Start Counterparty Card. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_WFElementDatails_WFD". The conflict occurred in database "BPS_Content", table "dbo.WFElements", column 'WFD_ID'. The statement has been terminated." I have exactly same button configured in other workflow in the same application and it works fine. It is irrelevant wha (...)

How to return weekend days in SQL?

0 12

Hi I have a question. I want to return all weekend days in SQL for my form validation. This is my SQL Code that returns these days, but only for the current month: WITH Dates AS ( SELECT CAST(DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) AS DATE) AS DateValue UNION ALL SELECT DATEADD(DAY, 1, DateValue) FROM Dates WHERE DATEADD(DAY, 1, DateValue) < DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) + 1, 0) ) SELECT DateValue FROM Dates WHERE DATEPART(WEEKDAY, Date (...)