I am trying to add Virtual Detail that will contain records which don't exist in DataBase.

Now I have Detail connected to Object "Card" and After clicking Get card I am calling Get method which returns Data which I Parse in my Detail . But records exists in DataBase and i want to make it virtual.

 

I am following https://community.creatio.com/articles/add-virtual-detail-page,

1.I Created Virtual Object .

2. I did not created service while we are making API call which will returns Data. 

3. I Created virtual detail. 

4. I Insert virtual detail into Contact page.

Error: As we see in collection there is my data and thats fine but I can not read Column in virtual Object. 

 

Please help how can i solve this issue and how to add virtual detail in proper way

Like 0

Like

2 comments

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.

Show all comments

How can I solve this block in the localhost environment?

Like 0

Like

2 comments

Hello,

Please note that the error "Cannot add more than 1000 records to table "%" in demo mode" means that your environment works in a demo mode, which is the only way a site can work without licenses. In the demo mode, there are certain restrictions on working with data, specifically a maximum number of a 1k records in a table, and your process seems to be trying to add more records than that, hence the error.

So, to solve it, you have to apply licenses to the instance.

 

Best regards,
Mariia

I thought we would have full access to prepare an environment as partners with localhost, and in the end just import the package on the client's server.
But ok, thanks for the answer Mariia.

Show all comments

Hi everyone,

I hope you're all doing well. I'm currently working on exporting an Excel report of section data and its details in Creatio. I found a package named IntExcelExport in the Creatio marketplace, which seemed perfect for my needs.

However, I ran into an issue while trying to configure the report. Whenever I try to set it up, I get the following error:

"Cannot read properties of null (reading 'isTiled')"

I've tried several times, but I keep encountering the same problem. Has anyone else experienced this issue or have any insights on how to resolve it?

 

Any guidance or suggestions would be greatly appreciated!

Thank you in advance for your help.

Like 0

Like

1 comments

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).

Show all comments

Hi Creatio Community,

 

I am currently working on a project in Creatio Freedom UI and need to implement a tree view for a section or detail. This functionality is essential for displaying data hierarchically and enhancing user navigation.

Could anyone provide guidance or share any documentation, examples, or best practices on how to achieve this in Creatio Freedom UI? Your assistance would be greatly appreciated.

Thank you in advance for your help.

Like 1

Like

1 comments

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.

 

inherit from base entity catalog page

 

Set the option on the hierarchy tree

Show all comments

Hi,

 

I have to implement validations on the editable detail of a section. For the purpose, I am using addRecord

But while I am trying to get the value of the lookup field which is connecting the records to the main section, it is returning undefined.

 

Please refer below code:

addRecord: function()

{

     this.DurationValidation();

     this.callParent(arguments);

}
DurationValidation : function()
            {
                var invalidMessage="";
                try
                {
                     var esqDuration = this.Ext.create("Terrasoft.EntitySchemaQuery", {
                    rootSchemaName: "UsrPRDetail"
                });
                esqDuration.addColumn("UsrDurationmin");
                var groupFilters = this.Ext.create("Terrasoft.FilterGroup");
                var currentPR = this.get("UsrPR");
                console.log(currentPR);
                var filterId = this.Terrasoft.createColumnFilterWithParameter(this.Terrasoft.ComparisonType.EQUAL, "UsrPR", currentPR);
                groupFilters.addItem(filterId);
                esqDuration.filters.add(groupFilters);
                esqDuration.getEntityCollection(function(result) {
                    if (!result.success) {
                        this.showInformationDialog("Request error");
                        return;
                    } else {
                        var totalDuration = 0;
                        result.collection.each(function(item) {
                            totalDuration += item.get("UsrDurationmin");
                        });
                        this.set("totalSessionDuration", totalDuration);
                        
                        console.log(totalDuration);
                        this.showInformationDialog(totalDuration);
                         invalidMessage = this.get('Resources.Strings.DurationLimitExceeded');
                        this.showInformationDialog(invalidMessage);
                    }
                }, this);
                }
                catch(e)
                {
                    console.log(e);
                }
                finally
                {
                    return {
                        invalidMessage: invalidMessage
                    };
                }   
            }

 

 

Due to this undefined value, I am not able to check the total duration of details elements in current section record. Please guide in this regard.

Like 0

Like

1 comments

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):

Show all comments

When we are creating a case using single object, the cases are getting created. But when we are trying to create using multiple objects we are getting the null response. I'm posting the requests and response and the screenshots below.

Like 0

Like

2 comments
Best reply

Hello,

 

