Service_Creatio_enterprise_edition

11:30 Jan 24, 2022

Hi Pedro,

If you need to create a filter of the Group lookup on the case page then why do you replace the SysAdminUnitPageV2? And which case and account do you expect to see on the SysAdminUnitPageV2 for some role (for example for "System administrators")? Also I cannot see any filtration logic on the SysAdminUnitPageV2 module code you've shared.

You need to create a filter on the CasePage using an example provided here.

Best regards,

Oscar

Pedro Pinheiro

13:29 Jan 24, 2022

Hi Oscar,

Thank you for the response.

My question consists of two parts:

1) I've created a replacing page of the "SysAdminUnitPageV2", so I could add my custom boolean field "Case" and the pre-built lookup field "Account". Since the "Account" field is not custom, I only added the field on my "SysAdminUnitPageV2" page through the “diff” array (image below). Every time I change and save my "Account" value, it will automatically update the value in the database for my specific record. However, the same does not happen to my custom field "Case".

I’ve created the “Case” field the same way "Account" field was created, but I think I'm missing some page logic that is responsible to store my “Case” values in the database.

2) The lookup filter that I want to add is for the "Group" lookup field inside the "CasePage". This filter should use the "Case" field, previously added to the "SysAdminUnit" object. With the example you provided I was able to complete this second part.

Best Regards,

Pedro Pinheiro

14:07 Jan 24, 2022

Pedro Pinheiro,

In the Fig.4 modify the "bindTo": "Case" to "bindTo": "UsrCase", save the schema and refresh the "role" page after that. Try saving some value and let me know about the result.

Best regards,

Oscar

Pedro Pinheiro

14:19 Jan 24, 2022

Oscar Dylan,

I've made the changes, but my page cannot find the UsrCase column. I think it's because this page does not have the "entitySchemaName" attribute. But even if I try to add the "entitySchemaName" attribute the page will throw an exception.

Error Translation: "It was not possible to find the column through the following configuration."

Best Regards,

Pedro Pinheiro

17:54 Jan 24, 2022

Pedro Pinheiro,

To achieve your first result you need to:

1) Create a replacing object selecting the VwSysAdminUnit object as a parent

2) Create the lookup column with the "UsrCase" code and "Case" title inside the object from step 1.

3) Save and publish the object from step 1.

As a result here you should get this result:

4) Execute the following query in the database (please note that if you already have customizations in the VwSysAdminUnit table (new columns inside it) then the query that should be executed in your case can differ (all the columns of the already existing replacement should be mentioned in the query, study it before running)):

IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[VwSysAdminUnit]'))
DROP VIEW [dbo].[VwSysAdminUnit]
GO
CREATE VIEW [dbo].[VwSysAdminUnit]
AS
SELECT [SysAdminUnit].[Id]
	,[SysAdminUnit].[CreatedOn]
	,[SysAdminUnit].[CreatedById]
	,[SysAdminUnit].[ModifiedOn]
	,[SysAdminUnit].[ModifiedById]
	,[SysAdminUnit].[Name]
	,[SysAdminUnit].[Email]
	,[SysAdminUnit].[Description]
	,[SysAdminUnit].[ParentRoleId]
	,[SysAdminUnit].[ContactId]
	,[SysAdminUnit].[IsDirectoryEntry]
	,[TimeZone].[Id] AS [TimeZoneId]
	,[SysAdminUnit].[UserPassword]
	,[SysAdminUnitType].[Id] AS [SysAdminUnitTypeId]
	,[SysAdminUnit].[AccountId]
	,[SysAdminUnit].[Active]
	,[SysAdminUnit].[LoggedIn]
	,[SysAdminUnit].[SynchronizeWithLDAP]
	,[LDAPElement].[Name] as [LDAPEntry]
	,[LDAPElement].[LDAPEntryId]
	,[LDAPElement].[LDAPEntryDN]
	,[SysAdminUnit].[SysCultureId]
	,[SysAdminUnit].[ProcessListeners]
	,[SysAdminUnit].[PasswordExpireDate]
	,[SysAdminUnit].[HomePageId]
	,[SysAdminUnit].[ConnectionType]
	,[ConnectionType].[Id] AS [UserConnectionTypeId]
	,[SysAdminUnit].[ForceChangePassword]
	,[SysAdminUnit].[LDAPElementId]
	,[SysAdminUnit].[DateTimeFormatId]
	,[SysAdminUnit].[Id] as [SysAdminUnitId]
	,[SysAdminUnit].[SessionTimeout] as [SessionTimeout]
	,[SysAdminUnit].[UsrCaseId] as [UsrCaseId]
