Hello everyone,

 

Is there a way to create a filter in a metric or columns widgets that returns the number of active users based on the shift ? (Morning: 7 am-3 pm, Night: 3pm-11pm, overnight: 11pm-7am) 

 

Note that it needs to be refreshed daily

 

does anyone has an answer to this one?

 

Thanks in advance.

Like 0

Like

2 comments

Dear Anas, 
 
To achieve this functionality you can add a new boolean field (for example: IsActive) for users. This field will be updated by a business process that will start every hour.  

The business process can set the value of the IsActive field according to the filtration or you can create an object where you will specify the shifts that users have. 
 
I hope this helps. Have a great day! 

Alina Yakovlieva,

Thank you for responding!, 

could you please elaborate more about the steps that you provided? 

Show all comments

Hello all,

 

I've been facing this error as it's shown in the screenshot and Subject, it occurs when i try to save the record after filling the required fields.

 

does anyone familiar with this error ? it's pretty urgent so I'll appreciate it if anyone provided the solution. 

 

Thanks in advance.

 

 

Like 0

Like

2 comments

Greetings!
 

The issue is that if you remove the requirement for the "ReactionTimeUnit" and "SolutionTimeUnit" fields and leave them empty, you won’t be able to save the record. 
 

An error will occur:  
"Specified argument was out of the range of valid values. Parameter name: Index value is out of range"

 

These fields are mandatory because the entire out-of-the-box product logic of the Service relies on them being filled in.  

As a workaround, you can set default values for these fields, and everything will work fine.


Alternatively, you can build your application completely independent of the out-of-the-box functionality.


Regards,

Orkhan

Orkhan,

Much appreciated!

Show all comments

Hi, 

 

Is it possible to add a datetime quick filter to a grid, where you set a time to the filer?

 

Thank you. 

Like 0

Like

3 comments
Best reply

Javier Collazo,

 

We have double checked it with the responsible team and unfortunately, it is not possible to setup Time specifically in this filter. The issue here is that name Date/Time is confusing for the users and therefore we have registered this problem for our R&D team to either change the filter name or add the ability to also apply a filter by time.

Hello,

 

You can find the instructions on how to set up a date/time quick filter in this academy article.

Thank you Mira for your answer, but I already tried what is in the guide and it does not include the time in the filter. 

 


I need to be able to filter by time too. 

Javier Collazo,

 

We have double checked it with the responsible team and unfortunately, it is not possible to setup Time specifically in this filter. The issue here is that name Date/Time is confusing for the users and therefore we have registered this problem for our R&D team to either change the filter name or add the ability to also apply a filter by time.

Show all comments

Good afternoon!

I am trying to deploy deduplication-web-api using docker container registry.creatio.com/dup-web-api:3.0.12

 

I see this problem in the logs.

 

fail: Microsoft.AspNetCore.Server.Kestrel[13]
     Connection id "0HN5FOGURGKI1", Request id "0HN5FOGURGKI1:000000E2": An unhandled exception was thrown by the application.
     System.InvalidOperationException: Synchronous operations are disallowed. Call WriteAsync or set AllowSynchronousIO to true instead.
        at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpResponseStream.Flush()
        at System.IO.StreamWriter.Flush(Boolean flushStream, Boolean flushEncoder)
        at System.IO.StreamWriter.Dispose(Boolean disposing)
        at System.IO.TextWriter.Dispose()
        at App.Metrics.Formatters.Prometheus.Internal.AsciiFormatter.Write(Stream destination, IEnumerable`1 metrics, NewLineFormat newLine)
        at App.Metrics.Formatters.Prometheus.MetricsPrometheusTextOutputFormatter.WriteAsync(Stream output, MetricsDataValueSource metricsData, CancellationToken cancellationToken)
        at App.Metrics.AspNetCore.Endpoints.Middleware.MetricsEndpointMiddleware.Invoke(HttpContext context)
        at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpProtocol.ProcessRequests[TContext](IHttpApplication`1 application)

 

appsettings.json looks like this:

 

