The Cast function in select class is not working, second parameter 'DBDataValueType' gets error as 'Error   CS1503   Argument 2: cannot convert from 'System.Guid' to 'Terrasoft.Core.DBDataValueType'   Terrasoft.Configuration.Dev'.

 

var SelQuery = new Select(UserConnection)
.Column(Func.Cast("UsrName", DBDataValueType.TextDataValueTypeUId)).As("UsrName")
.From("UsrTableName") as Select;
 
var SelRecord = SelQuery.ExecuteScalar<string>();

 

Like 0

Like

2 comments

Hi there, 

 

It seems that the error may be hidden in this line: 

.Column(Func.Cast("UsrName", DBDataValueType.TextDataValueTypeUId))

 

Please try to use the code below as an example: 

var textDataValueType = new TextDataValueType(new DataValueTypeManager()) {
   Name = "Text"
};
var SelQuery = new Select(UserConnection)
   .Column(Func.Cast("Name", textDataValueType)).As("Name")
   .From("Contact") as Select;
var SelRecord = SelQuery.ExecuteScalar&lt;string&gt;();

 

Regards,

Anastasiia

Anastasiia Markina,

 

Thanks for code, Now its working.

Show all comments

Hello colleagues,

 

I have a process and some elements have a lot of parameters, I need to create another with the same parameters to get some info, and don't want to have to write all them again. Is there any way to do it?

 

Thanks in advance

Like 0

Like

4 comments

The only way to do it is to duplicate the entire process by selecting it in the process library and clicking the Copy option.

Dear Julio, 



Please see the response above from Ryan. 

The only possible way to copy all the needed parameters is to copy an entire process and then work with this copy. 



Kind regards,

Roman

Thanks or create a custom one and reuse it, in this case the element I want to reuse was a "User Task", thanks

It would be really helpful to be able to copy a single process element instead of copying an entire business process. Can this functionality be added?

 

Show all comments

Can we keep action/task panel open (expanded) for all users in a section by default?

Like 1

Like

2 comments
Best reply

Dear Krishna,

 

Information about whenever the panel is opened or not is stored in SysProfileData table. The key for the data will be like 

ActionsDashboard_SectionName. By default it is expanded, so you can delete all data from the table for key = ActionsDashboard_SectionName if you need to do it once or build a process on an entity if you need to make it permanent (for example). 

 

Best regards,

Angela

Dear Krishna,

 

Information about whenever the panel is opened or not is stored in SysProfileData table. The key for the data will be like 

ActionsDashboard_SectionName. By default it is expanded, so you can delete all data from the table for key = ActionsDashboard_SectionName if you need to do it once or build a process on an entity if you need to make it permanent (for example). 

 

Best regards,

Angela

Angela Reyes,

Thanks Angela; It worked

Show all comments

Hi;

I create a word document base on DataBase data.

I merge multi line field.

it create the document with soft line brakes inside field



do you have any suggestions how to change them to hard line breakes

 

Regards

Tomek

Like 0

Like

3 comments

Hi Tomacz,



Could you please clarify all the steps to reproduce the same?



Also, please provide us with an example of a printable template.



Thank you.

Bohdan Zdor,

Hi;

I use multi line text field on page to set value to database field in the table

Then I Use this value in Marge field in word field

i try to change chr(10) to char(13) chr(10)

to char(13) only to <br/> but it still doesn't work

Maybe you know how to change text to has hard not soft linebrakes.



Tkank you

Hi Tomasz, 



You can find the information regarding hard/soft line breaks convertion in the next article:



https://stackoverflow.com/questions/35766136/can-i-convert-soft-returns…



Thank you.

Show all comments

Hello Comunity! 

 

I know in the last version is restricted the replace of the modules. There is a way to create a new module for LeftPanelTopMenuModule? where is calling this module to remplace the client schema with the new module?

 

Regards,

 

Like 0

Like

4 comments

Hello Frederico,

 

I have the steps written up to override a module here: https://customerfx.com/article/overriding-modules-in-creatio-formerly-bpmonline/

 