FROM [SysAdminUnit]
INNER JOIN [SysAdminUnitType] ON [SysAdminUnitType].[Value] = [SysAdminUnit].[SysAdminUnitTypeValue]
LEFT JOIN [ConnectionType] AS [ConnectionType] ON [ConnectionType].[Value] = [SysAdminUnit].[ConnectionType]
LEFT JOIN [TimeZone] AS [TimeZone] ON [TimeZone].[Code] = [SysAdminUnit].[TimeZoneId]
LEFT JOIN [LDAPElement] ON [LDAPElement].[Id] = [SysAdminUnit].[LDAPElementId]
GO
CREATE TRIGGER [dbo].[ITR_VwSysAdminUnit_I]
ON [dbo].[VwSysAdminUnit]
	INSTEAD OF INSERT
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO [SysAdminUnit](
	[Id]
	,[CreatedOn]
	,[CreatedById]
	,[ModifiedOn]
	,[ModifiedById]
	,[Name]
	,[Email]
	,[Description]
	,[ParentRoleId]
	,[ContactId]
	,[IsDirectoryEntry]
	,[TimeZoneId]
	,[UserPassword]
	,[SysAdminUnitTypeValue]
	,[AccountId]
	,[Active]
	,[LoggedIn]
	,[SynchronizeWithLDAP]
	,[LDAPEntry]
	,[LDAPEntryId]
	,[LDAPEntryDN]
	,[SysCultureId]
	,[ProcessListeners]
	,[PasswordExpireDate]
	,[HomePageId]
	,[ConnectionType]
	,[ForceChangePassword]
	,[LDAPElementId]
	,[DateTimeFormatId]
	,[SessionTimeout]
	,[UsrCaseId])
SELECT [Id]
	,[CreatedOn]
	,[CreatedById]
	,[ModifiedOn]
	,[ModifiedById]
	,[Name]
	,[Email]
	,[Description]
	,[ParentRoleId]
	,[ContactId]
	,[IsDirectoryEntry]
	,(SELECT COALESCE(
		(SELECT [TimeZone].[Code] FROM [TimeZone]
			WHERE [TimeZone].[Id] = [INSERTED].[TimeZoneId]), ''))
	,[UserPassword]
	,ISNULL((SELECT [SysAdminUnitType].[Value] FROM [SysAdminUnitType]
		WHERE [SysAdminUnitType].[Id] = [INSERTED].[SysAdminUnitTypeId]), 4)
	,[AccountId]
	,[Active]
	,ISNULL([LoggedIn], 0)
	,[SynchronizeWithLDAP]
	,(SELECT COALESCE(
		(SELECT [LDAPElement].[Name] FROM [LDAPElement]
			WHERE [LDAPElement].[Id] = [INSERTED].[LDAPElementId]), ''))
	,(SELECT COALESCE(
		(SELECT [LDAPElement].[LDAPEntryId] FROM [LDAPElement]
			WHERE [LDAPElement].[Id] = [INSERTED].[LDAPElementId]), ''))
	,(SELECT COALESCE(
		(SELECT [LDAPElement].[LDAPEntryDN] FROM [LDAPElement]
			WHERE [LDAPElement].[Id] = [INSERTED].[LDAPElementId]), ''))
	,[SysCultureId]
	,[ProcessListeners]
	,[PasswordExpireDate]
	,[HomePageId]
	,COALESCE([INSERTED].[ConnectionType],
		(SELECT [ConnectionType].[Value] FROM [ConnectionType]
		WHERE [ConnectionType].[Id] = [INSERTED].[UserConnectionTypeId]), 0)
	,ISNULL([ForceChangePassword], 0)
	,[LDAPElementId]
	,[DateTimeFormatId]
	,[SessionTimeout]
	,[UsrCaseId]
