Hello Oliver, 

It's expected behavior that both these fields are locked. They are predefined by the template option you've chosen while creating a new template record in "Message templates" section. By a default (in oob version of a system) 2 options are available:

Therefore, you'd need to simply choose the needed option to proceed with email template.

Best regards,

Anastasiia

Hi Anastasiia,

thanks for your answer. But there is no option "Chat template" or "Email template". There is just a "new" Button.

I just see that there is also only a "new" button in version 8.0.5.

In Version 8.0.4. everything is as expected.

Best regards,

Oliver

Oliver Herzog,

Hello,

As mentioned, in oob version of a system there are two options (corresponding edit pages):

Situation from your screenshot may occur on a specific site in a result of applied customizations or modifications done from your side, for example if one of the edit pages have been deleted. Such changes (adding or deleting the edit pages) can be done through the Section Wizard of the corresponding section.

Best regards,

Anastasiia

Hello Damien,

if I understood your question, you want to display the detail on a different section, is it correct?

If yes, there are two options.

1. You can simply open the Wizard of the page where you want to have your detail. Click on "New detail", then find it by Detail name. And the one you are looking for is Education and certificate.

2. You can create exactly the same detail. You still need to open the Wizard, click on "New Detail" but now you have to create a new one. All you have to do is open the Education and certificate detail setup and copy the parameters to a new detail. Then you will be able to display it on the page and save.

Regards,

Gleb.

Solved 

Example

new Update(_userConnection, "SysAdminUnit")
					.Set("LDAPElementId", Column.Parameter(null, "Guid"))
				.Where("SynchronizeWithLDAP").IsEqual(Column.Parameter(true));
			int operationsCount = update.Execute();

Hello,

We have already registered it in the backlog of our R&D team to fix this logic in future releases.

Currently, you can only change the version of a case manually in each record separately.

+1 here, it would be great to update all or select opps in batch to switch to new dcm version.

Hello,



Would like to ask if this is possible now?



Thank you

Kalymbet Anastasia,

Any update on this.

Hello,

Information relating to the tables is given below:

- SysAdminUnit (Administration object: users and roles)

- SysUserInRole (Users in roles)

- SysFuncRoleInOrgRole (Functional role into organizational role)

- SysAdminOperation (System operations)

- SysAdminOperationGrantee (Access to system operations)

- SysEntitySchemaOperationRight (Access to objects)

- SysEntitySchemaRecordDefRight (Access to default records)

- SysEntitySchemaColumnRight - (Access to object columns)

- SysAdminUnitGrantedRight - (Delegated)

- SysWorkplace - (User Workplace)

- SysAdminUnitInWorkplace - (Users in the workplace)

- SysModuleInWorkplace - (Section in workplace)

Thank you for this information,



How about the link/relationship between the User and its Managers in Organizational role, where it is saving?

Hello Fulgen,

You can get real user roles, including those received as a manager, delegated, etc. using the script below.

Substitute the username for <SysAdminUnit.Name>.

select

sau1."Name" as UserName,

sau2."Name" as RoleName,

sau3."Name" as GotRoleFrom,

(select "CanExecute" from "SysAdminOperation" sao join "SysAdminOperationGrantee" saog on sao."Id" = saog."SysAdminOperationId" where sao."Code" = 'CanSelectEverything' and saog."SysAdminUnitId" = sau2."Id") as CanSelectEverything,

(select "CanExecute" from "SysAdminOperation" sao join "SysAdminOperationGrantee" saog on sao."Id" = saog."SysAdminOperationId" where sao."Code" = 'CanInsertEverything' and saog."SysAdminUnitId" = sau2."Id") as CanInsertEverything,

(select "CanExecute" from "SysAdminOperation" sao join "SysAdminOperationGrantee" saog on sao."Id" = saog."SysAdminOperationId" where sao."Code" = 'CanUpdateEverything' and saog."SysAdminUnitId" = sau2."Id") as CanUpdateEverything,

case WHEN sauir."Source" & 1 > 0 THEN 'YES' ELSE 'NO' END as "Role source: Self",

