Studio_Creatio_free_edition | Community Creatio

8.0

Object Creation Error

pubudu

06:54 Jul 18, 2022

2 comments

Kalymbet Anastasia

18:06 Jul 18, 2022

Hello,

Such error may occur if any of the default localizations were deleted (any records from the dbo.SysCulture)

Please flush Redis of your instance and try to create an object again.

pubudu

08:51 Jul 19, 2022

Yes Did It's working Thank you

Show all comments

Question

Cannot add data to object: Terrasoft.Common.DbOperationException: 42P01: relation does not exist

8.0

Iustina Necula

16:21 Jul 15, 2022

Hi,

I'm using Creatio Studio(trial version for now) and I have created my own custom object(Car Rental) - with the Represents Structure of Database View behavior (meaning that a table should be created for it).

As part of my business process I want to add data to the object, but I'm receiving the following error: Terrasoft.Common.DbOperationException: 42P01: relation "public.UsrCarRental" does not exist

I have saved and compiled the object accordingly but it seems that it does not work.

Could you give me some hints?

Thanks.

2 comments

Ryan Farley

20:08 Jul 15, 2022

Iustina,

The "Represents Structure of Database View" means a table is *not* created for it. Instead it looks for a database view of the same name as the object.

For normal objects that will have records, you should not check the "Represents Structure of Database View" checkbox for the object. Does that make sense?

Ryan

Iustina Necula

10:59 Jul 18, 2022

Hi Ryan, thanks a lot. Your suggestion helped me ;)

Show all comments

Question

How can i change user type when i change user?

14:56 Feb 24, 2022

Hello, when I change Owner, type section also should change, please help how can i do that?

Thanks so much in advanced.

2 comments

17:11 Feb 24, 2022

Hi,

You need to set the value for the "type" column using a client-side code and this.set method. This should be added to the "Owner" attribute modification handler method (the handler example was provided in this post for example).

Best regards,

Oscar

Ryan Farley

17:46 Feb 24, 2022

You can see an article on how to wire up change events on the page here: https://customerfx.com/article/triggering-an-event-when-a-field-is-chan…

As far as setting the value of the Type lookup, a lookup needs an object with two properties to display properly, (1) a value property (the Id of the lookup item) and (2) displayValue (the text of the lookup item). You'd set it like this:

this.set("Type", {
    value: theIdOfTheTypeItem,
    displayValue: theTextOfTheTypeItem
});

This article on getting started with client side code for Creatio might help https://customerfx.com/article/getting-started-with-writing-code-for-bp…

Ryan

Show all comments

Question

ASAP! How can i change Account type when button clicked?

07:33 Feb 23, 2022

Hello community!

I am going to change user type when button clicked, plaese help me ASAP!

define("ContactPageV2", [], function() {
	return {
		entitySchemaName: "Contact",
		attributes: {},
		modules: /**SCHEMA_MODULES*/{}/**SCHEMA_MODULES*/,
		details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
		businessRules: /**SCHEMA_BUSINESS_RULES*/{}/**SCHEMA_BUSINESS_RULES*/,
		methods: {
			// owner is NULL = disable button 
			onPageClick: function() {
				var textInput = this.get("Owner");
				var textType = this.get("Type");
				console.log(textType);
				console.log(textInput.value);
				if (textInput) {
					this.set("Type", {value: "60733efc-f36b-1410-a883-16d83cab0980", displaValue: "Employee", markerValue: 							"Employee", customHtml: "Employee", primaryImageVisible: false });
 
				}
				var ageInput = this.get("Age");
				this.set(ageInput, 24);
				console.log(ageInput);
 
			},
			getMyButtonEnabled: function(){
				var textInput = this.get("Owner");
				var result = !!textInput;
				return result;
			}
		},
		dataModels: /**SCHEMA_DATA_MODELS*/{}/**SCHEMA_DATA_MODELS*/,
		diff: /**SCHEMA_DIFF*/[
			{
				"operation": "insert",	
				"parentName": "ContactGeneralInfoBlock",
				"propertyName": "items",
				"name": "NewButton",
				"values": {
					itemType: Terrasoft.ViewItemType.BUTTON,
                    caption: {bindTo: "Resources.Strings.NewButtonCaption"},
					click: {bindTo: "onPageClick"},
					enabled: {bindTo: "getMyButtonEnabled"},
					"style": Terrasoft.controls.ButtonEnums.style.BLUE,
					"layout": {
						"column": 12,
						"row": 2,
						"colSpan": 8,
						"rowSpan": 1
					}
 
				},
 
            },
		]/**SCHEMA_DIFF*/
	};
});

