Here is an example of code for the detail that will input values from the custom array into the detail. Please also note that this approach will only work if the detail contains at least 1 record (in case there are no records you will need to click the button twice for the array content to be displayed in the page). Also don't forget to add the LoadGridButtonCaption localizable string to your detail schema:

define("UsrSchema130af5ebDetail", [], function() {
	return {
		entitySchemaName: "UsrTestDetail",
		details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
		attributes: {
			IsGridEmpty: {
                    dataValueType: this.Terrasoft.DataValueType.BOOLEAN,
                    value: true
                }
		},
		diff: /**SCHEMA_DIFF*/[
			{
                "operation": "insert",
                "name": "LoadGridButton",
                "parentName": "Detail",
                "propertyName": "tools",
                "values": {
                    "itemType": Terrasoft.ViewItemType.BUTTON,
                    "caption": {"bindTo": "Resources.Strings.LoadGridButtonCaption"},
                    "click": {"bindTo": "onLoadGridButtonClick"},
                    "style": Terrasoft.controls.ButtonEnums.style.TRANSPARENT
                }
            }
		]/**SCHEMA_DIFF*/,
		methods: {
			onLoadGridButtonClick: function() {
				//object to load data from
				var object = [
					{
						UsrName: "1111",
						UsrIntColumn: 1
					},
					{
						UsrName: "Test2",
						UsrIntColumn: 24
					}
				];
				//create view model for the object items
				var newCollection = Ext.create("Terrasoft.Collection");
				Terrasoft.each(object, function(item, key) {
					var model = Ext.create("Terrasoft.BaseViewModel", {
						rowConfig: {
							Id: {
								columnPath: "Id",
								dataValueType: Terrasoft.DataValueType.GUID
							},
							UsrName: {
								columnPath: "UsrName",
								dataValueType: Terrasoft.DataValueType.TEXT
							},
							UsrIntColumn: {
								columnPath: "UsrIntColumn",
								dataValueType: Terrasoft.DataValueType.INTEGER
							}
						},
						values: {
							Id: Terrasoft.generateGUID(),
							UsrName: item.UsrName,
							UsrIntColumn: item.UsrIntColumn,
						}
					}, this);
					newCollection.add(model.get("Id"), model);
				});
				//add new collection items from the created model
 
 
				//get current Grid collection
				var collection = this.get("Collection");
				//empty current Grid collection
				collection.clear();
				//add Grid collection items from the new collection
				collection.loadAll(newCollection);
				//specify that Grid data is loaded
				this.set("IsGridEmpty", false);
			}
		}
	};
});

Oleg Drobina,

It works, Thanks a lot.

Hello Abderrahman Tigami,

I have successfully configured and generated Excel reports using the current version of the app. I kindly ask you to provide more details how to reproduce your issue (version of Creatio instance, report type, any section or specific one).

Satyam, 

Have you checked the product selection in the order module ?

The object cannot be directly taken from the component in the Freedom UI designer but you can use it if you set as parent the "Base entity catalog page (BaseEntityCatalogPage)" page in your page. 

As restult you will get a hierarchy tree and then you can customize the page as needed. I tried it with the case object and using the account and contact in the hierarchy.

Hi Federica,

This process is assigning the access to all employees.

You can create a new version with appropriate access rights you want to apply.

I hope this helps!

Thanks Franck! Smart idea :)

Yes. These were a part of 8.1.2.

https://academy.creatio.com/docs/8.x/resources/release-notes/812-quantu…
Ryan 

Ryan Farley,

Thanks Ryan, I saw that it is a new component, I was looking for it in the DCM, as in Classic UI. :-)

Hello,

From the code I can suppose that the undefined value is in the UsrPR column and it happens because the addRecord method triggers before the record values are filled in and the record is actually added (the method is triggered once the + button to add a record is clicked).

In case you need to get the value for the lookup column that links the detail to the main section you can use

this.values.DefaultValues
 

to get the value for the main section record (in the screenshot below the detail is added to the CasePage and the main entity is Case, the lookup column to connect detail to the main section in the detail is UsrCase):

You can create an exists filter by using something like the following. This example would get accounts where an activity exists with a particular owner.

// create the sub filter for the condition inside the exists
var subFilters = Terrasoft.createFilterGroup();
subFilters.addItem(Terrasoft.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, "Owner", "a6b4ea0c-420c-45ab-81e7-6e76c8cc15f7"));
 