FROM [INSERTED]
END
GO
CREATE TRIGGER [dbo].[ITR_VwSysAdminUnit_U]
ON [dbo].[VwSysAdminUnit]
	INSTEAD OF UPDATE
AS
BEGIN
SET NOCOUNT ON;
UPDATE [SysAdminUnit]
SET [SysAdminUnit].[CreatedOn] = [INSERTED].[CreatedOn]
	,[SysAdminUnit].[CreatedById] = [INSERTED].[CreatedById]
	,[SysAdminUnit].[ModifiedOn] =[INSERTED].[ModifiedOn]
	,[SysAdminUnit].[ModifiedById] = [INSERTED].[ModifiedById]
	,[SysAdminUnit].[Name] = [INSERTED].[Name]
	,[SysAdminUnit].[Email] = [INSERTED].[Email]
	,[SysAdminUnit].[Description] = [INSERTED].[Description]
	,[SysAdminUnit].[ParentRoleId] = [INSERTED].[ParentRoleId]
	,[SysAdminUnit].[ContactId] = [INSERTED].[ContactId]
	,[SysAdminUnit].[IsDirectoryEntry] = [INSERTED].[IsDirectoryEntry]
	,[SysAdminUnit].[TimeZoneId] =
		(SELECT COALESCE(
			(SELECT [TimeZone].[Code] FROM [TimeZone]
				WHERE [TimeZone].[Id] = [INSERTED].[TimeZoneId]), ''))
	,[SysAdminUnit].[UserPassword] = [INSERTED].[UserPassword]
	,[SysAdminUnit].[SysAdminUnitTypeValue] =
		(SELECT [SysAdminUnitType].[Value] FROM [SysAdminUnitType]
			WHERE [SysAdminUnitType].[Id] = [INSERTED].[SysAdminUnitTypeId])
	,[SysAdminUnit].[AccountId] = [INSERTED].[AccountId]
	,[SysAdminUnit].[Active] = [INSERTED].[Active]
	,[SysAdminUnit].[LoggedIn] = [INSERTED].[LoggedIn]
	,[SysAdminUnit].[SynchronizeWithLDAP] = [INSERTED].[SynchronizeWithLDAP]
	,[SysAdminUnit].[LDAPEntry] =
		CASE
			WHEN (UPDATE(SynchronizeWithLDAP) AND [INSERTED].[SynchronizeWithLDAP] = 1 AND [INSERTED].[LDAPElementId] is not null)
					OR (UPDATE(LDAPElementId) AND [INSERTED].[LDAPElementId] is not null)
				THEN (SELECT [LDAPElement].[Name] FROM [LDAPElement] WHERE [LDAPElement].[Id] = [INSERTED].[LDAPElementId])
			WHEN UPDATE(SynchronizeWithLDAP) AND [INSERTED].[SynchronizeWithLDAP] = 0
				THEN ''
			ELSE [SysAdminUnit].[LDAPEntry]
		END
	,[SysAdminUnit].[LDAPEntryId] = 
		CASE
			WHEN (UPDATE(SynchronizeWithLDAP) AND [INSERTED].[SynchronizeWithLDAP] = 1 AND [INSERTED].[LDAPElementId] is not null)
					OR (UPDATE(LDAPElementId) AND [INSERTED].[LDAPElementId] is not null)
				THEN (SELECT [LDAPElement].[LDAPEntryId] FROM [LDAPElement] WHERE [LDAPElement].[Id] = [INSERTED].[LDAPElementId])
			WHEN UPDATE(SynchronizeWithLDAP) AND [INSERTED].[SynchronizeWithLDAP] = 0
				THEN ''
			ELSE [SysAdminUnit].[LDAPEntryId]
		END
	,[SysAdminUnit].[LDAPEntryDN] = 
		CASE
			WHEN (UPDATE(SynchronizeWithLDAP) AND [INSERTED].[SynchronizeWithLDAP] = 1 AND [INSERTED].[LDAPElementId] is not null)
					OR (UPDATE(LDAPElementId) AND [INSERTED].[LDAPElementId] is not null)
				THEN (SELECT [LDAPElement].[LDAPEntryDN] FROM [LDAPElement] WHERE [LDAPElement].[Id] = [INSERTED].[LDAPElementId])
			WHEN UPDATE(SynchronizeWithLDAP) AND [INSERTED].[SynchronizeWithLDAP] = 0
				THEN ''
			ELSE [SysAdminUnit].[LDAPEntryDN]
		END
	,[SysAdminUnit].[SysCultureId] = [INSERTED].[SysCultureId]
	,[SysAdminUnit].[ProcessListeners] = [INSERTED].[ProcessListeners]
	,[SysAdminUnit].[PasswordExpireDate] = [INSERTED].[PasswordExpireDate]
	,[SysAdminUnit].[HomePageId] = [INSERTED].[HomePageId]
	,[SysAdminUnit].[ConnectionType] = COALESCE([INSERTED].[ConnectionType],
		(SELECT [ConnectionType].[Value] FROM [ConnectionType]
		WHERE [ConnectionType].[Id] = [INSERTED].[UserConnectionTypeId]), 0)
	,[SysAdminUnit].[ForceChangePassword] = [INSERTED].[ForceChangePassword]
	,[SysAdminUnit].[LDAPElementId] = [INSERTED].[LDAPElementId]
	,[SysAdminUnit].[DateTimeFormatId] = [INSERTED].[DateTimeFormatId]
	,[SysAdminUnit].[SessionTimeout] = [INSERTED].[SessionTimeout]
	,[SysAdminUnit].[UsrCaseId] = [INSERTED].[UsrCaseId]
