I want to show only the Completed value, not the other values of the lookup.

Printscreen:

Another printscreen :

Is there some lookup where these values are stored, or they are hardcoded an I cant modify them ?

Like 0

Like

2 comments
Best reply

Hello Petrika,

 

For the 1st image, you can search for the lookup named "Activity results" and set the "Available in business process only" column to true/Yes for the values which you don't want to see in the dropdown:

 

 

For the 2nd image, you can search for the lookup named "Activity statuses" and delete/add the values which you want to see in the dropdown:

 

 

Regards,

Sourav

Hello Petrika,

 

For the 1st image, you can search for the lookup named "Activity results" and set the "Available in business process only" column to true/Yes for the values which you don't want to see in the dropdown:

 

 

For the 2nd image, you can search for the lookup named "Activity statuses" and delete/add the values which you want to see in the dropdown:

 

 

Regards,

Sourav

Sourav Kumar Samal,

Thank you very much , it worked

Show all comments

Hello Creatio Community !

Is it possible to add a mini page in Portal ?

I want to add the mini-page of creating an Application in portal. Printscreen below

Like 0

Like

2 comments

Hello,

Currently there is no oob functionality that can allow to use mini pages for portal users and it cannot be changed with basic system tools. 

We already have a query registered for our responsible R&D team to consider implementing this functionality in the upcoming releases.

 

You may consider implementing this functionality with a help of development, please find more information in the below article:

https://academy.creatio.com/docs/developer/interface_elements/mini_page…

Best regards,

Anastasiia

Thank you Anastasia !

Show all comments

Dear,



We are having issues with installing several add-ons from the marketplace.

These same add-ons were successfully installed in other Creatio instances, but here with one specific website they are throwing errors.



1. https://marketplace.creatio.com/app/excel-reports-builder-creatio



2022-05-24 16:14:35,661 Compiling configuration dll

2022-05-24 16:15:33,735 Errors and (or) warnings occurred while compiling configuration dll

2022-05-24 16:15:33,735 Autogenerated\Src\IntReportHelper.IntExcelExport.cs(273,31) error CS0433: The type 'ExcelWorksheet' exists in both 'EPPlus, Version=4.1.0.0, Culture=neutral, PublicKeyToken=ea159fdaa78159a1' and 'EPPlus, Version=4.5.3.2, Culture=neutral, PublicKeyToken=ea159fdaa78159a1'





2. https://marketplace.creatio.com/app/email-approvals-creatio



2022-05-24 17:45:40,097 Compiling configuration dll

2022-05-24 17:46:32,008 Errors and (or) warnings occurred while compiling configuration dll

2022-05-24 17:46:32,008 Autogenerated\Src\IntReportHelper.IntExcelExport.cs(273,31) error CS0433: The type 'ExcelWorksheet' exists in both 'EPPlus, Version=4.1.0.0, Culture=neutral, PublicKeyToken=ea159fdaa78159a1' and 'EPPlus, Version=4.5.3.2, Culture=neutral, PublicKeyToken=ea159fdaa78159a1'



It is strange that they both throw the same error.

Is there any way to fix this?





Kind regards,

Vincent

Like 0

Like

1 comments

Hi Vincent,

Creatio platform doesn't allow installing one .dll library several times (in this case, EPPlus). Both errors indicate that you already have the EPPlus library installed on your Creatio site. The 'Excel reports builder for Creatio' app uses the library, while the 'Email approvals for Creatio' app does not.

The problem can be fixed by finding the other package that has the library on your Creatio site and manually removing the library from one of the packages to resolve the conflict.

Show all comments

Hello there,

I've got a question about email templates in business processes and the signature configured in the mailbox settings.

Is it possible to remove the signature from emails with templates?

Our problem is that the signature is bound to the left and the templates is in the middle, so the signature won't fit style wise. 

On normal emails the signature should still be filled in automatically.

Like 0

Like

1 comments

Hello Markus,

 

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.



We have already registered the idea for our R&D team to implement this functionality in further releases. I will assign your case to this project in order to increase its priority. 



Best regards,

Bogdan

Show all comments

Hello Community!

I have modified the Activity object in order to display a custom Object (Order) and added an Activity column too. 

Now, when clicking on the RightSideMenu I have the same object (Activity = Attività, and Ordini = Orders) repeated twice. Does anybody know which module is in charge of displaying the options within this menu? Or do you have any idea of what the "cleanest" solution might be?