// now create the exists filter and pass the sub filter conditions to it
// note, this second param of subFilters is optional if all you want is the exists without sub conditions
var existsFilter = Terrasoft.createExistsFilter("[Activity:Account].Id", subFilters);
esq.filters.addItem(existsFilter);

That is the equivalent to the following:

Ryan

Ryan Farley,

I am sincerely grateful to you. With your help, other answers in the community and articles from the Academy, I learned and managed to write this complex filter. Thank you. The code currently looks like this:

attributes: {
	"UsrPlatform": {
		"dataValueType": Terrasoft.DataValueType.LOOKUP,
		"lookupListConfig": {
			"filter": function() {
				var platformFilter = this.Ext.create("Terrasoft.FilterGroup");
				var accountId = this.get("Account").value;
 
				var licenceFilter = Terrasoft.createExistsFilter(
					"[UsrLicenceClient:UsrProductLic].Id");
 
				licenceFilter.subFilters.addItem(
					Terrasoft.createColumnFilterWithParameter(
						Terrasoft.ComparisonType.EQUAL,
							"UsrAccount", accountId));
 
				var productFilter = Terrasoft.createExistsFilter(
					"[Product:UsrPlatform].Id", licenceFilter);
					platformFilter.addItem(productFilter);
				return platformFilter;
			}
		}
	}
}

I hope it helps someone and saves a lot of time.

You can include values from the page as default values for the detail by modifying the detail definition on the page. 

details: {
    MyDetailSchema: {
        schemaName: "MyDetailSchema",
        entitySchemaName: "MyObject",
        filter: {
            masterColumn: "Id",
            detailColumn: "MyObject"
        },
        defaultValues: {
            UsrSomeName: {masterColumn: "UsrName"},
            UsrSomeDate: {masterColumn: "CreatedOn"}
        }
    }
}

The above will populate the UsrSomeName column on the detail with the value of the UsrName column on the current page and also populate UsrSomeDate on the detail using the value of the CreatedOn of the page. 

You can also use values that don't exist on the page, for example: 

"defaultValues": {
   "UsrSomeDate": { "value": new Date() }
}

Ryan

thank  you, Ryan.

But something wrong.

my page's default:

When I boot page, my parametr "CtsTuOpport" is undefined:

Hi,
The code Ryan provided worked for me, what it does, is automatically fill the detail column when you create a new page:

details: /**SCHEMA_DETAILS*/{
            "Schema685740a4Detail9ea5ec10": {
                "schemaName": "Schema685740a4Detail",
                "entitySchemaName": "TestDet",
                "filter": {
                    "detailColumn": "Order",
                    "masterColumn": "Id"
                },
                "defaultValues": {
                   "UsrSomeDate": {masterColumn: "CreatedOn"}
               }
            }

Perhaps the issue in your case is that you didn't use the "" brackets.

Thanks for reply

Dmytro Vovchenko, tell me, where is the sintaxis trouble, please:

        details: /**SCHEMA_DETAILS*/{
            "GenFinanceOperations_Detail2cec2e66": {
                "schemaName": "GenFinanceOperations_Detail",
                "entitySchemaName": "GenFinanceOperations",
                "filter": {
                    "detailColumn": "GenTuInspector",
                    "masterColumn": "GenCheckFinOper",
                },
               "defaultValues": {
                  "GenTuInspected":  {masterColumn: true}
              }
            }
        }/**SCHEMA_DETAILS*/,
 

I need set parametr "true" for the calling detail

There was a discussion about this - https://community.creatio.com/questions/change-dcm-record-automaticly

No, diff cannot be loaded based on conditions (only properties like visible or enabled can be changed using conditions, but not blocks of code).

The best approach is to add a boolean attribute on the LinkPageV2

attributes: {
	"IsForAccount": {
		dataValueType: Terrasoft.DataValueType.BOOLEAN,
		columnType: Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN,
		value: false
	}
}

Then bind it to the visible property of the element in the diff

{ //...
    "visible": { "bindTo": "IsForAccount" }
}

On the page init check what the entity type is for the page and set the boolean: 

init: function() {
	this.callParent(arguments);
	this.set("IsForAccount", this.get("entitySchemaName") === "AccountFile");
}

Using this approach will work since the value will never get submitted when saved.

Ryan