4 comments

Best reply

11:14 Feb 23, 2022

Hello,

Eugene in this community post shared an example on how to modify the lookup value from the client-side logic. Use the:

this.set("LookupName", {value:"id", displayValue:"text"});

Best regards,

Oscar

11:14 Feb 23, 2022

Hello,

Eugene in this community post shared an example on how to modify the lookup value from the client-side logic. Use the:

this.set("LookupName", {value:"id", displayValue:"text"});

Best regards,

Oscar

06:42 Feb 24, 2022

it is showing undefined when i clicked the button.

06:45 Feb 24, 2022

Oscar Dylan,

can you help me like that?

08:11 Feb 24, 2022

Muhammadjon Yakhyoev,

It means that you specify something that shouldn't be set in this column. Only records present in the AccountType lookup can be set as a value in this column. Additionally you need to debug the code and see what exactly is being set in this column and check if there is no additional logic that set the value for a field there.

Best regards,

Oscar

Show all comments

Question

value

input

How can i get value of input?

06:22 Feb 22, 2022

I am going to change the value of an input when i clicked a buttun. How can i do that?

3 comments

Artem

06:33 Feb 22, 2022

Hello,

Could you please elaborate on the task you want to achieve?

Which button are you referring to?

Thank you,

Artem.

06:46 Feb 22, 2022

Artem,

Artem thanks for your reply.

