Время создания
Filters

Here I want to show the resize button but I can't click on the visibility section and did not know how to do it ! 
Ay idea please ?
notification panel

Like 0

Like

0 comments
Show all comments
Is_this_the_recommended_approach_for_handling_configurable_products_in_Creatio?
Has_anyone_implemented_a_similar_CPQ-style_configuration_model?
Are_there_any_built-in_Creatio_capabilities_or_marketplace_add-ons_that_support_product_configuration?
What_is_the_best_practice_if_inventory_needs_to_be_tracked_for_some_variants_(e.g.
size-wise_stock)?
Studio_Creatio_free_edition
8.0

Hi Community,

I am currently designing a Gifting CRM in Creatio, where many products require customization options.

For example:
Product: Custom Print T-Shirt
Customization options:

  • Size (S, M, L, XL)
  • Color (Red, Blue, Black)
  • Print Type (Screen print, Vinyl, Embroidery)

In the standard Creatio Product data model, products are stored as individual records (SKU-based). However, if I create a separate product for every combination, it will lead to a very large number of SKUs and difficult maintenance.

My Current Approach

I am planning to:

  1. Keep a base product in the Product catalog (e.g., “Custom Print T-Shirt”)
  2. Create a custom object/data model to store customization options (Option Groups and Option Values)
  3. Link these options to the product
  4. Store selected customization at the Order Product / Opportunity Product level
Like 1

Like

0 comments
Show all comments

For a case record all the email activity is visible to the admin roles but not to the user of a particular role.What can be the possible reason for this and how to resolve this issue?

Like 0

Like

0 comments
Show all comments
QueueItem
list
column
removed
Studio_Creatio
8.0

Hello,

I have noticed that configuring a list to display Agent desktop queue element (QueueItem) always results in the default column displaying 'Colum removed'. It is pointing to Caption of QueueItem.

When you try to remove it (hide) and save you will be unable to open the page in no-code configuration. Console returns: Cannot read properties of null. 

Essentially we have to display this default column or the page breaks in configuration. From UI perspective it opens regardless.

I have observed this in multiple environments with versions 8.2 and higher. 

It is not a big issue but I am wondering if anyone has encountered this or has a solution for this.

Like 0

Like

0 comments
Show all comments
Auto-number_sequence_generation_not_working_in_Creatio_Online_environment
Studio_Creatio
8.0

Hello,

We are importing data from an external ERP system and creating records (e.g., Orders / Invoices) via backend code. These objects have an auto-number column (“Number”) configured with a prefix such as ORD- or INV-.

We attempted to generate the next auto-number value by querying the database sequence directly using SQL like NEXT VALUE FOR based on the column UID. This approach works in some local environments but fails in Creatio Online. The query either throws an error or does not return the expected value.

Below is the code we have written for next sequence:
 EntitySchema entitySchema = userConnection.EntitySchemaManager.GetInstanceByName(objectName);
                    var numberColumn = entitySchema.Columns.GetByName("Number");
                    string sequenceName = numberColumn.UId.ToString();
                    
                    long nextValue=0;

                    try
                    {
                        string sql = $"SELECT NEXT VALUE FOR dbo.[{sequenceName}]";
                        
                        using (var dbExecutor = userConnection.EnsureDBConnection())
                        {
                            using (var reader = new CustomQuery(userConnection, sql).ExecuteReader(dbExecutor))
                            {
                                if (reader.Read())
                                {
                                    nextValue = reader.GetInt64(0);        
                                }
                            }
                        }
                    }
                    catch(Exception ex)
                    {
                        
                    }

The trail online version of Creatio is "8.3.2.4199". 

What are we missing here?

Any help would be appreciated.

Like 0

Like

2 comments

First of all, how are you loading the orders/invoices? It should be creating these numbers unless you're going directly to the database (or the numbers are being created using the older method on the client-side page only).

I assume that somewhere you're setting the nextValue in the Number field and that just isn't showing in the code?

Ryan Farley,

We are currently performing a direct SQL insert using the following code:

Guid newRecordId = Guid.NewGuid();
var insertQuery = new Insert(userConnection).Into(objectName).Set("Id", Column.Parameter(newRecordId));

foreach (var property in objectData.Properties())
{
    string propertyName = property.Name;
    string propertyValue = property.Value.ToString();
    insertQuery.Set(propertyName, Column.Parameter(propertyValue));
}
int affectedRows = insertQuery.Execute();

However, in the online environment, the order number is not incrementing as expected. Instead, all orders are being created with the same number (ORD-0).

Show all comments