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 exception

 

System.NotSupportedException: The CLR type Terrasoft.Core.DB.QueryColumnExpression isn't supported by Npgsql or your PostgreSQL. If you wish to map it to a PostgreSQL composite type you need to register it before usage, please refer to the documentation.
 

If this is not a suitable way, which is the proper way to insert a null guid directly in a PostgreSQL db from C# code ?

Like 1

Like

1 comments

Solved 

Example

new Update(_userConnection, "SysAdminUnit")
					.Set("LDAPElementId", Column.Parameter(null, "Guid"))
				.Where("SynchronizeWithLDAP").IsEqual(Column.Parameter(true));
			int operationsCount = update.Execute();

 

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 service instruction?

 

Thank you in advance!

Olga. 

Show all comments