Sales Creatio | Community Creatio

SysModuleEdit

Package Installation Error

Sales_Creatio

8.0

Installation error about SysModuleEdit

Andrew Sheng

11:22 Feb 13, 2023

Hello community,

I got an error while installed package from DEV to PRE environment. The error in the log showed as below. Please advise what was wrong and what should I do?

Thank you in advance!

2023-02-13 10:24:54,107 Lookup values "SysModuleEdit_SysModuleEditManager_3060a5b7123046008292d2ff391eca00" from package "Dynasafe1" installed
2023-02-13 10:24:54,170 Error occurred while installing data "SysModuleEdit_SysModuleEditManager_2e6d095fc4d0489e85718fd9726cd018" in package "Dynasafe1". UId c3395037-7ea2-4919-a3bf-75881b2dd66f: 23503: insert or update on table "SysModuleEdit" violates foreign key constraint "FKfswQzuMwAT8Bnlby6UilfQqmU"
UPDATE "public"."SysModuleEdit"
SET
	"ModifiedOn" = TO_TIMESTAMP('2023-02-13 10:24:54.154', 'YYYY-MM-DD HH24:MI:SS.FF3'),
	"ModifiedById" = '{410006E1-CA4E-4502-A9EC-E54D922D2C00}',
	"SysModuleEntityId" = '{45417B49-B9B2-4255-893D-F1FB10103294}'
WHERE
	"Id" = '{2E6D095F-C4D0-489E-8571-8FD9726CD018}'
2023-02-13 10:24:54,201 Terrasoft.Common.DbOperationException: 23503: insert or update on table "SysModuleEdit" violates foreign key constraint "FKfswQzuMwAT8Bnlby6UilfQqmU" ---> Npgsql.PostgresException: 23503: insert or update on table "SysModuleEdit" violates foreign key constraint "FKfswQzuMwAT8Bnlby6UilfQqmU"
   at Npgsql.NpgsqlConnector.<DoReadMessage>d__157.MoveNext()

1 comments

Cherednichenko Nikita

12:50 Feb 22, 2023

Hello,

The package installation issue is caused by the fact that the elements "SysModuleEdit_SysModuleEditManager_2e6d095fc4d0489e85718fd9726cd018" from the Dynasafe1 package have bindings to non-existent data.

The "SysModuleEdit_SysModuleEditManager_2e6d095fc4d0489e85718fd9726cd018" element contains the binding ID 45417B49-B9B2-4255-893D-F1FB10103294 of the SysModuleEntity object (SysModuleEntityId column), but the SysModuleEntity table does not contain this ID.

Show all comments

8.0.5

Freedom_UI

client_module

Sales_Creatio

8.0

How to read the start date value to validate enddate value before saving a record

Gargeyi Gnanasekhar

11:53 Feb 08, 2023

Hello Community,

I wanted to validate Start date and enddate. For start date I will use current date to validate. But to validate EndDate I wanted the value of Startdate field.

I want to know how to read the startdate attribute value in the end date validator.

I am able to get the value of the attribute in handler, But i could not get value in the validators

"usr.usrenddatevalidator":{

               "validator": function(config){

                   return function(control){

                       var date1 = new Date();

                       var date2 = new Date(control.value);

                       var date3 = startdateAttributeValue;

                       return (date2 < date1 || date3 >= date2) ? {"usr.usrenddatevalidator": { message: config.message }} : null;

                   };

               },

               "params":[

                   {"name":"message"}

                   ],

               "async":false

           },

Thanks in Advance

Gargeyi.G

4 comments

Oleg Drobina

19:30 Feb 08, 2023

Hello Gargeyi,

Unfortunately there is no way to get data from other controls on the page in the context of validator execution triggered on some of the controls on the page. I've asked our core R&D team to add the possibility to operate with other controls values in terms of validator execution. Thank you for helping us in making the app better!

NCS.JulioFalcon

23:16 Aug 14, 2024

Oleg Drobina,

Thanks Oleg

I have the same issue, I saw this issue was from more than one year, I'm working on Creatio v8.1.3. Is still not possible to resolve what Gargeyi Gnanasekhar ask?

In my case I need to validate just when some conditions met regarding some data in the page, for example, the type of document is type1 or type2 or type 3.

Is there any workaround to accomplish this need?

Thanks in advance

Anhelina

14:09 Aug 15, 2024

Julio.Falcon_Nodos, hello!

I've checked the problem status, and it's in the process of being resolved. Follow the release updates to be the first to see the news.

souresh khandelwal

18:57 May 26, 2025

Hi

follow below post, I hope you'll find a better solution to your query

How to Read Custom Attribute OR Other Field Value in Validator | Community Creatio

Show all comments

homepage

Sales_Creatio

8.0

Filter Lists on Homepage by Owner

Vladimir Sokolov

18:16 Feb 07, 2023

Hello!

As Homepages have options to add different components, is it possible to add differenct filters (e.g. by Year, by Owner and so on) to different Lists?

E.g. we have list of ordered and invoiced products. So, users should have options to filter these lists by predefined fields (Year, Owner)

Thank you for help!

1 comments

Yuliya Gritsenko

15:58 Feb 09, 2023

Hello,

Unfortunately, it is not possible to add an option to filter lists on a Homepage.

However, you specify data filtering conditions while setting up a chart as described in this article.

Best regards,

Yuliya Gritsenko

Show all comments

maps

OpenStreetMap AccountAdress

GPSN

GPSE

GPS

Sales_Creatio

8.0

GPSN GPSE fields are not updated when account address is created

Sasori Oshigaki

16:02 Feb 07, 2023

Hello Team,

When I create an address the GPSN and GPSE fields are not updated. THe map although shows the excat location as it should be. Any idea why this can happen ?

Sasori

3 comments

Kate Karpik

17:39 Feb 08, 2023

Hello, Sasori!

Could you please provide more details on how exactly did you add an account address?

Please note that GPS N and GPS E fields will populate only if you add an address manually.

For example, if you add value using import the fields won't be populated automatically.

Also, please try to reproduce the issue again but with an open browser console (press F12 to open it).

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

Best regards,

Kate

Sasori Oshigaki

14:22 Feb 10, 2023

Kate Karpik,

Thank your for the reply Kate.

The Account data and Account adress data are added in the system through integration with third party system via ODATA.

Should the problem exist in this scenario ?

Sasori

Sasori Oshigaki

18:05 Feb 10, 2023

Kate Karpik,

From what I can understand the update of the GPS fields is done only when clicking Save (front-end event) in the Account Address.

Is there any way or workaround to update these fields if the Account and its address are created via the OData4 Protocol ?

Show all comments

Feed

notifications

Sales_Creatio

7.17

Follow the feed notification

Vladimir Sokolov

11:54 Feb 07, 2023

Hello!

When user clicks "Follow the feed" (e.g. in exact Document), they expects to receive notification in CTI-panel on every Feed/Comment added to that Document.

However notifications do not appear. Is it normal behavior or anything wrong?

And is there any option to notify users about Feed/Comment added to the Document they follows?

Thank you

1 comments

Bogdan

13:42 Feb 07, 2023

Hello Vladimir,

It's expected behavior.

As for now, your business task could be achieved by business process.

Show all comments

Sales_Creatio

8.0

How to add Rich Text column from section wizard

Adharsh

17:18 Feb 06, 2023

Hi All,

I could able to add the rich text column from the Freedom UI page using the designer for Contact section.

But when I tried to add the rich text field from the object,

and drag-deop the element from the section wizard, this column seems to be a normal Text field.

Creatio Product version - 8.0.5.2483

How to make this coulmn as actual rich text field similar to which we see in Freedom UI?

3 comments

Best reply

Ryan Farley

17:28 Feb 06, 2023

I don't believe that data type works for classic pages. Instead you can use the steps in this article to convert a text field to a rich text editor:

https://customerfx.com/article/adding-custom-rich-text-editors-to-a-pag…

Ryan

Ryan Farley

17:28 Feb 06, 2023

I don't believe that data type works for classic pages. Instead you can use the steps in this article to convert a text field to a rich text editor:

https://customerfx.com/article/adding-custom-rich-text-editors-to-a-pag…

Ryan

Kavya

12:46 May 17, 2023

Ryan Farley,

It's very useful. What if I want 2 rich text field in one section page. I tried to create 2 rich text field . All are working good except when I tried to upload image. Image is being cloned in both the field. If I upload image in one of the field it is been shown in both as well. Any solution for this issue?

Mid

16:50 Jul 10, 2023

Hi,

Please may I ask can the field set as "Rich Text" then be printed without any html characters?

Show all comments

Freedom_UI

Sales_Creatio

8.0

Default Image

Yasaswini Indurthi

12:27 Feb 06, 2023

Hello Community,

How can we set a default Image for image link column in freedom UI?

I want to Change the Image to my own Default Image. Can someone help?

Thanks in advance!

Indurthi Yasaswini

7 comments

Best reply

Ryan Farley

