Studio_Creatio
Studio_Creatio_enterprise_edition
8.0

Hello All, 

 

I have created code to load Custom Page. How i can add the await in Creatio Client Module function to read Object Data

 

Code Sample : 

define("UsrCustomFunction", [], async functio(){
                
       // API call Terrasoft.EntitySchemaQuery, to read the creatio table.
       var getProcessData = function(){

              var esq = Ext.create("Terrasoft.EntitySchemaQuery", {
                      rootSchemaName: "UsrGUMUProcessList"
              });

              esq.addColumn("Id");
              esq.addColumn("UsrName");


              return new Promise(function(resolve, reject) {
                     esq.getEntityCollection(function(response) {
                     if (response.success) {
                             resolve(response.collection);
                      } else {
                             reject(new Error("Failed to retrieve data: " + response.errorInfo.message));
                      }
               }, this);
             });

           }

 

             // [ Is it possible to add await or any other solution available for this? ]
             var processData = await getProcessData(); 
            
             //Process and return the Config based on the processData.
             return {
                 viewConfigDiff: /**SCHEMA_VIEW_CONFIG_DIFF*/
             };

});

 

 

Is this good solution to Create Custom Page in Creatio or any other solutions are available, then please assist me.

 

Regards,

Ajay K

 

Like 1

Like

1 comments

Hello Ajay,

Thank you for your question.

I suggest you to change your approach. You can override a default crt.HandleViewModelInitRequest  handler that is called before a page is fully rendered. There you might want to put your API call and depending on the result open a specific page. 

Here is a code snippet on how this might lookcode
In this case you also need to add @creatio-devkit/common dependency to schema dependenciescode

It is not recommended to dynamically modify entire schema configuration. Thus a better solution in your case could be binding your API call response to page element properties such as "visible" or "enabled".

Some helpful articles on the Academy: 
1. Generic handlers.
2. Open a Freedom UI page from a handler

Hope this helps and let me know if you have any questions left!
 

Show all comments
Studio_Creatio
8.0

Hi Everyone, 
 

I have a customization task to read data from let's say "Project" table and insert into external Database. I am using ESQ for this in a source code (screenshot attached).

"Project" have more than 20000 records in it, and we are getting this error message -

Please suggest what we can do to change this limit.

Thanks in advance. 

Akshit

Like 1

Like

3 comments

If all this is doing is reading data, instead of using an ESQ, use the Select class or direct database query. Neither option will have the 20,000 record limit.

Be aware that both of these options are reading direct from the database tables, bypassing any record access security, etc.

Note, if you want to stick with using ESQ you can page back the results using RowCount and SkipRowCount to read pages less than 20K at a time.

Ryan

Ryan Farley,

Thank you for your response, I have to first read data and then I need to push this data to external Database. So more specifically in this case I am reading data from Project table in creatio and then I have to upsert data to Project table in external Database (outside creatio)  by iterating on the records I will read. 

Do you think Select class or direct database query this will work in this case? 

 

Thanks.

AS,

Yes either one should work fine, and will likely run faster than using ESQ since it's not adding all the other logic in the Creatio entity model and just reading the data directly from the database.

Ryan

Show all comments
Studio_Creatio
Studio_Creatio_enterprise_edition
8.0

Hello Community,

 

I want to Create the Custom Page as shown in Image where, I can List the Custom UI Card Based on the Table Rows of Creatio. also I want to run the particular Process of the Creatio on click of the Button.

 

Give me any reference for this, if available.

 

Regards,

Ajay K

 

Like 0

Like

1 comments
FreedomUI
Javascript
Studio_Creatio
8.0

Hi,

I'm trying to add a live calculated field onto a Freedom List.

When 2 columns are set (e.g. Start Time, End Time) I want the Duration Column to be updated with the time difference. (With the picture below the Duration column should be set to "1hr")

 

 

Is there a way to do this?

Like 1

Like

1 comments

Hi,
 

You can implement logic similar to the DurationInMinutes and DurationInMinutesAndHours fields in the Activity object (CrtCoreBase).
 

You can check the logic for calculating these columns and build similar event-driven logic (an object-level process).
 

Method: CalculateDurationOnSaving();
 

img1


img2

img3


Alternatively, you can build a business process that will trigger when the Start Time or End Time fields are changed and calculate the required Duration field using a formula.

https://academy.creatio.com/docs/8.x/no-code-customization/bpm-tools/business-process-setup/process-formulas

Best regards,
Pavlo!

Show all comments

Hi team,

 

