Service_Creatio | Community Creatio

Question

19:44 Jul 02, 2020

Formerly, a detail was added to our Case section using the main Change object instead of a new custom object specifically designed to be a detail that shows the connection between a Case record and Change record. This legacy Change detail has been used a lot over the past few years to create new Change records, so you can see which Change record was created by the detail if you look at the individual Case record where the Change detail was used. The problem is I don't know if I can export all the Change records and be able to see which Case they are associated with. I want to set up a proper detail after I create a new custom "Change in Case" object that has lookup columns for each object. I would like to be able to import data to this new object from the old detail. Does anyone know how I can export data to show which changes were created from which cases? (I can't simply create a lookup for the detail's object, because again, the detail uses the main Change object....)

typo....*legacy*

4 comments

Dean Parrett

14:51 Jul 03, 2020

Hello,

The Detail column in the settings is set to Id that may not be correct in your case.

Try to change the Detail column value from "Id" to "CaseId" . That should help.

Let me know the resuts.

Regards,

Dean

Mitch Kaschub

20:39 Jul 07, 2020

Dean Parrett,

It does not look like that will work. CaseId is not a column on the Changes object.

I recognize this detail was set up wrong, I am not looking to fix it, I just want to know with the existing settings, is it possible to know which Change records were added on which Case record page?

Dean Parrett

13:30 Jul 08, 2020

Dear Mitch,

It seems like Changes object is not connected to the Case object. The Detail column field doesn't have Case in the drop down list since the Changes object doesn't have the column based on Case object. Most likely the same happens to Case object, it doesn't have any lookup field based Changes object. I might be wrong if the fields just have different titles. Try to look through the lookup field of both objects and see if there are any lookups based on Cases and Changes objects. If they do exist, you can try to build filter in the section to see if the case records that have some existing records in Changes.

Regards,

Dean

Mitch Kaschub

20:12 Jul 08, 2020

Dean Parrett,

Thanks Dean. I did find that there is a lookup column for Cases on the Changes object, however the column is blank for all records because the objects are not connected. I think I'm out of luck.

Show all comments

Question

7.15

Service_Creatio

Updating one column from another column for each selected record

Akshit

11:51 Jun 30, 2020

Hi,

From each selected record I have to update the "UsrAmountForTheMonth" column from "UsrDueAmount" using script task element.

var select = new Select(UserConnection)

               .Column("Id")

               .From("UsrBeta")

               .Where("UsrConfirmationId").IsNotEqual(new Select(UserConnection)

.Column("Id")

.From("UsrCorrect")

.Where("Name").IsEqual(Column.Parameter("Yes"))) as Select;

var up = (Update) new Update(UserConnection,"UsrBeta").Set("UsrAmountForTheMonth",new Select(UserConnection)

.Column("UsrDueAmount")

.From("UsrBeta")

.Where("Id").IsEqual(select))

.Where("Id").In(select);

But this way I got the error: Subquery returned more than 1 value

Please help !

Many thanks.

5 comments

Grigoriy

13:07 Jun 30, 2020

Try change .IsEqual() on .in(select)

