Hello,


I'm working on a service where I have to fetch data from Database. For this, service file 'ClientDBService' was created.

(Code):
----------
using System;

using System.Data;

using System.Data.SqlClient;

using System.Collections.Generic;

using System.ServiceModel;

using System.ServiceModel.Web;

using...MoreLess

Like 0

Like

1 comments

Hello,

Database connection using Script task doesn't relate to the specific Creatio functionality. Please read the C# documentation to find the answer to your question.

Show all comments

Hi,

I'm working on Freedom UI. According to requirements, I have to make connection with Client's DB to fetch data to show on UI.

How can I integrate client's database in Creatio?

Platform: Creatio: Energy (Freedom UI)

Like 0

Like

1 comments

Hello,

You can use integrations to retrieve data.

Such as Odata, Custom Service, etc.

https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/category/integrations-tools


 ...MoreLess

Show all comments

Dear colleagues,

I'm having a problem running my Creatio local environment when use PostgreSQL.

When start the app, I'm getting this error Exception Details: Npgsql.PostgresException: 28000: no hay una l�nea en pg_hba.conf para �fe80::1c5:206f:bef4:e3e9%13�, usuario �dev-toledano�, base...MoreLess

Like 0

Like

2 comments
local   all             postgres                                peer
 
# TYPE  DATABASE        USER            ADDRESS                ...

MoreLess

Show all comments (1)

Hello Team,

I am trying to insert a null guid directly to the DB. I use the following snippet

	QueryColumnExpression nullParameter =
					Column.Parameter(DBNull.Value, new GuidDataValueType(UserConnection.DataValueTypeManager));
				update.Set("ResponseDetailsId", nullParameter);

I get the following...

MoreLess

Like 1

Like

1 comments

Solved 

Example

new Update(_userConnection, "SysAdminUnit")
					.Set("LDAPElementId", Column.Parameter(null, "Guid"))
				.Where("SynchronizeWithLDAP"...

MoreLess

Show all comments

Hi Community,

We decided to install a new Creatio Application instance on our linux based servers. We would like to know if we could use the lastest version of PostgreSQL (13 or 14)?

Thanks in Advance.

Best Regards,

Pedro Pinheiro

Like 0

Like

1 comments
Best reply

Hello Pedro,

You can use the 13th version of PostgreSQL. But not the 14th for now.



Best regards,

Bogdan

Hello Pedro,

You can use the 13th version of PostgreSQL. But not the 14th for now.



Best regards,

Bogdan

Show all comments

Team,

Trying to look for the "Indexing for full-text Search" option for a custom section in 7.17.2.1728_SalesTeam_Softkey_PostgreSQL_ENU and 7.17.3.1377_SalesTeam_Softkey_PostgreSQL_ENU packages deployed on-site. Though I find "Indexing for full-text Search" option in 7.17.3.1377 cloud instance, I am not able to find the same options in the site locally hosted in my laptop. Is there a way by which we can enable it?

Screenshot attached.

Like 0

Like

1 comments

Hello!

Could you please confirm that the Global Serch was installed for the local websites according to the Setting up the global search...MoreLess

Show all comments