The InsertQuery endpoint in the DataService doesn't support an array of objects in the body. If you are using InsertQuery for data creation, you can pass only one record (object) in the body. You can use BatchQuery, which contains an array of InsertQueries, or other endpoints of the DataService to create multiple records.

 

More information about DataService can be found here: https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/dataservice-references

 

But I recommend using the OData v4 API for data access from an integration. You can find additional information about OData v4 in the Creatio Academy article here: https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/category/odata

 

Also here is a body for the BatchQuery (example) to insert two case records into the system (maybe it will be helpful). The endpoint to call is /0/DataService/json/SyncReply/BatchQuery (POST request):

{
   "items":[
      {
         "__type":"Terrasoft.Nui.ServiceModel.DataContract.InsertQuery",
         "operationType":1,
         "rootSchemaName":"Case",
         "columnValues":{
            "items":{
               "CreatedBy":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"Supervisor",
                        "primaryColorValue":null,
                        "value":"410006e1-ca4e-4502-a9ec-e54d922d2c00"
                     }
                  }
               },
               "ModifiedBy":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"Supervisor",
                        "primaryColorValue":null,
                        "value":"410006e1-ca4e-4502-a9ec-e54d922d2c00"
                     }
                  }
               },
               "Number":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":null
                  }
               },
               "Subject":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":"Test (from Postman 1)"
                  }
               },
               "Symptoms":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":null
                  }
               },
               "Owner":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "ResponseDate":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "SolutionDate":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "Status":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"New",
                        "primaryColorValue":"#0058EF",
                        "value":"ae5f2f10-f46b-1410-fd9a-0050ba5d6c38"
                     }
                  }
               },
               "Priority":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"Medium",
                        "primaryColorValue":null,
                        "value":"d9bd322c-f46b-1410-ee8c-0050ba5d6c38"
                     }
                  }
               },
               "Origin":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"Call",
                        "primaryColorValue":null,
                        "value":"5e5e202a-f46b-1410-3692-0050ba5d6c38"
                     }
                  }
               },
               "Account":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "Contact":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "IsChanged":false,
                        "PrimaryModelMode":"update",
                        "HasUnsavedData":false,
                        "value":"c4ed336c-3e9b-40fe-8b82-5632476472b4",
                        "displayValue":"Andrew Baker (sample)",
                        "State":"Active"
                     }
                  }
               },
               "Group":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "RespondedOn":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "SolutionProvidedOn":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "ClosureDate":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "ClosureCode":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "Solution":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":null
                  }
               },
               "SatisfactionLevel":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "Category":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "SatisfactionLevelComment":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":null
                  }
               },
               "ServiceItem":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "ServicePact":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "FirstSolutionProvidedOn":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "SolvedOnSupportLevel":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "SupportLevel":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"1st-line support",
                        "primaryColorValue":null,
                        "value":"ff7f2f92-f36b-1410-3d9c-0050ba5d6c38"
                     }
                  }
               },
               "ParentCase":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               }
            }
         },
         "queryKind":0
      },
      {
         "__type":"Terrasoft.Nui.ServiceModel.DataContract.InsertQuery",
         "operationType":1,
         "rootSchemaName":"Case",
         "columnValues":{
            "items":{
               "CreatedBy":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"Supervisor",
                        "primaryColorValue":null,
                        "value":"410006e1-ca4e-4502-a9ec-e54d922d2c00"
                     }
                  }
               },
               "ModifiedBy":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"Supervisor",
                        "primaryColorValue":null,
                        "value":"410006e1-ca4e-4502-a9ec-e54d922d2c00"
                     }
                  }
               },
               "Number":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":null
                  }
               },
               "Subject":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":"Test (from Postman 2)"
                  }
               },
               "Symptoms":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":null
                  }
               },
               "Owner":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "ResponseDate":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "SolutionDate":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "Status":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"New",
                        "primaryColorValue":"#0058EF",
                        "value":"ae5f2f10-f46b-1410-fd9a-0050ba5d6c38"
                     }
                  }
               },
               "Priority":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"Medium",
                        "primaryColorValue":null,
                        "value":"d9bd322c-f46b-1410-ee8c-0050ba5d6c38"
                     }
                  }
               },
               "Origin":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"Call",
                        "primaryColorValue":null,
                        "value":"5e5e202a-f46b-1410-3692-0050ba5d6c38"
                     }
                  }
               },
               "Account":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "Contact":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "IsChanged":false,
                        "PrimaryModelMode":"update",
                        "HasUnsavedData":false,
                        "value":"c4ed336c-3e9b-40fe-8b82-5632476472b4",
                        "displayValue":"Andrew Baker (sample)",
                        "State":"Active"
                     }
                  }
               },
               "Group":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "RespondedOn":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "SolutionProvidedOn":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "ClosureDate":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "ClosureCode":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "Solution":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":null
                  }
               },
               "SatisfactionLevel":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "Category":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "SatisfactionLevelComment":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":null
                  }
               },
               "ServiceItem":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "ServicePact":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "FirstSolutionProvidedOn":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "SolvedOnSupportLevel":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "SupportLevel":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"1st-line support",
                        "primaryColorValue":null,
                        "value":"ff7f2f92-f36b-1410-3d9c-0050ba5d6c38"
                     }
                  }
               },
               "ParentCase":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               }
            }
         },
         "queryKind":0
      }
   ],
   "includeProcessExecutionData":true
}