and change .IsNotEqual( on ..Not().in(select)

Or use CustomQuery for use sql code with creatio

Grigoriy

13:10 Jun 30, 2020

Smile samples

			var delete = new Delete(UserConnection)
				.From("PersonalAccountRegistration")
				.Where("Id").In(new Select(UserConnection)
					.Column("par","Id")
					.From("PersonalAccountRegistration").As("par")
					.LeftOuterJoin("VerificationCode").As("hvc")
					.On("hvc", "Id").IsEqual("par", "HashId")
					.LeftOuterJoin("VerificationCode").As("svc")
					.On("svc", "Id").IsEqual("par", "VerificationCodeId")
					.Where("hvc", "ExpiresOn").IsLess(Column.Const(nowDate))
					.Or("svc", "ExpiresOn").IsLess(Column.Const(nowDate))
				);
			delete.Execute();

Akshit

14:19 Jun 30, 2020

Hi Grigoriy,

I make the changes as per your suggestion but still It shows the same error.

I think the problem is with this bolded select query inside Set method :

var up = (Update) new Update(UserConnection,"UsrBeta").Set("UsrAmountForTheMonth", new Select(UserConnection)

.Column("UsrDueAmount")

.From("UsrBeta")

.Where("Id").In(select) )

.Where("Id").In(select);

Beacause I have to update the value of "UsrAmountForTheMonth" column with the value of "UsrDueAmount" column for each selected record in the select query.

But the bolded subquery inside Set method returns the collection of "UsrDueAmount" values.

This is how my section looks like!

Please suggest any solution to the same.

Thanks.

Grigoriy

22:16 Jun 30, 2020

Akshit,

As I wrote above, for complex cases, try writing and debugging a sql query and calling it as in the example below

var sqlText=@"update ....";

var customQuery = new CustomQuery(UserConnection, sqlText);

var rowCount = customQuery.ExecuteScalar<int>();

                var selectQueryString =
                    @"update ""Lead"" set ""ScpTimer"" = QS.""ScpLifetimeDays"" - (CAST(NOW() AT TIME ZONE 'UTC' AS date) - CAST(LD.""ScpDateTransitionNewStatus"" AS date))
                    from ""Lead"" as LD
                    inner join ""QualifyStatus"" as QS on QS.""Id"" = LD.""QualifyStatusId""
                    where LD.""Id"" = ""Lead"".""Id"" and ""Lead"".""QualifyStatusId"" in  (
                    'd790a45d-03ff-4ddb-9dea-8087722c582c',
                    'ceb70b3c-985f-4867-ae7c-88f9dd710688',
                    '128c3718-771a-4d1e-9035-6fa135ca5f70',
                    '7a90900b-53b5-4598-92b3-0aee90626c56')";
                var selectQuery = new CustomQuery(userConnection, selectQueryString);
                selectQuery.Execute();

Akshit

07:33 Jul 01, 2020

Hi Grigoriy,

This time it works Thank you very much for your constant support!

Best Regards.

Show all comments

Question

7.15

Service_Creatio

How to compare date column with current month

Akshit

13:33 Jun 29, 2020

Hi,

I am using a select class to build a query where I have to compare date column "Net due date" with the current month.

var currentMonth = DateTime.Now.Month;

var select = new Select(UserConnection)

.Column("Id")

.From("UsrBeta")

.Where("UsrDate").IsEqual(Column.Parameter(currentMonth)) as Select;

But I am getting this error : Operand type clash: date is incompatible with int

3 comments

Grigoriy

16:14 Jun 29, 2020

Try this

.....

.Where(Func.Month("UsrDate")) .IsEqual(Column.Parameter(currentMonth));

Akshit

17:15 Jun 29, 2020

Hi Grigoriy,

Thank you very much! It works

Akshit

13:34 Jul 06, 2020

Hi Grigoriy,

I have to sum up the values of Column("Score") of several records so for this what should I use in place of Func.Month() .

Can you provide the reference for This Func method?

Many Thanks.

Show all comments

Question

7.16

Service_Creatio

Postgresql Error

Akshit

15:27 Jun 25, 2020

Hi,

I have construct this select query in script task and got the attached error !

var UserConnection = Get("UserConnection");

var mangager = (DataValueTypeManager)UserConnection.AppManagerProvider.GetManager("DataValueTypeManager");

var currentDate = DateTime.Now;

var select = new Select(UserConnection)

               .Column("Id")

               .From("UsrAlpha")

               .Where("UsrStatusId").IsEqual(Column.Parameter("82f4864d-3c3b-46a7-93dc-318695dc90ec")) as Select;



var up = (Update) new Update(UserConnection,"UsrAlpha").Set("UsrCurrentDate",Column.Parameter(currentDate)).Where("Id").In(select);



up.Execute();

return true;

Please help !

Many thanks.

1 comments

Grigoriy

22:44 Jun 25, 2020

In 7.15 with PostgeSql this code work

Guid contactId = ......
Select select = new Select(UserConnection)
				.Column("ScpSNILS")
				.Column("INN")
				.From("Contact").WithHints(new NoLockHint())
				.Where("Id")
				.IsEqual(new QueryParameter(contactId)) as Select;

Change Column.Parameter to QueryParameter

Show all comments

Question

CommunicationPanel

7.15

Service_Creatio

How can I move the position of the alert icon (centerNotification)

Grigoriy

11:11 Jun 25, 2020

I try to override in CommunicationPanel the index property but it doesn’t work :

define("CommunicationPanel", ["terrasoft", "CommunicationPanelHelper"],
	function(Terrasoft, CommunicationPanelHelper) {
		return {
			messages: {},
			attributes: {},
			methods: {	},
			diff: [
				{
					"operation": "merge",
					"name": "centerNotification",
					"index":  1,				
				}

How can I change the position of the icon?

1 comments

Olga Avis

15:49 Jun 25, 2020

Hello Grigoriy,

You can only move elements defined in the "diff" of the CommunicationPanel schema, for instance to move esnFeed use:

{

"operation": "move",

  "parentName": "communicationPanelContent",

  "propertyName": "items",

  "name": "esnFeed",

  "index": 6

}

Best regards,

Olga.

Show all comments

Question

7.16

Service_Creatio

Multi-select record update using a custom button in creatio mobile app

Akshit

16:06 Jun 19, 2020

Hi,

How to develop the functionality of updating multiple selected records using custom button or section action on creatio mobile application side?

I have developed the above functionality in the main application (creatio server) side.

Please respond to this.

Many thanks.

5 comments

Dennis Hudson

17:43 Jun 25, 2020

Dear Akshit,

You can implement this by creating an action that will display a lookup with multi-select choice, similarly to how it is implemented in the section filters. After that, you would be able to perform some action on chosen records. You can look into how filters in a section are implemented and implement similar functionality.

Also, you can create an action that will take the filters in the section, send a request to db with those filters, and perform some action with the received records. You can get the section filter in getFilterPanel method that you can find in the view that you can get from current page controller.

Best regards,

Dennis

Akshit

17:55 Jun 25, 2020

Hi Dennis Hudson,

Is there any documentation or way to implement custom action on creatio mobile application.

I have already gone through this https://academy.creatio.com/documents/technic-sdkmob/7-16/creatio-development-guide but creating a custom action (creatio mobile application) is not a development case here.

Thanks.

Dennis Hudson

18:22 Jun 25, 2020

Dear Akshit,

Here is a community article on creating custom actions:

https://community.creatio.com/articles/adding-custom-user-action-mobile-application

Best regards,

Dennis

Akshit

06:08 Jun 26, 2020

Hi Dennis Hudson,

I am not able to open this page It says that I am not authorized. Did you know why?

Any other option?

Thanks.

Dennis Hudson

11:45 Jun 26, 2020

Dear Akshit,

Unfortunately, I am not aware of any other article on creating custom actions. I've checked this one and it seems to open without an issue. Please try clearing the cache and logging in once again.

Best regards,

Dennis

Show all comments

Question

URL not updating when drilling into detail records

Harvey Adcock

18:13 Jun 05, 2020

When drilling into a detail record from an edit page, the URL shown for the page in the address bar does not update to match the record shown by default. Is there any way to make this happen in client-side code? Or perhaps a setting which can be enabled? An important part of the application I'm currently working on is the ability for users to share the links to pages externally, and being able to do so by copying the URL sometimes (e.g. when drilling into a Section record to get to the edit page) but not other times isn't good UX for the client.

We know we can add an action bar button to copy the link, but this also isn't what he client would like if avoidable, for the above reason (consistency).

1 comments

Oleg Drobina

12:12 Jun 06, 2020

Hello Harvey,

Unfortunately, there is no way to retrieve a direct URL when opening a record from the detail since Creatio is a single-page application, the navigation is stored in operative memory and could not be obtained. This is done to enhance system speed.

We do have a problem registered for our R&D team in the "Accepted" status regarding the possibility to dynamically change the link once the record from the detail is opened and it is planned to modify the current logic in one of the future releases. As for now the only way to retrieve the direct link is to open the detail record in another tab by right-clicking on it and selecting the "Open in another tab" option.

Best regards,

Oscar

Show all comments

Question

Service_Creatio

Adding Rich Text

Michael Dorfman

22:33 Jun 03, 2020

Hello,

Is there a way to make the feed post text box a rich textbox like the image i have attached?

3 comments

Best reply

Bohdan Zdor

20:01 Jun 05, 2020

Hi Michael,

Yes, it can be implemented via additional development.

You can create a module (e.g. GlbExtendedHtmlEditModule) extending ESNHtmlEditModule with the template (tpl) from ExtendedHtmlEditModule:

define("GlbExtendedHtmlEditModule", ["ESNHtmlEditModule"], function() {
 Ext.define("Terrasoft.controls.GlbExtendedHtmlEditModule", {
 extend: "Terrasoft.ESNHtmlEdit",
 alternateClassName: "Terrasoft.GlbExtendedHtmlEdit",
 tpl: [
 //jscs:disable
 /*jshint quotmark: false */
 "<div id=\"{id}-html-edit\" class=\"{htmlEditClass}\" style=\"{htmlEditStyle}\">",
 "<div style=\"display: table-row;\">",
 "<div id=\"{id}-html-edit-toolbar\" class=\"{htmlEditToolbarClass}\">",
 "<div id=\"html-edit-toolbar-undo\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'undo' || tag == 'redo'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-font-family\" class=\"{htmlEditToolbarButtonGroupClass}\" style=\"{htmlEditFo" +
 "ntFamilyStyle}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'fontFamily'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-font-size\" class=\"{htmlEditToolbarButtonGroupClass}\" style=\"{htmlEditFont" +
 "SizeStyle}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'fontSize'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-font-style\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'fontStyleBold' || tag == 'fontStyleItalic' || tag == 'fontStyleUnderline'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-font-color\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'fontColor'\">",
 " <@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-highlight\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'hightlightColor'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-list\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'numberedList' || tag == 'bulletedList'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-justify\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'justifyLeft' || tag == 'justifyCenter' || tag == 'justifyRight'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-indent\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'outdentList' || tag == 'indentList'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-image\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'image'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-link\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'link'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-justify\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'htmlMode' || tag == 'plainMode'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-tools\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'maximized'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"{id}-html-edit-toolbar-table\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'table'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-addTemplate\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'addTemplate'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-addMacros\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'addMacros'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "</div>",
 "</div>",
 "<div style=\"display: table-row;\">",
 "<div id=\"{id}-html-edit-htmltext\" class=\"{htmlEditTextareaClass}\">",
 "<textarea id=\"{id}-html-edit-textarea\" style=\"border: none\"></textarea>",
 "</div>",
 "<div id=\"{id}-html-edit-plaintext\" class=\"{htmlEditTextareaClass}\" style=\"margin-bottom: 24px;\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'plainText'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "</div>",
 "<span id=\"{id}-validation\" class=\"{validationClass}\" style=\"{validationStyle}\">" +
 "{validationText}</span>",
 "</div>"
 /*jshint quotmark: true */
 //jscs:enable
 ]
 });
});

And replace SocialFeed (ESN):

define("SocialFeed", ["GlbExtendedHtmlEditModule"], function() {
 return {
 diff: /**SCHEMA_DIFF*/[
 {
 "operation": "merge",
 "name": "SocialMessageEdit",
 "values": {
 "className": "Terrasoft.GlbExtendedHtmlEdit",
 }
 }
 ]/**SCHEMA_DIFF*/
 };
});

Please find the result example attached.

Thank you for choosing Creatio!

Bohdan Zdor

20:01 Jun 05, 2020

Hi Michael,

Yes, it can be implemented via additional development.

You can create a module (e.g. GlbExtendedHtmlEditModule) extending ESNHtmlEditModule with the template (tpl) from ExtendedHtmlEditModule:

define("GlbExtendedHtmlEditModule", ["ESNHtmlEditModule"], function() {
 Ext.define("Terrasoft.controls.GlbExtendedHtmlEditModule", {
 extend: "Terrasoft.ESNHtmlEdit",
 alternateClassName: "Terrasoft.GlbExtendedHtmlEdit",
 tpl: [
 //jscs:disable
 /*jshint quotmark: false */
 "<div id=\"{id}-html-edit\" class=\"{htmlEditClass}\" style=\"{htmlEditStyle}\">",
 "<div style=\"display: table-row;\">",
 "<div id=\"{id}-html-edit-toolbar\" class=\"{htmlEditToolbarClass}\">",
 "<div id=\"html-edit-toolbar-undo\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'undo' || tag == 'redo'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-font-family\" class=\"{htmlEditToolbarButtonGroupClass}\" style=\"{htmlEditFo" +
 "ntFamilyStyle}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'fontFamily'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-font-size\" class=\"{htmlEditToolbarButtonGroupClass}\" style=\"{htmlEditFont" +
 "SizeStyle}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'fontSize'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-font-style\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'fontStyleBold' || tag == 'fontStyleItalic' || tag == 'fontStyleUnderline'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-font-color\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'fontColor'\">",
 " <@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-highlight\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'hightlightColor'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-list\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'numberedList' || tag == 'bulletedList'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-justify\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'justifyLeft' || tag == 'justifyCenter' || tag == 'justifyRight'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-indent\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'outdentList' || tag == 'indentList'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-image\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'image'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-link\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'link'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-justify\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'htmlMode' || tag == 'plainMode'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-tools\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'maximized'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"{id}-html-edit-toolbar-table\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'table'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-addTemplate\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'addTemplate'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "<div id=\"html-edit-toolbar-addMacros\" class=\"{htmlEditToolbarButtonGroupClass}\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'addMacros'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "</div>",
 "</div>",
 "<div style=\"display: table-row;\">",
 "<div id=\"{id}-html-edit-htmltext\" class=\"{htmlEditTextareaClass}\">",
 "<textarea id=\"{id}-html-edit-textarea\" style=\"border: none\"></textarea>",
 "</div>",
 "<div id=\"{id}-html-edit-plaintext\" class=\"{htmlEditTextareaClass}\" style=\"margin-bottom: 24px;\">",
 "<tpl for=\"items\">",
 "<tpl if=\"tag == 'plainText'\">",
 "<@item>",
 "</tpl>",
 "</tpl>",
 "</div>",
 "</div>",
 "<span id=\"{id}-validation\" class=\"{validationClass}\" style=\"{validationStyle}\">" +
 "{validationText}</span>",
 "</div>"
 /*jshint quotmark: true */
 //jscs:enable
 ]
 });
});

And replace SocialFeed (ESN):

define("SocialFeed", ["GlbExtendedHtmlEditModule"], function() {
 return {
 diff: /**SCHEMA_DIFF*/[
 {
 "operation": "merge",
 "name": "SocialMessageEdit",
 "values": {
 "className": "Terrasoft.GlbExtendedHtmlEdit",
 }
 }
 ]/**SCHEMA_DIFF*/
 };
});

Please find the result example attached.

Thank you for choosing Creatio!

Michael Dorfman

20:43 Jun 05, 2020

Bohdan Zdor,

Does this wok on Creatio hosted environments?

Bohdan Zdor

20:50 Jun 05, 2020

Michael Dorfman,

Unfortunately, we do not have an experience of such functionality implementation.

Though, it should work on Creatio hosted environments.

Thank you.

Show all comments

Question

configuration

7.15

Service_Creatio

Deleting replacing schemas which have schemas inheriting from them

Harvey Adcock

12:40 May 21, 2020

Is it possible to delete a replacing schema when you have also created inheriting schemas based on that schema? I've tried this, and it seems to turn the inheriting schemas into being read-only, showing the following message when trying to edit them:

Here is an example set up for this issue:

Create a replacing schema of FileDetailV2 (called FileDetailV2, as it as to be)
Create a schema inheriting from FileDetailV2 (any name)
Delete the replacing schema created in step 1

Once these steps have been performed, it appears the inheriting schema created in step 2 is now read-only for some reason. My expectation would be that, because the OOTB FileDetailV2 still exists, there should be no issue. Does anyone know how to resolve this?

Thanks,

Harvey

3 comments

Olga Avis

19:03 May 21, 2020

Hello Harvey,

We do not recommend to delete schemas that are set as [Parent object] for some other schemas. It could lead to unexpected system behavior and further errors.

Furthermore, we suggest performing [Compile all items] and [Compile modified items] actions when deleting schemas and packages from the [Configuration] section.

Best regards,

Olga.

Harvey Adcock

20:23 May 21, 2020

Olga Avis,

Thanks for your reply. I think the same issue could be reached by doing step 2 first, and then creating a replacing schema of the schema that inherits from, and then realising this wasn't what you wanted so you delete the replacing schema. In this case, you could break things without knowing, since on a larger project you may not be aware of every schema which inherits from another schema.

Is there any way to bypass this warning message, since it doesn't describe the situation (the schema isn't 3rd party and wasn't installed from a file archive)?

Thanks,

Harvey

Oleg Drobina

20:32 May 21, 2020

Harvey Adcock,

It seems that your schema and the package of this schema is locked and as a result you are not able to modify it. We cannot provide you with the script that unlocks the package and the schema, but you can email us at support@creatio.com and provide us with the link to the app, the name of the package and schema and we will unlock it for you.

Best regards,

Oscar

Show all comments

Question

excel

report

reportservice

Issue_in_Excel_reports_Setup

7.11

Service_Creatio

Excel report error

Gokul Krishnan

02:43 May 20, 2020

Hi Team,

We were trying to generate a report based on the service section. We created an Excel report to generate the number of cases created for last year along with some other filters. However, when we try to generate the report we are getting the below error. This error pops up only for certain filters and for some filters the report seems to be working. Like if we get the report for month it works while if we try for last one year it pops with an error.

2 comments

Irina Lazorenko

12:13 May 26, 2020

Hi Gokul Krishan,

this error relates to configuration or data. Set up all columns from the report in the 'Cases' section, use similar section filters, and try to export data using a basic functionality 'Export to Excel'. Come back with results.