root@deduplication-web-api:/app# cat appsettings.json
{
 "Version": "1.0.0",
 "Logging": {
   "LogLevel": {
     "Default": "Warning"
   }
 },
 "Kestrel": {
   "AllowSynchronousIO": true
 },
 "AllowedHosts": "*",
 "ApplicationBasePath": "/",
 "MetricsOptions": {
   "Enabled": true,
   "ReportingEnabled": true,
   "GlobalTags": {
     "app": "deduplication-web-api",
     "env": "production"
   },
   "DefaultContextLabel": "deduplication-web-api"
 },
 "MetricsWebTrackingOptions": {
   "ApdexTSeconds": 0.1,
   "ApdexTrackingEnabled": false,
   "IgnoredHttpStatusCodes": [],
   "IgnoredRoutesRegexPatterns": [],
   "OAuth2TrackingEnabled": false
 },
 "MetricEndpointsOptions": {
   "MetricsEndpointEnabled": true,
   "MetricsTextEndpointEnabled": true,
   "EnvironmentInfoEndpointEnabled": true
 },
 "RabbitConfiguration": {
   "RabbitMQUri": "HIDDEN",
   "QueueName": "dup-start-deduplication-task",
   "ConnectAttempts": "5",
   "ReconnectInterval": "0.00:00:05",
   "NetworkRecoveryInterval": "0.00:00:05"
 },
 "RabbitPublisherConfiguration": {
   "QueueName": "dup-start-deduplication-task"
 },
 "DataServiceRestConfiguration": {
   "DataServiceUri": "http://deduplication-data-service/api"
 },
 "Logger4NetConfiguration": {
   "LoggerName": "bulk-deduplication-logger",
   "LoggerRepositoryName": "default",
   "LogFilePath": "/app/config/log4net.config"
 },
 "DuplicatesSearchConfiguration": {
   "DefaultMaxDuplicatesPerRecord": 100
 }
}

 

Can you please tell me what the problem could be?

Like 2

Like

3 comments

Hi Igor,

 

The basic appsettings.json does not mention "Kestrel": { "AllowSynchronousIO": true }. 

 

 

Could you please let us know if an error occurs without this parameter?

Sergii Zhmurko,


Yes, you are right, I found this solution on the internet but it didn't help.

Hi Igor,

 

Try redeploying the service with only the basic settings. If the error occurs again, please contact Creatio support, providing the logs of all containers and the docker-compose file you are using for deployment. 

Additionally, please include your server specifications in the request. We will then investigate the issue in more detail.

Show all comments

Hello all,

 

I have a client that is trying to add the communication options detail to the Portal user's Profile page in Freedom UI. However, it seems the User profile is no longer visibly connected to the User's contact record. How can we add the detail?

Like 0

Like

2 comments

Hello,

 

Could you please describe the end result that you would like to obtain and the exact steps that you are making?

 

Thank you!

Hanna Skalko,

I would like to add communication options to the user profile page as it could be in the Classic UI. (See below)Image of a Creatio Portal UI page that shows the user's name, address and communication options.

 

I would like to do the same in Freedom UI. However, when I open the Freedom UI user profile page, I haven't been able to find the connection the user's contact in order to add the same details to the page.

Show all comments

Hello everyone! ,

 I've added new values to "Case category" Lookup, but when i choose one of them when setting up "List of Mailboxes for case registration" it doesn't send auto email response or any email in stage transition like "Service request" or "Incident" which already exists. 

 

so to sum up there is a problem with sending auto email in case i choose the new categories that i added to the lookup. (auto case registration works perfectly)

 

so does anyone is familiar with this problem so he/she can help me to solve it? 

 

and in case of manual registration, the emails is being generated as a drafts in the conversation tab, is there a way to not make it as draft and send it automatically like case registration by email?

 

thank you for your time.

 

Like 0

Like

2 comments

Hello!

Regarding notifications for new categories:
You need to configure the necessary rules in the lookup: ‘Case notification rule’.
 

If you have any issues with draft emails, please contact our support team at support@creatio.com

Best regards,
Anton

Anton Starikov,

Much appreciated 

Show all comments

Hello everyone,

 

I need to write a formula that subtracts Current date and time from Registartion date/time and the result is more that 4 hours (Current date/time - Registration date/time > 4 hours)

 