Thank you and have a great day! :) 

Like 0

Like

5 comments
Best reply

Federica,

 

Basically, there is a table in the database called EntityConnection. You can delete all the records from this table that refer to the objects which you do not need (for example, contact, requests etc).

You can do the following:

delete from EntityConnection where SysEntitySchemaUid in (select Uid from SysSchema where Name = '')

where '' is the name of the object, for example, Contact.

But the thing is if you delete the records from the EntityConnection table - the next fields on the activity page will be deleted automatically as well:



Best regards,

Bogdan

Hello Federica,



Could you please send the screenshot once again?



Best regards,

Bogdan

Hello Bogdan,



Here's the image, sorry for the mishap

Federica,

 

Basically, there is a table in the database called EntityConnection. You can delete all the records from this table that refer to the objects which you do not need (for example, contact, requests etc).

You can do the following:

delete from EntityConnection where SysEntitySchemaUid in (select Uid from SysSchema where Name = '')

where '' is the name of the object, for example, Contact.

But the thing is if you delete the records from the EntityConnection table - the next fields on the activity page will be deleted automatically as well:



Best regards,

Bogdan

Thank you Bogdan! That's exactly what I did (according to your suggestion) ! :) Do you happen to know how to change the icon too? 

 

I made a few tests and to access the icons I need to implement EmailItemSchema client module

Now: 

Show all comments

Hi community,

 

I'm working on a new view object to create custom dasboards for my customer based on Bulk Email stats. I noticed that Creatio has an OOTB View object called "VwBulkEmailAudience" which is based on "BulkEmailTarget", "BETArchiveFirstGeneration" and "BETArchiveSecondGeneration".

Does anybody knows what the least two tables are used for? I have checked both the local-dev and the production site, and those tables are empty.

I enclose the script for the OOTB View in case you'd like to gain a better understanding of what I'm talking about.

 

Thank you in advance guys and girls! Have a nice day :)

-- View: public."VwBulkEmailAudience"
 
-- DROP VIEW public."VwBulkEmailAudience";
 
CREATE OR REPLACE VIEW public."VwBulkEmailAudience" AS
 SELECT "BET"."MandrillId" AS "Id",
    "BET"."CreatedOn",
    "BET"."ModifiedOn",
    "BET"."BulkEmailId",
    "BET"."ContactId",
    "BET"."EmailAddress",
    "BERR"."DCReplicaId" AS "ReplicaId",
    "BET"."LinkedEntityId",
    "BET"."BulkEmailResponseId",
    "BET"."Clicks",
    "BET"."Opens",
    "BET"."ProviderName",
    NULL::text AS "SessionId",
    0 AS "IsSent"
   FROM "BulkEmailTarget" "BET"
     LEFT JOIN "BulkEmailRecipientReplica" "BERR" ON "BERR"."RecipientId" = "BET"."MandrillId"
UNION ALL
 SELECT "FG"."MandrillId" AS "Id",
    "FG"."CreatedOn",
    "FG"."ModifiedOn",
    "FG"."BulkEmailId",
    "FG"."ContactId",
    "FG"."EmailAddress",
    "BERR"."DCReplicaId" AS "ReplicaId",
    "FG"."LinkedEntityId",
    "FG"."BulkEmailResponseId",
    "FG"."Clicks",
    "FG"."Opens",
    "FG"."ProviderName",
    NULL::text AS "SessionId",
    0 AS "IsSent"
   FROM "BETArchiveFirstGeneration" "FG"
     LEFT JOIN "BulkEmailRecipientReplica" "BERR" ON "BERR"."RecipientId" = "FG"."MandrillId"
UNION ALL
 SELECT "SG"."MandrillId" AS "Id",
    "SG"."CreatedOn",
    "SG"."ModifiedOn",
    "SG"."BulkEmailId",
    "SG"."ContactId",
    "SG"."EmailAddress",
    "BERR"."DCReplicaId" AS "ReplicaId",
    "SG"."LinkedEntityId",
    "SG"."BulkEmailResponseId",
    "SG"."Clicks",
    "SG"."Opens",
    "SG"."ProviderName",
    NULL::text AS "SessionId",
    0 AS "IsSent"
   FROM "BETArchiveSecondGeneration" "SG"
     LEFT JOIN "BulkEmailRecipientReplica" "BERR" ON "BERR"."RecipientId" = "SG"."MandrillId";
 