Ryan

Ryan Farley,

Thanks Rayan. Regards,

Hello Frederico,

 

Hope you're doing well.

 

Thanking Ryan for creating and sharing the useful article. We can confirm that the steps described in the mentioned instruction can be used for overriding the needed module.

 

At the same time, we don't recommend this way because in the case when you have more than 2 overriding modules, it will not work properly or won't work at all.

 

Best regards,

Roman

Roman Rak,



Since you don't recommend this way, may I know any other way to do this?



Regards,

Solem.

Show all comments

Hi;

When I want to create a data I got an error

Data is not bound for connected package ...

have you met such problem?

what can cause it?

 

regards

Tomek

Like 0

Like

2 comments

Hi Tomek,

 

Can you please provide us with more details on the data that you are creating? How do you do this, please provide us with steps to reproduce the message? In which package do you try to save the data? Can you please provide us with the screenshot of the error?

 

Best regards,

Oscar

Oscar Dylan,

Thanks Oskar 

I think i found the problem.

I use lookup reference in Data and main table was not transfer by data as well.

So thing thats a problem.

 

I transfer the data by script by codes.

thanks for help

 

Regasrds

Tomek

Show all comments

Hello Community,

 

1. How does one achieve a custom URI path like '/customer/update/{id}' while building a custom configuration service? Can we use the UriTemplate attribute to define a custom path like below - 

[OperationContract]    
[WebInvoke(Method = "GET",UriTemplate = "/customer/update/{id}", BodyStyle = WebMessageBodyStyle.Wrapped,RequestFormat = WebMessageFormat.Json,ResponseFormat = WebMessageFormat.Json)]

2. Is there a way to avoid/bypass the '0/rest' prefix which gets added to every custom configuration service??



Thank you

Shrikanth



 

Like 0

Like

2 comments
Best reply

Hello M Shrikanth, 



1. Yes, you can use it. For more details on this please Check the official Microsoft docs.

For example, the following article;

https://docs.microsoft.com/en-us/dotnet/api/system.servicemodel.web.web…



2. No, unfortunately there is no way to bypass adding of the mentioned prefix. 



Kind regards, 

Roman



 

Hello M Shrikanth, 



1. Yes, you can use it. For more details on this please Check the official Microsoft docs.

For example, the following article;

https://docs.microsoft.com/en-us/dotnet/api/system.servicemodel.web.web…



2. No, unfortunately there is no way to bypass adding of the mentioned prefix. 



Kind regards, 

Roman



 

Roman Brown,

Hi Roman. Thank you for the response. 



How does one enable PUT and PATCH methods on a custom configuration service endpoint?? Are there any specific settings or attributes to be added? 

Show all comments

Dear mates,

In our process log, a synchronization error appear several times per days.

 

Here's the detail of one error:

And the message error detail:

Terrasoft.Mail.ImapException: Impossible de se connecter au serveur mail . Vérifier les paramètres de connexion ---> MailBee.MailBeeSocketTimeoutException: Socket connection has timed out. InnerException message follows: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond XXX.YY.ZZ.TTT:993 ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond XXX.YY.ZZ.TTT:993

 

Impossible de se connecter au serveur mail . Vérifier les paramètres de connexion

=> Impossible to connect to the mail server. Check the connexion param

 

However the mails are working fine on computers. We can send and receive email even automatically.

 

Do you have and idea of where the problem can come ?

 

Thank you,

Regards,

Nicolas

Like 1

Like

2 comments

Dear Nicolas,

 

This error message indicates that Creatio application could not connect fo mail server using the connection parameters specified in mail server settings. It says that Creatio sends a connection request and the mail server closes the connection for some reason. To check the source of the issue network settings and logs on the mail server side should be checked on the same time period as those error messages. 

 

Best regards,

Angela

We have the same errors currently

Show all comments

Hello Community,

 