it's pretty urgent so i'll really appreciate if anyone knows the solution and provided it.

 

thanks in advance.

Like 1

Like

2 comments

([#System variable.Current Time and Date#] - [#RegistrationDateHere#]).TotalHours > 4

 

Ryan

Much appreciated Ryan, Thanks!

Show all comments

Hi team. I have a business need to add multiple records to the same table on the server side during process execution. 

What is the best approach to do so? 

I was looking into EntitySchemaManager functionality but couln'd find solution myself. I am able to add one record at a time (see example below) but this proves to be ineficient aEntitySchemaManager approach. 

 

var entitySchema = _userConnection.EntitySchemaManager.GetInstanceByName("UsrTableName");
           var entity = entitySchema.CreateEntity(_userConnection);
           entity.SetDefColumnValues();
           entity.SetColumnValue("UsrColumn1Id", id);
           entity.SetColumnValue("UsrDate", date);
           entity.Save();

 

Please, advice.

Like 0

Like

3 comments

Hi Iuliia, 
You could probably use the "Add element" with "Add from selection" mode selected. It's hard to tell having so few details. If you could tell a bit more details it'd make it easier to suggest something. 
 

Hello Iuliia,
Thank you for your question,

It would be nice if you could provide more details regarding issue that you are facing: your code, business process etc.

Yevhenii Grytsiuk, Yurii Sokil,

the (simplified) business process is next: 

user creates some record in UsrTableName_1 that has StartDate and EndDate, usually they are far apart (for example, long leave of absence, that last up to few month). 

For reporting purposes we need to have these dates stored as separate records, meaning for each date between StartDate and EndDate we need to have separate record added to UsrTableName_2. 

To do so I am able to loop through dates  between StartDate and EndDate and add necessry records one by one (using the code snippet provided by me above) but it is ineficient approach because of the multiple Save calls. 

What I want to do is to calculate all the necesary records, add/attach them and then call Save() only once, so there would be only one call to the DB to write the data. All this should be implemented on backend. Essentially I am looking for similar functionality that is provided by EntityFramework where one can call context.SaveChanges() after adding all records to the context (here is example how EF works https://learn.microsoft.com/en-us/ef/core/saving/basic#multiple-operations-in-a-single-savechanges) 

Does such approach exist in creatio? 

Thanks

 

 

 

Show all comments

Hi all,

 

Is there a settings to notify user when a ticket is open directly in the Case section?
 

We are basically registering cases through email, and it works fine, but if I register a case directly in the Case section there is no notification to the user.

 

User only receive email if I send an email from the case, meaning not automatically.

 

Any thougths?

Like 0

Like

2 comments

Hello,

 

This behavior can be achieved using the OOB functionality.

This article will help you with the setup: https://academy.creatio.com/docs/8.x/creatio-apps/products/service-tools/service-cases/case-settings/set-up-email-notifications

 

Please, pay attention to this block: https://academy.creatio.com/docs/8.x/creatio-apps/products/service-tools/service-cases/case-settings/set-up-email-notifications#set-up-contact-case-notification-rules

It will guide you through the necessary settings.

 

Hanna Skalko, 

Thank you, I will take a look on them

Show all comments

Добрий день. Робимо запрошення на портал через автоматичну реєстрацію (Налаштування-Налаштування порталу-Організаційні ролі на порталі-Обираємо організацію - На вкладці "Основна інформація" натискаємо на "+", обираємо "Додати нові контакти"-Вказуємо email і надсилаємо запрошення). У зв'язку з великою кількістю запрошень необхідно розуміти кому запрошення на портал вже були надіслані. Яким чином можна вивести цей параметр (запрошення надіслане) в контактах?

Like 0

Like

2 comments

Доброго дня!

На жаль, в контактах не зберігається подібна інформація, тому і вивести її не буде можливим. 

Ми вже зареєстрували побажання на додавання такого функціоналу в майбутніх версіях системи, тому сподіваємось на скорішу реалізацію цього функціоналу. 

Дякуємо, що допомагаєте нам покращувати нашу систему. 

З повагою,
Антон

Дякую за відповідь. Дуже чекаємо на дане доопрацювання.

Show all comments