([#System variable.Current Time and Date#] - [#RegistrationDateHere#]).TotalHours > 4

Ryan

Much appreciated Ryan, Thanks!

Hi Iuliia, 
You could probably use the "Add element" with "Add from selection" mode selected. It's hard to tell having so few details. If you could tell a bit more details it'd make it easier to suggest something. 
 

Hello Iuliia,
Thank you for your question,

It would be nice if you could provide more details regarding issue that you are facing: your code, business process etc.

Yevhenii Grytsiuk, Yurii Sokil,

the (simplified) business process is next: 

user creates some record in UsrTableName_1 that has StartDate and EndDate, usually they are far apart (for example, long leave of absence, that last up to few month). 

For reporting purposes we need to have these dates stored as separate records, meaning for each date between StartDate and EndDate we need to have separate record added to UsrTableName_2. 

To do so I am able to loop through dates  between StartDate and EndDate and add necessry records one by one (using the code snippet provided by me above) but it is ineficient approach because of the multiple Save calls. 

What I want to do is to calculate all the necesary records, add/attach them and then call Save() only once, so there would be only one call to the DB to write the data. All this should be implemented on backend. Essentially I am looking for similar functionality that is provided by EntityFramework where one can call context.SaveChanges() after adding all records to the context (here is example how EF works https://learn.microsoft.com/en-us/ef/core/saving/basic#multiple-operations-in-a-single-savechanges) 

Does such approach exist in creatio? 

Thanks

Hello,

This behavior can be achieved using the OOB functionality.

This article will help you with the setup: https://academy.creatio.com/docs/8.x/creatio-apps/products/service-tools/service-cases/case-settings/set-up-email-notifications

Please, pay attention to this block: https://academy.creatio.com/docs/8.x/creatio-apps/products/service-tools/service-cases/case-settings/set-up-email-notifications#set-up-contact-case-notification-rules

It will guide you through the necessary settings.

Hanna Skalko, 

Thank you, I will take a look on them

Доброго дня!

На жаль, в контактах не зберігається подібна інформація, тому і вивести її не буде можливим. 

Ми вже зареєстрували побажання на додавання такого функціоналу в майбутніх версіях системи, тому сподіваємось на скорішу реалізацію цього функціоналу. 

Дякуємо, що допомагаєте нам покращувати нашу систему. 

З повагою,
Антон

Дякую за відповідь. Дуже чекаємо на дане доопрацювання.

Hello,

Try the following steps:
1. Log in to your site (not portal) under Supervisor
2. Go to System Settings and select Enable2FA
3. Check the checkbox 'allow reading for portal users'
4. Have the portal user clear the cache and cookies in the browser and try to enter User profile again

That worked! Thanks

Hello Serhiy,

Could you please clarify which step exactly you have problems with? 

Was it possible for you to make the text bold without conditions?

If so then how exactly do you add the specific field value? 

Anhelina writes:

Hello Serhiy,

Could you please clarify which step exactly you have problems with? 

Was it possible for you to make the text bold without conditions?

If so then how exactly do you add the specific field value? 

Thank you for your interest. I have overridden 2 methods: 

initQueryColumns: function(esq) {
	this.callParent(arguments);
 
	esq.addColumn("ModifiedBy.Type.Id", "ModifierType");
 
},
 
prepareResponseCollection: function(collection) {
	this.callParent(arguments);
	// Аor each record returned in the query for the list 		
	// check the Amount field value and then apply style
	collection.each(function(item) {
		if (item.get("ModifierType") == "00783ef6-f36b-1410-a883-16d83cab0980") {
			item.customStyle = Ext.apply(item.customStyle || {}, {
				"background-color": "#FFFFCC",
				"font-weight": "bold"
	        });
		}
	}, this);
}

I understand that I need to change this part of the code:

item.customStyle = Ext.apply(item.customStyle || {}, {
	"background-color": "#FFFFCC",
	"font-weight": "bold"
}

It must be something like this:

.title {
	"background-color": "#FFFFCC",
	"font-weight": "bold"
}

But I have no idea how to apply the style to a specific entry element in the list.

Сергій Сермакшев,

Hello,

Try another approach:

define("CaseSection", [], function() {
	return {
		entitySchemaName: "Case",
		messages: {},
		attributes: {},
		diff: /**SCHEMA_DIFF*/[]/**SCHEMA_DIFF*/,
		methods: {
			onGridDataLoaded: function(response) {
				this.callParent(arguments);
				this.performStylesChange();
			},
 
			performStylesChange: function() {
				var recordTitles = document.getElementsByClassName("grid-primary-column");
				for (var i = 0; i < recordTitles.length; i++) {
					var element = recordTitles[i];
					element.style.fontWeight = 'bold';
				}
			}
		}
	};
});

The logic here is simple: once grid data is loaded we go through all elements on the page and change the style for the text to bold to all title columns (which is a case number). This is not the best solution, but it works properly when the list is loaded or sorting\filtering is changed in the list.

Oleg Drobina writes:

i <

Thank you. For some reason, it complained about "i &lt;" had to delete. Everything worked. 

But how to implement this part of the logic?

if (item.get("ModifierType") == "00783ef6-f36b-1410-a883-16d83cab0980")

It is necessary to highlight only those records where some field matches a specific record in the directory.

Сергій Сермакшев,

Hello. Here is an example. It uses jQuery, but you may easily adapt it to Oleg's example. Main idea is that items[i] is viewModel coresponding to recordTitles[i] DOM element from Oleg's example. 

applyCustomCss: function(){
	var gridData = this.getGridData();
	var items = gridData.getItems();
	var uiItems = $("div[column-name='ColorByProductType']");
 
 
	for (var i = 0; i < items.length; i++){
		var height = $(uiItems[0]).css("height");
		var bgColor;
		var category = items[i].get("Product.SxGoodsCategory").value;
		if (category === SxProductConstants.GoodsCategory.Wine){
			var wineColor = items[i].get("Product.SxColor").value;
			if (wineColor === SxProductConstants.WineColor.Red){
				bgColor = "#cc0a0a";
			}
			else if (wineColor === SxProductConstants.WineColor.White){
				bgColor = "gold";
			}
			else if (wineColor === SxProductConstants.WineColor.Pink){
				bgColor = "pink";
			}
		}
		else if (category === SxProductConstants.GoodsCategory.Champagne){
			bgColor = "bisque";
		}
		else if (category === SxProductConstants.GoodsCategory.StrongAlcoholDrink){
			bgColor = "saddlebrown";
		}
		else if (category === SxProductConstants.GoodsCategory.Water){
			bgColor = "blue";
		}
		$(uiItems[i]).css(
			{"background-color": bgColor, 
			"border-radius": "50%",
			"vertical-align:": "middle",
			"margin-top": "7px",
			"margin-right": "2px",
			"width": height});
	}
},

And instead of oveeriding initQueryColumns method it is better to override getGridDataColumns

                getGridDataColumns: function () {
                   var baseGridDataColumns = this.callParent(arguments);
                   var gridDataColumns = {
                       "ModifiedBy.Type.Id": {path: "ModifiedBy.Type.Id"}
                   };
                   return Ext.apply(baseGridDataColumns, gridDataColumns);
               },

Сергій Сермакшев,

&lt is the html code for < symbol, it's a "feature" of the code editor here in the Community:)

As for ModifierType

We have access to items that will be displayed in the grid and their position will be the same as in the response.collection.collection.items. You can pass response to the performStylesChange method and process it there as well and perform the check for the needed ModifierType and change styles only for those records.

Something like:

define("CaseSection", [], function() {
	return {
		entitySchemaName: "Case",
		messages: {},
		attributes: {},
		diff: /**SCHEMA_DIFF*/[]/**SCHEMA_DIFF*/,
		methods: {
			onGridDataLoaded: function(response) {
				this.callParent(arguments);
				this.performStylesChange(response);
			},
 
			performStylesChange: function(response) {
				var processedItemsIndexes = this.checkResponseCollection(response);
				var recordTitles = document.getElementsByClassName("grid-primary-column");
				for (var i = 0; i < recordTitles.length; i++) {
					for (var j = 0; j < processedItemsIndexes.length; j++) {
						if (processedItemsIndexes[j] == i) {
							var element = recordTitles[i];
							element.style.fontWeight = 'bold';
						}
					}
				}
			},
 
			checkResponseCollection: function(response) {
				var responseItems = response.collection.getItems();
				var processItemsIndexes = [];
				for (var i = 0; i < responseItems.length; i++) {
					if (responseItems[i].values.Status.displayValue == "New") {
						processItemsIndexes.push(i);
					}
				}
				return processItemsIndexes;
			}
		}
	};
});

Here I marked tickets in the New status in bold text:

So you can use the same approach in your task.

Oleg Drobina,

Thank you very much. With your help to solve this problem. It also gave me some insight into working with section entries via JavaScript.
Also, if you don't mind, tell me how to compare the "Contact Type" lookup value in the : "ModifiedBy" field. Something like  "ModifiedBy.Type.Id". Thank you again.

Сергій Сермакшев,

You are welcome!

As for ModifiedBy.Type - the easiest way is to display this column in the section list.

Alternatively you can add the initQueryColumns method override to the section methods in the following manner:

initQueryColumns: function(esq) {
				this.callParent(arguments);
				esq.addColumn("Owner.Type", "OwnerType");
			},

What I did here is add the Owner.Type column in the Cases section esq (Case has an Assignee (which is the Owner column that references the Contact entity) and I need to check the contact type specified in this column). As a result

we have access to this OwnerType in the context of the onGridDataLoaded and performStylesChange execution. We can also use it for style recalculation. In your case it should be similar but using another column. 

Oleg Drobina,

You are great. Everything worked out.

Hello,



The issue is already fixed in version 8.1.2, so we recommend to update your application.

If you require the fix for 8.1.1 please contact support team on this matter.

Bogdan,

Thank you, We are currently on 8.1.1.3635.

I will plan an update.

Hello,



If I understand your business task correct, you can set up the filter for the list component itself:

@Bogdan

Thank you for you reply

But unfortunately we need to dynamically set up filter.

Case:

1. User opens our card (like setting entity)

2. User configures a filter to search for records to apply some logic (like conditions to execute some server-side logic)

Joseph D,

Thank you for clarifying. We don't have such ready examples of implementing your business task. 



It could be achieved only through additional development.

Bogdan,

Thank you.

Is there any development tips? :)