Hello,

 

The InsertQuery endpoint in the DataService doesn't support an array of objects in the body. If you are using InsertQuery for data creation, you can pass only one record (object) in the body. You can use BatchQuery, which contains an array of InsertQueries, or other endpoints of the DataService to create multiple records.

 

More information about DataService can be found here: https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/dataservice-references

 

But I recommend using the OData v4 API for data access from an integration. You can find additional information about OData v4 in the Creatio Academy article here: https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/category/odata

 

Also here is a body for the BatchQuery (example) to insert two case records into the system (maybe it will be helpful). The endpoint to call is /0/DataService/json/SyncReply/BatchQuery (POST request):

{
   "items":[
      {
         "__type":"Terrasoft.Nui.ServiceModel.DataContract.InsertQuery",
         "operationType":1,
         "rootSchemaName":"Case",
         "columnValues":{
            "items":{
               "CreatedBy":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"Supervisor",
                        "primaryColorValue":null,
                        "value":"410006e1-ca4e-4502-a9ec-e54d922d2c00"
                     }
                  }
               },
               "ModifiedBy":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"Supervisor",
                        "primaryColorValue":null,
                        "value":"410006e1-ca4e-4502-a9ec-e54d922d2c00"
                     }
                  }
               },
               "Number":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":null
                  }
               },
               "Subject":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":"Test (from Postman 1)"
                  }
               },
               "Symptoms":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":null
                  }
               },
               "Owner":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "ResponseDate":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "SolutionDate":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "Status":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"New",
                        "primaryColorValue":"#0058EF",
                        "value":"ae5f2f10-f46b-1410-fd9a-0050ba5d6c38"
                     }
                  }
               },
               "Priority":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"Medium",
                        "primaryColorValue":null,
                        "value":"d9bd322c-f46b-1410-ee8c-0050ba5d6c38"
                     }
                  }
               },
               "Origin":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"Call",
                        "primaryColorValue":null,
                        "value":"5e5e202a-f46b-1410-3692-0050ba5d6c38"
                     }
                  }
               },
               "Account":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "Contact":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "IsChanged":false,
                        "PrimaryModelMode":"update",
                        "HasUnsavedData":false,
                        "value":"c4ed336c-3e9b-40fe-8b82-5632476472b4",
                        "displayValue":"Andrew Baker (sample)",
                        "State":"Active"
                     }
                  }
               },
               "Group":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "RespondedOn":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "SolutionProvidedOn":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "ClosureDate":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "ClosureCode":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "Solution":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":null
                  }
               },
               "SatisfactionLevel":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "Category":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "SatisfactionLevelComment":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":null
                  }
               },
               "ServiceItem":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "ServicePact":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "FirstSolutionProvidedOn":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "SolvedOnSupportLevel":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "SupportLevel":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"1st-line support",
                        "primaryColorValue":null,
                        "value":"ff7f2f92-f36b-1410-3d9c-0050ba5d6c38"
                     }
                  }
               },
               "ParentCase":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               }
            }
         },
         "queryKind":0
      },
      {
         "__type":"Terrasoft.Nui.ServiceModel.DataContract.InsertQuery",
         "operationType":1,
         "rootSchemaName":"Case",
         "columnValues":{
            "items":{
               "CreatedBy":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"Supervisor",
                        "primaryColorValue":null,
                        "value":"410006e1-ca4e-4502-a9ec-e54d922d2c00"
                     }
                  }
               },
               "ModifiedBy":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"Supervisor",
                        "primaryColorValue":null,
                        "value":"410006e1-ca4e-4502-a9ec-e54d922d2c00"
                     }
                  }
               },
               "Number":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":null
                  }
               },
               "Subject":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":"Test (from Postman 2)"
                  }
               },
               "Symptoms":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":null
                  }
               },
               "Owner":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "ResponseDate":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "SolutionDate":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "Status":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"New",
                        "primaryColorValue":"#0058EF",
                        "value":"ae5f2f10-f46b-1410-fd9a-0050ba5d6c38"
                     }
                  }
               },
               "Priority":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"Medium",
                        "primaryColorValue":null,
                        "value":"d9bd322c-f46b-1410-ee8c-0050ba5d6c38"
                     }
                  }
               },
               "Origin":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"Call",
                        "primaryColorValue":null,
                        "value":"5e5e202a-f46b-1410-3692-0050ba5d6c38"
                     }
                  }
               },
               "Account":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "Contact":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "IsChanged":false,
                        "PrimaryModelMode":"update",
                        "HasUnsavedData":false,
                        "value":"c4ed336c-3e9b-40fe-8b82-5632476472b4",
                        "displayValue":"Andrew Baker (sample)",
                        "State":"Active"
                     }
                  }
               },
               "Group":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "RespondedOn":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "SolutionProvidedOn":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "ClosureDate":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "ClosureCode":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "Solution":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":null
                  }
               },
               "SatisfactionLevel":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "Category":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "SatisfactionLevelComment":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":1,
                     "value":null
                  }
               },
               "ServiceItem":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "ServicePact":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "FirstSolutionProvidedOn":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":7,
                     "value":null
                  }
               },
               "SolvedOnSupportLevel":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               },
               "SupportLevel":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":{
                        "displayValue":"1st-line support",
                        "primaryColorValue":null,
                        "value":"ff7f2f92-f36b-1410-3d9c-0050ba5d6c38"
                     }
                  }
               },
               "ParentCase":{
                  "expressionType":2,
                  "parameter":{
                     "dataValueType":10,
                     "value":null
                  }
               }
            }
         },
         "queryKind":0
      }
   ],
   "includeProcessExecutionData":true
}

