database | Community Creatio

14:12 Oct 04, 2022

Hello!

I've been searching for documentation on how to access data in a column, from the database, but to no avail. To give you some sort of background, my Product object has a detail called Collateral. Users can add more collaterals - each having an allocation percentage. What I need is to create...MoreLess

4 comments

Oleg Drobina

20:52 Oct 04, 2022

Hi Maria,

You need to use ESQ to get the data from some record in the detail related to the section. In this case you need to get the Id o...MoreLess

Ryan Farley

23:50 Oct 04, 2022

Hi Maria,

I have an article outlining a simple place to start with EntitySchemaQuery (to query the database from client-side code) here: ...MoreLess

Nicolaiciuc Maria

14:17 Oct 06, 2022

Oleg Drobina,

Thank you, your answer enlightened me very much. Though I have some trouble accessing the id of the product.

Based on what...MoreLess

keith schmitt

14:46 Oct 06, 2022

For me, I usely add a debugger to the code. Then examine "this" In the console to see what values are already available.

Show all comments (3)

sql

database

Financial_Services_Creatio_lending_edition

popup

Financial_Services_Creatio_customer_journey_edition

8.0

Invalid object name

Petrika Mele

15:21 Aug 25, 2022

Hello Creatio Community,

This happens in the Application Section. When i fill in the product terms and try to save the Application this pop up is shown. Meanwhile the object SysFinApplicationSpecRight doesnt exist at all in the database. How can I fix this problem ?

Regards

2 comments

Petrika Mele

15:32 Aug 25, 2022

Printscreen of Error Logs

Show all comments (1)

I have to Import "product in order" data from excel file but it cannot match 2 field in table name: order with order no and order date

butsayamat

06:59 Aug 02, 2022

In database I have Order table and Product in Order Table. The Order table i have the same Order no but it not a same record because it order created a different day

Ex.

OrderNo : 0001 Created : 2022-01-21

OrderNo : 0001 Created : 2022-02-21

The problem is I cannot import Product in Order table data by match order no and date in Order table

How import data by excel file with same order no but different date and different record

1 comments

Ryan Farley

18:43 Aug 02, 2022

Maybe you could create a single column in Creatio to store order number + date, then in the Excel file use a formula to append the values together...MoreLess

Show all comments

Inconsistency in data type changes

M Shrikanth

19:16 Apr 23, 2021

Hello Community,

There are many use cases where we need to change the data type of a column. We have observed the following behavior wrt data type changes and want to understand why this happens.

DB - MS SQL

Behavior #1

Say a column has been created as String(250) and published. Changing it...MoreLess

4 comments

Roman Rak

17:10 Apr 25, 2021

Hello,

Hope you're doing well.

We tried to reproduce the behavior you have described for different types of DB (PostgreSQL and MSSQL) in two...MoreLess

M Shrikanth

18:34 Apr 25, 2021

Roman Rak,

Hi Roman, Appreciate your effort in trying to reproduce this.

Your steps does look right -

1. Create as 250 in Object designer...MoreLess

Ivanna Yatsura

23:31 Apr 25, 2021

M Shrikanth,

As for your question - no, it was not changed in the latest versions.

Best Regards,

Ivanna Yatsura

M Shrikanth

18:50 May 23, 2021

Roman Rak,

Hi Roman. Checked this use case once again. The behavior I have stated in my question is correct. I have used a on-premises Creatio...MoreLess

Show all comments (3)

Design / Architecture - Where does Creatio filter data? - Application layer or database layer

M Shrikanth

17:18 Feb 06, 2021

Hello community,

There are numerous use cases where Creatio filters for some data before showing on the UI. Few examples below -

Writing ESQ from JavaScript where we filter an object for only select records by adding filter groups.
User applying of a filter in a section list page or a...MoreLess

5 comments

Ryan Farley

18:19 Feb 06, 2021

Hello,

Yes, all filter conditions are added as conditions for queries and are performed at the database layer. You can see this if you...MoreLess

Roman Rak

18:38 Feb 06, 2021

Hello Shrikanth,

We can confirm that filtering conditions are configured as conditions for queries and they are being performed...MoreLess

M Shrikanth

18:49 Feb 06, 2021

Ryan Farley,

Thank you Ryan. Yes, I was aware of the views and similarly noticed usage of Stored procedures in the community. This prompted my question.

M Shrikanth

18:51 Feb 06, 2021

Roman Rak,

Thank you Roman for the answer.

Gareth Osler

15:22 May 24, 2022

Ryan Farley,

If I can quote:

you can also create SQL views in the database containing aggregates/joins/unions/ranks/partions/etc and create...MoreLess

Show all comments (4)

cloud

database

7.17

Database access in Creatio cloud environments

M Shrikanth

07:32 Feb 02, 2021

Hello community,

Earlier, we would not be able to access the database directly on Creatio SaaS cloud installations and would have to reach out to Creatio support for any assistance. Does this still continue or is there a roadmap to enable direct database access even in the Creatio cloud offering?

If...MoreLess

4 comments

Dean Parrett

07:48 Feb 02, 2021

Dear Shrikanth,

Due to security reasons the direct access to the databases is not available. If there is a necessity to migrate some data from\to...MoreLess

amanthena

13:38 Feb 02, 2021

Dean Parrett,

Could you elaborate on the "DB Server Linking" part here, Dean? Thanks

Dean Parrett

23:57 Feb 02, 2021

Dear Amanthena,

This is typical on-site\non-cloud integration. It's basically looks like this:

Creatio database<--->buffer database<...MoreLess

Ryan Farley

18:41 Feb 06, 2021

I have done data migrations directly to the database on several occasions with no issues. The most challenging part is the creation of the access...MoreLess

Show all comments (3)

database

Index

Creatio & Database Indexes

Halludeen

14:05 Dec 01, 2020

Hi Community,

I'm trying to understand the behavior of Creatio with Indexed / Non-Indexed databases. Does Creatio handle database indexing by default? If yes, which are the default fields that are indexed?

Also, can a Non-Indexed database affect Creatio's performance considering a production environment? Or does indexing only affect direct DB scripts configured in the packages?

Thanks in advance.

1 comments

Roman Rak

23:36 Dec 01, 2020

Hello Halludeen,

Hope you're doing well.

By default, the Creatio application can handle the database indexing. For cloud solutions...MoreLess

Show all comments

Discussion

Custom database field length from the Object designer

M Shrikanth

18:56 Nov 14, 2020

Creatio by default allows a user to choose between 50, 250 and 500 as max lengths of a Text column from the Object designer. In a use case where Creatio co-exists with an external system and both share the same fields, it becomes important to maintain consistency with respect to data type...MoreLess

Do you like this idea?

1 comments

Roman Rak

09:14 Nov 16, 2020

Hello Shrikanth,

Hope you're doing well.

Thank you for being interested in the Creatio application and further its improvements. We have...MoreLess

Show all comments

Sales_Creatio_enterprise_edition

Unable to use multiple filters in esq query in client side modules

RAMNATH SHARMA

15:29 Jun 26, 2020

When I try to implement esq and multiple filters, only last added filter will work. Rest will be kind of overrided by the next filter.

For example, If I use 3 filters -

esq.filters.add(esqFirstFilter);
esq.filters.add(esqSecondFilter);
esq.filters.add(esqThirdFilter);

I am getting results on the...

MoreLess

1 comments

Norton Lingard

16:34 Jun 26, 2020

Dear Ramnath,

In order to resolve the issue please use the following code for adding filters:

esq.filters.add("esqFirstFilter", esqFirstFilter)...MoreLess

Show all comments

12:07 May 29, 2020

Dear mates,

I would like to modifiy our timelines on differents pages.

I try to follow the guide: https://academy.creatio.com/documents/technic-sdk/7-13/timeline-tab

But i can not access the database to do the modifications.

How can we have an access to the database ?

Thanks,

Nicolas

1 comments

Olga Avis

13:06 May 29, 2020

Hello Nicolas,

This method is only good for the development environments deployed on-site. Since the modifications are implemented directl...MoreLess

Show all comments

Subscribe to database