Hello community,

I'm trying to import/export data from one environment to another. I noticed that for each type of entity a table named 'Sys' +  entityName + 'Right' was created. I could not create data type schemes for these tables. What solution does Creatio offer for the transfer of this data?

Like 0

Like

0 comments
Show all comments

I have set up sales teams 7.18 .net core in windows system. I have come across the following post (https://community.creatio.com/questions/anonymous-custom-configuration-service-net-core) to create anonymous service. Please guide me on following questions:

  1. Should .svc file be externally created? If so where exactly it should be placed in the local folder?
  2. what are the steps for visual studio IDE settings for .net core setup in windows?
Like 0

Like

3 comments

Hello,

 

Regarding your question about creating an anonymous web service: please follow the link below to the documentation, here you can find all the needed information in the "Develop a custom web service that uses anonymous authentication for .NET Core" section.



https://academy.creatio.com/docs/developer/back_end_development/web_services/overview#title-1243-5



The short answer is, in .NetCore you don't need need to create the .svc file, you simply need to modify an appsettings.json file.

 

As for your second question, basically, there are no special steps/settings in VS IDE for .net core. It contains lots of tools but they are all optional and are not absolutely required for .net core. 

The only thing you should understand is that the code will be compiled under netstandard.

 

The application installation package on the .Net Core platform is universal, both on Linux and Windows.

 

Best regards,

Anastasiia

Hi

Anastasiia Lazurenko,

Thank you firstly for your answer,

 

after configuring anonymous service for .net core indicated in the previous link, how we can test if they work ?

i tried with this link : "http://mycreatio.com/0/ServiceModel/UsrCustomConfigurationService.svc/G…"

but i get this error : page can’t be found

Hello,

 

If you have followed the example on Creatio Academy, please note that you cannot use the mycreatio.com website, but need to substitute the URL of your Creatio site and the name of the service you created.

Form a link like this

 

[Creatio application URL]/ServiceModel/[Custom web service name]/[Custom web service endpoint]

 

Thank you.

Show all comments

 Hi community,

I'm trying to disable the columns of an editable detail to make them read only and I have read many articles about it, but I'm still having a problem that I can't fix.



I wrote this code in the GridDetail to disable the fields but I noticed that for some of the columns of the detail is not working.

getCellControlsConfig: function(entitySchemaColumn) {
    if (!entitySchemaColumn) {
        return;
    }
    var columnName = entitySchemaColumn.name;
    var enabled = (entitySchemaColumn.usageType !== this.Terrasoft.EntitySchemaColumnUsageType.None) &&
        !this.Ext.Array.contains(this.systemColumns, columnName);
    var config = {
        itemType: this.Terrasoft.ViewItemType.MODEL_ITEM,
        name: columnName,
        labelConfig: {visible: false},
        caption: entitySchemaColumn.caption,
        enabled: enabled
    };
    if (!this.values.IsEnabled) {
        config.enabled = false;
        //config.labelConfig.enabled = false;
        //this.set("Is"+columnName+"enabled", false);
    }
    if (entitySchemaColumn.dataValueType === this.Terrasoft.DataValueType.LOOKUP) {
        config.showValueAsLink = false;
    }
    if (entitySchemaColumn.dataValueType !== this.Terrasoft.DataValueType.DATE_TIME &&
        entitySchemaColumn.dataValueType !== this.Terrasoft.DataValueType.BOOLEAN) {
        config.focused = {"bindTo": "Is" + columnName + "Focused"};
    }
    console.log(config);
    return config;
},

Debugging I have discovered that the detail adds to the labelConfig the property "enabled" which is binded to an attribute ("isProductenabled").

I tried to force the property writing it in the method and I also tried to set the attribute manually, but it's not working... do you have any idea?



Let me know.

Thanks in advance.



Best regards,

Luca

Like 0

Like

5 comments
Best reply

Luca Tavasanis,

While I was debugging I have noticed that the properties of the labelConfig that enabled some of the fields where added in the method: "applyBusinessRulesForActiveRow: function(id, gridLayoutItems)" and to fix the issue I just added this method in the client module.

You can lock the fields in the editable detail using business rules on the page for the detail, rather than in code. On the page for the detail, add a business rule to make the field not editable. Something like 

Condition: Boolean true = Boolean false (something that is never true)

Then: Make field editable (the condition is never true, so field is never editable)

The business rule will apply to the detail list and the fields will not be editable in the detail list.

Ryan

Hi Ryan,

I'm actually working with the BaseGridDetail so I can't lock it with a business rule... do you have any other idea?

 

Thanks anyway.

Luca

Luca Tavasanis,

IIRC to do it in code I usually do it like this (but unable to verify if this is correct at the moment)

getCellControlsConfig: function(entitySchemaColumn) {
    // get config from base 
    var config = this.mixins.ConfigurationGridUtilities.getCellControlsConfig.apply(this, arguments);
    var columnName = entitySchemaColumn.name;
 
    // if this is the column I want to disable
    if (columnName === "UsrMyColumn") {
        Ext.apply(config, {
            enabled: false
        });
    }
 
    return config;
}

Hopefully that gets you closer, of course, if you're wanting to disable all, you could just remove the if to check the column it's for.

Ryan

Ryan Farley,

I just tried what you suggested but unfortunately it's not working... it returns an error when I use this.callParent(arguments);.

Thank you anyway.



Luca

Luca Tavasanis,

While I was debugging I have noticed that the properties of the labelConfig that enabled some of the fields where added in the method: "applyBusinessRulesForActiveRow: function(id, gridLayoutItems)" and to fix the issue I just added this method in the client module.

Show all comments

HI,

Q: Why there is no option to select "Amount" when creating business rule on Order page?

Also.. no option to select "Price" when creating business rule on Order-products page

Like 0

Like

0 comments
Show all comments

The requirement is to hide the business process a business process from the record/list page for certain user roles.

For example we have connected an approval business process with a section, we need to show that process only for the approver user roles.

Is there a way we can configure this. Please advice

Thank you!

Like 1

Like

1 comments

Hi Community,

 

We have this requirement from our client, they have existing password management system. They want us to do the login authentication on that system. Any idea where we can start customizing/extending the login functionality.

Like 0

Like

0 comments
Show all comments

Hello community,

I am implementing a way to import/export organizational data. The thing I want to do is create a business process that will transfer the data from SysAdminUnitCopy to SysAdminUnit and vice versa.  For the transfer of this data I created a script in sql server which transfers this data and executes successfully.

The next thing i need to do now is put this script in a sql script type schema and call it from a process.

Is there any way to call/execute a sql script schema from a business process?

 

Like 0

Like

1 comments

Hi Team,

 

How to provide the Delete all and Select options in detail menu.

 

Can any one help with this?

 

 

 

Like 0

Like

1 comments

Hello Akshit,

To select all records in a detail, you just need to call this:

this.setSelectAllMode();

This will select all records in the detail. Once all records are selected, you should just be able to use the Delete menu option to delete all selected records.

Ryan

Show all comments

Hi

I want to send a notification to a case owner and an escalation manager when a case has not been updated in 48 hours.

For this I found in the admin guide a reference to performing a pipeline condition (https://academy.creatio.com/docs/7-18/user/bpm_tools/business_process_setup/formulas/process_formulas) and used this to create the following condition:

 

(decimal)RoundOff(([#System variable.Current Time and Date#]-[#Read modified time.First item of resulting collection.Modified on#]).TotalHours) > 48

However, when trying to save I get the following error - Formula value error: Invalid Operator. I cannot see why this is the case, as it follows the guide exactly with just the variable values updated.

 

thanks in advance

 

Mark

 

Like 0

Like

0 comments
Show all comments

Hello Community,

I'm trying to import the administration roles from one environment to another. When trying to add a schema of type data for the SysAdminUnit entity object I get the following message.

 

The record with Id "6f9af602-3a22-455c-b056-2cf14241f943" is already bound in the data "SysAdminUnit_CompanyAdministrator" of package "SSP" for schema "System administration object"

The record with Id "cc83e259-3630-49fd-918a-27a841d0c4cb" is already bound in the data "SysAdminUnit" of package "Lending" for schema "System administration object"

The record with Id "40cb908c-2a03-4bd6-9415-6c83e8aff297" is already bound in the data "SysAdminUnit" of package "Lending" for schema "System administration object"

The record with Id "720b771c-e7a7-4f31-9cfb-52cd21c3739f" is already bound in the data "SysAdminUnit" of package "SSP" for schema "System administration object"

The record with Id "83a43ebc-f36b-1410-298d-001e8c82bcad" is already bound in the data "SysAdminUnit" of package "Base" for schema "System administration object"

 

How can I perform this import/export because I have a lot of data of this type. 

 

Like 2

Like

0 comments
Show all comments