Hi guys! There is a question. It is necessary to establish rules for the segmentation of the counterparty. If he has more than $10,000 revenue, then assign a segment in the directory with the value A, if the revenue field is less than $1,000, then segment B. How do I do this? In the "event - signal" business process, there is no sign greater than or equal to, only flat or uneven. I didn't find anything that would help me in setting up business rules either. Who can tell you? Version 7.18

[ec2-user@ip-x-x-x-x ~]$ COMPlus_ThreadPool_ForceMinWorkerThreads=100 dotnet Terrasoft.WebHost.dll

2024-11-27 00:56:21,031 Application starting

Unhandled exception. System.Security.SecurityException: System login error. Error has been recorded in system log of the server. Please contact your system administrator.

---> Npgsql.PostgresException (0x80004005): 28000: no pg_hba.conf entry for host "", user "postgres", database "creatio", no encryption

   at Npgsql.NpgsqlConnector.DoReadMessage(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isPrependedMessage)

   at Npgsql.NpgsqlConnector.ReadMessage(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications)

   at Npgsql.NpgsqlConnector.ReadMessage(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications)

   at Npgsql.NpgsqlConnector.ReadExpecting[T](Boolean async)

   at Npgsql.NpgsqlConnector.Authenticate(String username, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)

   at Npgsql.NpgsqlConnector.Open(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)

   at Npgsql.ConnectorPool.AllocateLong(NpgsqlConnection conn, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)

   at Npgsql.NpgsqlConnection.Open(Boolean async, CancellationToken cancellationToken)

   at Npgsql.NpgsqlConnection.Open()

   at Terrasoft.Core.DB.DBExecutor.b__23_0() in /opt/buildagent/work/ApplicationCoreLinux/TSBpm/Src/Lib/Terrasoft.Core/DB/DBExecutor.cs:line 224

   at Polly.Policy.<>c__DisplayClass109_0.b__0(Context ctx, CancellationToken ct)

   at Polly.Policy.<>c__DisplayClass103_0.b__1(Context ctx, CancellationToken ct)

   at Polly.NoOp.NoOpEngine.Implementation[TResult](Func`3 action, Context context, CancellationToken cancellationToken)

   at Polly.Policy.<>c.b__103_0(Action`2 action, Context context, CancellationToken cancellationToken)

   at Polly.Policy.Execute(Action`2 action, Context context, CancellationToken cancellationToken)

   at Polly.Policy.Execute(Action action)

   at Terrasoft.Core.DB.RetryDBOperation.Execute(Action operation) in /opt/buildagent/work/ApplicationCoreLinux/TSBpm/Src/Lib/Terrasoft.Core/DB/RetryDBOperation.cs:line 29

   at Terrasoft.Core.DB.DBExecutor.RetryOnFailure(Action action) in /opt/buildagent/work/ApplicationCoreLinux/TSBpm/Src/Lib/Terrasoft.Core/DB/DBExecutor.cs:line 432

   at Terrasoft.Core.DB.DBExecutor.get_DBConnection() in /opt/buildagent/work/ApplicationCoreLinux/TSBpm/Src/Lib/Terrasoft.Core/DB/DBExecutor.cs:line 223

   at Terrasoft.Core.DB.DBExecutor.PingDB(UserConnection userConnection) in /opt/buildagent/work/ApplicationCoreLinux/TSBpm/Src/Lib/Terrasoft.Core/DB/DBExecutor.cs:line 1126

   --- End of inner exception stack trace ---

I get this error when i'm trying to start the application..the connectivity is all fine fro the server..

Hi there, i'd like to know how to get the sales and leads related with a contact. I'm using odata to get the contacts by using the following   endpoint 'mycrm_url//0/odata/Contact' this return a collection of contacts and i'd like to get the sales and leads related with every contact, are there endpoints to achieve this ?

• - Best regards

I need to open a lookup page for editing when a button is clicked, But l can't find the way to get a direct link (url) to a lookup page (in a classic view)

Hello,

Is there a way to configure a field's logic in client module like,

If condition A, use lookup A

if condition B, use lookup B

Can you provide a sample code for it? 

Thank you!

Hi Team,

We notice below redis timeout error in application logs - 

Redis LogRetryData - Retry operation. RetryCount = [1]. Sleep duration = [00:00:05]. Causing exception: 

[StackExchange.Redis.RedisTimeoutException: Timeout performing HMGET (5000ms), next: HMGET 0f21kpmv0wrwvnntd5cf3ah2:Cache, inst: 1, qu: 0, qs: 26, aw: False, rs: ReadAsync, ws: Idle, in: 188, in-pipe: 35, out-pipe: 762, serverEndpoint:, mgr: 10 of 10 available, clientName: , IOCP: (Busy=48,Free=952,Min=4,Max=1000), WORKER: (Busy=49,Free=32718,Min=4,Max=32767), v: 2.0.601.3402 (Please take a look at this article for some common client-side issues that can cause timeouts: https://stackexchange.github.io/StackExchange.Redis/Timeouts)

   at StackExchange.Redis.ConnectionMultiplexer.ExecuteSyncImpl[T](Message message, ResultProcessor`1 processor, ServerEndPoint server)

   at StackExchange.Redis.RedisBase.ExecuteSync[T](Message message, ResultProcessor`1 processor, ServerEndPoint server)

   at StackExchange.Redis.RedisDatabase.HashGet(RedisKey key, RedisValue[] hashFields, CommandFlags flags)

   at Terrasoft.Redis.StackExchangeAdapters.RedisClientAdapter.GetValuesFromHash[TValue](String hashId, String[] keys)

   at Terrasoft.Redis.BaseRedisStore.<>c__DisplayClass22_0.b__0()

   at Polly.Policy.<>c__DisplayClass119_0`1.b__0(Context ctx, CancellationToken ct)

   at Polly.Policy.<>c__DisplayClass129_0`1.b__0(Context ctx, CancellationToken ct)

   at Polly.RetrySyntax.<>c__DisplayClass12_1.b__1(Context ctx, CancellationToken ct)

   at Polly.Retry.RetryEngine.Implementation[TResult](Func`3 action, Context context, CancellationToken cancellationToken, IEnumerable`1 shouldRetryExceptionPredicates, IEnumerable`1 shouldRetryResultPredicates, Func`1 policyStateFactory)]

A few articles found online suggested extending timeout on redis client using connectTimeout to more than default 5000ms. The timeout parameter was added in the connection string and set to 10000. Yet, we see the same type of timeout error referencing 5000ms. 

Connection string for redis as follows- 

; db=; port=6379; connectTimeout=10000; maxReadPoolSize=250; maxWritePoolSize=250; " />

Has anyone come across this issue before? Any insight is very much appreciated.

Hi Team,

I'm trying to set up a report for Order section using FastReport. The intent is for users to apply the required date filter on the Order section and generate the report for that period. For eg, order report for month of April, May etc.

The problem I'm facing is that I'm unable to show the selected date period on the report heading (eg. Order Report 04/01/2024 - 04/30/2024). All the rest of the data populates fine. Not sure if there is a way to pass them as parameters to the report template.

Can anyone suggest a way to achieve this?

Hello, 

any support with runtime error? Can you share your experience?

Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a "web.config" configuration file located in the root directory of the current web application. This tag should then have its "mode" attribute set to "Off".

Hello! Does anyone know how to add an iframe to a specific entry in the details?
It’s just that an iframe should appear inside a specific entry below the values. It will appear when a detail entry is active.

Thank you in advance!

Hi all,

Further to the thread below, is it possible to make a button added to the active row of a detail conditional?
Add button into the active row of detail | Community Creatio

I want to make the button enabled on a certain condition but when I add the enabled and visible values to the Diff of the datagrid, I get no result (tried passing "enabled": false to check it wasn't an issue with the CanSplitFlights method)

define("UsrFlightsDetail", ["ProcessModuleUtilities"], function(ProcessModuleUtilities) {
	return {
		entitySchemaName: "UsrFlights",
		details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
		diff: /**SCHEMA_DIFF*/[
			{
				"operation": "merge",
				"name": "DataGrid",
				"parentName": "Detail",
				"propertyName": "items",
				"values": {
					"activeRowActions": [],
					"activeRowAction": {"bindTo": "onActiveRowAction"}
				}
			},
			{
				"operation": "insert",
				"name": "DataGridActiveRowSplitFlights",
				"parentName": "DataGrid",
				"propertyName": "activeRowActions",
				"values": {
					"className": "Terrasoft.Button",
					"style": Terrasoft.controls.ButtonEnums.style.BLUE,
					"caption": "Split flights",
					"tag": "SplitFlights",
					"visible": true,
					"enabled": CanSplitFlights
				}
			}
		]/**SCHEMA_DIFF*/,
		methods: {
            CanSplitFlights: function() {
                var FlightTypeId = this.getActiveRow().get("UsrFlightType");
				var FlightTypeValue =  FlightTypeId  && FlightTypeId.value;
 
				if (FlightTypeValue == '3a0d3b1b-9af5-472a-bac9-e785500ac4e9') {
					return true;
                }
                return false;
            },
			onActiveRowAction: function(SplitFlights) {
				switch (SplitFlights) {
					case "SplitFlights":
						this.onSplitFlights();
						break;
					default:
						break;
				}
			},
			onSplitFlights: function(){
				ProcessModuleUtilities.executeProcess({
					sysProcessName: "UsrSplitFlights",
					parameters: {
						FlightId: this.getActiveRow().get("Id")
					}
				});
			},