when we tried to create a report it worked normally when the user language was English, however

when a user language Arabic the BP shows the below error



System.NotSupportedException: Unsupported report type '0'

   at Terrasoft.Configuration.ReportEngine.Generate(ReportSettings settings)

   at Terrasoft.Core.Process.Configuration.ReportFileProcessingUserTask.InternalExecute(ProcessExecutingContext context)

   at Terrasoft.Core.Process.ProcessActivity.RunInCultureScope[T](Func`1 action)

   at Terrasoft.Core.Process.ProcessActivity.ExecuteElement(ProcessExecutingContext context)

   at Terrasoft.Core.Process.ProcessActivity.ExecuteItem(ProcessExecutingContext context)

   at Terrasoft.Core.Process.ProcessFlowElement.Execute(ProcessExecutingContext context

Like 0

Like

1 comments

Dear Sayed!

 

We can see that you have already submitted a case for our support team and this case is currently in progress. We will update you in that request. 

 

Have a great day!

Show all comments

Hello,

 

is it possible to configure that communication options should be entered with mask, like it can be set for simple fields?

Communication options block:

Simple field:

Thank you!

Vladimir

Like 3

Like

2 comments

Hello Vladimir,



There is no such option for now. 

 

However, we've registered it in our R&D team backlog for consideration and implementation in future application releases.

 

Thank you for helping us to improve our product.

Yeeess !!



This has been a little puzzle for ourselves and clients to implement. Communication block looks great but too limited in options, at the same time, simple fields are not as elegant in presentation ...

Show all comments

I need to read system settings in mobile application from client side. Can anyone help me on this?

Like 1

Like

4 comments

Hello Pavan,

 

Could you please elaborate on your business task? 

You can use Terrasoft.SysSettings.YourCodeSysSetting if the system settings is cached and enabled for portal users.

Bogdan,

I have a Boolean in system setting. I need to show a popup if the Boolean is false. For that, I have to read system setting value.

Hello Pavan,

 

Please check the Federico's reply above. Is it suitable in your case? 

Show all comments

Hello,

 

Lately i added a section for a custom object (let's call it mainObject), which has a collection of objects attached to (subObject), so there is a detail to show that subObject list on every mainObject pages.

Then i did another section to display the whole list of subObject, to get a global view of these.



But i now have troubles editing the subObject page : 

 

When i want to open the section wizard for subObject from its section, a page is opened but not the one actually used for editing,

The good one can be found by reading url of the page : Nui/ViewModule.aspx#CardModuleV2/Schema4dec7c8bPage

 

If i try to edit the subObject page from the mainObject page ( from the detail then the page designer),

the js framework fail with "Uncaught TypeError: Cannot read properties of undefined (reading 'moduleId')"



For now i can edit the code from Schema4dec7c8bPage for needed changes,

but i would prefer to understand what went wrong, and fix it.

Maybe adding a section for subObject did something wrong, as it already had an edit page at that stage ?

 

i hope it's clear enough :)

 

Best regards

Patrice

Like 0

Like

2 comments

Hello,



To analyze this issue, we need access to the site. Please write to us at our email: support.creatio.com.

Malika,

thank you Malika, i'll do.

Show all comments

We were trying to expose the automatically-created Change Log entities created by Creatio when change tracking is turned on for entities, which generally take the form of SysLog but don't actually get navigable entities created in the package. Is there any way to expose these, for example in a detail on a page in Freedom UI? We wanted to be able to specify our own sorting and filtering logic on the OOTB section, as it's quite frustrating to use - for example, every time you drill into a record, it resets the date range for that record to the current day. You also can't search for specific record IDs that you want to see modifications to unless the record never had a Name filled in which makes trying to see what happened to deleted records you know must have existed very difficult!

 

I tried manually creating an entity over the table name (specifying it as a database view so Creatio didn't try to create or update the actual table) but then adding the change log entity's columns wasn't possible due to them having to have the prefix before the names, which the automatically-created columns of the change log table didn't have (e.g. Id, ChangeTypeId etc). Any way of working around this or a way of adding a change log entity as List in the UI somehow?

Like 1

Like

5 comments
Best reply

You can avoid needing the prefix by clearing the prefix system setting. Then no prefix will be needed.

However, I'm not sure creating the object would be a good idea, perhaps? Seems risky. What I would do is create a database view wrapping the data and then expose that as an object instead. That seems like the best route to me.

Ryan

Any ideas on how this might be possible?

You can avoid needing the prefix by clearing the prefix system setting. Then no prefix will be needed.

However, I'm not sure creating the object would be a good idea, perhaps? Seems risky. What I would do is create a database view wrapping the data and then expose that as an object instead. That seems like the best route to me.

Ryan

Thanks Ryan, sounds like a great idea - then the view over the top of the change log table can have its columns renamed where the prefix isn't present to start with the prefix, which will avoid the need to turn prefix off and on when adding new columns to the change log view entity.

Harvey,

 

Can I ask, what tables the change log is saved to if you know?  Or if there is a view to read the change log?  There is an API I note but I have a scenario where a SQL query is the better option.

Hi Gareth, the name of the tables created for the change log is Sys[object name]Log, so for example for the Account entity, it would be SysAccountLog. Hope this helps!

Show all comments

Hi Community, 

 

I wanted to show a popup window with input box in business process to fill up some field and then continue with the process. 

Is there a way to do it in Freedom UI. I don't want to use Auto-Generated page as it doesn't open up always.

Any suggestions are really helpful.

 

Thanks

Gargeyi.G

Like 0

Like

1 comments

Hi!

Is it possible to make same date picker as for pipeline but for the List? 

 

Like 1

Like

1 comments
Best reply

Hello,



In Classic UI, there is unfortunately no option to change the date in the dashboard list. However, in Freedom UI, you have this option:



Link to article: https://academy.creatio.com/docs/8.x/no-code-customization/customizatio…

Hello,



In Classic UI, there is unfortunately no option to change the date in the dashboard list. However, in Freedom UI, you have this option:



Link to article: https://academy.creatio.com/docs/8.x/no-code-customization/customizatio…

Show all comments

In the academy documentation, there is limited information about using the ESQ/ORM server-side methods to delete data, with only 2 or 3 toy examples. We need to efficiently delete large volumes of data using server-side ESQ in one of our processes, but we can't see anything about bulk deleting while still firing off any event-based triggers on the entity or generating change log records for it. Obviously the direct Terrasoft.Core.DB delete statement would be very efficient, but would skip the Creatio logic where needed.

 

We've been able to delete records by iterating over a collection of entities matching the required filtering condition retrieved by using GetEntityCollection and then for each entity in the collection, running a FetchFromDB on its Id before deleting it, but this seems like quite a few steps more than should be required and doesn't do it in a batched way.

 

Any help would be greatly appreciated.

Like 0

Like

2 comments

Hello Harvey,

 

You can use out-of-the-box examples of bulk deletion logic. For example we can take the BulkEmailTargetArchiver class and the DeleteArchiveLevel method in it:

private void DeleteArchiveLevel(string sourceSchemaName, string targetSchemaName) {
			int processedRecords;
			do {
				var deleteQuery = new Delete(_userConnection).From(sourceSchemaName)
					.Where("Id").In(new Select(_userConnection)
						.Top(_batchSize)
						.Column("s", "Id")
						.From(sourceSchemaName).As("s")
						.Where().Exists(new Select(_userConnection)
							.Column(Column.Parameter(1))
							.From(targetSchemaName)
							.Where(targetSchemaName, "Id")
							.IsEqual("s", "Id")));
				processedRecords = deleteQuery.Execute(_dbExecutor);
			} while (processedRecords != 0);
		}

This is just one example of the logic. You can use:

 

select * from SysSchemaSource

where Source like '%DeleteQuery%'

 

to get other schemas in the application configuration with delete queries examples and build your own one using all examples you may find in the system.

Hi Oleg,

 

using these Delete classes bypasses Creatio’s internal logic though, right? So change logs will be inaccurate and any BPs that should be triggered on delete would not be triggered etc. This seems risky to me as important processes could hang off this, and I don’t know what other internal aspects of Creatio might be relying on logic that Creatio manages at an application level.

 

Is there any way to bulk delete while respecting that?

Show all comments

Hi,

How can I restrict the "send mail" action so that for all processes, e-mails can only be sent to addresses with a specific domain, and if another domain is used, a pop-up with an error message appears when saving the process?

 

Thank you.

Like 1

Like

1 comments

Hi Ivan,

 

Unfortunately, it's not possible to display a pop-up showing an error message when attempting to save a process that is restricted to a specific domain. However, you can achieve something similar by implementing your business process logic.



For example, you can store an email address in a parameter and check if the email address contains a specific domain. If it doesn't, you can change the parameter to an empty value. Then, uncheck the "Ignore errors on sending" option in the "Send email" action to display a pop-up if any errors occur. This way, you will receive a pop-up with an error message because having a different domain in the email address will result in an empty recipient, which leads to an error.



Show all comments

Hi, 



    I input the Chinese address on Account, however, it can't show on the map below,  Besides, the Creatio connector, mapsly, is okay to input Chinese address. Please help. 



I user the instance of Version 8.1.1.3635 locating in Japan.



Jeffrey / Taiwan user

Like 0

Like

2 comments

Hello,



Open Street Map is an external service; unfortunately, we cannot control its operation. Please note that this is mentioned in our Academy documentation: [link to documentation].



Now, let's go into more detail about how this service works.



Unfortunately, the Open Street Map service is not predictive, and searching a specific address requires maximum completeness and accuracy in the address input, including city, country, and postal code. However, if any of these indicators are incorrect (for example, a city that does not exist in the country), the search may be conducted based on different parameters.



It's also important to understand that OpenStreetMap is not Google, and the data in its database may differ. Therefore, it's essential to ensure that the data you are searching for exists in this service.



For example, you can notice that the address you provided does not exist in this service, so it displays the nearest address to the one you filled in: [link to OpenStreetMap].



Therefore, when filling in such addresses, you should rely not on Google but on the service used in the integration.



It's also worth noting that the address does not exist in the service even upon clicking on this building directly.



The OpenStreetMap service allows users to contribute data.



Unfortunately, as Creatio vendors, we do not have the ability to influence third-party services.

Our team is actively exploring alternatives to improve this functionality in future versions of the application.



I hope I was able to answer your questions.

Have a great day!

Thank you for your help, hope it will be solved in the next version release.

Show all comments