// Read entity.
EntitySchemaManager manager = UserConnection.EntitySchemaManager;
var entity = manager.FindItemByName("Account");
// Tables that reference the entity.
var entityCollection = manager.GetSchemaOppositeReferences(entity.UId, EntitySchemaColumnUsageType.General, UserConnection, false);
string result = string.Join(", ", entityCollection.Select(i => i.SchemaName));
 
/*
VwAccountRelationship, VwAccountDuplicate, VwRelationship, VwAccountRelationship, VwAccountModuleHistory, VwAnniversary, CompetitorProduct, AccountCommunication, Relationship, Call, VwAccountDuplicate, CTISearchResult, Contact, AccountAlternativeName, AccountEnrichedData, AccountInFolder, VwModuleHistory, AccountFile, Relationship, ContactCareer, QuickDialUserSettings, EmailFolderColumnValuesSetting, VwRelationship, Employee, AccountAnniversary, AccountInTag, AccountDuplicate, VwSspAdminUnit, AccountOrganizationChart, AccountAddress, AccountBillingInfo, VwSspAdminUnit, VwSSPSysAdminUnit, EnrchFoundAccount, EmployeeCareer, AccountDuplicate, Account, VwContactRelationship, Activity
*/

I can read the tables that reference an entity with an opposite references call on the entity.

How would I i) find out what the details (classic UI) and the list components (Freedom UI) of a section are?  and, ii) know what object the grid object was referencing?

Like 0

Like

2 comments

Hello,

 

i) From the server-side - there is no way to get this information since this is the information on the client side (on the page) and connections are done only on the page. For example you cannot retrieve Contract object in case you have a list of Contracts on the account form page with the connection like the following:

ii) Once again - this is a client-side information that is not available from the server-side code. This information cannot be retrieved from the server-side methods.

Oleg Drobina,

Thanks for looking at this.

 

I have been asked for a data dictionary, which I can do with the API provided in the .NET classes reference.  I have been asked also for user interface documentation, which is where I could do to know what the fields, tabs, etc. of a section edit page are.  This information is going to have to be entered manually for now.

 

Module information I think has to be in Creatio tables, but I don't know what the rubric is for querying Creatio tables with SQL, let alone which tables.  An API would be better.

Show all comments

Hi all

 

Somebody know where can I change or restart autonumbering, i need to define a process to eache year restart the numbers

 

I'm asking regarding the new Creatio feature to AutoNumber any entity (8.1)

 

Thanks in advance

Like 1

Like

3 comments

Hello, somebody can help me with this question please?

Hello,

 

Currently, no interface allows users to configure this manually, so the following steps need to be taken:



Identify the UId of the auto-numbered column.



For the identified column, use the script below to set a new starting number. In the examples provided, '4a40180c-61bf-de86-2f08-b05852a5ea6d' represents the UId of the auto-numbered column, and '1' is the next value from which the auto-numbering will proceed.



Script for MSSQL:

 

ALTER SEQUENCE [4a40180c-61bf-de86-2f08-b05852a5ea6d]
RESTART WITH 1;



Script for PostgreSQL:

SELECT setval('4a40180c-61bf-de86-2f08-b05852a5ea6d', 1, false);



If you need further information or assistance, please reply to this message and we will be happy to help you.

 

Thanks, I need to reset them yearly in a process, how can automatically fit it?

Show all comments

I have an organizational role name "Sales Reps" that has my account added in its Users area.

I also have a workplace named "Sales Reps" with the desired app under Sections and "Sales Reps" added under User groups.

 

When I log in to my account, I do not see any apps. There is also no dropdown menu at the top to change workplaces (see attached image). When I am logged in as Supervisor, I see apps as expected. 

 

What other steps do I need to take to grant my user access to an app? 

 

File attachments
Like 0

Like

2 comments

Hello,

 

Please use this documentation, which will help you:



https://academy.creatio.com/docs/8.x/setup-and-administration/administr…



Regards, 

Orkhan

Orkhan,

Thank you for the reply. Deleting the user and readding them fixed the problem. 

Show all comments

Hi all, 



Is anyone else experiencing bugs in the quick filters on 8.1.1 ?



When using the "Following days" or "Previous days" method, it does not pick up any records, even though they exist. 

 

 

Like 0

Like

2 comments

Hi!

 

We do not currently have such a massive problem. 

 

In this case, we ask you to contact our support team at support@creatio.com to resolve the issue. 



Best regards,

Anton

Hi Anton, 



Unfortunately I think this is a bug with 8.1.1 because I have just tested on a demo account and receive the same issue....

 

Show all comments

Hello all,

 

I've been working on applications in the application hub and I've had some trouble with the run app button defaulting to a different section than I'd prefer, is there a way to change which page the button opens? I haven't been able to find instructions on how.

 

Like 0

Like

1 comments

Hello Kevin,

 

There is no such option for now. 



Such a possibility will be available since the 8.1.2 version but only for custom apps.

Show all comments

We are facing one issue specifically related to displaying images in the word document. We have a use case where we want to print rows of data which includes images as well to the word document, which is working fine.

 

But we do have some exceptions where for a particular row image is not there, but rest of the column data is present. In this specific case, the data is printed correctly but in the image column we are getting a blank canvas. Instead of blank canvas we want to display a default image is no image data is present in the DB for the rows.

 

 

Like 0

Like

1 comments

Thank you for reaching out to us about this.

Upon reviewing your request, we have identified that the current underlying logic of our program is configured to operate in the way you described. That is, if there is no image, a macro is displayed (a gray square) instead of an empty field. However, we understand that this is not ideal for your specific needs.

We want to assure you that we have submitted a request to our development team to implement this feature in upcoming versions of our program. We understand the importance of providing the best service to our customers and will diligently work towards implementing the changes you have suggested.

Thank you again for bringing this to our attention.

Show all comments

Hi, 



     I input the Chinese address in the address of Account, but the map below can't reflect the actual location(please see attachment),

Is it because that Creatio don't support Chinese character right now? please kindly help. 



    I use the instance of Japan, which is the version of 8.11.3635.

File attachments
Like 0

Like

1 comments

Hello,



For a more detailed analysis of this issue, please email Creatio Support: support@creatio.com.

Show all comments

when adding a CSS module in Creatio it is deleted when refresh, i cannot show the effective colors after refresh

 in first pic i add CSS file and it work 

After refresh it return to original

Can any one help?

Like 0

Like

1 comments
Best reply

Hello, ElSayed!

Such problem can appear when you've opened the app in a few tabs and logged out+ loged in on one of the tabs. For example: the tab with the configuration page is open and you're writing code there. Then you press the save button, click on the nearest tab to check the result, and relogging to the second tab. After this, your changes in the first settings tab will not be saved. Or it can happen if you have two settings tabs for one object.

I would recommend you to close all tabs and try to add the CSS again, save it and check the result by reloading the page button.

Hello, ElSayed!

Such problem can appear when you've opened the app in a few tabs and logged out+ loged in on one of the tabs. For example: the tab with the configuration page is open and you're writing code there. Then you press the save button, click on the nearest tab to check the result, and relogging to the second tab. After this, your changes in the first settings tab will not be saved. Or it can happen if you have two settings tabs for one object.

I would recommend you to close all tabs and try to add the CSS again, save it and check the result by reloading the page button.

Show all comments

Hi,

I have a task to create a filter on a specific text field, how can I do it ?

Like 0

Like

2 comments

Hello Vadym,



Could you please elaborate on your business task? 

Bogdan,

i have text column 'Title' and i want have static filter for this column in register interface but in freedom i can do quicke filter only for column with type lookup, date and chekbox

Show all comments

Hello, 

 

I would like to set an upper limit on the size of an image that gets sent in an email. The image being sent is a variable in a form using the [#ImageName#] syntax. 

 

I have tried styling the element in div and img tags, but I think that this variable syntax does not respect styles.  

 

How can I style an image in an email template? 

 

Thanks!

Like 0

Like

1 comments

Hello,

 

Unfortunately, the logic of inserting an image through a macro into a letter template is not implemented in Creatio.

I am broadcasting your wish to the development team to consider the possibility of adding similar logic in future versions.

Show all comments