Hello Markus,

Please clarify the question a little:

1) Do you need it for the Freedom UI interface or 7x interface?

2) You need to place it in the case section page or on the edit page of the case section?

3) In case the answer to the question 2 is "case section" - which particular account use from the grid?

4) Which column of the case account should be displayed? Account name, account code, account primary contact?

Hi, thanks for replying,



I want to add the virutal column to 7x interface, int the case edit page to be precise.

The field of the account I want to be displayed is a field cretaed by me. It's a text field aswell

Markus Kumpfmüller,

here is a simple example I created and tested recently:

 define("CasePage", [], function() {
		return {
			entitySchemaName: "Case",
			attributes: {
				"CustomTextColumn": {
					dataValueType: this.Terrasoft.DataValueType.TEXT,
					type: this.Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN
				},
				"Account": {
					"lookupListConfig": {
						"columns": ["UsrCustomAccountColumn"]
					},
					"dependencies": [
						{
							"columns": ["Account"],
							"methodName": "setCustomTextColumnValue"
						}
					]
				}
			},
			messages: {},
			methods: {
				onEntityInitialized: function() {
					this.callParent(arguments);
					this.setCustomTextColumnValue();
				},
 
				initOnRestored: function(callback, scope) {
					this.callParent(arguments);
					this.reloadEntity();
					this.setCustomTextColumnValue();
				},
 
				setCustomTextColumnValue: function() {
					var currentCaseAccount = this.get("Account");
					if (currentCaseAccount) {
						var currentCaseAccountCustomColumn = currentCaseAccount.UsrCustomAccountColumn;
						this.set("CustomTextColumn", currentCaseAccountCustomColumn);
					} else {
						this.set("CustomTextColumn", "");
					}
				}
			},
			details: /**SCHEMA_DETAILS*/ {} /**SCHEMA_DETAILS*/ ,
			diff: /**SCHEMA_DIFF*/ [
				{
					"operation": "insert",
					"name": "CustomAddedColumn",
					"values": {
						"layout": {
							"column": 0,
							"row": 10,
							"colSpan": 24,
							"rowSpan": 1
						},
						"bindTo": "CustomTextColumn",
						"caption": {
							"bindTo": "Resources.Strings.CustomAddedColumnCaption"
						},
					},
					"parentName": "ProfileContainer",
					"propertyName": "items"
				}
			] /**SCHEMA_DIFF*/
		};
	});

also the "CustomAddedColumnCaption" localizable string should be added to the CasePage schema. The logic is:

1) Populate the column when the page is opened (onEntityInitialized method)

2) In the "Account" attribute:

"lookupListConfig": {
						"columns": ["UsrCustomAccountColumn"]
					},

retrieve the value for the "UsrCustomAccountColumn" column from the "Account" object (added as a lookup to the CasePage)

3) In the "Account" attribute:

"dependencies": [
						{
							"columns": ["Account"],
							"methodName": "setCustomTextColumnValue"
						}
					]

modify the "CustomTextColumn" virtual column value each time account is changed in the "Account" lookup

4) Modify the value in the "CustomTextColumn" virtual column each time we open the account from the CasePage (click on the value in the "Account" lookup) and modify the value in the "UsrCustomAccountColumn" custom column on the account page and return back to the case page (initOnRestored method).

5) Also pay attention to this part in the diff:

"layout": {
							"column": 0,
							"row": 10,
							"colSpan": 24,
							"rowSpan": 1
						},

I took the last element that has "ProfileContainer" as a parent element, took its layout (which was:

{
						"operation": "merge",
						"name": "CaseOwner",
						"values": {
							"layout": {
								"column": 0,
								"row": 9,
								"colSpan": 24,
								"rowSpan": 1
							}
						}
					},

) and added 1 to the "row" attribute (to place my custom element right after the previous one).

The outcome is:

Oleg,

