Hello Patrice,

it seems like you added some data to the model which cannot be correctly proccessed. There is a chance it was a column with the type "Date" which cannot be operated automatically.

To fix this, you need to delete the "StartDateLastStage" column from the request for the machine learning model.

Regards,

Gleb.

Hi Gleb,

thanks for your answer.

in "Advanced tools for adding columns", i deleted the StartDateLastStage part in the sql query : 

the model works now.

Though I'm not sure what happened, as the model is a OOB one which was not modified from our side.

Best regards

Patrice

Patrice-ABPost,

thnks for letting me know.

I will pass this information to the dev team so they can take a look.

Regards,

Gleb.

mmh, after all it does not seems to work so well :

the model testing is ok, but when using [Predict data] process element, an error occur, i must have messed up the model.

Maybe i should start from a fresh new model, or maybe use the 7.14.0 version of the model, which is available in the model collection.

System.AggregateException: One or more errors occurred. ---> Terrasoft.Web.Http.Abstractions.HttpException: [InternalServerError] {"responseStatus":{"errorCode":"InternalServerError","message":"Engine: [UsageException] ['CreatedOn']: Column(s) ['CreatedOn']] contain missing values"}} ---> System.Exception: {"responseStatus":{"errorCode":"InternalServerError","message":"Engine: [UsageException] ['CreatedOn']: Column(s) ['CreatedOn']] contain missing values"}}
   --- End of inner exception stack trace ---
   at Terrasoft.Configuration.ML.MLServiceProxy.TransformResponseErrorByStatus(IRestResponse response)
   at Terrasoft.Configuration.ML.MLServiceProxy.Post[T](String methodName, Object requestBody, Int32 timeoutSec)
   at Terrasoft.Configuration.ML.MLServiceProxy.Predict[TOut](Guid modelInstanceUId, String methodName, PredictionInput predictionParams, Int32 timeoutSec)
   at Terrasoft.Configuration.ML.MLServiceProxy.Predict[TOut](Guid modelInstanceUId, IList`1 dataList, String methodName, DatasetInput defaultPredictionParams, Int32 timeoutSec)
   at Terrasoft.Configuration.ML.MLServiceProxy.Score(MLModelConfig model, IList`1 dataList, Boolean predictContributions)
   at Terrasoft.Configuration.ML.MLBaseEntityPredictor`1.Predict(MLModelConfig modelConfig, IList`1 dataList, MLDataPredictionUserTask predictionUserTask)
   at Terrasoft.Configuration.ML.MLBatchPredictor`1.Predict(MLModelConfig model, IList`1 dataList, MLDataPredictionUserTask predictionUserTask)
   at Terrasoft.Configuration.ML.MLBatchPredictor`1.<>c__DisplayClass17_0.<Predict>b__0(IList`1 dataForPrediction)
   --- End of inner exception stack trace ---
   at Terrasoft.Configuration.ML.MLBatchPredictor`1.Predict(MLModelConfig modelConfig, Action`1 chunkPredictedHandler, MLDataPredictionUserTask predictionUserTask)
   at Terrasoft.Configuration.ML.MLBatchPredictionJob.PredictAndSaveResult(MLModelConfig model, UserConnection userConnection, MLDataPredictionUserTask predictionUserTask)
   at Terrasoft.Configuration.ML.MLBatchPredictionJob.ProcessModel(UserConnection userConnection, Guid modelId, String filterData, MLDataPredictionUserTask predictionUserTask)
   at Terrasoft.Core.Process.Configuration.MLDataPredictionUserTask.InternalExecute(ProcessExecutingContext context)
   at Terrasoft.Core.Process.ProcessActivity.RunInCultureScope[T](Func`1 action)
   at Terrasoft.Core.Process.ProcessActivity.ExecuteElement(ProcessExecutingContext context)
   at Terrasoft.Core.Process.ProcessActivity.ExecuteItem(ProcessExecutingContext context)
   at Terrasoft.Core.Process.ProcessFlowElement.Execute(ProcessExecutingContext context)
---> (Inner Exception #0) Terrasoft.Web.Http.Abstractions.HttpException (0x80004005): [InternalServerError] {"responseStatus":{"errorCode":"InternalServerError","message":"Engine: [UsageException] ['CreatedOn']: Column(s) ['CreatedOn']] contain missing values"}} ---> System.Exception: {"responseStatus":{"errorCode":"InternalServerError","message":"Engine: [UsageException] ['CreatedOn']: Column(s) ['CreatedOn']] contain missing values"}}
   at Terrasoft.Configuration.ML.MLServiceProxy.TransformResponseErrorByStatus(IRestResponse response)
   at Terrasoft.Configuration.ML.MLServiceProxy.Post[T](String methodName, Object requestBody, Int32 timeoutSec)
   at Terrasoft.Configuration.ML.MLServiceProxy.Predict[TOut](Guid modelInstanceUId, String methodName, PredictionInput predictionParams, Int32 timeoutSec)
   at Terrasoft.Configuration.ML.MLServiceProxy.Predict[TOut](Guid modelInstanceUId, IList`1 dataList, String methodName, DatasetInput defaultPredictionParams, Int32 timeoutSec)
   at Terrasoft.Configuration.ML.MLServiceProxy.Score(MLModelConfig model, IList`1 dataList, Boolean predictContributions)
   at Terrasoft.Configuration.ML.MLBaseEntityPredictor`1.Predict(MLModelConfig modelConfig, IList`1 dataList, MLDataPredictionUserTask predictionUserTask)
   at Terrasoft.Configuration.ML.MLBatchPredictor`1.Predict(MLModelConfig model, IList`1 dataList, MLDataPredictionUserTask predictionUserTask)
   at Terrasoft.Configuration.ML.MLBatchPredictor`1.<>c__DisplayClass17_0.<Predict>b__0(IList`1 dataForPrediction)<---

Hi Eran,

Here is how you should write a set function:

set(columnName, value, fireEventConfig)

Here is an example of how to set lookup fields:

record.set("ActivityCategory", ActivityCategory.Store.getById("8b16d130-313e-4b12-a12e-73a2dd8d33cf"), true);

Please note, the value parameter should always contain a record, if this lookup is not loaded in your mobile app then you should do a request to a database in order to get it instead of Store.getById.

Thanks Dmytro,

You are right, I needed to request the database to fetch the lookup record, and only then I could use the  " set(columnName, <lookup record>, fireEventConfig)  "

Hello Nicolas,

Since other email clients work as expected - it seems that the issue is limited to iOS and not connected to Creatio specifically.

I tried looking for similar problems on the web. Here is an example, perhaps you have a similar issue:

https://discussions.apple.com/thread/7491137

Best Regards,

Dan

Hello,

Patrice from the Nicolas team here.

This issue is not resolved from our side, so i tried to investigate a bit more about it :



I tried sending an email with attachment from Creatio, then read it from an iPhone.

Then sent  an email with same attachment from thunderbird.

The email sent from Creatio do no show the attachment, while the one sent from thunderbird works fine.



Having a look at the email source show some differences around the MIME structure :

the email sent from thunderbird has that structure :

Content-Type: multipart/mixed;

Content-Type: text/plain;

Content-Type: application/pdf;

The email sent from Creatio has that structure : 

Content-Type: multipart/related;

Content-Type: multipart/alternative;

Content-Type: text/plain;

Content-Type: application/pdf;

according to that documentation https://learn.microsoft.com/en-us/previous-versions/office/developer/ex…

it seems that Creatio should use multipart/mixed as root..

So depending of the email client, the attachment may show or not. 

I'm not 100% sure of this as i'm not used to that topic, but maybe it's worth checking ?

Best regards

Patrice

Patrice-ABPost,

Is the issue reproducing only on IOS?

Hello Bogdan,

yes, so far, there is no complains with other  platform..

Hello, 



Please check the discussion regarding your question here.

Bogdan,

Hello Bogdan, 

Thank you for your response.

But I wanted to reload the detail in Freedom UI, the detail is in the form page and on click of '+' we add the new details which is in other form

Once I save the details the page automatically moves the parent form page. But the detail is not refreshed, Only the record gets added to the detail.

I wanted to refresh entire detail after click of Save while saving a new record in child form.

const handlerChain = sdk.HandlerChainService.instance;

                             await handlerChain.process({

                            type: "crt.LoadDataRequest",

                            $context: request.$context,

                            config: {

                                loadType: "reload"

                            },

                            dataSourceName: "datasourcename"

                        });

This works in the current form page. But i wanted to refresh the detail in parent form page once I click on save button in child form page.

GargeyiGnanasekhar,

Unfortunately, we don't have ready examples of the implementation of your business task.

We've registered it in our R&D team backlog for consideration and implementation in future application releases.

Thank you for helping us to improve our product. 

Hi,

Please use a business process in this case to read all remaining records from the detail and update their values that will be triggered upon record deletion from the object of this detail. It's much easier than trying to create a UI logic using DeleteRecordReqeust.

Oleg Drobina,

Hello Oleg, 

I have almost implemented functionality in the client schema under deleteRecordRequest handler. Right now the functionality is working irrespective of the confirmation option choosen, It works even when we click No from the confirmation box. 

I wanted to make the functionality to work only if I click "Yes" from the confirmation box. 

Is it possible to read the option chosen by user while deleting a record(either Yes or No) in the handler?

Thanks

GargeyiGnanasekhar,

What I've observed from the behavior is that the DeleteRecordRequest is called twice: once you click delete button and once you select one of the yes\no options. Then I was trying to find a difference in either requests contexts or in the requests, but there is none or it's not obvious. And finally if we take a look at the initiator of the GetCanDelete method (that is called once you hit the "Yes" option) it's also not obvious who calls it:

I really tried to find a place in the code that could be overriden, but it seems that it's impossible to do in the current version (tested in 8.0.6). That's why I've asked to use a business process instead.

If you want to initiate the delete from your own code, you can use the Model class for that. See https://customerfx.com/article/deleting-a-record-from-client-side-code-…

If you're handling the crt.DeleteRecordsRequest you could simply not call the "next" handler in the chain. Basically, only call this if the answer is yes: await next?.handle(request); 

Ryan

Hello,

Could you please provide us with an example of the InsertQuery which is not working?

Hello,

Object name is ContactInFolder. If you try to catch an event ( when contact is added to a Static Folder) through a Business Process, the business Process wont trigger.

My question is how to catch the event of adding Contacts to a Static Folder?

Sasori Oshigaki,

Hello,

And is the option with the business process with the timer that starts each 1 hour and reads records that were created in the previous 1 hour suitable here? You can read data and process it in this way. 

Hello Oleg,

Thats the solution we are providing for the moment. Thought that it was better to do something more performant, that doesnt overload the system by executing each hour.

Thank you

Hello,

Besides the option that Oleg provided, another variant is to create a trigger in the DB because normal events like OnInserted won't work with INSERT INTO.

Hello Dmytro,

Thank you for your answer. Is there anywhere in the system a similiar implementation of a trigger, so that we can take it as a reference while we develop our own ?

Thank you,

Sasori

The system rarely uses database triggers so it would be hard to provide a suitable example.

It would be better to search trigger examples in the DB documentation

Thank you for your reply Dmytro!

Hello Dmytro,

I created this trigger

CREATE OR ALTER Trigger [dbo].[trigger_InsertContactInFolderAfterEvent] 
ON [dbo].[ContactInFolder]
AFTER INSERT AS
BEGIN
SET NOCOUNT ON;
DELETE cf
FROM ContactInFolder AS cf
inner join Contact as co on cf.ContactId=co.Id
where co.[Name] like 'V3%'
END;

It practically deletes Contacts (whose name start with V3),that are added in the Static Folders. Does this added trigger may cause problems for the overall system ?

Thank you Sasori

Dmytro Vovchenko,

Hi Dmytro

Any Update ?

All the best Sasori

Dear Taras,



Could you please specify exactly what information you expect to receive from the system Data filter, we do not fully understand the needs of your request.



Best regards,

Pavlo.

I expect to see just current date there. The main goal is to make filter display 0 records whenever it is used on Sundays

Taras,

It won't be possible to add a condition like in your screenshot. Are we interested in a specific filter all in any filter in the section (for example disable displaying data in some section on Sunday)? If so we can restrict loading data to grid on Sundays using:

loadGridData: function() {
					var currentDate = new Date();
					var currentDayNumber = currentDate.getDay();
					var restrictDataLoading = currentDayNumber == 0;
					if (restrictDataLoading) {
						return;
					}
					this.callParent(arguments);
				}

This should be added to the section schema (like ContactSectionV2). If we are interested in a specific filter in the context of loadGridData we can read current filters using this.getFilters().getItems() and in case a needed filter is found - use additional current day check and restrict grid data loading. 

Thanks! This should work for me, I will try

Hello,

The idea here is to use the Terrasoft.LogicalOperatorType.OR and specify the filtration inside as in the following example:

"DataGrid_6477jgb_PredefinedFilter": {
					"value": {
						"items": {
							"9a10762b-e098-4df1-9f2f-808b0f2a1e1d": {
								"filterType": 1,
								"comparisonType": 8,
								"isEnabled": true,
								"trimDateTimeParameterToDate": true,
								"leftExpression": {
									"expressionType": 0,
									"columnPath": "CreatedOn"
								},
								"isAggregative": false,
								"dataValueType": 7,
								"rightExpression": {
									"expressionType": 2,
									"parameter": {
										"dataValueType": 7,
										"dateValue": "2022-10-02T14:00:52.067Z",
										"value": "\"2022-10-02T17:00:52.067\""
									}
								}
							},
							"3027b84f-c411-4bd4-adea-064011d278fa": {
								"filterType": 1,
								"comparisonType": 7,
								"isEnabled": true,
								"trimDateTimeParameterToDate": false,
								"leftExpression": {
									"expressionType": 0,
									"columnPath": "Age"
								},
								"isAggregative": false,
								"dataValueType": 4,
								"rightExpression": {
									"expressionType": 2,
									"parameter": {
										"dataValueType": 4,
										"value": 18
									}
								}
							},
							"97395925-0187-4dda-8c82-777172c5e74c": {
								"filterType": 4,
								"comparisonType": 3,
								"isEnabled": true,
								"trimDateTimeParameterToDate": false,
								"leftExpression": {
									"expressionType": 0,
									"columnPath": "Country"
								},
								"isAggregative": false,
								"dataValueType": 10,
								"referenceSchemaName": "Country",
								"rightExpressions": [
									{
										"expressionType": 2,
										"parameter": {
											"dataValueType": 10,
											"value": {
												"Name": "Argentina",
												"Id": "7347f03f-d4d0-4553-9231-855f23623b94",
												"value": "7347f03f-d4d0-4553-9231-855f23623b94",
												"displayValue": "Argentina"
											}
										}
									}
								]
							}
						},
						"logicalOperation": 1,
						"isEnabled": true,
						"filterType": 6,
						"rootSchemaName": "Contact"
					}
				}
			}

In this case the contact where CreatedOn >= 2022-10-02 or Age > 18 or Country is Argentina will be returned. This should be inserted into the lookup attribute as in the example from the provided community thread and will work for the lookup column.

Hello,



Could you please elaborate on your business task?

Bogdan, GargeyiGnanasekhar,



Below is the method for tab change and found in BasePAgeV2,

activeTabChange: function(activeTab) {
	this.callParent(arguments);
	console.log("Tabs in Creatio");
},

var tabName = this.get("ActiveTabName");

Bogdan,

I have 4 tabs in a form page each Tab has a button named "Continuation". On Click of the button, the current tab fields should be saved and then move to 2nd tab.

Thanks

Gargeyi.G

Hello, 

How can we use this in Freedom UI. I wanted to read this from base page v2?

I am not able to find a way reading this.get("ActiveTabName") from base page, also i wanted to call  activeTabChange method in my form page

Any suggestions is really helpful

Thanks in advance

Hello Damien,



Please contact our support team (suuport@creatio.com) and describe the issue.

Bogdan,

Hi I did already, they told me to ask the question on the community..





Damien

Damien Collot,

Please create a new case and write that it was recommended to create case on the community,