FROM [SysAdminUnit]
INNER JOIN [INSERTED] ON [SysAdminUnit].[Id] = [INSERTED].[Id]
END
GO
CREATE TRIGGER [dbo].[ITR_VwSysAdminUnit_D]
ON [dbo].[VwSysAdminUnit]
	INSTEAD OF DELETE
AS
BEGIN
SET NOCOUNT ON;
DELETE FROM [SysAdminUnit]
WHERE EXISTS(SELECT * FROM [DELETED] WHERE [SysAdminUnit].[Id] = [DELETED].[Id])
END
GO

This query is for MS SQL, if your application is hosted using the PostgreSQL database then your query should be written using PostgreSQL syntax (you can copy the OOB VwSysAdminUnitPostgreSql SQL-script from the LDAP package, add your custom columns inside the ready script and execute it after that).

5) In the replaced SysAdminUnitPageV2 module add the following code to the diff array of the module:

{
					"operation": "insert",
					"parentName": "Header",
					"propertyName": "items",
					"name": "UsrCase",
					"values": {
						"bindTo": "UsrCase",
						"dataValueType": this.Terrasoft.DataValueType.LOOKUP,
						"layout": {
							"column": 0,
							"row": 1,
							"colSpan": 24
						}
					},
				}

6) Add the entitySchemaName: "VwSysAdminUnit", part to the replaced SysAdminUnitPageV2 module (below you can find an example of the correctly replaced module):

