Hello Selva,

We see that you also registered a case directly for the support team and will provide you with an elaborate answer regarding your instance there.

Selva,



All the physical files (i.e., attachments are stored in a DB server of type BLOB). And if required external servers/integrations supported can be used. 



This Academy article will guide further: https://academy.creatio.com/docs/user/setup_and_administration/base_int…

BR,

Bhoobalan Palanivelu.

Hello Sasori,

 

We need more information to analyze your problem.

Please contact our technical support team (support@creatio.com)

Hello,

Please note that there are several different Global Search templates that you can choose from to configure on your instance, depending on your needs. Please refer to this Academy article to know more about it.

You can either set this up on your own in a locally deployed instance or send a request to our support team so we could change the Global Search template if you have a cloud site.

Greetings,



Unfortunately, we do not yet have an out of the box solution for such a request, hence we have registered an idea for our R&D team to further implement such feature in our future versions.

Hi,

it seems that you are trying to add the macro straight from the table column. In this case, such scenario should be changed.

Please, make sure you added the column to the "Set up report data" section in your Report template in Creatio before you add this column to the report template in Word, then in Word you will have to find this columns in the list and drag it to the field where you need it.

For example, if now the macro looks something like "Object1.Column1.Currency", then you need to go to your Report in Creatio and add the column in such way:

- Set up report data -> "+"

- Object1 -> "+"

- In the second field you need to find your Column1

- In the last window you should have a list from the Column1 and there you should be able to find your Currency column.

In this case, it should work fine.

Regards,

Gleb.

Thank you for your replay.

Yes, we have created VIEW and added this object as report table.

And if report is based on Order, a lot of Order's calculated fields are taken from VIEW.

When we add 'Currency' field to the 'report data', it realy works - thank you.

But we also have some fields, that are calculated in VIEW, so they cannot be added to the 'report data', only to 'report table'. As I understand, they cannot be used in other table header?

And only option is to add new field to Order object, calculate and store this value in the object?

Kind regards,

Vladimir

Vladimir Sokolov,

if the field is calculated in View, it cannot be added to the header, I'm afraid.

However, you can try to add another field to your object and simply populate it with the value from the second field. In this case, it should work fine.

Regards,

Gleb.

Gleb,

Thank you!



Would be nice to have Word reports based not only on Section, but on any other objects, also objects on View

Greetings,



We have checked the information with our R&D team and it is as follows:

Newtonsoft.Json;

Newtonsoft.Json.Linq;

Both of these should work with no problem with the new versions of Creatio, but

System.Web.Script

Needs some adjustments from your side, since you have an on-site system.

The adjustments are as follows:

Within the file \Terrasoft.WebApp\Terrasoft.Configuration\Terrasoft.Configuration.Dev.csproj 

Within this section: <ItemGroup Label=".NET references"> 

You should add this reference <Reference Include="System.Web.Extensions" />

And correctly use the beforementioned libraries (Newtonsoft.Json; Newtonsoft.Json.Linq;) in C# schemas

Hello Mykhailo Zeleniuk,



Right now, my code is very simple (see screenshot), so I'm bothered by the compilation error...

Especially since the same code worked in version 7.18.5.

Someone would have examples of Json deserialization code with other libraries than Newtonsoft ?

Thanks

Vincent

LAVIGNE Vincent,

I did an example of a webservice that returns a JSON string result using only System; and System.Text.Json. The code is below:

namespace Terrasoft.Configuration.UsrCustomServiceNamespace
{
    using System;
	using System.Text.Json;
    using System.ServiceModel;
    using System.ServiceModel.Web;
    using System.ServiceModel.Activation;
    using Terrasoft.Core;
    using Terrasoft.Web.Common;
    using Terrasoft.Core.Entities;
 
 
 
	public class SerializedObject
	{
		public string FirstPart { get; set; }
		public string SecondPart { get; set; }
		public string ThirdPart { get; set; }
	}
 
    [ServiceContract]
    [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Required)]
    public class UsrCustomService: BaseService
    {
 
		private SystemUserConnection _systemUserConnection;
        private SystemUserConnection SystemUserConnection
		{
            get
			{
                return _systemUserConnection ?? (_systemUserConnection = (SystemUserConnection)AppConnection.SystemUserConnection);
            }
        }
 
	[OperationContract]
        [WebInvoke(Method = "GET", RequestFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.Wrapped,
        ResponseFormat = WebMessageFormat.Json)]
        public string ReturnCustomResult(string param1, string param2, string param3)
		{
			var objectToSerialize = new SerializedObject
            {
                FirstPart = param1,
                SecondPart = param2,
                ThirdPart = param3,
            };
			string jsonString = JsonSerializer.Serialize(objectToSerialize);
			return jsonString;
		}
	}
}

As a result calling this endpoint http://localhost:1026/0/ServiceModel/UsrCustomService.svc/ReturnCustomR… returned this result:

{"ReturnCustomResultResult":"{\"FirstPart\":\"test1\",\"SecondPart\":\"test2\",\"ThirdPart\":\"test3\"}"}

So you can this approach on your side as well.

And the test was performed in 8.0.6 full bundle application (sales + marketing + service) MS SQL.

Hello Oleg Drobina,

Thank you very much for your answer, I will try to adapt your example code to my case.

Indeed, I want to retrieve a JSON which is in the body of the HTTP request, so do more of a "Deserialize" request.

If you have an example of code in this way too, I am interested.

Thanks

Vincent

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.