Dashboard_widget
Studio_Creatio
7.18

Hello Community,

 

I want to add an static page showing a custom message or an image on the section dashboard using Dashboard widget. Is this task achievable? For image, I do not want to use the web page element.

 

Thanks,

Sourav

Like 0

Like

1 comments
Studio_Creatio
c#
server_side_esq
ESQ
7.18

Hi everyone,

how to use filter month and year Esq Server (EntitySchemaQuery)?

SELECT 
* 
FROM UsrTable 
WHERE 
MONTH(CreatedOn) = 1 AND YEAR(CreatedOn) = 2022

I found there is a function at https://academy.creatio.com/api/netcoreapi/7.17.0/#Terrasoft.Core~Terrasoft.Core.Entities.EntitySchemaQuery~CreateMonthFunction.html for get month and year.

https://prnt.sc/8brMGtYq3qhP

But how to use in filter?

esq.Filters.Add(esq.CreateFilterWithParameters(FilterComparisonType.Equal, "CreatedOn", Month));
esq.Filters.Add(esq.CreateFilterWithParameters(FilterComparisonType.Equal, "CreatedOn", Year));

Thank you.

Like 1

Like

1 comments
Best reply

Hello Romadan,

You can do filters like this using macros: 

// CreatedOn is the 1st month (January)
esq.Filters.Add(esq.CreateFilter(FilterComparisonType.Equal, "CreatedOn", EntitySchemaQueryMacrosType.Month, 1));
 
// CreatedOn is the first day of the month
esq.Filters.Add(esq.CreateFilter(FilterComparisonType.Equal, "CreatedOn", EntitySchemaQueryMacrosType.DayOfMonth, 1));
 
// CreatedOn is in the year 2022
esq.Filters.Add(esq.CreateFilter(FilterComparisonType.Equal, "CreatedOn", EntitySchemaQueryMacrosType.Year, 2022));

Ryan

Hello Romadan,

You can do filters like this using macros: 

// CreatedOn is the 1st month (January)
esq.Filters.Add(esq.CreateFilter(FilterComparisonType.Equal, "CreatedOn", EntitySchemaQueryMacrosType.Month, 1));
 
// CreatedOn is the first day of the month
esq.Filters.Add(esq.CreateFilter(FilterComparisonType.Equal, "CreatedOn", EntitySchemaQueryMacrosType.DayOfMonth, 1));
 
// CreatedOn is in the year 2022
esq.Filters.Add(esq.CreateFilter(FilterComparisonType.Equal, "CreatedOn", EntitySchemaQueryMacrosType.Year, 2022));

Ryan

Show all comments
Javascript
Field validation
Studio_Creatio
7.18

We are looking for a for a way to impose a character limitation on a string value that is different than the standard settings. 

 

For example, the user enters a job number as a string and we want to restrict entry to only 10 characters. Is there a way to do this? Obviously not OOTB but with some customization?

Like 0

Like

1 comments

There is a possibility to setup a field validation and this approach is described in this Academy article.

 

Best regards,

Oscar

Show all comments
Studio_Creatio
7.18
devlabs

Hi Devlabs Team,



We have a requirement to add attachments in mail by reading the attachment from a custom attachment detail. To achieve this, we are using a Send email with attachments Marketplace application. 



The issue with the above application is, it is getting installed successfully. But when accessing the element in business process its settings is not opening also getting some error in the console. (refer the screenshot attached)

 



Thanks,

Sourav Kumar Samal

Like 0

Like

2 comments

Hi Team,

 

Could you please help on this?

 

Thanks

Sourav Kumar Samal,

 

Hi Sourav!

We are aware of this issue. R&D department fixed this bug in version 7.18.4. If you have an earlier version of the application, we recommend updating it to the current version.

Show all comments

Hi Community,

I have a requirement that an error message will populate once you save a record in details section with a record no which is already exists. The error message format is like "Settlement ID is already exists with record no 1001(where 1001 is the record no of parent record)".

Here is the code below that I have written.

