We found some validation errors indicating we have a package hierarchy issue on an older package that already deployed to production.  To resolve this, we need to unlock some packages and change their dependencies.  While I am able to unlock them with the following script below, I still can't change the package dependencies even when unlocked.  How can I change the package dependencies on a package that has already deployed?

DECLARE @packageName nvarchar(50); 
SET @packageName = 'Package_Name'; 
UPDATE SysPackage 
SET IsChanged = 0, 
    InstallType = 1, 
    IsLocked = 0, 
    Maintainer = 'Customer' 
WHERE Name = @packageName 
AND SysWorkspaceId IN (SELECT 
  Id 
FROM SysWorkspace 
WHERE Name = 'Default'); 
UPDATE SysSchema 
SET IsChanged = 0, 
    IsLocked = 0
FROM SysSchema 
JOIN SysPackage 
  ON SysSchema.SysPackageId = SysPackage.Id 
WHERE SysPackage.name = @packageName 		
Like 1

Like

3 comments

Hello,

Please note that we do not recommend making changes to this package on the end environment. It is best for you to fix the issue with the dependencies on the dev site and then transfer the package with the updated dependencies to prod again. It will ensure that in future, if you decide to transfer this package or a connected package to prod again, it does not override your settings and the system's integrity is preserved.

Mira Dmitruk,

Hi Mira, thank you.  I understand that and am trying to make changes in our development environment.  That is where I am encountering this issue where I cannot change the package dependencies even when they are unlocked.

Francine Braese,

Please describe which errors exactly you get when trying to change the dependencies.

Show all comments

Please guide me.

Like 0

Like

1 comments

Hello,

Please describe your request in more detail.

Show all comments

Hi,

