Hi Team,

 

I am actually trying to do something like this https://customerfx.com/article/executing-direct-sql-statements-in-a-process-or-configuration-web-service-in-creatio-formerly-bpmonline/  using CustomQuery

 

Please see below : 

 

But I am getting all these errors : 

 

Though I checked System.Data is already there. 

Can anyone please help me with this issue ?

Like 0

Like

5 comments

Hi Akshit,

 

Also add using the Terrasoft.Core.Entities namespace to your code as well as System, Terrasoft.Core.Factories and System.Runtime.Serialization namespaces.

 

Best regards,

Oscar

Oscar Dylan,

 

Thank you most of them are resolved only this persist.

Akshit,

 

You should also add the System.Data.IDataReader namespace to the code.

 

Best regards,

Oscar

Oscar Dylan,

 

Yes, I tried but it says IDataReader is not a namespace it's a type.

Akshit,

Hello Akshit,

reader.GetColumnValue<T> is an extension method defined in Terrasoft.Common. Add that as a using directive and it should fix your issue.

Ryan

Show all comments

Hi,



Is it possible that when an email is replied to, and an email template is added, the email subject is deleted?



I think it could be developed in EmailMessagePublisherPage or EmailPageV2, but I don't know how to recognize when the email template is added.



Thank you. Regards.

Like 0

Like

4 comments

Hi Celia,

 

The development of such a logic is redundant since the subject can be modified even if it's filled in with the subject of a template. You can manually remove the subject and fill it in with the value you need.

 

Best regards,

Oscar

Oscar Dylan,

Hi Oscar,

 

Thank you for your response!

Sorry, I should have clarified that what I need is  to delete it automatically.

 

Regards.

Celia de la Torre,

 

The answer remains the same: the development of such a logic is redundant since the subject can be modified even if it's filled in with the subject of a template. You can manually remove the subject and fill it in with the value you need.

 

Best regards,

Oscar

Oscar Dylan,

 

That's the thing, not having to delete it manually.

 

When user reply to an email, the subject is filled in automatically (regardless of whether a template is added or not). To force the user to change the subject when adding a new template, it is necessary to delete the subject (required field) for them to complete it.

 

It may not be a correct solution to my problem, but I can't think of another idea to force change the subject only in cases where a new template is added.

 

I welcome any new ideas with pleasure.

 

Thank you.

Show all comments

Hi,

 

We're looking to integrate a Creatio instance with the Mitel telephony system and we installed the MiContact Center connector for the instance. Is the connector a standalone solution to integrate with the phone system or do we still need to have the BPM Messaging Service running in order to establish the connection between Creatio and the phone system?

 

Thanks

Like 0

Like

1 comments

Hello,

 

For Mitel telephony it is not necessary to have BPM Messaging Service. The connector can be used alone. 

 

Regards,

Dean

Show all comments

Hi,

 

I have a need to add additional status's to the case workflow and for one of them I need to pause the case SLA timers. I am adding under 'Waiting for Response' a new case status 'Session booked' as that has a number of specific actions generated for it and for this additional status, how can I also put a pause on the case.

 

The documentation just indicates that cases are paused when moved in to a 'Waiting for Response' stage, but I cannot find a process or field which controls this.

 

Thanks for any guidance you may have.

Like 0

Like

3 comments

Dear Mark,



You can use the Case Designer to configure case steps and their sequence.



Please find the Creatio Academy article about Case Designer workflows here



Best regards,

Bogdan.

Bogdan,

Thanks for your reply. I am aware of the process of using the Case Designer to add another stage in the process, and also the ability to group them, for which this entry is intended to be grouped with the Waiting for Response stage that already exists. It is the method of applying a pause to the SLA timer when a user puts a case in this stage that I cannot find how to do.

 

I looked at using a process, for when a case changes to that stage, but I cannot find a no-code method of pausing the SLA timer.

 

Do you, or anyone else know how to put the pause in place?

Anyone able to help?

 

Is this just not possible, as I cannot find anything in the process designer either

Show all comments

Hello Community,

 

I have a scenario where I need to trigger a business process on record addition in CaseFile Object, but the record will be added using an SQL Query.

 

 The issue is that even after the execution of "INSERT INTO CaseFile . . " SQL command using SSMS, the business process does not get triggered in Creatio. Any help on this would be highly valuable.

 

Thank you in advance. 

Like 0

Like

2 comments

Dear Rahul, 



The processes are not triggered when you do direct inserts/updates in the database. Technically, it is possible to create a trigger in the database that would start a process for you upon the database insert. Else, you can try to achieve the similar functionality with the help of external applications.



Kind regards,

Roman

Roman Brown,

Thank you for your response Roman. I'll try working on this approach. 

Show all comments

Hi All,

 

I would like to execute a business process from a 3rd party tool. I found this Creatio article for this purpose. 

 

I followed each step on this article to define business processes to add contact and list contacts. When I save the process, I see pop-up screen to "Publish" the business process. When I try to publish it, I receive "The name ContactName does not exist in the current context" message. I also see same error message for other process paramaters (ContactPhone and ContactList) as shown below. 

 

 

Does anyone have any idea about this issue? I'm concerned if I'm missing a step or this article script content is not valid anymore. Thanks.

 

Like 0

Like

1 comments

Hello, 

 

Such error occurs when variables (ContactName, ContactPhone and ContactList) are not defined in the function, the code itself should be revised a bit. 

After adding 

var ContactName = Get<string>("ContactName");

var ContactPhone = Get<string>("ContactPhone");

.... etc

at the beginning of the Script Task element the process can be saved and published with no errors. 

 

Best regards, 

Anastasiia Zhuravel