Thank you,it is working as expected 

Show all comments

I want to know my client secret in creatio studio's system settings, but it is encrypted how can I know what it is to integrate my application with creatio

Like 1

Like

1 comments

Hello!

You cannot decrypt the encrypted field. 
The data in the secret field is hidden because it contains confidential information for a specific system. 
You don't need the secret key from system settings to set up OAuth integration. Please follow the instructions provided to resolve the issue:
https://academy.creatio.com/docs/8.x/setup-and-administration/on-site-d…

Show all comments

Hi Creatio Community,

I am currently facing an issue with the graphical representation of data in Creatio and would appreciate any advice or solutions you might have.
 

I am trying to demonstrate the data of each month every year using a graph. However, due to the large volume of data, the graph becomes cluttered and the data points overlap, making it difficult to read.

Is there a way to make the graph scrollable in Creatio, or any other method to represent the data in such a way that it becomes more readable and less cluttered?

 

Like 1

Like

1 comments

does the graph need to span such a wide period? Could you not have a graph for each year and one which compares all the years? Try also changing the graph to a bar so the period runs vertically.

Show all comments

Hello Creatio Community,

I am currently working with two sections in Creatio: "Contact" and "Line Item." Both sections contain a common field, "Territory ID." My goal is to ensure that whenever a User opens the "Line Item" section, they can only access those records where the "Territory ID" matches the "Territory ID" of their contact.

The challenge I'm facing is that the "Line Item" section contains more than 3 million records, and using a business process to apply permission on these records is taking a considerable amount of time.

Could anyone suggest a more efficient way to achieve this filtering? Any advice, examples, or insights would be greatly appreciated.

Like 1

Like

3 comments

Hello!

 

Please note that such logic can be implemented only by creating a business process. 

 

Best regards,

Mariia

Hi Team,

 

With our current process taking days to run, the system is overloaded. We need a faster solution. Can you propose an alternative approach?

Hello!

Could you please clarify how you imagine this being implemented? Do we need to restrict access rights to the entire record or just to specific fields, since the values of the fields can be hidden at the client logic level?

Show all comments

I am writing to request assistance with applying a filter on a lookup field within a detail while performing inline editing of a record on a Freedom UI page in Creatio. The object of this detail resides in the Classic UI.

Could you please provide guidance on how to achieve this functionality? Any examples, documentation, or step-by-step instructions would be greatly appreciated.

Thank you

Like 0

Like

1 comments

Hello,

 

Please note that this can be setup with the help of business rules, you can find the detailed instructions in this Academy article:
https://academy.creatio.com/docs/8.x/no-code-customization/customization-tools/ui-and-business-logic-customization/freedom-ui-business-rules


You can set it up either for the detail element or for the object itself, you can try the latter to achieve your business goal.

Show all comments