I want to show/hide a custom button depending on a field of an opportunity, in the page what I do is to create an attribute with dependencies to this field to call the method that points to the property of the diff  (visible/enabled), but in the section I can't do this. I would like to know how I can make the same thing of the example below in the section.

 

The attribute I made in the page: 

"SubastaValidate": {
               dependencies: [{
                   columns: ["Stage"],
                   methodName: "ShowButton"
               }]
           },

In the diff of the page add the property:

"enabled": {
                        "bindTo": "ShowButton"
                    },



Thanks in advance,

Nicolas

Like 0

Like

1 comments

Hello Nicolas,
Thank you for you question.

If i understood you correctly you successfully binded field value change to attribute in your record page but you could not achieve same result in the section page. It might be because those two pages have different fields (e.g in record page there are fields related to that specific record and in section page there is information related to the list of those records). 

In section page i created a method that checks status of selected row. If the status of an order is completed than a button becomes hidden.

Here is how i accomplished that: 


Alternatively you can directly subscribe to changes in ActiveRow in your section page by overriding init method as follows:

Hope this helps and let me know if you have any other question left!

 

Show all comments
Studio_Creatio
7.18

The records of associations in the MailboxFoldersCorrespondence and ActivityFolder tables exist, but when an email arrives, the Activity is not linked to the ActivityFolder, ActivityInFolder is empty. As a result, all emails are not associated with the folder on the mail server in which they are located.

How can I fix it?

 

Like 0

Like

1 comments

Dear Sergey,

 

Could you please provide us with an example and more details of this issue?

 

Thank you in advance!

Show all comments
Studio_Creatio
8.0

Greetings, we want to setup a trigger campaign to send to those members that turn 18 years of age. We have a dynamic folder setup for just these audiences. The question is, what would be the correct filter logic? This is what is currently setup in Creatio so far.

 

Any help is greatly appreciated. Thanks.

Like 0

Like

3 comments

Hello,

Could you clarify whether the goal is to send emails to the contact specifically on their birthday, or is it to send a newsletter to all contacts who have turned 18 this year?

Pavlo Sokil,

The goal is to send emails to the contacts that meet this criteria on their birthday or two days after their birthday.

Lucas Centeno,

 

Unfortunately, regular filtering won't work for these purposes.

 However, you can implement the following approach:
 

Create a separate column of type "Date" in the "Contact" object, for example, "18YearsDate," and populate it using a business process.


 This process should take the birth date from the "Birth Date" column, add 18 years to it, and set this value in the "18YearsDate" column. After that, you can set up a filter as follows:

18YearsDate = Today 
OR
 18YearsDate = Tomorrow, etc.
 

You can implement this calculation for the column using a formula  in the business process.
 

I hope this helps!

Show all comments

Can Some one guid me through screenshot

Like 0

Like

1 comments

To format values in a printable you need to create a macro. The macro will format the value when placed into the Word doc when the printable is run. See an example here: https://customerfx.com/article/creating-custom-macros-to-format-values-in-word-printables-for-creatio-formerly-bpmonline/

Ryan

Show all comments
FreedomUI
Studio_Creatio
lookup
display
8.0

Hello,

 

I have a Freedom UI Page with a city field filter to show only US cities. If the user starts typing a city that belongs to more than 1 state, the user does not have a way of choosing the right one, without using the search icon where, by default we have the state shown on the search results. 

 

Ideally, we just want to display the state on the search results and not on the city field itself on the page, as we do have another field showing the State for the city selected.

 

Thanks,

Jose

 

 

 

Like 2

Like

2 comments

yes, adding the view for more columns in the dropdown field would be great !

Hello,
We created a dedicated task for our R&D team in order for them to review the possibility of adding this logic to a dropdown list. For now, you can use "Selection window"

Show all comments
Studio_Creatio
8.0

Does Creatio can counts in years? I would like count how many years "Contacts" have.

Like it works for days - .Totaldays

Like 0

Like

4 comments

Hello,
Please provide us with a little bit more information on your task, so we can better understand your idea.

Hi. I have a day of birthday filed in Contacts. And I want send a reminder po responsable for the contacts when left 7 day to day of birthday. My idea is create a BP which will start at 1:00 everyday and analizing this field.

Antonii Viazovskyi,

Hi. I have a day of birthday filed in Contacts. And I want send a reminder po responsable for the contacts when left 7 day to day of birthday. My idea is create a BP which will start at 1:00 everyday and analizing this field.

Дмитро Вовченко,

This functionality can only be implemented by development tools. We advise you to pay attention to how the GenerateAnniversaryRemindings business process is implemented and use it as an example.

Show all comments