define("SysAdminUnitPageV2", [],
	function() {
		return {
			entitySchemaName: "VwSysAdminUnit",
			details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
			diff: /**SCHEMA_DIFF*/[
				{
					"operation": "insert",
					"parentName": "Header",
					"propertyName": "items",
					"name": "UsrCase",
					"values": {
						"bindTo": "UsrCase",
						"dataValueType": this.Terrasoft.DataValueType.LOOKUP,
						"layout": {
							"column": 0,
							"row": 1,
							"colSpan": 24
						}
					},
				}
			]/**SCHEMA_DIFF*/,
			attributes: {},
			methods: {}
		};
});

7) Save the module and refresh the page

As a result you will get a working lookup that references the "Case" object:

and

PS: also please share code itself, but not its screenshots, sometimes copying some ready code can save the time:)

Best regards,

Oscar

Show all comments

feedback

Service_Creatio

#cases

Change the page appearing after Customer enters feedback through email in case management

Shinoli Perera

13:25 Jan 05, 2022

Case Management platform has being configured and distributed to one of our clients. They had a request to change the page that appear after the customer provides a feedback through email. Image of the page provided below.

The Logo and text in the page need to be changed.

Can someone please provide me a method configure this?

Thank you!

4 comments

Bogdan

16:10 Jan 05, 2022

Hello Shinoli,

The only way to customize this page using out-of-the-box tools is the system setting called "Logo - Thank you for your feedback" that is described in the Academy article here.

The only way to completely change this page is to apply changes to "CaseRatingFeedbackPage" schema (using additional development). Bogdan is already CC'd to this email so I hope he will be able to find a developer who can adjust this page base on your needs in terms of advisory hours.

At the same time we have two problems registered to our R&D team so to make the possibility to change this page more user-friendly (using standard tools such as section wizard), but unfortunately there is no ETA on this task. Once it is done - we will update all our clients and partners about it in our official release notes.

Best regards,

Bogdan

Shinoli Perera

06:55 Jan 06, 2022

Thank you for the information.

luis.goncalves@imdigital.pt

21:29 Jun 08, 2022

Important to update this page design without code!

Damien Collot

10:04 Oct 26, 2022

I agree with all of the above, this is a major reason why one of our clients does not use this functionality.

Show all comments

Self service portal

Hide Complain Button and Leave a Message for the Support Team box

21:53 Dec 27, 2021

Hello,

We are repurposing the Case section in the Self Service Portal to create an Opportunity via a business process. As such, we do not need the Complain button nor the ability to Publish a message to the support team box. Is there a method to remove these two items from the Self Service Portal Case Page?

Thanks,

-Scotty Chapman

Blytheco

4 comments

Best reply

15:25 Dec 28, 2021

Hello Scotty,

Please create a replacing view model and select PortalMessagePublisherPage module as a parent and specify the following code in the created schema:

define("PortalMessagePublisherPage", [],
	   function() {
	return {
		entitySchemaName: "PortalMessage",
		mixins: {},
		attributes: {
 
			/**
				 * Publish message enabled flag.
				 */
				"IsPublishButtonEnabled": {
					dataValueType: this.Terrasoft.DataValueType.BOOLEAN
				},
		},
		methods: {
			setPublishButtonProperties: function(publishMessageInfo) {
				this.callParent(arguments);
				this.set("IsPublishButtonEnabled", false);
			},
		},
		diff: /**SCHEMA_DIFF*/[]/**SCHEMA_DIFF*/
	};
});

As a result once the schema is saved and the page is refreshed you will see that the button is always disabled:

Best regards,

Oscar

23:49 Dec 27, 2021

Update - I did find the System Setting for Enable Complain Function and am able to disable and hide the button that way. Still wondering if there's a way to disable the Publish Message box though. Thanks!

15:25 Dec 28, 2021

Hello Scotty,

Please create a replacing view model and select PortalMessagePublisherPage module as a parent and specify the following code in the created schema:

define("PortalMessagePublisherPage", [],
	   function() {
	return {
		entitySchemaName: "PortalMessage",
		mixins: {},
		attributes: {
 
			/**
				 * Publish message enabled flag.
				 */
				"IsPublishButtonEnabled": {
					dataValueType: this.Terrasoft.DataValueType.BOOLEAN
				},
		},
		methods: {
			setPublishButtonProperties: function(publishMessageInfo) {
				this.callParent(arguments);
				this.set("IsPublishButtonEnabled", false);
			},
		},
		diff: /**SCHEMA_DIFF*/[]/**SCHEMA_DIFF*/
	};
});

As a result once the schema is saved and the page is refreshed you will see that the button is always disabled:

Best regards,

Oscar

18:04 Dec 28, 2021

Oscar Dylan,

Hi Oscar,

I will give this a try. Thanks so much!

-Scotty Chapman

00:35 Dec 29, 2021

Oscar - that worked like a charm. Many Thanks!

-Scotty Chapman

Show all comments

Custom Detail Section in Portal Case Page - how to get to detail setup for page?

20:39 Dec 15, 2021

Hello,

I have used the Portal Case Section Wizard to successfully create new tabs and custom fields in the Case Entity for Portal Users. I have also created a new custom detail based on creating a new object on one of these tabs. What I am not clear on is how can I now get to the Detail Setup for this new custom detail? Normally of course we get there by going to an existing record and entering detail setup there, but this is not possible for a Portal User to do. I looked in the Advanced Settings (DEV) page but the objects created don't seem to get me to the detail setup. I also am curious how one then can setup the columns setup for all portal users for this detail one the page is created. Any help would be most appreciated :)

Cheers,

-Scotty Chapman

2 comments

Bogdan

17:34 Dec 16, 2021

Hello Scotty,

To modify the fields in the detail. Please follow the nest steps:

1. Open the page in the section wizard and click on the edit icon:

2. Click on the edit icon to open the detail wizard:

3. Chose the "page" tab to edit the field:

As for your second question, unfortunately, there is no such functionality in our system that allows saving column setup for all users.

Best regards,

Bogdan

19:27 Dec 16, 2021

Bogdan,

Hi - thanks so much, that did the trick. Appreciated!

-Scotty Chapman

Show all comments

Updating a column value via OData return error (500)

oData

Error(500)

Antoine Gilliéron

15:40 Nov 04, 2021

Hello

I am updating the unsubscribe column data on Contact records with a php script.

Since a few days i get an error 500 when updating value in Contact: {"DoNotUseEmail":"true"}

When trying the request in postman, I get error 500 the first time, if I immediatly trying a second time it just works.

Using the same php script on a test environment doesnt give me this error.

2 comments

16:25 Nov 04, 2021

Hello Antoine,

Is the application hosted in the cloud or locally?

Best regards,

Oscar

Antoine Gilliéron

17:20 Nov 04, 2021

Hello Oscar the application is hosted locally (On premise). Also updating other detail column in the same script is working fine. I suspect a database error and plan to do a Generate all-compile all-webApp restart tonight.

Show all comments

How to remove a button for recently viewed records from Portal

Anna Stolichnova

12:53 Sep 16, 2021

Hi Community,

We use an add-on https://marketplace.creatio.com/app/recently-viewed-records-creatio

It adds a button to the notification panel:

Could you please advise on how not to display this button on Portal?

Thank you in advance,

Best regards,

Anna

3 comments

Best reply

17:09 Sep 16, 2021

Hello Anna,

I am the developer of this add-on. This has already been fixed in current version of the add-on, please update to the newest version in the marketplace and it should resolve the issue. If it does not, let me know.

Thanks,

Ryan

Bogdan

15:46 Sep 16, 2021

Hi Anna,

Please contact the developer of this add-in: customerfx.com who will assist you on this matter.