I am going to change Inputs` value on ContactPageV2 page when I click costum button. Like I when I clicked button Age's value should change to 24.

Artem

03:16 Feb 23, 2022

Hello,

You could use the next method:

Insert the code below into the click handler function of your button:

this.set("Age", 24);

Thank you,

Artem.

Show all comments

Question

How to set Input's value to an element?

10:55 Feb 21, 2022

I am going to set input's value to a text element when button is clicked? How can i do that?

define("ContactPageV2", [], function() {
	return {
		entitySchemaName: "Contact",
		attributes: {},
		modules: /**SCHEMA_MODULES*/{}/**SCHEMA_MODULES*/,
		details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
		businessRules: /**SCHEMA_BUSINESS_RULES*/{}/**SCHEMA_BUSINESS_RULES*/,
		methods: {
			onPageClick: function() {
				var GreetingValue = this.get("SalutationType").value;
				var GreetingDisplayValue = this.get("SalutationType").displayValue;
 
 
				console.log(GreetingDisplayValue);
			},
			getMyButtonEnabled: function(){
				return true;
			}
		},
		dataModels: /**SCHEMA_DATA_MODELS*/{}/**SCHEMA_DATA_MODELS*/,
		diff: /**SCHEMA_DIFF*/[
			{
				"operation": "insert",	
				"parentName": "ContactGeneralInfoBlock",
				"propertyName": "items",
				"name": "NewButton",
				"values": {
					itemType: Terrasoft.ViewItemType.BUTTON,
                    caption: {bindTo: "Resources.Strings.NewButtonCaption"},
					click: {bindTo: "onPageClick"},
					enabled: {bindTo: "getMyButtonEnabled"},
					"style": Terrasoft.controls.ButtonEnums.style.BLUE,
					"layout": {
						"column": 12,
						"row": 2,
						"colSpan": 8,
						"rowSpan": 1
					}
 
				},
 
            },
			{
				"operation": "insert",	
				"parentName": "ContactGeneralInfoBlock",
				"propertyName": "items",
				"name": "NewInput",
				"values": {
					itemType: Terrasoft.utils.inputBox,
                    caption: {bindTo: "Resources.Strings.NewButtonCaption"},
					click: {bindTo: "onPageClick"},
					enabled: {bindTo: "getMyButtonEnabled"},
					"style": Terrasoft.controls.ButtonEnums.style.BLUE,
					"layout": {
						"column": 6,
						"row": 3,
						"colSpan": 8,
						"rowSpan": 1
					}
 
				},
			}
		]/**SCHEMA_DIFF*/
	};
});

3 comments

Best reply

11:41 Feb 21, 2022

You can do it by using this.set("StringColumn", valueNeeded); in the click-handler function for your button.

Best regards,

Oscar

11:41 Feb 21, 2022

You can do it by using this.set("StringColumn", valueNeeded); in the click-handler function for your button.

Best regards,

Oscar

06:00 Feb 22, 2022

Oscar Dylan,

thanks i will try it

06:02 Feb 22, 2022

Oscar Dylan,

how can i get innertext or innerhtml of something?

Show all comments

Question

Button

custom button

How can i create custom button which alerts some text?

7.18

11:55 Feb 17, 2022

I am going to add custom button which alerts some text on contact page. Is it possible?

2 comments

Dariy Pavlyk

13:04 Feb 18, 2022

Hello Muhammadjon,

in order to achieve this you need to create a Replacing view model at the Custom package.

For the partent object you will need to select ContactSectionV2, or the section where you want to create this button.

Then you need to create a new localizable string (you will see the possibility to create a new one on the left) where you will put the desired text. for the button. While creating the localizable string you will need to enter the value, and the code. The code is something that you will use later.

After that you insert this code on the page:

define("ContactSectionV2",

       function(BaseFiltersGenerateModule, Enums, ConfigurationConstants, BusinessRuleModule) {

           return {

               entitySchemaName: "Contact",

               messages: {},

               attributes: {},

               rules: {}/**SCHEMA_MODULES*/,

               /**

               * Current schema mixins

               */

               mixins: {},

               methods: {

                   OnTestButtonClick : function() {

                       Terrasoft.showInformation('Test')

                   }

               },

               diff: /**SCHEMA_DIFF*/[

                   {

                   "operation": "insert",

                   "parentName": "ActionButtonsContainer",

                   "propertyName": "items",

                   "name": "TestButton",

                   "values": {

                       "itemType": Terrasoft.ViewItemType.BUTTON,

                       "style": Terrasoft.controls.ButtonEnums.style.GREEN,

                       "caption": {"bindTo": "Resources.Strings.TestButtonCaption"},

                       "markerValue": {"bindTo": "QualificationProcessButtonCaption"},

                       "classes": {"wrapperClass": ["t-btn-wrapper t-btn-text t-btn-style-blue actions-button-margin-right"]},

                       "iconAlign": Terrasoft.controls.ButtonEnums.iconAlign.RIGHT,

                       "click": {"bindTo": "OnTestButtonClick"},

                       "layout": {

                           "column": 6,

                           "row": 0,

                           "colSpan": 2

                       },

                       "visible": true

                   }

               }   ]/**SCHEMA_DIFF*/

           };

       });

The method Terrasoft.showInformation('Test') is the one responsible for displaying the message on screen. Here instead of Test you can write any message.

The part where it says "caption": {"bindTo": "Resources.Strings.TestButtonCaption"}" , this is where you put the code from the localizable string previously created. So if the code of the string was called TestButtonCaption, then you need to put Resources.Strings.TestButtonCaption. If you name the code like "RandomButton" then it will be Resources.Strings.RandomButton.

Best regards,

Dariy

Package Installation Error

14:15 Feb 18, 2022

Thanks so much! This is so helpful

Dariy Pavlyk,

Show all comments

Question

Data binding tool for Creatio

Eran Malik

11:56 Feb 08, 2022

Hi,

I'm trying to install the :Data binding tool for Creatio

https://marketplace.creatio.com/app/data-binding-tool-creatio

from a downloaded zip file. But I get installation error:

"2022-02-08 11:31:39,427 Error occurred while generating schema source code "SysSettingsSection" in package "GlbDataBinding". UId ffd3e4fe-d38d-4f6c-a20f-690345cee210: Object with UId c37d05e9-7adc-41ce-a34f-e9a600885f5b already added to manager.

2022-02-08 11:31:39,443 System.ArgumentException: Object with UId c37d05e9-7adc-41ce-a34f-e9a600885f5b already added to manager."

I'm trying to install it on a fresh demo (8.0.0.5434) instance.

Any idea ?

1 comments

Eugene Vorobiov

16:01 Apr 27, 2022

Hi Eran!

We had no issues with installing this add-on into the current latest version 8.0.0.5476. Could you try installing the add-on once again on the latest version?

Show all comments

Question