Question

Return details (classic UI) / list components (Freedom UI) of a section edit page

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