Hi

I created a custom section and I use it for filtering on a contact lookup in case portal page.

The search returns an empty result because the query use the SysEmpty table, not my custom section table.

I give all permission on the custom sectio for the portal users, but nothing change.

What am I doing wrong?

Like 0

Like

2 comments

Hi Stefano,

 

There might be multiple causes of this behavior.

First of all please keep in mind that access rights might be inherited and since your custom section is based on Contact lookup - permissions are checked for Contacts as well as for your Custom section. 

 

We also recommend looking at the SysSSPEntitySchemaAccessList table. There should be a record of the schema with which you have a problem. For portal users, by default, all schemas are considered to be administered and inaccessible. In order that portal users can use them, this schema must be in the lookup (the list of objects available to portal users). In other words - it must be in the SysSSPEntitySchemaAccessList table. After adding this schema to this table, the problem should be solved.

 

Should the above trouble-shooting not resolve your issue - please send us an email with detailed explanations of your problem to support@creatio.com so we may inspect and analyze your specific case (as it is too few details available by now and further evaluation will be required for precise solution)

 

Best Regards,

Dan

Denis Bidukha,

Thank you very much, for your suggestion.

Adding the missing record in the SysSSPEntitySchemaAccessList table solved my problem.

Show all comments

Hello community,

I want to catch the step change event of an entity in the client side.

Does Creatio offer a built-in method that implements this functionality that I can override?

Like 0

Like

1 comments

Hello!

 

Thank you for your question. Could you please elaborate more on your business task? Would you like to receive a notification each time a record is modified? Kindly provide us with more details.

 

Best regards,

Anastasiia

Show all comments

Hello Community,

I am trying to create a lookup filter in client side based on the values of a detail. The case is as follows: I want to display within the application only the contacts which are in the detail UsrApplicationAssignedTo where the application id must be equal to the id of the current application.

 

After adding the following code to my page I get 0 records.

 

attributes: {
	"UsrAssignedTo": {
		// Attribute data type.
		"dataValueType": Terrasoft.DataValueType.LOOKUP,
		// The configuration object of the LOOKUP type.
		"lookupListConfig": {
			// Array of filters used for the query that forms the lookup field data.
			"filters": [
				function() {
					var filterGroup = Ext.create("Terrasoft.FilterGroup");
					filterGroup.add("Contact",
						Terrasoft.createColumnIsNotNullFilter("[UsrApplicationAssignedTo:UsrContact].UsrContact.Id"));
					debugger;
					filterGroup.add("AppFilters",
						Terrasoft.createColumnFilterWithParameter(
						Terrasoft.ComparisonType.EQUAL,
						"[UsrApplicationAssignedTo:UsrApplication].Id",
						this.get("Id")));
					return filterGroup;
				}
			]
		}
	}
}

 

Like 0

Like

1 comments
Best reply

Hello User 1997,

 

