data binding | Community Creatio

Question

16:26 Mar 11, 2024

Hey, everyone!

I'm new to Creatio and still getting myself around, just got my Analyst certification too.

Anyway, How am I to bind the SysAdminUnit to my Application? (trying to bind 4 Functional roles that I've created for my application)

I'm getting the prompt from the print below.

I know that the "sysCulture" is due to the language being "pt-br" (I've been using Creatio on English, and I don't have any clue as to why it created as "pt-br"... Also.. how to alter these specifics into en-US?).

I've read a few posts here and there (all from 2022 and before... something must have changed) on the community and all of them tell me to build a SQL Querry. The problem is that I don't know how to acess my portal through SQL or any querry format. Downloading the SSMS (version 19) and inputting my login credentials and the link to my portal (www.myportal.creatio.com) doesn't work..

Thanks for now!

File attachments

prompt creatio2.png

2 comments

Alona Dolya

17:26 Mar 12, 2024

Hello!

You can add a separate data binding for the SysCulture object to transfer the culture code, specifically the "pt-br" culture, during migration, and then attach the role record. But please note that it is important to deactivate the "pt-br" culture when binding it.

Gabriel Henrique Pagotto Otero

17:45 Mar 12, 2024

Hey, Alona!

I'll try it. Many thanks!

Show all comments

Question

email templates

data binding

Hyperlink

Studio_Creatio_enterprise_edition

8.0

When bind an email template and it has LINKS the links URL didn't change to the destination instance

Julio.Falcon_Nodos

23:05 Feb 22, 2024

Dear colleagues,

How can AVOID this? The link to an object in dev is "https://dev-XXXXX.creatio.com/Navigation/Navigation.aspx?schemaName=Ndo…]" and in TESTING or production, when deploy packages remains https://dev-XXXXX.creatio.com, when it must be https://pre-XXXXX.creatio.com or https://XXXXX.creatio.com

Some idea, how to solve this?

1 comments

Mariia Sorochan

23:33 Feb 22, 2024

Hello!

Please create a separate case for Support Team support@creatio.com and we will analyze it deeply.

Show all comments

Idea

Discussion

Improve the way to know wich data is binded, in particular in EmailTemplate & EmailTemplateLang schemas

Julio.Falcon_Nodos

20:22 Feb 06, 2024

Dears

Due those schemas usually have the EmailBody binded and this is a large string is very difficult to found the name of the binded templates, this is due Creatio show its names centered in the row where they are.

Suggestion, could export the data binded in those schemas or select which columns to see (not binded ones),

For example see the image

Thanks

Do you like this idea?

3 comments

Robert Pordes

19:00 Feb 07, 2024

Good Idea!

Although I do have a strong technical background, I would prefer a more user-friendly "no-code-way" of creating data bindings.

I like the flexibility of the existing data binding feature, but it would be awesome for a lot of people to have the functionality to select what they want to bind and the system does the heavy lifting and generates the technically necessary data bindings.

For instance, if the element that should be bound to the package is an email template, then you would just select the template and the system creates the bindings for you. The same applies to workplaces, dashboards, reports (incl. reports table and the word template), lookups (including their manager), etc.

Damien Collot

08:51 Feb 08, 2024

Robert Pordes,

Yes please !

Very well put. For a nocode tool, there still a lot to be implemented. A lot of great new stuff with Freedom UI but still quite some things missing for it to be truely nocode.

Cheers,

Damien

Mira Dmitruk

06:57 Feb 15, 2024

Hello,

Thank you for your suggestion, we have registered this idea for our R&D team and such functionality may appear in future.

Show all comments

Question

How to bind section folders & his data in case of static to a package

Julio.Falcon_Nodos

14:21 Jan 24, 2024

Dear colleagues,

I need to bind my section folder, but at this time it appears no available in Freedom, I saw in documentation https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platfor… and Folders are not available to bind

I'm using Creatio 8.1.1

Somebody knows some workaround to this?

Thanks in advance

Best regards

Julio Falcón

1 comments

Best reply

Alona Dolya

19:00 Jan 31, 2024

Hello!

Folders are stored in a separated table for each section, [object name]+Folder.

For example, for the contact section, it's ContactFolder.

For sections that were created exclusively in the Freedom UI, folders are stored in FolderTree.

Alona Dolya

19:00 Jan 31, 2024

Show all comments

Question

Data binding error for Org and Functional roles

Yasaswini Indurthi

10:46 Feb 28, 2023

Hello Community,

I have data-binded the organizational and functional roles, while importing it to another instance it shows an error.

Thanks in Advance

Yasaswini I

2 comments

Vladimir Sokolov

11:33 Feb 28, 2023

Hello!

Every time when we want to import data with changes in SysAdminUnit we should do the following:

1. disable trigger TRSysAdminUnitRoot

2. install the package with data

3. enable trigger TRSysAdminUnitRoot

Kind regards,

Vladimir

Yasaswini Indurthi

13:06 Feb 28, 2023

Vladimir Sokolov,

Thank You

Show all comments

Question

Open edit pages in portal

Vladimir Sokolov

23:28 Dec 12, 2022

Hello!

We have several details on Portal (e.g. Product price, Contract and some custom ones).

When portal user double clicks on the record, edit page is opened.

But this happens only on Dev environment. When we install package to Test, it is not possible to open edit page there.

What data should be added to the package in order to open edit page for detail records?

Thank you

3 comments

Vladimir Sokolov

11:18 Dec 14, 2022

As we have found, there are 2 records for one CardSchemaUId in SysModuleEdit:

Select * from "SysModuleEdit"

where "PageCaption" LIKE '%Contracts%'

So, it is necessary to bind the record, that doesn't exist in Test environment. And to this for all pages that should be opened from details

Maybe someone will give better explanation, but this works

Kind regards,

Vladimir

Roman Brown

17:35 Dec 19, 2022

Hello Vladimir,

What you did is bind the SysModuleEdit record for the page supposed to open for the portal section which was missing before.

That's necessary to make sure you bound data from this table along with data from SysSchema, SysModuleEntity, SysModuleEntityInPortal and SysModule to make sure that the portal section and it's pages are correctly transferred.

Kind regards,

Roman

Vladimir Sokolov

11:15 Apr 04, 2024

Hello Roman,

we've got new issue with this. Currently page is opened with double click on portal in our dev and test environment (with demo license)

But not opened on customer environment (with real license).

So, that means, that all bindings are done, but something still necessary to do.

Do you have exact manual how to add detail with edit page to the Portal?

Thank you!

Show all comments

Idea

Discussion

17:25 Dec 06, 2022

It would be nice to add one more 'Delete&Bind' action to Sections, Details, Lookups etc. Id's of deleted records should be bound to the package and deleted on other environments as well when package is installed.

Do you like this idea?

2 comments

Anastasiia Marushenko

01:25 Dec 08, 2022

Dear Vladimir!

Thanks for sharing your idea! We have registered it to add such functionality in future releases.

Best regards,

Anastasiia

Damien Collot

11:52 Jan 10, 2023

This would be amazing !

Show all comments

Idea

Discussion

portal

data binding

Automaticaly bind SysModuleEntity when adding new objects to 'List of objects available for portal users'

Vladimir Sokolov

22:24 Dec 05, 2022

Currently it is necessary to bind SysModuleEntity manualy when adding new objects to 'List of objects available for portal users'

It would be nice to bind such objects automaticaly

Do you like this idea?

1 comments

Alla Blinova

13:35 Dec 06, 2022

Hi!

Thank you for bringing your idea to our attention!

I have registered it for review by the development team. They will process your suggestion and decide whether to add it to future updates of our product.

We appreciate your efforts to improve Creatio!

Show all comments

Question

data binding

Business Process

Bind processes to section

Nicolaiciuc Maria

15:58 Dec 02, 2022

Hello all,

I am trying to bind the processes that I'm running from section to the package, so when we transfer the package into prod the processes will remain attached to the sections. How can I achieve this? It is unclear.

Thank you!

1 comments

Vladimir Sokolov

08:51 Dec 03, 2022

Hi Maria,

this information is stored in ProcessInModules object.

So, if you want to attach this on the prod, you need just to bind data with this records.

If you want to delete it from the prod, you need to run such script with your processes schemas Id's in it:

delete from "ProcessInModules"

Where "SysSchemaUId" IN ('1b0e7dfb-5f68-4d7c-8641-88276ef47148','3d523f87-b74f-414f-9f3c-509f326f8313','006df98f-dde0-4997-b904-9fc0586c10d2')

Kind regards,

Vladimir

Show all comments

Question

dashboard

data binding

Studio_Creatio

BINDING DASHBOARDS FROM AN ENVIRONMENT TO ANOTHER

Eralda Ismaili

13:50 May 23, 2022

How to bind dashboards from an environment to another as a portal user and as a full user?

1 comments

Kalymbet Anastasia

16:54 May 24, 2022

Hello!

The dashboard's data is stored in the SysDashboards for dashboards on analytics,

and SysWidgetDashboard for dashboards in the section pages.

You can transfer this data using data bindings or on the DB level (merge for existing on the target instance and insert for non-existing).

Data for folders, filters, and column setup is stored in the SysProfileData. You can transfer it similarly to the dashboard's data.

In case if you need more information on adding data bindings for the package, please see the article below: