// 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

I'm looking to trigger page data validation in a specific circumstance from code. I've found that you can use

request.$context.validate()

within client event handlers to trigger the OOTB fields validation for the page, but this just returns an object representing any/all errors in validation for the data. What would make sense to do in our use case after that would be to trigger the NotifyService message you usually see when saving fails due to such validation checks, but I can't see how to trigger it/how to fetch the string that should be shown in the message. I located a method that looks like it is performing this task for the OOTB save validation, called getValidationErrorMessage, which would be passed the request context and the error object returned by the validate function, but this method doesn't seem to be available for use.

 

Has anybody had any luck with triggering validation in Freedom UI and then displaying the OOTB message based on that validation result? Any help would be greatly appreciated. We're currently running on 8.1.0

Like 2

Like

4 comments

Hello,

If I'm not mistaken, you can use simple OOTB validation that is described here https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platfor…

Hi Dmytro,

 

This doesn't give us a way to trigger the validation manually though unfortunately. What we were trying to achieve was to show the validation message to users without saving/trying to save the record at that point in time. We ended up making our own very basic error message that shows the results returned by

request.$context.validate()

if there are any and stops the user progressing in our custom path, but it would be good to be able to tap into the OOTB error toast message so it's a little more detailed and polished.

Harvey Adcock,

 

Hello! 

Unfortunately, so far, we don't have the functionality to trigger the OOTB validation snackbar-message without saving /trying to save the record. 

We have registered your suggestion, and our R&D team will consider implementing it in future releases.

Thank you for making our product better!

 

Best regards, 

Natalia

Harvey Adcock,

Dear Harvey,

 

See this community article, I think it could help you to answer your question https://community.creatio.com/questions/dynamic-parameter-validator-freedom-ui

 

Regards,

Julio

Show all comments

Hello,

 

I am trying to automate the gathering of data using some business process that perform API calls to one of our client private APIs. I have defined the WebServices with no problem like the one from this example:

 

 

And sending the test request with a valid API Key and Authorization token works perfectly. However, if I try to group all of this inside a business process I get an error that I don't know how to solve. This is the business process:

 

 

And the error that I get exactly on the web service call is this one:

 

 

The full error message states:

Terrasoft.Common.UnsupportedTypeException: Type "System.Collections.Generic.List`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" is not supported.

 

I have done some tests and I can confirm that the error only appears when I try to use a the valid Authorization token retrieved previously, and if I set any other value in that Web Service parameter I don't get the error but obviously the call fails because I am using and incorrect token.

 

The length of the token is 299 characters and as it is an authorization token, it must be preceded by the word "Bearer", so the full value that I am passing to that parameter is "Bearer " with a total length of 306 characters. I also tested using some random strings of length 500+ and the error doesn't show up, so it is not related to a limit of the parameter length. I also checked that the token I am passing is 'correct', i.e. no breaklines, weird characters (not UTF-8) or anything that could cause problems with the encoding of the string.

 

Therefore, I guess it is something related to the way Creatio builds the API request from inside the process, that is not the same as doing from a test request inside the Web Service...

 

Your help is highly appreciated.

Regards.

Like 0

Like

2 comments

Note: I have not tried yet to perform the same kind of requests inside a business process to another API (like a public one), but the error I am getting is not related to the API I am using, it must something related to the Creatio business process logic when invoking web services methods, regardless of the endpoint and the API specifications.

Hello,

 

I recommend that you create a support request.

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

While configuring amazon connect with Creatio, we did all set as per the user guide, still encountering an issue related to Input parameter (like softphone login and extension), can you please guide, what exactly these terms mean and what to fill here.

File attachments
Like 0

Like

0 comments
Show all comments

While configuring amazon connect with Creatio, we did all set as per the user guide, still encountering an issue related to Input like ( softphone login and extension), can you please guide, what exactly these terms mean and what to fill here.

File attachments
Like 0

Like

1 comments

Hello,

 

As the developer of this addon is Velvetech, please contact their support team to clarify your question: creatio@velvetech.com.

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,

 

how can I add the multicurrency data to my Opportunity page, like it worked properly in the Classic UI? 

 

For example, I would like to add the Opportunity value in USD, than the system calculate the EUR value, or if I add the value in EUR, the system will calculate the USD value.opps



Thanks, Timea

Like 1

Like

2 comments

Hello,

 

Our R&D team has a task to implement a multicurrency field in Freedom UI in the 8.2 application version.

 

Unfortunately, there are no examples in the documentation or application of implementing it in the current application versions. So please wait until 8.2 when this column will be available out-of-the-box and could be used on the pages.

Thanks for your answer.

Show all comments

Hi, I am new in Creatio and try to resolve some reported issue.

 

Currently i have long list of users during assigning cases.

I have untick "Active" at "System User" for those inactive employee.

However, the list still the same.

 

Any guidance on how to do it correctly?

 

Thanks in advance.

Like 1

Like

1 comments

Hello,

 

Hello,

Thank you for your question!

The problem is that the responsible field takes information from the contacts lookup. Contacts include not only system users of the company and employees, but also other contacts created on your website. That is, this field will contain all the contacts you have created, as well as system users. You can change the lookup from which the information for the responsible field will be taken and thus have only the contacts you have selected when filling out this field. 

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