In the spirit of minimising code/making more of the config declarative rather than telling the system exactly how it should be doing things step by step, it would be very useful to be able to have calculated fields on entities in Creatio. Currently this needs to be done in business processes, which means creating the field in one place, creating the calculation somewhere else, and maintaining the conditions for firing of updates manually. It would be much better if we could have OOTB calculated fields much like many other CRM offerings on the market.

 

It would reduce issues around data not being updated at the right time, or changes in one place breaking config in others, and reduces processing time/disk IO spent on running business processes that have to read, modify and write data in addition to the data originally being written to disk - essentially duplicating the work the servers are having to do for each record. It can also centralise business logic into one place, rather than having different areas of code/config doing the calculation themselves and potentially becoming misaligned.

 

Ideally it would be able to incorporate data from other entities, including the ability to aggregate, but honestly just being able to have calculated fields based entirely on data on the same entity would be a big improvement.

1 comments

+1

Show all comments

Hello Community!

 

I'm trying to fill a field with the result of a simple calculation (e.g. field A - field B).

 

However, when I create the business rule and select "set field" as action, I can only provide a constant value and not a formula...am I missing something?

 

Here is a screenshot of the 

 

I know that I can use a business process to achieve this, but this would be much more simpler and elegant I think.

 

BR,

Robert

Like 0

Like

4 comments
Best reply

It's not yet available in Freedom UI --> Creatio Roadmap indicates for Q4 2023 https://academy.creatio.com/docs/release/creatio-roadmap?check_logged_i…

I forgot to add that I use version 8.0.10.4735

It's not yet available in Freedom UI --> Creatio Roadmap indicates for Q4 2023 https://academy.creatio.com/docs/release/creatio-roadmap?check_logged_i…

Damien Collot,

Thanks Damien, at least I know that I did overlook something.

Hi Damien,

I do not have access to the link to the roadmap.

I get this message:

"

Access denied

You are not authorized to access this page.

"

Is it restricted?

It is very interesting information.

Thanks,

Luis

Show all comments

Hello Community,

Is there any way in Creatio to read all Entity fields from front-end (including lookups),besides fetching the entity Metadata?

Thank you

Like 0

Like

3 comments

Hello Petrika,

 

Can you please share a screenshot or a detailed description of your business task?

 

Thank you!

 

Best regards,

Oscar

Oscar Dylan,

In this case I want that in the Lookup, all the fields (Display Value, not the name of the fields in the database) regarding the application form are displayed. How is this realised Oscar ?

Thanks very much !

Petrika,

 

Now I understood, thank you!

 

You will need to preform the SelectQuery request directly to the database from the client-side using filtration needed (this is what happens if you click the lookup, just check it in the "Network" tab of the console) or you can perform the ESQ query to get data from the lookup drop-down. Using one of the scenarios above you will be able to get data needed.

 

Best regards,

Oscar

Show all comments

Hi all,

    I try to use class Entity to save data, here is my code:

DsslmContractActivityLogData logData = new DsslmContractActivityLogData(UserConnection);

                logData.DsslmLogId = logId;

                logData.DsslmSchemaPrimaryKeyValue = item.SchemaPrimaryKey;

                logData.DsslmSchemaName = item.SchemaName;

                logData.DsslmSchemaJsonData = item.JsonData;

                if (!logData.InsertToDB())

                {

                    this.Logger.Info("Create log failed");

                }

The result is always false without any error message. What happen?

Like 0

Like

1 comments

Dear Toan,

 

Unfortunately, it is difficult to determine the root cause of the issue without debugging the source code. Please try to use the “Insert” class instead of the current approach. Please find more information about this class in the article by the link below:

 

https://academy.creatio.com/documents/technic-sdk/7-16/insert-class

 

Best regards,

Norton

Show all comments