define("AMDSchema09eec6a7Page", [], function() {
	return {
		entitySchemaName: "AMDSettlement",
		attributes: {},
		modules: /**SCHEMA_MODULES*/{}/**SCHEMA_MODULES*/,
		details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
		businessRules: /**SCHEMA_BUSINESS_RULES*/{}/**SCHEMA_BUSINESS_RULES*/,
		methods: {
			/*setValidationConfig: function() {
                // This calls the initialization of validators for the parent view model.
                this.callParent(arguments);
                this.addColumnValidator("AMDSettlementID", this.SettlementIDDuplicateValidator);
            },*/
			save: function(){
				var currentvalue = this.get("AMDSettlementID");
				var esq = Ext.create("Terrasoft.EntitySchemaQuery", { rootSchemaName: "AMDSettlement" });
				esq.addColumn("AMDSettlementID");
				esq.addColumn("AMDClaims");
				esq.filters.add("AMDSettlementID", Terrasoft.createColumnFilterWithParameter(
  					Terrasoft.ComparisonType.EQUAL, "AMDSettlementID", currentvalue));
				esq.getEntityCollection(function(response) {
  					if (response && response.success) {
						console.log("Test ",response);
   						var result = response.collection.collection.length;
						if (result > 0)
							{Terrasoft.showErrorMessage("Settlement ID {result} already Exists");
							return false;}
						else{
							return true;}
						}
 					}, this);
				}
			},

So I need a syntax in "Terrasoft.showErrorMessage()" which will read the column value from the console page(read from rowConfig) . Below adding the picture of console page.

 

 

Best Regards,

Jagan

 

 

 

Like 0

Like

3 comments

Hi Jagan,

 

In your part of code:

Terrasoft.showErrorMessage("Settlement ID {result} already Exists")

you need to pass something to this {result} in the following manner (standard JavaScript):

Terrasoft.showErrorMessage(`Settlement ID ${result} already Exists`)

and the result should be formed according to your business task. If you need to understand what to pass to the result - debug the code, set the breakpoint before showing this error message and in the console itself check what is passed and how to get to the values needed. You will be able to find out what should be passed in the console directly.

 

Best regards,

Oscar

Hi.

 

In addition to the Oscar comment please as well read this post regarding async validation i think You would like to achieve:

 

https://community.creatio.com/questions/overriding-save-function

 

Best regards,

Marcin

Oscar Dylan,

Hi Oscar,

In the above code the error message is coming when you create a record with existing record no but if you create a record with different record no it is not getting saved. Could anyone help me what is wrong with the code.

 

Regards,

Jagan

Show all comments
Studio_Creatio
#BusinessProcess
7.18

Hi Creatio Community

I have created a custom attachment object which is sitting in a detail.

While trying to use the "Process File" element in a business process, I am unable to see that "custom attachment object" in the "Which object to receive file from?" dropdown list.

I need to trigger a business process whenever a new file is added in that custom attachment object, and then use that file as an email attachment in the Send email element.

 

Can you help me figure out how can I read the files present in that custom attachment object in a business process?

 

Thank You.

 

Like 0

Like

1 comments

Hi Nisarg,

 

Please check this Marketplace solution. I believe it has the exact functionality you are looking for.

 

Best regards,

Bogdan 

Show all comments
Payment_Schedule
Studio_Creatio
7.18

Can someone help please?

 

Trying to add Invoice payment schedule from the marketplace, error in deployment - Dependent package "Passport" not found

2022-04-04 12:27:07,260 System.ApplicationException: Dependent package "Passport" not found
   at Terrasoft.Core.Packages.PackageDBStorage.SavePackageDependencies(Package package)
   at Terrasoft.Core.Packages.PackageDBStorage.SaveDependencies()
   at Terrasoft.Core.Packages.PackageDBStorage.Save(IPackageContentProvider packageContentProvider)
   at Terrasoft.Core.Applications.Packages.Operations.SystemPackageOperations.PackageDBStorageInternal.Save(IPackageContentProvider packageContentProvider)
   at Terrasoft.Core.Applications.Packages.Operations.SystemPackageOperations.Save(IEnumerable`1 packages, PackageInstallOptions options)
   at Terrasoft.Core.Applications.Packages.SystemPackageManager.Save(PackageInstallOptions installOptions)
   at Terrasoft.Core.Applications.Installation.AppInstaller.Install(String sourcePath, String destinationPath, PackageInstallOptions installOptions, IInstalledAppInfo installedAppInfo)
   at Terrasoft.Core.ServiceModelContract.PackageInstaller.AppInstallerServiceInternal.<>c__DisplayClass10_0.<InstallApp>b__0()
   at Terrasoft.Core.ServiceModelContract.PackageInstaller.BaseInstallerServiceInternal.InvokeWithLogging[TResult](Func`1 action)

https://marketplace.creatio.com/app/invoice-payment-schedule-creatio

 

Like 0

Like

6 comments

Hi Nicola,

 

What Creatio edition You have ?

 

This addon required one of Sales Enterprise or Sales Commerce according to marketplace link in tab Installation.

 

Best regards,

Marcin

Hi

 

bpmonline sales team, so I expect this should be correct?

Is anyone able to help, please?

Hi Nicola,

The app is only compatible with commerce and enterprise editions of Sales Creatio. Sales Creatio, team edition, doesn't have all of the required packages for the app's correct operation.

I'm confident we have an enterprise licence, how do I confirm this, I cannot find it in the application

Nicola Wall,

Hi Nicola!

I recommend you contact support so that they recheck your licenses and app type.

Show all comments

Hi All,

 

I have a scenario as follows:

While creating a new or editing the record in a detail, the parent section saving functionality, should either be skipped or restricted to after the detail record is saved.

 

Is there a way to achieve this?

Thanks,

Sourav Kumar Samal

Like 0

Like

1 comments

Hello Kumar,

 

Thank you for your question. Unfortunately, it's not possible to implement this with the help of the OOB tools yet, this can be achieved only by means of additional development for now.

 

Best regards,

Anastasiia

Show all comments
Atlas_release
Business Process
open edit page
Studio_Creatio

Hi all,

I am trying to Create New Record in a custom Section using an open edit page in Business Process but the section doesn't appear on the open edit page activity .

in atlas release.

Like 0

Like

1 comments

Hello Sayed,

 

at the moment in the atlas release the business processes do not support pages from sections customly created. That is why this section does not appear in the BPM.

 

At the moment the BPM only supports already existing sections.

 

Our R&D team is already working to develop this functionality and it will be available in further releases.

 

Best regards,

Dariy

Show all comments
Studio_Creatio
duplicates
7.18

Hi Community,

I have a requirement that in details once you created a record with a record number(for Ex:-800009),  you can't create another record with same record number. I have to restrict the duplicate creation of record number.

Can anyone help me to achieve this?

 

Like 1

Like

4 comments

Hello Jagan,

 

Unfortunately, at the moment, deduplication functionality can only be used for the main columns of the object, i.e. You cannot set up rules for searching for duplicates for details.

 

Details pull information from another section. It is necessary to search and merge duplicates in the section itself. 



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

Hi Bogdan,

Can I get the script code for How to achieve the deduplication functionality for the  main columns of the object?

Regards,

Jagan

Jagan Nayak,

 

Hello,

 

Unfortunately, as of now we do not have any ready to use examples of such implementation done by code. 

 

Best regards,

Anastasiia

+ 1 for this functionality

Show all comments