22:17 Feb 06, 2023

Julio.Falcon_Nodos,

Julio, he is referring to the Image column type that can be added to a Freedom UI page. It uses a default icon called "image-placeholder"

Ryan

Shivani Lakshman

14:48 Feb 06, 2023

Hello community,

We have tried Localizable images and direct links to SysImage as well. Please give an example of how to use Resources.Images to have a default image set up

Ryan Farley

18:55 Feb 06, 2023

Hello,

That image is not a resource image, but a mat-icon. I don't know whether the component has a property to select the default icon. I tried guessing at a few:

icon
defaultIcon
default
image
defaultImage

None of the above worked. It's possible that it does not have a property to set the initial default icon - but that seems unlikely? Either way, we'll have to wait for more documentation on what properties the component supports I suppose.

Ryan

NCS.JulioFalcon

19:50 Feb 06, 2023

Which image, this one?

Ryan Farley

22:17 Feb 06, 2023

Julio.Falcon_Nodos,

Julio, he is referring to the Image column type that can be added to a Freedom UI page. It uses a default icon called "image-placeholder"

Ryan

NCS.JulioFalcon

23:38 Feb 06, 2023

Thanks Ryan, sorry, also have no idea how change it

Yuliya Gritsenko

20:55 Feb 07, 2023

Hello Yasaswini,

You will need to add these fields as shown on the screenshot:

"placeholderMode":"icon",

"placeholder": "eye-blue",

Best regards,

Yuliya Gritsenko

Ryan Farley

22:30 Feb 07, 2023

Yuliya Gritsenko,

Thanks for this Yuliya. How can we go about finding this sort of thing out for ourselves in the new angular components? In the Extjs-based pages, it's easy to look at source to see what things can be done. However, with the angular components, plus everything being minified, it's very difficult to find where to look. Are there any tricks to using devtools to find the source of the components to look for this sort of thing (even if minified)?

Ryan

Show all comments

detail

Make_the_list_editable

Sales_Creatio

8.0

HOW TO set “Make the list editable” as true after creating a detail

Amritha Mayan Gorky

16:36 Feb 04, 2023

Hi Team,

We have created a detail and while creating didn’t opt for “Make the list editable” checkbox [didnt check it] and saved it but now not able to select the box and looks like it is locked.

Question : is there a way to check the “Make the list editable” checkbox

Thanks in advance!

Regards,

Mayan

File attachments

Make the list editable.png

1 comments

Akshit

16:18 Feb 05, 2023

Hi Amritha,

You can also make the editable list in detail following this article - https://academy.creatio.com/documents/technic-sdk/7-13/adding-detail-editable-list

No need to create replacing schema if it's your custom detail object because you already have it.

Hope it helps

Show all comments

location

#geolocation

Is there a way to find contacts / accounts near a specific city?

Christian Waidner

11:55 Feb 03, 2023

I'm searching for a way to find all accounts or contacts in maybe 50km around my city. Is there an easy way to achieve this in creatio crm?

Thanks

2 comments

Anastasiia Zhuravel

15:58 Feb 03, 2023

Hello Christian,

As of now it's not possible to achieve this business task with a help of basic system tools.

We've registered a query for our R&D team to consider implementing such functionality in the upcoming releases.

Thank you for helping us to make our application better!

Best regards,

Anastasiia

LÉZORAY Nicolas

18:27 Jun 24, 2024

i did it with SQL, look here in the comment: https://community.creatio.com/questions/there-way-query-list-near-accou…

Show all comments

delete records

permissions

recordpermission

Sales_Creatio

8.0

Block deletion of data records for every role and group

Markus Kumpfmüller

17:53 Feb 02, 2023

Dear Community,

is there any way to block the deletion of records of an object for all users and user groups (including system administrators and the supervisor) depending on a lookup value, such as a status.

Adjusting the object permissions still let's sysadmins delete a record.

1 comments

Dmytro Vovchenko

11:43 Feb 07, 2023

Hello Markus,

You can write your own EventListeren on onDeletnig event and if your condition is satisfied, you can call base.OnDeleting(sender, e).

If not, it will block the delete action no matter who is the user.

public override void OnDeleting(object sender, EntityBeforeEventArgs e) {
				var entityOrderProduct = (Entity)sender;
            	var OrderProductid = entityOrderProduct.PrimaryColumnValue;
				string name = entityOrderProduct.GetTypedColumnValue&lt;string&gt;("Name");
				if (name != 'someting'){
					base.OnDeleting(sender, e);
				}
			}

Show all comments

Subscribe to Sales Creatio