this helped me very much. Do you know how I could didplay this text as multiline? Currently the formatting of the source field in the account page is not being passed on.

Thanks,

Markus

Oleg Drobina writes:

Markus Kumpfmüller,

here is a simple example I created and tested recently:

 define("CasePage", [], function() {
		return {
			entitySchemaName: "Case",
			attributes: {
				"CustomTextColumn": {
					dataValueType: this.Terrasoft.DataValueType.TEXT,
					type: this.Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN
				},
				"Account": {
					"lookupListConfig": {
						"columns": ["UsrCustomAccountColumn"]
					},
					"dependencies": [
						{
							"columns": ["Account"],
							"methodName": "setCustomTextColumnValue"
						}
					]
				}
			},
			messages: {},
			methods: {
				onEntityInitialized: function() {
					this.callParent(arguments);
					this.setCustomTextColumnValue();
				},
 
				initOnRestored: function(callback, scope) {
					this.callParent(arguments);
					this.reloadEntity();
					this.setCustomTextColumnValue();
				},
 
				setCustomTextColumnValue: function() {
					var currentCaseAccount = this.get("Account");
					if (currentCaseAccount) {
						var currentCaseAccountCustomColumn = currentCaseAccount.UsrCustomAccountColumn;
						this.set("CustomTextColumn", currentCaseAccountCustomColumn);
					} else {
						this.set("CustomTextColumn", "");
					}
				}
			},
			details: /**SCHEMA_DETAILS*/ {} /**SCHEMA_DETAILS*/ ,
			diff: /**SCHEMA_DIFF*/ [
				{
					"operation": "insert",
					"name": "CustomAddedColumn",
					"values": {
						"layout": {
							"column": 0,
							"row": 10,
							"colSpan": 24,
							"rowSpan": 1
						},
						"bindTo": "CustomTextColumn",
						"caption": {
							"bindTo": "Resources.Strings.CustomAddedColumnCaption"
						},
					},
					"parentName": "ProfileContainer",
					"propertyName": "items"
				}
			] /**SCHEMA_DIFF*/
		};
	});

also the "CustomAddedColumnCaption" localizable string should be added to the CasePage schema. The logic is:

1) Populate the column when the page is opened (onEntityInitialized method)

2) In the "Account" attribute:

"lookupListConfig": {
						"columns": ["UsrCustomAccountColumn"]
					},

retrieve the value for the "UsrCustomAccountColumn" column from the "Account" object (added as a lookup to the CasePage)

3) In the "Account" attribute:

"dependencies": [
						{
							"columns": ["Account"],
							"methodName": "setCustomTextColumnValue"
						}
					]

modify the "CustomTextColumn" virtual column value each time account is changed in the "Account" lookup

4) Modify the value in the "CustomTextColumn" virtual column each time we open the account from the CasePage (click on the value in the "Account" lookup) and modify the value in the "UsrCustomAccountColumn" custom column on the account page and return back to the case page (initOnRestored method).

5) Also pay attention to this part in the diff:

"layout": {
							"column": 0,
							"row": 10,
							"colSpan": 24,
							"rowSpan": 1
						},

I took the last element that has "ProfileContainer" as a parent element, took its layout (which was:

{
						"operation": "merge",
						"name": "CaseOwner",
						"values": {
							"layout": {
								"column": 0,
								"row": 9,
								"colSpan": 24,
								"rowSpan": 1
							}
						}
					},

) and added 1 to the "row" attribute (to place my custom element right after the previous one).

The outcome is:

Markus Kumpfmüller,

just add this line

"contentType": this.Terrasoft.ContentType.LONG_TEXT,

into the "values" object of the "CustomAddedColumn" element in diff:

{
					"operation": "insert",
					"name": "CustomAddedColumn",
					"values": {
						"contentType": this.Terrasoft.ContentType.LONG_TEXT,
						"layout": {
							"column": 0,
							"row": 10,
							"colSpan": 24,
							"rowSpan": 1
						},
						"bindTo": "CustomTextColumn",
						"caption": {
							"bindTo": "Resources.Strings.CustomAddedColumnCaption"
						},
					},
					"parentName": "ProfileContainer",
					"propertyName": "items"
				}