Best regards,

Bogdan

17:09 Sep 16, 2021

Hello Anna,

Thanks,

Ryan

Anna Stolichnova

17:51 Sep 16, 2021

Thank you, Ryan!

It works fine after upgrade to the newest version of the add-on.

Best regards,

Anna

Show all comments

case

Where do I change the structure of the subject line for emails sent from a case

Rick Emery

23:42 Jul 08, 2021

Need to change the subject lines for emails sent from a Case. Either:

- allow the agent to enter their own subject or

- allow us to restructure the elements of the subject line

3 comments

Tetiana Bakai

14:38 Jul 12, 2021

Hello Rick!

In order to change the subject lines for emails sent from a Case it is necessary to replace EmailMessagePublisherPage model in Configuration and in setListenerEmailData method to set the value of "IsTitleEnabled" to true. Please check the attached image with the solution to this problem.

Best Regards,

Tetiana Bakai

Rick Emery

15:52 Jul 12, 2021

Thank you

Chris Isbell

16:17 Jul 22, 2021

Tetiana Bakai,

That worked for being able to actually edit the subject line, but when the email gets sent, any changes made to the subject line are discarded and the default subject line is used regardless. Do you know how to change that?

Thanks!

Chris

Show all comments

getAddRecordButtonVisible

activitydetail

getAddRecordButtonVisible doesn't works on a detail with Activities object

7.17

Julio.Falcon_Nodos

02:03 Jun 01, 2021

Dear colleagues,

I have a detail using activities (activities of a custom type). Those activities are created just by a DCM and I don't want users add/delete or copy new ones manually. So in the detail schema I have this code in methods section:

// Disable add button
getAddRecordButtonVisible: function() {
	return false;
},
 
// Deshabilita operaciones nuevo registro
addRecordOperationsMenuItems: function() {
	return false;
},

This works to other details, but to this detail having ACTIVITIES doesn't work, why?

Some ideas how to solve this?

Thanks in advance

Regards

1 comments

13:32 Jun 01, 2021

Hello Julio,

Please specify how was this detail created, which schemas were specified as a parent schema for the detail edit page and the detail schema itself. Also where is this detail located and which buttons do you want to hide.

Thank you!

Best regards,

Oscar

Show all comments

Compile after Installing package

7.12

ayman

11:50 May 28, 2021

Hello,

we are not able to compile the application after installing our package to a new dev environment, however it is working well on other dev environments.

knowing that, we tried to generate all items and got hte following error :Error

Unable to generate source codes for the following schemas:

then compile all items and got the following error : Error

Dependency 'StProcess3ST_Package4' of package 'ST_Package' was not found. Search path: C:\CRM\Dev\Terrasoft.WebApp\Terrasoft.Configuration\Autogenerated\Src\StProcess3ST_Package4.ST_Package_Entity.cs

1 comments

Olga Avis

18:14 May 28, 2021

Hello!

Please, execute the UpdateWorkspaceSolution operation and try to perform the compilation once again.

More detailed information about the parameters of the WorkspaceConsole utility can be found in the Deployment - WorkspaceConsole parameters Academy article.

Best regards,

Olga.

Show all comments

ExcelReportBuilder

Custom Report download contains which date format?

7.17

Charles Cushing

20:00 May 06, 2021

Hi all. I have created some custom reports and exported them as xlxs. I am looking at the DATE data from Creatio objects that appear in the xlxs files.

What is the format used in the Date fields ?
What MS Excel function will display this data in a human readable format?

2 comments

Best reply

01:56 May 07, 2021

Hello Charles,

What you need to do is create a template for the Excel report. In the date columns, you can add cell formatting in any date format you'd like. Then upload the template for the Excel report and from then on the report will use the date format you specified in the template. I have a video tutorial of how to do this here: https://customerfx.com/video/using-templates-for-excel-reports-in-creat…

Ryan