I have a project where we have a decent amount of tabs per edit page. Many fields are labeled similarly due to the nature of the project. However, not all of them are required on a given page. I think it would make it easier for the users if there was a way to let them know in which tab they are missing a required value. I attach a picture describing what I mean. 

Thanks a lot for any recommendations!

Ignacio

 

 

File attachments
Like 1

Like

0 comments
Show all comments

Hi Community!

I'm working on the process with an email message base on feed notification.

If the user is mentioned on feed message, notification is created - that starts my process. The process reads info about the message and sends an email. My question is if it is possible to add a link in the email message to the record? For example, I can add info to feed on Lead record and in email message user will receive a link to this lead

In message/comment object there is filed Object instance but I'm facing an error in the custom message template for add link function "There is no entity for column section". I'm not sure how to work with this feature.

Any idea?

BR Paulina

Like 0

Like

5 comments
Best reply

Hi Paulina,

 

Please build the process like on the screenshot below:

and also add the text parameter called LinkParameter in its properties:

The value for the parameter should be set in the formula value and you need to use the following formula:

 

"https://o_drobina.tscrm.com/0/Nui/ViewModule.aspx#CardModuleV2/"+[#Read Schema.First item of resulting collection.Name#]+"PageV2/edit/"+[#Read Message.First item of resulting collection.Object instance#]

 

where o_drobina.tscrm.com should be replaced with your application name.

 

The idea here is to read the object schema name where the feed message was left using the "Read Schema" process element:

and as you can see we compare the UId from the "Schema" object with the "Schema" value that we read from the "Read message" process element (the "Read message" element has the following configuration):

And also we read the link to the record from the "Read message" element and use it in our formula ([#Read Message.First item of resulting collection.Object instance#]).

 

As a result when using the following template in the "Send email notification" process element:

we receive this email when adding the feed message to a lead record:

So you can test the following approach on your end and you will be able to send email notificaitons as well.

 

Best regards,

Oscar

Hi Paulina,

 

Please build the process like on the screenshot below:

and also add the text parameter called LinkParameter in its properties:

The value for the parameter should be set in the formula value and you need to use the following formula:

 

"https://o_drobina.tscrm.com/0/Nui/ViewModule.aspx#CardModuleV2/"+[#Read Schema.First item of resulting collection.Name#]+"PageV2/edit/"+[#Read Message.First item of resulting collection.Object instance#]

 

where o_drobina.tscrm.com should be replaced with your application name.

 

The idea here is to read the object schema name where the feed message was left using the "Read Schema" process element:

and as you can see we compare the UId from the "Schema" object with the "Schema" value that we read from the "Read message" process element (the "Read message" element has the following configuration):

And also we read the link to the record from the "Read message" element and use it in our formula ([#Read Message.First item of resulting collection.Object instance#]).

 

As a result when using the following template in the "Send email notification" process element:

we receive this email when adding the feed message to a lead record:

So you can test the following approach on your end and you will be able to send email notificaitons as well.

 

Best regards,

Oscar

Oscar Dylan,

 

Works perfect!

Thank you

 

BR Paulina

Hello,

Using "PageV2" is not good way for custom sections - there is another format like : "UsrSomesection1Page"
And it doesn't work in case if we have several pages for a section

Kind regards,

Vladimir

Hello,

 

You can select a contact by filtering or choose a specific contact.

https://academy.creatio.com/docs/8.x/no-code-customization/bpm-tools/process-elements-reference/user-actions/send-email-process-element

Could you please clarify what exactly you mean?

Vladimir Sokolov,

Hard coding CardModuleV2 will make this not work with Freedom UI pages, and appending "PageV2" will not work with custom pages. Instead of using the URL as shown above, you can make it more flexible by using it as follows:

https://mycreatiourl/Navigation/Navigation.aspx?schemaName=Case&amp;recordId=4adce53e-15ce-40ac-8058-04eedcfcc7c5

(Obviously, replace Case with the object name and the guid with the record Id - also replace &amp; with just an & - forum changing this)

This way will work with classic or Freedom and any page, classic, Freedom UI, and custom.

Ryan

Show all comments