I saw this in marketplace but could not make the business process add on work (https://marketplace.creatio.com/app/excel-reports-builder-creatio)

Is there anyone here who knows how the process element (generate excel) works?

Guidance is highly appreciated.

Like 0

Like

2 comments
Best reply

In order to use an Excel report in a process, it needs to:

  1. Must be a [custom report] - not a section report or page report
  2. Have the [Available in process] option checked (this option only shows if it's a custom report type)

Ryan

In order to use an Excel report in a process, it needs to:

  1. Must be a [custom report] - not a section report or page report
  2. Have the [Available in process] option checked (this option only shows if it's a custom report type)

Ryan

Ryan Farley,

Yes that made the process element works. Thank you!
 

Show all comments

I need to create a crm for which I need to add lists and everything. Please help in how to create a custom page and add data to that 

Like 0

Like

1 comments

Hello 

Thank you for your request regarding the creation of a CRM with custom pages and data lists.

To help you with this, we recommend following the official Creatio Academy guide, which provides a detailed step-by-step walkthrough on how to create a custom section and list page within your application. This guide covers all necessary steps, including adding custom data and configuring the user interface.

You can access the instructions at the following link:
🔗 Creating custom sections and list pages in Creatio

Should you need any further assistance or have specific questions during the setup process, please don’t hesitate to reach out.

Show all comments

Hello Community,

What is the standard way to achieve the following?

We have a list of mailboxes, each associated with different case categories. 

We would like to automatically send a standard reply—such as "Your request is under review"—when the first email (i.e., case registration) arrives in the mailbox.

Any guidance or best practices would be appreciated.

Sasor

Like 0

Like

1 comments

Hello,

To achieve automatic replies on the first incoming email to your mailboxes, we can suggest to create a business process based on the out-of-the-box "Send Email to Case Contact" business process.

You can take the existing process that’s already in the system as a template and customize it to fit your needs—such as sending a standard reply like "Your request is under review" when a new case is created from the first email.

This way, you leverage the built-in functionality and adjust it to your specific scenario.

Thank you!

Show all comments

Hello Community,

Is it possible to associate a specific mailbox with a section, such as Orders or Leads?

We’re looking to replicate the same logic used in Case Registration,where an incoming email to a designated mailbox automatically triggers the creation of a new case.

In our case, we’d like to apply this to Orders and Leads. That is, when an email is sent to a specific mailbox, a new order would be automatically created.

Is this functionality available, or are there any recommended workarounds?

 

Sasor

Like 0

Like

2 comments
Best reply

You can use the object EmailMessageData (Title "Email message") to know which mailbox (or mailboxes) an email (Activity) is from. Emails are Activity records, but each mailbox connected to Creatio that the email is located in will have a record in EmailMessageData to tie the email to the mailbox. 

One approach would be to have a process listening for Activity added with Type=Email that exist in the mailbox you're monitoring.

Then you do whatever is needed such as create a record in your section. The EmailMessageData object also will let you know if the email is a part of a thread. Then you could use that to determine you need to just add this new email to an existing record vs adding a new record, etc.

Ryan

You can use the object EmailMessageData (Title "Email message") to know which mailbox (or mailboxes) an email (Activity) is from. Emails are Activity records, but each mailbox connected to Creatio that the email is located in will have a record in EmailMessageData to tie the email to the mailbox. 

One approach would be to have a process listening for Activity added with Type=Email that exist in the mailbox you're monitoring.

Then you do whatever is needed such as create a record in your section. The EmailMessageData object also will let you know if the email is a part of a thread. Then you could use that to determine you need to just add this new email to an existing record vs adding a new record, etc.

Ryan

Hello Ryan,

Thank you for the recommendation. I tried this approach,

but the Business Process wont trigger when an email comes to the specified Mailbox.

I checked from Sql Console the related tables, and the Id that Im utilizing is correct.

But still the Process wont trigger.

Sasor

Show all comments

Hi everyone,

I’ve been facing some challenges when working with business rules in Freedom UI and wanted to share a specific case to see if anyone has found a solution.

In the Products In Orders page, I need to block certain fields (e.g., Field A, B, C) based on the status of the related Order. For example, if the Order.Status = “Approved”, those fields should become non-editable.

However, in Freedom UI business rules, it seems that we cannot reference fields from related objects (like Order.Status) directly in the IF condition. This was previously possible in Classic UI, where we could create conditions based on fields from related objects.

Has anyone found a workaround for this in Freedom UI that doesn't require custom code?

Thanks in advance for your help!

Like 0

Like

1 comments

Hello,

Unfortunately, it is not currently possible to use data from related objects to set up business rules. However, the responsible R&D team is already working on implementing this functionality in future releases, although we can't provide any exact ETA yet.

Thank you for your question!

Show all comments

Hi Community,

I have created a new Custom Section, and is not appearing in the Dropdown where sections are listed.

Is there any additional config I need to add in order to have the possibility to link the email with the custom section?

Sasor

Like 0

Like

2 comments
Best reply

Hello,

Thank you for your question.

If you've created a custom section and want it to appear in the "Connected to" dropdown (e.g., when linking emails in the communication panel), some additional configuration is required. This behavior is not handled automatically for custom sections.

 

This can only be implemented by development:

1. Add a column to the Activity object that references the desired directory.

2. Find the UId of the column added in the first point (in the directory metadata).

3) Execute the script:
DECLARE @columnName varchar(max) = 'UsrColumn';
INSERT INTO [EntityConnection] ([SysEntitySchemaUId], [ColumnUId])
  VALUES (
    (SELECT
      [UId]
    FROM [SysSchema]
    WHERE [Name] = 'Activity'
    AND [ExtendParent] = 0), 
    (SELECT DISTINCT
      [ColumnUId]
    FROM [SysEntitySchemaReference]
    WHERE [SysSchemaId] IN (SELECT
      [Id]
    FROM [SysSchema]
    WHERE [Name] = 'Activity')
    AND [ColumnName] = @columnName));

Where 'UsrColumn' is the name of the column you added to the Activity object. The script will fetch its UId automatically.

4) select * from EntityConnection order by CreatedOn desc
update EntityConnection set ColumnUId = 'UId column added in the first part' where id = 'UId column from select * from EntityConnection order by createdon desc'

5) Perform a cache clear and log back into the system.

 

After this, your custom section should appear in the "Connected to" list and allow linking emails or other activities to it.

Please note: This change requires backend access (via SQL Executor) and should be applied carefully.

 

Thank you!

Hello,

Thank you for your question.

If you've created a custom section and want it to appear in the "Connected to" dropdown (e.g., when linking emails in the communication panel), some additional configuration is required. This behavior is not handled automatically for custom sections.

 

This can only be implemented by development:

1. Add a column to the Activity object that references the desired directory.

2. Find the UId of the column added in the first point (in the directory metadata).

3) Execute the script:
DECLARE @columnName varchar(max) = 'UsrColumn';
INSERT INTO [EntityConnection] ([SysEntitySchemaUId], [ColumnUId])
  VALUES (
    (SELECT
      [UId]
    FROM [SysSchema]
    WHERE [Name] = 'Activity'
    AND [ExtendParent] = 0), 
    (SELECT DISTINCT
      [ColumnUId]
    FROM [SysEntitySchemaReference]
    WHERE [SysSchemaId] IN (SELECT
      [Id]
    FROM [SysSchema]
    WHERE [Name] = 'Activity')
    AND [ColumnName] = @columnName));

Where 'UsrColumn' is the name of the column you added to the Activity object. The script will fetch its UId automatically.

4) select * from EntityConnection order by CreatedOn desc
update EntityConnection set ColumnUId = 'UId column added in the first part' where id = 'UId column from select * from EntityConnection order by createdon desc'

5) Perform a cache clear and log back into the system.

 

After this, your custom section should appear in the "Connected to" list and allow linking emails or other activities to it.

Please note: This change requires backend access (via SQL Executor) and should be applied carefully.

 

Thank you!

Hello Valeria,

Thank you for the detailed script.

It's still a bit strange why the "Connected To" appears for some custom sections (created by us) and not for others.

I’ll try you approach

Show all comments

Hi,

I’m trying to upload a document to a custom table named RequestSysFile. Along with the document, I need to store an additional field called “Type of Document”, which comes from a field on the screen/form.

However, I’m not able to pass this additional data to the RequestSysFile table during the upload process. Could anyone guide me on how to include this extra field while uploading the file?

 

Like 0

Like

6 comments

I assume you're using crt.UploadFileRequest for the upload? I believe that request might return the uploaded file's Id, you could follow it up with an update to set the other field (I don't believe you can include it in the upload, but I've not tried that)

I have configure below on designer page .

Below is code behind. Help me where\how i will get the ID of uploaded File.  Help me in detailed way.

Also i tried with Business Process(insert signal on sysfile) , but on upload File, Screen details are not getting Saved. I am not able to get the document type data in Business process. 

khushbu kumari,

I think you'd need to do this via code in order to capture the request result and perform the update after

  I am trying to update the selected document type in Solicitud object.  but it is giving Internal server error. 

Below is the code i have written in client side code. Am i doing anything wrong here or any setup is missing to use model class. Note: i have already added “@creatio-devkit/common” to the modules page.

Show all comments

hello everyone! im having issues adding business rules, im trying to add a "filter" option in the "then"action but it is missing, any idea of why?

 

i am using freddom ui pages 8.2 version

 

Like 0

Like

1 comments
Best reply

There are two types of business rules, page-level business rules and object-level business rules. Filters are object-level business rules. In your screenshot you're showing page-level business rules. The object-level rules would show below those on the left side, but the fact that those are missing in your screenshot likely means that the page doesn't have an object data source. 

There are two types of business rules, page-level business rules and object-level business rules. Filters are object-level business rules. In your screenshot you're showing page-level business rules. The object-level rules would show below those on the left side, but the fact that those are missing in your screenshot likely means that the page doesn't have an object data source. 

Show all comments