string text field
performance
database
7.15_()
Sales_Creatio_()

Hi community,

I would like to know more about the amount of space next fields take in database (cloud version):

For example, Text(250) field holds a string of 70 characters. How much space would it take in bytes? 

What if the value is null?

If we have 20 custom Text columns for Contact object, how much do they affect the performance? For table of 10K-30K rows. And if they are null for bigger amount of contacts?

For the section table (Account, Contact) of 10K-30K rows, what should be... hmm... the strategy of creating new custom fields for better performance? As an option, instead of adding the columns to Contact object we may add them to a separate detail object, but that increases complexity.

Should we consider much about that?

Thank you.

Like 0

Like

1 comments

Dear Yuriy, 

We haven't performed such precised tests, however, the size of the string field is approximately 2 bytes per character. You can perform tests yourself populating columns in sql and evaluating the difference in size of the table. However, the value of the field itself doesn't affects the performance of the system. The amount of columns may affect the performance of the system depending on how often and in which volume you get the data (how many records and how many columns) as it loads an sql to the certain extent. However, 20 text fields shouldn't cause much trouble. There are some ways of optimizing this based on what's said above, e.g. when you use Read Data element in the Business process we recommend to read only columns that are further used in the system. 

Show all comments
7.15_()
Sales_Creatio_()

I am trying to add a mobile business rule that applies at various stages for an Opportunity. With the below code, the rule is only working on the Verified stage. I need it to work at 13 different stages so I was hoping to be able to add it all in one rule, but not sure if that is possible?

Terrasoft.sdk.Model.addBusinessRule("Opportunity", {

    ruleType: Terrasoft.RuleTypes.Visibility,

    events: [Terrasoft.BusinessRuleEvents.Load],

    conditionalColumns: [

                        {name: "Stage" , value: "e39b75ac-db07-4f37-a140-2f881a0a98e5"}, //Closed Won

                        {name: "Stage" , value: "423774cb-5ae6-df11-971b-001d60e938c6"} //Verified

                        

                        ],

    triggeredByColumns: ["Stage"] ,

    dependentColumnNames: ["UsrEstStartDate","UsrEstEndDate"]

    });

Like 0

Like

1 comments

Please check ids that are using in "conditionalColumns" array. It seems like the wrong id is used. The stage values are saved in the OpportunityStage table in the database.

Show all comments
mobile application
Mobile app
7.15_()
Sales_Creatio_()

Toggle operation mode for Mobile Creatio is not working now, when I click the button toggle for offline mode there are some process running on it,

and stack as long as the application is open. Anyone idea to solve this problem?

Like 0

Like

1 comments

Hi! In OOB creatio mobile app offline mode can be enabled only via PC version. If this button is custom try to debug it using mobile emulator that can be requested from support team. 

Best regards,

Angela

Show all comments
7.15_()
Sales_Creatio_()

Hi everyone,

Is it possible to resize message box in method "showInformationDialog" ?

and how ?

Thank you.

Like 0

Like

1 comments

Unfortunately, it's not possible to configure message box size in the method "showInformationDialog". However you can resize the message box by applying custom css. The article by the link below describes how to add custom css style:

https://community.creatio.com/articles/how-add-or-edit-css-style

The example for css style:

.ts-messagebox-box {

    height: 500px;

    width: 500px;

}

Please note that this css style can be applied globally, to all message boxes in the system. 

Show all comments
MailboxSyncInterval
Mailbox_synchronization_interval
7.15_()
Sales_Creatio_()

Good morning,

At difference with "LDAP synchronization interval, hours" that indicates is on hours or "Webhooks synchronization interval, min" minutes, the "Mailbox synchronization interval (MailboxSyncInterval)" didn't indicates if the sync value is hours or minutes, also on documentation just "LDAP synchronization interval" is documented,

Also there no reference to "Mailbox synchronization interval" on Creatio documentation on https://academy.creatio.com/documents/administration/7-15/system-settings-description

Somebody knows if the value here is hours or minutes?

Thanks in advance

Like 0

Like

3 comments

Hello!

 

This interval is stored in minutes. Please note that this system setting will not be applied for existing mailboxes - you need to add them again to apply this setting.

Best regards,

Angela

Angela Reyes,

thanks Angela, we have configured, by default 1, I understand minute, but it doesn't works. You indicate me if I change this setting I must to delete the current mailboxes and add it again to recognize the new setting, this is no logic, are you sure?

Thanks again

Julio.Falcon_Nodos,

Yes, system setting will work only for new mailboxes. Old mailboxes cannot be affected by it. 

Show all comments
7.15_()
Sales_Creatio_()

Hi,

  I have configured some email templates in recent weeks but when the email is sent the inserted image is not visible. This is the same image that I have always been using.

 

 

https://prnt.sc/qkgvdj

https://prnt.sc/qkgw16

Like 0

Like

2 comments

Dear Pedro, 

The issue happens with jpg images in the gmail provider. The issue would be fixed in one of the upcoming versions of the application. As a workaround you can change the image format to png or contact support team (support@creatio.com) to have temporary fix installed. 

Dennis Hudson,

Thanks

Show all comments

What is the reason why it is needed to link objects to processes?

Like 0

Like

1 comments

Dear Ricardo, 

This element is needed to track what objects were used in the process. It just adds the object to the corresponding record in process log. It doesn't do anything with the object itself and nothing would happen if you don't use it, however, it is easier to track the process flow with this element. It takes an extra space on the site though and process runs a bit slower. 

Show all comments
duplicates
7.13_()
Sales_Creatio_()

Is there a way to restrict adding duplicate records to the detail? 

Like 0

Like

2 comments

I use processes that are triggered by a signal when a new record is added to the section, then looks for duplicates, deletes the new record, and notifies the user with a link to the existing record.

Would the process pickup the signal from a record insertion happening during an excel import as well?

 

Show all comments
notification
7.15_()
Sales_Creatio_()

Is it possible to send notification messages from a process to a user`s notification center ?

Like 0

Like

1 comments

Dear Ricardo,

It may be done with the help of Add Data element. You would need to add the new record to the Notification object with the required parameters what to display.

Apart from that, I suggest you to take a look a this marketplace template. It may be also helpful:

https://marketplace.creatio.com/template/feed-notifications-account-rel…

Best regards,

Dean

Show all comments
Workplace
package
7.15_()
Sales_Creatio_()

Hi,

As i understanding till now package data banding works by inserting or updating records in corresponding tables but what if i want delete records from some table. Simple example is initial modification of Sales Workplace. Requirement is to remove unneeded sections. After this this modification i have 3 table to bind records to package:

[SysWorkspace]

[SysModuleInWorkplace]

[SysAdminUnitInWorkplace]

Here i have problem because i just removed some Sections from Worplace so i cannot bind this records from SysModuleInWorkplace. Result of installing this package is misleading because i don't have error but this changes doesn't applayed.

What is best practice to transfer this modification in package ?

Regards,

Marcin Kott

Like 0

Like

1 comments

Dear Marcin, 

You can delete records when transferring the package by writing an SQL query and adding it to the package: 

https://academy.creatio.com/documents/technic-sdk/7-15/introduction-6

Show all comments