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

Hi Community,

 

In "Case" we wanted to filter "assignee field". Currently all users are showing in the dropdown both active and inactive. Using business rule how we can filter it to show only active users? Thank you

 

 

 

Like 1

Like

3 comments

Hi Fulgen,



1. You have to set filter in the Case page:

           

"Owner": {

                "dataValueType": Terrasoft.DataValueType.LOOKUP,

                "lookupListConfig": {"filters": [

                    BaseFiltersGenerateModule.OwnerFilter

                ]}

            }



2. Change define part in the Case page ("UsrBaseFiltersGenerateModule" for BaseFiltersGenerateModule):



define("CasePageV2", ["UsrBaseFiltersGenerateModule"], 

    function(BaseFiltersGenerateModule)



3. Add UsrBaseFiltersGenerateModule schema (you can see commented options for users with or without license as well):

define("UsrBaseFiltersGenerateModule", ["UsrBaseFiltersGenerateModuleResources", "ConfigurationConstants"], 
	function(resources, ConfigurationConstants) {
		function getIsNotNullFilterGroup(refSchema) {
			const userFilter = Terrasoft.createColumnIsNotNullFilter(refSchema + ".Id");
			const filters = Ext.create("Terrasoft.FilterGroup");
			filters.addItem(userFilter);
			return filters;
		}
 
		function employeesFilter() {
			const sysAdminUnitRef = "[SysAdminUnit:Contact]";
			const employeesFilter = Terrasoft.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL,
					sysAdminUnitRef + ".ConnectionType",
					ConfigurationConstants.SysAdminUnit.ConnectionType.AllEmployees);
			// const hasLicFilter = Terrasoft.createExistsFilter("[SysAdminUnit:Contact].[SysLicUser:SysUser].Active");
			const isActiveUserFilter = Terrasoft.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, "[SysAdminUnit:Contact].Active", true);
			const filters = getIsNotNullFilterGroup(sysAdminUnitRef);
			filters.addItem(employeesFilter);
			// filters.addItem(hasLicFilter);
			filters.addItem(isActiveUserFilter);
			return filters;
		}
 
		function allUsersFilter() {
			return getIsNotNullFilterGroup("[VwSystemUsers:Contact]");
		}
 
		function selfFilter() {
			let primaryColumnName = "Id";
			if (this.entitySchema && this.entitySchema.primaryColumnName) {
				primaryColumnName = this.entitySchema.primaryColumnName;
			}
			const primaryColumnValue = this.get(primaryColumnName);
			return Terrasoft.createColumnFilterWithParameter(
				Terrasoft.ComparisonType.NOT_EQUAL, primaryColumnName, primaryColumnValue);
		}
 
		return {
			OwnerFilter: employeesFilter,
			SelfFilter: selfFilter,
			AllUsersFilter: allUsersFilter
		};
	});



 

Hello, Fulgen!



Unfortunately, Creatio can not set up additional filtering with OOB functionality for the " Responsible " field. It is possible to solve your business task by creating business rules using development tools. And we have already registered a request for the responsible R&D team to research the possibility of implementation of this solution for the future releases of Creatio application.

Thanks, Vladimir Sokolov

This is exactly what I need, but I am having some issues getting this to work.

I've done all 3 steps, but clearly have an issue with Step 1 as I am getting errors on the Case Page. When I add the Owner filter in the CasePage client module and compile, then CasePage will not load.

So, a newbie question for you, within what section of the CasePage code should the Owner element be added? I assumed businessRules, rather than attributes, modules, details, methods, dataModels, or diff.

I dropped it in as the last businessRules element (adding appropriate , and such). Things compile fine but the Case page does not load. 

"Owner": {

                "dataValueType": Terrasoft.DataValueType.LOOKUP,

                "lookupListConfig": {"filters": [

                    BaseFiltersGenerateModule.OwnerFilter

                ]}

            }

The first time that I tried this I got an error on browser console that BaseFiltersGenerateModule was unknown (sorry, I did not save the exact text of the error, but can reproduce it). So I added BaseFiltersGenerateModule into the define/function statement at the start of CasePage.

Show all comments

Hi Community!

 

I have a requirement to add fields for multiple records from the connected detail along with fields from the macro object (1:M Relation). Can anyone suggest how to achieve this task?

 

Thanks & Regards,

Kritika Vari

Like 0

Like

1 comments

Dear Kritika,

 

Thank you for your question.

 

Unfortunately, your business task can be achieved neither with basic nor with advanced tools. 

We have already registered the idea for our R&D team to implement this functionality in further releases. 

 

Best regards,

Anastasiia

Show all comments

Hi,



Does anyone know how we could transfer attachments and feed history from the lead to its corresponding opportunity when transferring to the sales team ?



Thanks,



Damien

Like 0

Like

2 comments
Best reply

Hello Damien,

 

Thank you for your question. Your task may easily be solved by a Business Process:

- for files, you may use Element "Process File"

- for Feed - you will need two Elements - Reed data and Add data that will process object "Message/comment". You will need to exact the body of the feed on the lead page and create a new feed message on the opportunity page. (It will be also needed to be careful while setting the schema lookup field by choosing Schema -> Opportunity for Add data element)

 

I hope my recommendation was useful for you.

 

Best Regards,

Dan

Hello Damien,

 

Thank you for your question. Your task may easily be solved by a Business Process:

- for files, you may use Element "Process File"

- for Feed - you will need two Elements - Reed data and Add data that will process object "Message/comment". You will need to exact the body of the feed on the lead page and create a new feed message on the opportunity page. (It will be also needed to be careful while setting the schema lookup field by choosing Schema -> Opportunity for Add data element)

 

I hope my recommendation was useful for you.

 

Best Regards,

Dan

Denis Bidukha,

Thanks a lot, will try that out :)

Show all comments