Similar filter example was already provided here with the only difference in the section name (there it was the Projects section, here it's Applications section).

 

Best regards,

Oscar

Hello User 1997,

 

Similar filter example was already provided here with the only difference in the section name (there it was the Projects section, here it's Applications section).

 

Best regards,

Oscar

Show all comments

Hi Community,

I have a requirement that in details once you created a record with a record number(for Ex:-800009),  you can't create another record with same record number. I have to restrict the duplicate creation of record number.

Can anyone help me to achieve this?

 

Like 1

Like

4 comments

Hello Jagan,

 

Unfortunately, at the moment, deduplication functionality can only be used for the main columns of the object, i.e. You cannot set up rules for searching for duplicates for details.

 

Details pull information from another section. It is necessary to search and merge duplicates in the section itself. 



We have already registered the idea for our R&D team to implement this functionality in further releases. I will assign your case to this project in order to increase its priority.

 

Best regards,

Bogdan

Hi Bogdan,

Can I get the script code for How to achieve the deduplication functionality for the  main columns of the object?

Regards,

Jagan

Jagan Nayak,

 

Hello,

 

Unfortunately, as of now we do not have any ready to use examples of such implementation done by code. 

 

Best regards,

Anastasiia

+ 1 for this functionality

Show all comments

Hi Team,

 

I'm looking for a solution where the current date can be fetched from the system in edit page code of a section. 

 

I tried using: 

var today = new Date();

var dd = today.getDate();

 

but is not working. Kindly help

 

Thanks,

Sarika

 

 

 

 

 

 

Like 0

Like

1 comments

Hello Sarika,

 

that seems to be regular JS code which works properly independently from the environment. Could you please specify what is exactly not working? It does not generate a number at all? Or it does generate a wrong one? How exactly are you using later this date?

 

Best regards,

Dariy

Show all comments

Hi Team,

 

There is one section  section1 with a lookup Lookup1 and another section section2 that has the same lookup Lookup1. I want to fetch the value of two columns of section1 with the same lookup value that is selected in section2. 

 

Kindly help me achieve this.

 

Thanks,

Sarika

Like 0

Like

1 comments

Hi Sarika,

 

You need to debug the ESQ execution to find the way to get the values needed. Here is the article related to ESQ that can be useful.

 

Best regards,

Oscar

Show all comments

Hi Team,

 

I'm facing the below error while saving the edit page schema.

 

 

Kindly assist in solving the error.

Like 0

Like

1 comments

Hi Sivaranjani,



The most possible reasons for the issue are: 



1) Empty ParentId for the module that the parent should have (you should deploy the OOB DB check with a query)



SELECT * FROM SysSchema

WHERE ManagerName = 'EntitySchemaManager'

AND ParentId IS NULL



set of return values on the box and on the site with the problem. If it is different, then delete such objects from the system (DELETE FROM SysSchema)



2) empty metadata for some object/scheme in the system. 



SELECT Id, CAST (MetaData AS varchar (MAX)) FROM SysSchema

WHERE CAST (MetaData AS varchar (MAX)) = ''



You can also look in the application logs in the Common and Error log files for whether additional information on the generation of statics has been recorded (usually the error should be signed there with details). And you can also directly filter all schemes by the "Has error" filter in the configuration:



 

and see if any objects in the list are returned. If yes, then "Last error message" will be filled on the object in "Properties":

 

and

 

Best regards,

Bogdan

Show all comments

I'm trying to sync activities from multiple email accounts but I'm being prompted that my an account is active.

Like 1

Like

0 comments
Show all comments

Hello community,

 

I am trying to get the organizational roles for a specific user. How to check if the role specified for that user is organizational? 

Like 0

Like

1 comments

You can check the SysAdminUnitTypeValue. 

  • Functional roles have a value of 6
  • Organizational units can have 0 (an organization) or 1 (a department/division in the organization)

If you need code to retrieve a user's roles they belong to, I have an article here with some code you can use https://customerfx.com/article/determining-if-a-user-has-a-specific-rol…

Ryan

Show all comments

Hi,

I'm trying to install add-on from Marketplace (https://marketplace.creatio.com/app/word-pdf-attachment-converter-creatio), but an error occurse in the process of instalation:

2022-03-23 15:20:14,091 Errors and (or) warnings occurred while compiling configuration dll

2022-03-23 15:20:14,091 Autogenerated\Src\GlbAsposePDFHelper.GlbWordToPdfConverter.cs(5,8) error CS0246: The type or namespace name 'Aspose' could not be found (are you missing a using directive or an assembly reference?)

 

Please suggest how solve this issue. Detailed log file is attached.

 

Thanks!

 

File attachments
Like 0

Like

1 comments

Hi,

 

The add-on is only compatible with Creatio 7.15.0 and earlier. We recommend using the following add-on instead: https://marketplace.creatio.com/app/asposepdf-connector-creatio.

Show all comments