ALTER TABLE public."VwBulkEmailAudience"
    OWNER TO puser;

 

Like 0

Like

2 comments
Best reply

Hi Federica,

The "BETArchiveFirstGeneration" and "BETArchiveSecondGeneration" tables have been added in the 7.17.1 version of Creatio. They are used as a way to archive old records from the BulkEmailTarget table. Records older than 1 year go into those tables.

To get information about the OLD licenses usage you would need to use the VwBulkEmailTarget view as it looks into both the BulkEmailTarget and BETArchive tables. 

 

Best regards,

Max.

Hi Federica,

The "BETArchiveFirstGeneration" and "BETArchiveSecondGeneration" tables have been added in the 7.17.1 version of Creatio. They are used as a way to archive old records from the BulkEmailTarget table. Records older than 1 year go into those tables.

To get information about the OLD licenses usage you would need to use the VwBulkEmailTarget view as it looks into both the BulkEmailTarget and BETArchive tables. 

 

Best regards,

Max.

Thank you very much Max for clarifying! :)

Show all comments

Dear community,

 

Is it possible to add more info in the approvals in the right sidebar?

In the desktop application, it is possible to click to the related record (e.g. invoice) to see the detailed info, but in the mobile app it is not possible.

Therefore, I would like to add some text containing a short description:

https://prnt.sc/rzKCmxQgIEnC

 

 

Kind regards,

Vincent

Like 0

Like

1 comments

Hello Vincent,

 

Please be informed that at the moment, in the existing interface of mobile application approvals, it is not possible to implement such logic as you described.

A request for the implementation of this functionality has already been registered and I will also attach your request there to increase its priority.

 

Thank you for choosing Creatio!

 

Kind regards,

Mira

Show all comments

Hello Creatio Community !

I created a portal Page which inherits from Application Form Edit Page. Cases workflow do not appear in portal page. Printscreeen below

In the original application form the cases appear. printscreen Below

How can this be corrected in Portal. Is this some permission issue ?

Like 0

Like

4 comments

Hello Petrika,



It's possible to add DCM panel for the portal user by following the instruction on our Community:



https://community.creatio.com/articles/enable-dcm-portal-users



Best regards,

Bogdan

Bogdan i believe the article is outdated. For example the object "Case status changed actions" didnt exist at all in nowdays versions of Creatio

Petrika,



Unfortunately, we don't have new examples of such implementation.

So, you can refer to the post by the link in the previous comment. 



Please note, that we have already registered the idea for our R&D team to implement this functionality in further releases. I will assign your case to this project in order to increase its priority.  





Best regards,

Bogdan

Bogdan,

I tried the operations described in the article and they didnt work.

I think there is some modifications that needs to be done in Operation Permissions and Object Permissions Bogdan. 

Because when i deploy the same portal page in another instance (which has an empty database) the cases appear !

Show all comments

Hello everybody,

we created some import templates in our Dev Instance. Is there a way to transfer these templates from the DEV to the Productive Instance? So we can use the ready-made Excel templates there as well and would not have to rebuild the mapping.

Stefan

Like 0

Like

1 comments
Best reply

Hello.

You can use the functionality "Binding data to the package".

To do this, you need to create a "Data" element in the "Configuration" section and bind the necessary data to the "FileImportTemplate" object.

Please find more information on your request in these Creatio articles:

https://academy.creatio.com/docs/developer/development_tools/packages/packages_basics/overview#title-2105-9

https://academy.creatio.com/docs/developer/development_tools/packages/bind_data

Hello.

You can use the functionality "Binding data to the package".

To do this, you need to create a "Data" element in the "Configuration" section and bind the necessary data to the "FileImportTemplate" object.

Please find more information on your request in these Creatio articles:

https://academy.creatio.com/docs/developer/development_tools/packages/packages_basics/overview#title-2105-9

https://academy.creatio.com/docs/developer/development_tools/packages/bind_data

Show all comments

Hi all,

I have an issue when publishing any objects since a while. The error occured after a timeout issue when registering a new section via the assistant.

The mentionned object has never been created.

How can I solve the issue ? I have access to the database.

 

Best regards,

Franck

Like 0

Like

1 comments

Dear Franck,

To help you with this error we need to investigate the issue and analyze the configuration of the application.

So, please, send a letter to support and we will help you.

Best regards, Alex.

Show all comments