Hi Adharsh,

you can try such a script, just use names of DCM you want to deactivate:



Update "SysSchemaProperty"

Set "Value" = false

WHERE 

    ("SysSchemaId" IN

        (SELECT s."Id" 

        FROM  "SysSchema" s 

        WHERE s."Name" IN ('DocumentCase','ContractCase')

    )



​​​​​​​Kind regards,

Vladimir

Vladimir Sokolov,

I could see 6-8 records when we run the query. As "SysSchemaProperty" contains many records for each SysSchemaId of different properties. Which column should be updated to "False".



Also I have attached below the image for reference which is the query result of deactivated DCM Case in local development environment. I could not able to find any column with value as "False".



Image -1 : "Result query of deactivated 'LeadCase' DCM"

Image-2: "Result query of newly activated 'LeadFlowCase' DCM"





Result of both queries seems to be similar. Not major difference. Initially I thought, Enabled property defines the Active/InActive state of DCM case. But in this case both values are True.



Kindly help us with it.



Best Regards,

Adharsh S

Adharsh writes:

Yes, you are rights. Enabled property should be set to false.  



... AND "Name"='Enabled'



But I don't know why they both are Enabled if one of them is deactivated.

Also I see in our project, that Enabled property for LeadCase didn't exist in production enviroment, so script just adds new one:



INSERT INTO "SysSchemaUserProperty"

("Id","Name","Value","SysSchemaId")

VALUES 

('0a16d853-9e01-4544-8a6f-3ebde5d3bbed','Enabled',false,'4944ebb5-1881-46a9-85df-b93d092424ad')

ON CONFLICT DO NOTHING

Vladimir Sokolov,

Thanks for it. I am able to deactivate the existing OOTB - Lead case stages. But the columns "Which column to build the stages by?" and "Which column determines which case to use with a record?" are not updating, Retains the same state. 



Ref Image,





Kindly help us, how to update these values! Am I missing any other thing?



Best Regards,

Adharsh S

Adharsh,

You should find SysDcmSettings in bound data (the easiet way to to find by Modified On date) and set 'Forced update' for column Filters. 

I think it can help

Kind regards,

Vladimir

Hello,

We see that you have also registered a case directly for our Support team and we are already working on it so we will update you on the problem in that case.

Regards,

Mira

Hi,

we also experience the same problem with an on-premise installation in version 8.0.3.

Is there already a solution available?

Thanks,

Robert

Robert Pordes,

We kindly recommend updating the Email Listener service to resolve the error of verification on the diagnostic page.

Could you provide us with the information on where you deployed for the Email Listener service (Kubernetes or Docker)?



Also you are adding gmail mailbox to the system and it require a few additional steps due to Google security policy.

There are 2 possible ways to add the mailbox to the system:

1. Enable 2-Step Verification for the mailbox, generate the App password from the appropriate Google account and add the mailbox to the system.

2. If you are using Gsuite, you can configure your own app on the Google's side for authorization through the Oauth.



1. Using the App password.

There is a need to perform the below steps:



1) Create a copy of the mailbox provider GMail

2) Disable the system setting with code "UseGoogleSharedApplication"

3) Created password for the external programs on the GMail's side as described here: https://support.google.com/accounts/answer/185833?hl=en

4) Use password from p.3 while adding the mailbox with the help of copy of the mailbox provider from p.1. 

Login and password for the mailbox will be used inside Creatio system, not GMail. 



2. Create your own program on the Gsuite side.

It's a bit more complex variant, as there will be a need to perform the corresponding setting both through Gsuite and in the app.



1. Please perform the setting on the Gsuite's side as described here: 

https://academy.creatio.com/docs/user/setup_and_administration/base_integrations/google_mail_contacts_and_calendar/register_with_google_workspace/register_creatio_application_in_gsuite

In p.5 you need to choose "Gmail API" and complete the settings on receiving ClientId and Client Secret.

2. Populate the values for the mailbox provided with the received keys in "OAUTH2.0" type of authorization. 



Best regards,

Bogdan

Hi Community!

We have solved this issue, by using the new version of the docker image called emaillistener (bpmonline/emaillistener Tags | Docker Hub)

This has to be changed in the docker-compose file for the ListenerAPI and ListenerWorker service.

Another change is the port mapping for the ListenerAPI. It has to be 10000:8080 instead of 10000:80.

Also, there is an error in the definitions.json file, which is used in the rabbitMQ container. The vhosts part has to look like this:

"vhosts": [
    {
      "name": "/"
    },
    {
      "name": "ELhost"
    }
  ]

I have created a case and Creatio promised to update the academy article accordingly.

BR,

Robert

Hello,

As we mentioned in the submitted case to support, we do not recommend you manually check those boxes, to properly add them please follow the steps below:

1. In the object, permissions section add your restrictions
2. The system will create a "copy" of the object you are working on in the current package as a reference to the original object
3. In that copy, you will see the checkboxes checked for the chosen options from object permissions.

Please make sure to set the "Current Package" system setting to the one you are developing in.

For further questions please refer to your support case.

Thank you.

Printscreen of Error Logs

Managed to solve the problem by re-compiling FinApplicationSpec

Hello, 

Please take a look at this conversation. I believe there you can find answer to your question.

Dmytro Vovchenko,

I have looked into to the code which is shared in the post. And also looked into the BaseOpportunityPage to implement other functionalities such as Probability, Days in Funnel in Leads section as you see below,









But I am unable to implement the Manager's Mood functionality. When I click on manager Mood, there is no event getting triggered, no error in console. I have looked through complete base opportunity page, unable to find its functional implementations. 

Can you help me in finding the right code to fit it to implement this feature.



Regards & Thanks,

Adharsh S

 

Hi Creatio Team,



Can you help me in figuring out the above scenario ?



Regards,

Adharsh S

Adharsh,

Hi,

Take a look at this conversation, there you will find a discussion about the problem you are struggling with.

Dmytro Vovchenko,

Thanks

Hello Suman,

We investigated this behaviour and currently, the system behaves correctly since you can add a macro in the signature so it could fit the template or depend on some value.



I informed our R&D department about this case so they could consider enhancing the following functionality in the upcoming releases.



Best regards,

Bogdan

Hello Amritha,

In order to change how resolution time is calculated please go to system designer -> Lookup -> Case deadline calculation schemas.

In there, you are able to choose one of the default options (one of which will suit your demand and is called "By service") or create your own rules.

To read more about resolution time calculation please refer to the academy article here.

Thank you,

Artem.

Hello Amritha,

We already have a support ticket regarding this issue.

Please refer to your case regarding this issue.

Thank you,

Artem.

Hi Amritha

Thank you for your question!

First of all, you need to add the 'email' field to the account's page as there is no such field as 'email' there (only communication options). After this, you can send a notification stated in this field using out-of-the-box functionality. It is possible to do it through the business process. It would be necessary to create a new one, which would read the newly created case, read its related account, and send the email to the mailbox which you mention as the primary one for this account. As for your second question, such templates can be created. They are not common as most of the time emails are sent to contacts or groups of contacts but not to accounts.

Best regards,

Anastasiia