The column will become multiline after that.

Is there any example of how we can do the same in the Freedom UI?

Hello, 

 

Unfortunately, we do not have that option. 

But we have registered it with our R&D team for review and implementation in future releases of the application.



Thank you for your help in improving our product.





Best regards,

Orkhan Gojaev

Very interesting idea indeed :)

Hello Christian,



Here is the academy page that will help you to set up such a field:

https://academy.creatio.com/docs/developer/interface_elements/record_pa…

Greetings,



Unfortunately, we are unable to see the pictures you have attached.

Could you kindly re-post them in the comment section? 

Mykhailo Zeleniuk,

Please find the images below.



In "Product Catalogue" the folder filter is not working.

Product section default folder filter is working.

How to set a folder filter default in Product Catalogue (Order section - Product detail).



BR,

Bhoobalan Palanivelu.

Hi!

If you remove all roles/users from default permissions (managed by records access rule settings), users who created the record and records owner will still be able to see/edit/delete the record. 

To change this behavior, there are several options: 

- open the record in the System Designer and set the rule for the author to grant himself the rights for "not reading" the record

- the database command to remote the specific rights in the sys[object]right table. You can check some details on the example of granting the rights and change the logic of the provided script: https://community.creatio.com/questions/there-way-provide-record-creato…

Here are some more details on how these system tables impact the record permissions: https://community.creatio.com/articles/what-database-tables-should-i-ta…

- design a business process with the "Change access" element to remove the rights from the record author

Hope this info helps you with the described case.

Hi Sasori,

It's possible, but proper css should be created:

what was done is adding the image to NuiLogin.aspx page css (add body elemnt there):

<style>
		.font-preload {
			position: absolute;
			opacity: 0;
		}
		.font-preload-open-sans {
			font-family: "Bpmonline Open Sans";
		}
		.font-preload-open-sans-light {
			font-family: "Bpmonline Open Sans Light";
		}
		.font-preload-open-sans-bold {
			font-family: "Bpmonline Open Sans Bold";
		}
		body {
			background-image: url("783px-Test-Logo.svg.png");
		}
	</style>

and put this image to the root directory of app binary files. Only css should be modified in case you don't need to repeat this image and to set the size for it.

Oleg Drobina,

Thanks for the explanation Oleg, 

I tried all the steps but still the image is not showing in the background of the login page.

1- Modified NuiLogin.aspx file (path : inetpub\wwwroot\creatio\Login)

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="NuiLogin.aspx.cs" Inherits="Terrasoft.WebApp.Loader.Login.NuiLogin" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml" dir="<%= PageDirection %>" culture="<%= LanguageCultureName %>">
<head runat="server">
	<meta http-equiv="X-UA-Compatible" content="IE=Edge" />
	<meta name="fontiran.com:license" content="LAXSN" />
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<title>Creatio</title>
	<style>
		.font-preload {
			position: absolute;
			opacity: 0;
		}
		.font-preload-open-sans {
			font-family: "Bpmonline Open Sans";
		}
		.font-preload-open-sans-light {
			font-family: "Bpmonline Open Sans Light";
		}
		.font-preload-open-sans-bold {
			font-family: "Bpmonline Open Sans Bold";
		}
		body {
			background-image: url("test.png");
		}
	</style>
</head>
<body>
	<div class="font-preload">
		<span class="font-preload-open-sans">_</span>
		<span class="font-preload-open-sans-light">_</span>
		<span class="font-preload-open-sans-bold">_</span>
	</div>
	<form id="IndexForm" runat="server">
	</form>
</body>
</html>

1- Added test.png image file in ( path - inetpub\wwwroot\creatio\)