Show all comments

My team and I are using the agile method of development so every couple of weeks we change, drop, hide, move, adjust, or add something to Creatio. I will reach out to the users with a mass email with screenshots and enrichment documents but the communications seem to add to the clutter. Is there anything available like Chameleon or another user onboarding communication tool that we can explore? Instead of moving forward with programs outside of Creatio I wanted to see what, if anything was in-house. 

Like 0

Like

2 comments

You can paste images in the feed. To do this you need to add this image to some section "Attachments and notes" detail and then drag it to the feed editor in the CTI-panel:

Or you can also copy links to download images in the feed message:

This is one of the ways to share images in the system. Also you can use standard feed and add a note that images can be found in the "Attachments and notes" detail of the related record (and share the link to this record).

 

And also there is a free marketplace app via this link https://marketplace.creatio.com/app/slack-feed-connector-creatio and you can also check if it fits your needs.

 

Best regards,

Oscar

I was looking more towards a tool that would help build training for clickable options or videos, the type that Chameleon makes. Is there anything like that in the Creatio Marketplace?

Show all comments

Hi Community,

 

For one of the system user, we have one custom action which is visible and editable only when certain conditions meet.

Code

 

When everything is working user can see the highlighted action and fields on which the condition is applied  : 

 

Issue : When we remove any one of the field let's say OrderType(lookup) from Section List view Action is not visible even when the conditions meet.

 

Please see the below image when Order Type is removed from section list view.

 

Error : 

In statusordertype = selectOrder.get("UsrOrderType"); It is taking statusordertype as undefined.

But UsrOrderType is filled.

 

So Complete scenario is this that when the field on which the condition are applied are visible on the section List view Custom Action is Visible but the moment we removed the field from section list view It is throwing error even when the field is filled in.

 

This is not the case with Admin.

 

Please help me to understand the root cause of this issue ?

Like 0

Like

6 comments
Best reply

Akshit,

Your issue is likely this line: 

if (!esq.columns.contains("UsrField1", "UsrField2", "UsrField3", "etc") 

The contains function on esq.columns accepts only a single field name to check for (so it is only checking for the first one, all the other parameters are ignored). See implementation here.

Change your code so you are doing it like this: 

if (!esq.columns.contains("UsrField1") {
    esq.addColumn("UsrField1");
}
if (!esq.columns.contains("UsrField2") {
    esq.addColumn("UsrField2");
}
// etc

Or something like this:

var fields = ["UsrField1", "UsrField2", "UsrField3"];
for (var i=0; i&lt;fields.length; i++) {
    if (!esq.columns.contains(fields[i]) {
        esq.addColumn(fields[i]);
    }
}

Hope this helps.

Ryan

Hi Akshit,

 

This is correct since the data is received from the grid itself (meaning only from columns in the grid), but not from the record. So in case some column is not present in the grid data from it won't be fetched by the client logic. I believe there was a community post previously with an explanation on how to overcome it, I will try to find it and share the link with you.

 

Best regards,

Oscar

Here is the link to the related topic where Ryan shared an idea on how to add missing columns to the ESQ - https://community.creatio.com/questions/unable-get-data-active-record-s….

 

Best regards,

Oscar

Hi Oscar Dylan,

 

We had already added the columns in esq, According to what Ryan has said in reply.

 

 

But it's not working.

 

There is one more Information I would like to share once the record is  approved the user only have read permissions.

 

For Admin it is working even when the fields are not on the section list view.

 

Any Idea what could be the issue ?

 

 

 

Akshit,

Hello,

 

Then if the columns esq working for Admin, but not for a regular user then maybe the problem is with column permissions? Also have you tried another approach with managing access rights to records via a business process (using the "Change access rights" element)?

 

Best regards,

Oscar

Akshit,

Your issue is likely this line: 

if (!esq.columns.contains("UsrField1", "UsrField2", "UsrField3", "etc") 

The contains function on esq.columns accepts only a single field name to check for (so it is only checking for the first one, all the other parameters are ignored). See implementation here.

Change your code so you are doing it like this: 

if (!esq.columns.contains("UsrField1") {
    esq.addColumn("UsrField1");
}
if (!esq.columns.contains("UsrField2") {
    esq.addColumn("UsrField2");
}
// etc

Or something like this:

var fields = ["UsrField1", "UsrField2", "UsrField3"];
for (var i=0; i&lt;fields.length; i++) {
    if (!esq.columns.contains(fields[i]) {
        esq.addColumn(fields[i]);
    }
}

Hope this helps.

Ryan

Ryan Farley,

 

Thanks, Ryan. It works!

Show all comments

Hi Community,

 

For one of our customers their On-Site deployed production instance site stops loading the login page certainly. This issue started appearing from last week many times apparently. Before that the site was working fine.

Though when I edit the web. config file(both under root and /Terrasoft.WebApp) from 

Https->Http and then Http-> Https and it resolves the issue temporarily.

 

Below is the screenshot when login page stops loading.

 

Below is the screenshot when login page loads.

 

This issue is appearing quite frequently now.

 

Can anyone please help me to understand the root cause of this issue?

 

Many thanks!

Like 0

Like

1 comments

Dear Akshit,



Please, register a case for our support team to be able to investigate the issue and resolve it.

You can just simply send an email to support@creatio.com with the description so we can help you.



Best Regards,

Ivanna Yatsura

Show all comments

What is the best way to restrict a user from being able to put a Case in the closed status if there are tasks associated with the case that are in the not started status?

Like 0

Like

1 comments

Dear Mitch,

 

You can set the activities on the DCM and make them required. Thus, the users will not be able to close a case.

 

Regards,

Dean

Show all comments