Hi community,

I’m working on a custom web service in Creatio that connects to an external PostgreSQL database deployed on Neon. My goal is to query data from this external database, acting like a custom ORM. However, I’m running into an issue with using the Npgsql package inside Creatio’s source code.

I’ve added the necessary references, but I keep getting the following error:

The type or namespace name 'Npgsql' could not be found (are you missing a using directive or an assembly reference?)

I’ve already added the Npgsql.dll to the Terrasoft.web/bin folder and modified the web.config to include a binding redirect for Npgsql. After restarting the IIS server and flushing Redis, I now get a 'System.Data.Common' assembly error.

Here’s the code I’m using:

using Npgsql;
using System;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.ServiceModel.Activation;
using System.Data;
using System.Collections.Generic;
using Terrasoft.Core;
using Terrasoft.Web.Common;
 
namespace Terrasoft.Configuration
{
    [ServiceContract]
    [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Required)]
    public class PostgresService : BaseService
    {
        private string connectionString;
 
        public PostgresService()
        {
            // PostgreSQL connection string
            connectionString = "Host=your_host;Port=5432;Database=your_database;Username=your_username;Password=your_password";
        }
 
        [OperationContract]
        [WebInvoke(Method = "GET", RequestFormat = WebMessageFormat.Json, ResponseFormat = WebMessageFormat.Json,
            BodyStyle = WebMessageBodyStyle.Wrapped, UriTemplate = "GetData")]
        public List<Dictionary<string, object>> GetData()
        {
            var result = new List<Dictionary<string, object>>();
            try
            {
                using (var connection = new NpgsqlConnection(connectionString))
                {
                    connection.Open();
                    string sql = "SELECT * FROM users LIMIT 100";
 
                    using (var cmd = new NpgsqlCommand(sql, connection))
                    using (var reader = cmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            var row = new Dictionary<string, object>();
                            for (int i = 0; i < reader.FieldCount; i++)
                            {
                                row.Add(reader.GetName(i), reader.GetValue(i));
                            }
                            result.Add(row);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception($"Error retrieving data: {ex.Message}");
            }
 
            return result;
        }
 
 
 
    }
}

Hello Creatio Community,

I am working on a project where I need to either replace or override an existing Creatio web service with a custom implementation. Specifically, I want to extend or modify the functionality of a base Creatio web service (e.g., CallServiceSchemaService) to fit my business requirements.

Here’s what I want to achieve:

• Create a custom web service in a separate package without affecting the existing functionality of the base service.
• Either extend the existing service (if possible) or completely replace it with my custom implementation.
• I want to customize the behavior of how service requests and responses are handled, while ensuring that all references to the original service use my new service.

Questions:

1. What is the best approach to achieve this in Creatio? Should I extend or replace the service, and what are the steps to do so?
2. How can I ensure that the system references my custom service in place of the base service without breaking existing functionality?
3. Are there any best practices or limitations I should keep in mind when implementing custom web services in Creatio?

I would appreciate any guidance, examples, or documentation that can help me with this process.

Thank you!

I am trying to open a page for an object that I have created in a business process, but the page isn't showing up in the dropdown menu for the "Open edit page" process element.

The closest I have come to a solution is on this post from 2020, where someone said that in order for it to show up you need to use "out-of-the-box" or "standard" tools to create the page and not development tools. 

What are these tools that I can use to create a freedom UI page that will show up?

The method I used to create the page which isn't showing up is by clicking on the "+" sign on the "Pages" tab of the object editing page.

Edit: To clarify, I'm looking to have a modal page appear as part of the process. If I create a new freedom UI section, the auto generated page will appear in the "Open edit page" dropdown, but no other pages I create for it afterwards will.

Hello!
I have encountered such problems, maybe someone knows how to solve them?

There is a configured queue and a process that processes a queue item.

The first problem is that when opening the Cases_FromPage page the Case state is not loaded into the progress bar

The second problem I encountered is that it is necessary to close the page automatically and terminate the process element so that the queue element is considered processed, but this problem is solved with the help of this request:

{
	request: "crt.HandleViewModelInitRequest",
	handler: async function(request, next) {
		this.applyMethods(request.$context);
		await next.handle(request);					
	},
	applyMethods: function(context) {
		let methods = {
			closeProcessElement: async function() {
				const state = window.history.state;
				if (state && state.isProcessCardInChain && state.executionData && state.executionData.isOpened) {
					const executionData = state.executionData;
					const result = await context.executeRequest({
						type: "crt.CompleteProcessElementRequest",
						processElementUId: executionData.currentProcElUId,
						$context: context
					});
				}
			}
		};
		Ext.apply(context, methods);
	}
},

But another problem arose when changing the Case stage, in this case manually, the page doesn't always close.

I noticed that this behaviour on those stages where DCM has elements of activity creation.

In my case here:

When changing the stage from Waiting for Evaluation to Evaluation, the page should have closed.

The crt.CompleteProcessElementRequest request was executed.

Who knows what could be the problem?
Thanks!

Hello,

In the classic UI, there is an element that allows you to send emails, chat, etc. that is towards the top of the page by default and looks like the following screenshot:

How can I get the same functionality in Freedom UI? I am specifically asking because I am trying to use the Twilio SMS Connector app (the rightmost icon), and can't seem to figure out how you are supposed to manually send a text message in Freedom UI pages outside of this option other than building a business process from scratch. If I need to I can do so, but if there is already a solution I would prefer to use that.

Thanks in advance for any and all help!

I have a record that I'm trying to delete, but just as the title says, the system is telling me that I do not have the rights to any CRUD operations despite me being the system user and making sure that I have full operation permissions on the object.

The specific object in question is the AppValidation object from the FinAppLending package. The record was created automatically by a business process. Is there something I'm missing that will allow me to do anything with this object?

Thanks in advance!

In the default Addresses expanded list, there is a column called "Full address" which combines all of the different parts of the contact address object into one, and cannot be edited directly, such as in the following screenshot.

I'm having trouble figuring out how this is implemented, as I would like to do something similar for another object. Any help would be appreciated, because I cannot seem to think of a search term that would pull up a relevant article on the subject.

Thanks in advance for any help!

As the title says, we sometimes need to disable buttons while still showing them - something which was easy to do in Classic UI. Is there any way of doing so in Freedom UI? I can't see any examples in OOTB Freedom UI areas, anywhere that does have disabled buttons OOTB are in Classic UI sections (e.g. the "Finish session" button on the System User page on the Access Rules tab when no record is selected).

Hello community, 

I want to test sending an email function in Trial site

Can it possible?

Thanks 

Is it possible to set the value of a System setting which has the "Save value for current user" setting enabled for a specified user from C# code, e.g. from a script task? I've found the below code for setting a System setting, but presume that if the checkbox for the above is selected, then it will only set the value for the current user (or the System User if running in the system context):

var settingCode = Get<string>("UsrSystemSettingCode");
var value = Get<string>("UsrSettingValue");
Terrasoft.Core.Configuration.SysSettings.SetValue(UserConnection, settingCode, value);
return true;

We need to be able to set the per-user system setting for a specific user (determined by data in the BP in our case) but looking at the (always hard to find) API documentation, it doesn't seem like there's an overloaded version of SetValue that allows you to do so as a specified user - except possibly one that is marked as being deprecated in a much older version: