Hi Fulgen,

There is no example of using ESQ inside the business rule that is triggered upon a record save. But you can try creating a server-side logic that will be triggered upon the record save (either a process in the object or using the EventListener) that will then send a push notification and stop record saving in case some conditions are not met. To send a push notification you can use the following construction:

var userConnection = this.Get<UserConnection>("UserConnection");
var pushNotification = new PushNotification(userConnection);
var sysAdminUnitId= new Guid("85AEEF58-0827-41E0-BFC8-1C1DC7D97B6C");
var title = "Validation error";
var message = "Message text";
pushNotification.Send(sysAdminUnitId, title, message);
return true;

also

Terrasoft.Configuration

Terrasoft.Core

Terrasoft.Core.Factories

assemblies should be added to the code (or the process using). The sysAdminUnitId parameter is an Id of a user that should receive this message, can be dynamically received using the

(Guid)UserConnection.SystemValueManager.GetValue(UserConnection, "CurrentUserContact");

construction and SelectQuery class request to the database to get the SysAdminUnit Id value by ContactId.

Best regards,

Oscar

Oscar Dylan,

Hi,

How about using "store.loadPage". I think it is possible to use this, however it is not working for custom objects, it is only working for OOB objatcts like Contacts and Accounts. Any idea about  "store.loadPage"?

Hello,

Please note that you should register such questions as Cases for our Support team, as we will need to check your instance to see what the problem is. So please, register a new case and provide us with all the details there.

Kind regards,

Mira

Hello,

Could you please elaborate on your issue?

Thank you,

Artem.

for example -> some processes are scheduled in creatio scheduler to execute at some point of time. But at that time process start but never finish and still in running state after long long time. 

Why process stuck in running status? anyone can help!

Shruti,

The reason might be in the application restart.

If RabbitMQ is not configured to your instance - all data about the running processes will be lost when the application is down or restarted.



To fix the issue, please use RabbitMQ. It will save the data about the running processes in RabbitMQ memory.

 

Best regards, Alex.

Hello, Lirzae!

Please try to upload the report again but with an open browser console (press F12 to open it) and provide us with a screenshot of that. 

There might be errors that could help us find the cause of the issue.

Best regards,

Kate

Hello Rishabh,

I am afraid the used method presented in the referenced post will not work for your current need as you seem to have some replacements in the system. There are some alternatives, though.

First of all, it is recommended to create a section based on the object you need. This will give a lot of functions to work with the required entity.

If it is needed to work with lookups only - in your case, the easiest solution will be to populate it directly via the Lookup section (as it is done by default).

We are already working on the mentioned problem, and in future releases, there will be a specific tool to create advanced edit pages for lookup. (Planned for version 8.0.3)

I hope my answer was helpful to you.

Best Regards,

Dan

Denis Bidukha,

hey,

there is a tool now for create advanced edit pages for lookup?

thanks.

noyzada,

Hi! 

Yes, it is available if your version is 8.0.3 and higher.

The advanced lookup edit page may be created in Freedom UI designer and the required Object (lookup) should be chosen as a source.

Best Regards,

Dan

Hello Petrika, 

Please check whether you portal user has the needed access rights and can access other Contacts records, the issue may occur if the user doesn't have access to the Contacts records.

Best regards,

Anastasiia

That was the issue. Thank you Anastasiia

Hello Petrika, 

Yes, you can access here only Contacts that have existing system users. 

Best regards,

Anastasiia

Hello,

The logic provided in the previous post doesn't depend on the file size (that is specified in the system setting with "MaxFileSize" code). Additionally it doesn't use file locator in it, it only uses values from the account object column and compare it to the current date and time. There should be another custom logic that generates this exception, something that is triggered when adding the file to the system and if the upload is restricted another logic stops its execution with this exception.

Best regards,

Oscar

Oscar Dylan,

I have added the following code:

		#region Methods: Public
 
		public override void OnFileSaving()
		{
			var ClaimId = Entity.GetTypedColumnValue<Guid>("ClaimsId");
			var ResultESQ = new EntitySchemaQuery(UserConnection.EntitySchemaManager, "Claims");
			ResultESQ.UseAdminRights = true;
			ResultESQ.AddColumn("Id");
			ResultESQ.AddColumn("ClaimStatus");
			var Result = ResultESQ.GetEntity(UserConnection, ClaimId);
			var DCMStatus = Result.GetTypedColumnValue<Guid>("ClaimStatusId").ToString();
 
			if(DCMStatus == "ff78a06e-9d37-474a-841c-32a8faaa7776" || DCMStatus == "13c42d45-0fb9-4854-9a5d-5a5feb126db2" || DCMStatus == "19226327-e2ff-420c-937e-c36949be4425"
				|| DCMStatus == "3adf1d1d-bc90-475b-b24b-ca837e9ca9fc"|| DCMStatus == "942af147-3fc9-4a80-89aa-76f0412e0ade"){
			    base.OnFileSaving();
			}else{
			    throw new Exception("Attachments can not be added as Claim is already Submitted.");
			}
		}
 
		#endregion

When the file size is small, the following popup is coming:

When the file size is large, the following popup comes up:

The above popup comes only when the above condition is met. We have not implemented any other logic for this object. Could you help us here with what might be the cause of the issue, when it is working fine with smaller files but not with larger files.

Thanks,

Sourav Kumar Samal

Hello Robert,

Could you please elaborate on your business task?



Who do you need to reed the values of a record before the update?



Best regards,

Bogdan

Hi Bogdan,

I have a business process, which grants access permissions based on a linked contact in an activity (not the owner field).

When this contact changes, I need to read the value of this contact field that was stored before the update, so that I can remove the access permissions for that contact.

BR,

Robert

Robert Pordes,

There is no basic logic for your needs.

But, as a workaround, you can create a new column contactBackup in the activity object and store old contact there.

You can use Modify Data business process element to set the value for the contactBackup column.

Also, it is not necessary to add this column to the section page. It can be just a "system" column.

Best regards, Alex.

Robert Pordes writes:

When this contact changes, I need to read the value of this contact field that was stored before the update, so that I can remove the access permissions for that contact.

We do it in another way - remove all rights and set new ones. 

Vladimir Sokolov,

Thanks for the reply, but that doesn't work in our case, because the initial permissions can be quite complex, and also due to delegation we do not know the exact current permissions of the records.

I will post an idea for Creatio to implement this feature in the business processes, as it would be handy for several business tasks.

BR,

Robert

Aleksei Efimenko,

I have thought about this, too, but it is not very elegant and I don't want to create fields for every requirement and also don't want to have the fields visible in the filters for the users.

I will try activating and reading the change log in the business process...

BR,

Robert

Robert Pordes,

In case you dont want to show the fileld in any dropdown on the UI, then you can set the Usage Mode for that field to None.

Regards,

Sourav Kumar Samal

Sourav Kumar Samal,

That's a good point and I might consider this, thanks!

Hello Mariam,



I like the following way (you can make your own filtering condition to mark that Contact doesn't have such Case yet)