Like 0

Like

2 comments

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. 

 

 

Yes Did It's working Thank you

Show all comments

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.

Like 0

Like

2 comments

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

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

Show all comments

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

Thanks so much in advanced.

Like 1

Like

2 comments

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

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

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*/
	};
});

 

Like 0

Like

4 comments
Best reply

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

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

it is showing undefined when i clicked the button.

Oscar Dylan,

can you help me like that?

 

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

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

Like 0

Like

3 comments

Hello,

 

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

Which button are you referring to? 

 

Thank you,

Artem.

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.

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

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*/
	};
});

 

Like 0

Like

3 comments
Best reply

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

 

Best regards,

Oscar

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

 

Best regards,

Oscar

Oscar Dylan,

thanks i will try it

 

Oscar Dylan,

how can i get innertext or innerhtml of something?

 

Show all comments

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

Like 0

Like

2 comments

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 

Thanks so much! This is so helpful

Dariy Pavlyk,

Show all comments

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 ?

 

Like 0

Like

1 comments

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

I've setup my yahoo mail in creatio and I can send emails.

BUT in my "incoming" box in creatio I can't see any email! (looks like it won't sync).

BTW: I can see my sent emails the "outgoing" (so some sync did happen ! )

 

Any idea?  

Like 0

Like

1 comments

Hello Eran,

 

It's hard to say without access to the configuration of the website. Perhaps you have enabled specific folders for the synchronization and Incoming is not one of them.

Please contact Creatio technical support via email support@creatio.com so our team can assist you.

 

Best regards,

Bogdan S.

Show all comments

When I try to create a new object I get the message "Primary Column property not set" I cannot see anywhere in the object creation page to set this.

 

Can someone direct me to where to set this property

I using the trial version

Like 0

Like

2 comments
Best reply

Hi Robert,

Typically, your object should have "BaseEntity" as it's parent. When BaseEntity is selected as the parent, it will inherit an Id column (plus others) and the Id column will be selected as the Id column for the object. The error is letting you know that the object does not have a column selected as the Id column (when you select BaseEntity as the parent it will select the Id column as the objects "Id" property).

Here's an example of what I mean: https://share.customerfx.com/ApuEljAl

Ryan

Hi Robert,

Typically, your object should have "BaseEntity" as it's parent. When BaseEntity is selected as the parent, it will inherit an Id column (plus others) and the Id column will be selected as the Id column for the object. The error is letting you know that the object does not have a column selected as the Id column (when you select BaseEntity as the parent it will select the Id column as the objects "Id" property).

Here's an example of what I mean: https://share.customerfx.com/ApuEljAl

Ryan

Ryan Farley,

Thanks Ryan, makes total sense.  I was coming at this from a DB perspective not an ORM object modeling perspective duh!

 

And thanks so much for thge video, that is awesome!

Show all comments