case WHEN sauir."Source" & 2 > 0 THEN 'YES' ELSE 'NO' END as "Role source: ExplicitEntry",

case WHEN sauir."Source" & 4 > 0 THEN 'YES' ELSE 'NO' END as "Role source: Delegated",

case WHEN sauir."Source" & 8 > 0 THEN 'YES' ELSE 'NO' END as "Role source: FuncRoleFromOrgRole",

case WHEN sauir."Source" & 16 > 0 THEN 'YES' ELSE 'NO' END as "Role source: UpHierarchy",

case WHEN sauir."Source" & 32 > 0 THEN 'YES' ELSE 'NO' END as "Role source: AsManager",

sauir."CreatedOn" as LastRolesActualization

from "SysAdminUnitInRole" sauir

LEFT join "SysAdminUnit" sau1 on sauir."SysAdminUnitId" = sau1."Id"

LEFT join "SysAdminUnit" sau2 on sauir."SysAdminUnitRoleId" = sau2."Id"

LEFT join "SysAdminUnit" sau3 on sauir."SourceAdminUnitId" = sau3."Id"

Where sau1."Name" = '<SysAdminUnit.Name>'

order by CanSelectEverything desc, CanInsertEverything desc, CanUpdateEverything desc, sau2."Name"

Hi,

You need to override shema BaseDataView and modify the button SeparateModeViewOptionsButton:

  define("BaseDataView",[],function(){
	 return {
		 details:/**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
		 attributes:{},
		 methods:{
			 checkIsAdmin:function() {
				 var user = Terrasoft.SysValue.CURRENT_USER;
				 var name = user.displayValue;
				 if(name==='Supervisor')
					 return true;			 
				 		return false;
			 }
		 },
		 diff:/**SCHEMA_DIFF*/[
			 {
				"operation": "merge",
				"name": "SeparateModeViewOptionsButton",
				"values": {
					"enabled": { "bindTo": "checkIsAdmin"}
				}
			}
		 ]/**SCHEMA_DIFF*/
	 };
  });

Dmytro Vovchenko,

Thanks a lot! It worked!

Hello,

In Postman I was able to get the content of the file using the following URL (GET request): https://site.creatio.com/0/rest/FileService/GetFile/d95c76f6-64bc-444c-…

This is the URL that is called when you try to get the attachment from the UI. d95c76f6-64bc-444c-9bfc-1b9cfd4f06e0 is the UId from the SysSchema table representing the object where the attachments are stored (ContactFile, AccountFile, FileLead etc) and the eba29d21-2922-4094-b996-f5c18ee025d1 is an Id of the actual attachment.

This should be also received using some program call (like some integration) as either a plain text or the set of bytes (should be tested). Then the content can be encoded\decoded using something like this https://stackoverflow.com/questions/11743160/how-do-i-encode-and-decode…. These are suggestions, unfortuantely we don't have a ready solution for this. 

Hi Lewis, 



Please contact our support team since this question has to be checked more detailed. 



Kind regards,

Roman

Hi,

How was this issue solved?

Hello Sasori,

The issue was related to the "Schema_name" schema, which had a reference to the "Column_name" column that didn't exist in the object. This led to the assumption that it might have been renamed or deleted

I do wish we could add dashboard list elements on pages. It would make things easy to display unrelated data on a page and things like pivot tables. However, I don't believe there is anyway to add it to the page that I know of. We usually just create a view, then display the results in a detail on the page instead. For creating a pivot table, Postgresql does have the crosstab function which does this easily - However, that is part of the tablefunc extension, which isn't installed in Creatio postgresql databases - I've never tried to see if it allows you to install extensions like that. See https://stackoverflow.com/questions/3002499/postgresql-crosstab-query/1…

Ryan

Ryan Farley,

We have added widget with list to the page, but it is still displayed like flat list, not pivot... 

That's why I would like to find out if it is possible to make this last step :)

Hello Vladimir,

Did you find a solution ?

Vladimir Sokolov,

Could you please add the steps for adding the list element to a page?

Thanks!

Jacek

Hello,



Please find more infomation on server code debugging here.