Sasori Oshigaki,

Strange, this approach worked in my local app perfectly. Maybe there is an error message in the console when trying to reach the Login page and it will provide more details? Or maybe the image is empty? Also try restarting the application in IIS.

Oleg Drobina,

Just fixed it Oleg

The mistake was the path of the image ( got it from console window)

The image should be placed under this path :

inetpub\wwwroot\creatio\Login

Thanks a lot for the help

Sasori

Sasori Oshigaki,

hm, in my case it requested the root directory of the app when I was testing it. Anyway, it's good that the console message answered the question!

Hello,

Please contact support team on this matter.

Greetings,



We kindly ask you to contact support@creatio.com directly in order for us to provide you with a necessary package for updating your on-site application.

You cannot use the updater to get the update files since Creatio 8.0.0, you need to ask support for the files. For some reason, the update guide does not mention it, and nothing in the partner knowledge base explaining it either...

Hi Vladimir!



Fonts should be installed on the IIS side and the template also needs to be set up correctly to make them available.



The following instructions can help you to achieve the result you are looking for:

https://www.fast-report.com/en/blog/show/custom-fonts-online-designer/

Pavlo Sokil,

Thank you, Pavlo!



We have installed fonts on our Dev IIS server and it works.

But when customer has done the same, on their Test server it works, but on Production - not.



Can you give any idea what can be checked more?



Thank you!

Vladimir

Hi Vladimir.



There are several possible reasons why a custom font added to IIS for Fast Reports may work for one site but not for another, even with the same settings. Here are a few possible reasons:

1. Different versions of IIS: If the two sites you are configuring the custom font for are running on different versions of IIS, this can cause compatibility issues. Therefore, depending on which version of IIS your sites are running on, you should use the corresponding version of the custom font.

2. Different IIS settings: Another possible issue is different IIS settings on different sites. For example, if one site is working with custom fonts over HTTP, and another is over HTTPS, this can affect how the fonts are displayed on the site.

3. Different font locations: It's possible that the fonts are not located in the same place on two different servers, and this can cause issues with loading the fonts on one of the sites.

4. Caching: If the font is added to one site, and then you add it to another, the browser may have a cached copy of the old version of the font. This can cause the font to not change when you switch to the other site.

5. If this is a self-hosted font, it may be necessary to modify the hosting settings of the font to allow access from other domains (perhaps by adding the instance address of Creatio to the Allowed domains list).

To address these issues, make sure you are using the correct version of the font, check if the settings are the same on both servers, make sure the fonts are located in the same place, and clear the browser cache.

Hello,

As far as I understand you need to pull the "Design Transformation : Design Paid Upfront" detail data from the "Parts, Design, Labor Components" detail into Quotes printable. Unfortunately, that would not work since it is not possible to print out the table in the table.

As a workaround to display data in a report from the nested second-level detail data as a hierarchy, you can use an object as a database view. The view can be created using a Common Table Expression (CTE). For example:

WITH  cte AS (
    select
             cast(l1.Name as NVARCHAR(MAX)) as Name,
             l1.Id,
             0 as hierarhy,
             l1.Id as Level1,
             m.Id as MainId
       from Main as m
       join Level1 as l1 on m.Id = l1.MainId
 
    UNION ALL
 
     select
             cast('  -  ' + l2.Name as NVARCHAR(MAX)) as Name,
             l2.Id, 
             1 as hierarhy,
             l2.Level1Id as Level1,
             m.MainId as MainId
       from cte as m
       join Level2 as l2 on m.Id = l2.Level1Id
)
 
SELECT *
FROM   cte
order by Level1, hierarchy

In this example,

Main is the main object, Level1 is the detail that is linked to Main, and Level2 is the detail that is linked to Level1.

As a result, an object can be obtained that joins two tables and displayed the data. Therefore, when creating the necessary columns in the view, they can be used to build the table and output the information row by row.

Best regards,

Kate