If the end result you're after is to add days to a date, you can use a formula such as:

[#Case.TheDateField#].AddDays(3)

Note, the [#Case.TheDateField#] would be the date fields read in the process. the important part is the .AddDays(3) which would add 3 days.

Ryan

Hello,

The problem here is that this user task is written for MSSQL, and there is a query that looks like this:

var selectQuery = new Select(_userConnection) .Column("dow", "Code").As("Code") .From("DayOfWeek").As("dow") .InnerJoin("DayInCalendar").As("dic").On("dow", "Id").IsEqual("dic", "DayOfWeekId") .InnerJoin("DayType").As("dt").On("dic", "DayTypeId").IsEqual("dt", "Id") .Where("dt", "IsWeekend").IsEqual(Column.Parameter(1)) .And("dic", "CalendarId").IsEqual(Column.Parameter(calendarId)) as Select;

We are interested in this line: .Where("dt", "IsWeekend").IsEqual(Column.Parameter(1))

In MSSQL, boolean columns are represented as 0 and 1 (false and true, respectively), whereas in PostgreSQL, they are represented as true and false. To address this issue, there are a few options:

- Avoid using this line of code and find an alternative way to filter the data without relying on the boolean comparison directly.

- Reach out to the addon developer and ask them to make the necessary adjustments to handle the PostgreSQL boolean representation.

- Try searching for a PostgreSQL-specific cast or conversion function that can convert an integer (1 or 0) to a boolean (true or false). 

Ryan Farley,

Thank you, but I need to add only working days.  The user task named  

"Add Business Days" is what I need but the problem is that it only works for MSSQL and not for PostgreSQL. 

Claudia.

Hello!

At the moment we are carrying out preparatory work to move the product line from large products to composable applications and to comply with the upcoming release of the new pricing.

As part of this work, ITIL sections (including the Configurations section) have been removed from the builds for the new sites. For backwards compatibility when upgrading, the ITIL functionality packages remain on the existing sites.



Best regards,

Maria

Kevin,

You can see in this post that the ITIL sections are back when installing the component. Please follow this thread: https://community.creatio.com/ideas/itil-objects-configuration-items-pr…

Yes. You can add a Case (or any entity) using a webhook. All you need to do is specify EntityName: Case in the payload and include any of the fields needed for the case, including any default values. 

What I've not tested yet (and I suspect cannot be done with a webhook) is include a nested payload for related data - such as an account)

You can also specify in webhook an entity which will be used as an intermediate object before case registration. 

For ex, Submitted form. 

You will need to add your case relating fields in Submitted form (including nested payload) and then to write a process which will be triggered when a form is submitted and 

to manage nested data, perform any searches and register a case from this process.

More than using the webhook to entity conversion using the OOTB process, I've been just adding my own. If the payload from the webhook doesn't contain an "EntityName" the ootb process rejects it, however, you can still create your own process that triggers from a signal of webhook added, plus you can add filters for the headers or payload containing some specific values. Then deserialize the JSON payload and do whatever you want with it. I'll have an article written up on this topic soon.

Ryan

Creatio 8.0.10 https://academy.creatio.com/docs/release/release-notes/8010-atlas-relea…

Hello, 

Thank you for your question.

More useful information which helps you well understand Creatio functionality you find in the article below: 

https://academy.creatio.com/docs/user/bpm_tools

Hello Kevin, 

Please use this article in order to find an answer to your query: https://academy.creatio.com/docs/user/bpm_tools/dynamic_case_setup/case…

Run a process from the case that carries out the checks (displaying messages if errors) before creating the task?

Gareth Osler,

Thanks for the reply however this assumes the checking should be done when creating a task. I need to be able to intercept the hover over an existing task and at that point check the criteria and either enable or disable the "Complete" button before it appears against the task.

Click on any white space in the process to get the blue "Process" plane on the side. On the Methods tab you can add usings.

Ryan

Ryan Farley,

Thank you for the clarification!

I have tried but I need to add previously the libraries to the site. Do you know how to add this library to the configuration for calling it later from the script?

You need to add the assembly to your package, there's an option for "Import" on the add menu.

I have tried and it works, thank you very much Ryan!

Такабаев Тимур,

Здравствуйте,  мы проверили и увидели, что действительно данная проблема наблюдается в версии 8.0.8. Мы передали данную ошибку на ответственную команду, чтобы исправили в следующих релизах. 



Спасибо, что помогаете делать продукт лучше. 



С уважением, 

Орхан Годжаев. 

Orkhan,

Орхан, здравствуйте! Как сейчас быть? Можем ли мы сами каким-то образом выполнить переводы указанных элементов?

Такабаев Тимур,

Как альтернативный вариант мы можем вам предложить воспользоваться данной документацией: 

 

https://academy.creatio.com/docs/user/customization_tools/ui_and_busine…



С уважением, 

Орхан Годжаев. 

Orkhan,

Указанная вами документация для страниц редактирования. Это всё можно менять в разделе Переводы в настройках системы.

Для элементов UI ядра этот метод не подходит. Например для заголовков пунктов меню при нажатии на кнопку профиля или поля Search или "Drop files here or use" etc...

Hello,

Currently, Freedom UI is not supported for Customer Portal, but we already have a registered task for the R&D team in regard to this question.

We have linked this post to the beforementioned R&D task to expedite the implementation process.

Bogdan,

Thanks for the reply,

Can you please suggest any workaround/solution that can be used to achieve the above mentioned functionality?

Janhav,

Unfortunately, there is no workaround for now.