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()

 

Like 0

Like

1 comments

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

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

 

Like 1

Like

3 comments

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!

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

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.

Show all comments

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!

Like 3

Like

1 comments

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

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

Like 0

Like

3 comments

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

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

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

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

Like 0

Like

1 comments

Hello Vladimir,



It's expected behavior.  



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

Show all comments

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?

 

Like 0

Like

3 comments
Best reply

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

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,

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?

Hi,

 

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

Show all comments

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

 

Like 0

Like

7 comments
Best reply

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

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

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

Which image, this one? 

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

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

Hello Yasaswini,

 

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

      "placeholderMode":"icon", 

      "placeholder": "eye-blue",

 

 

Best regards,

Yuliya Gritsenko

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

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
Like 0

Like

1 comments

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

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.

 

Like 0

Like

1 comments

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

Hello!



We have Product field in 'Product in order' detail and we can add Product.Type, Product.Category and other columns in the detail for employee users.

But is no option to add them in the detail for Portal users. It is incorrect way to add such fields and synchronise them (cause there can be a lot of them) to the detail.



How can we display such linked fields in details for Portal users?

Thank you!

Like 0

Like

4 comments

Hello Vladimir,

 

Thank you for your question. There is an intentional limitation for portal users not to be able to display linked objects. That is one of the core differences between the system and portal user.

 

Best Regards,

Dan

So, all characteristics of object (e.g. Product type, Product category, Product code, Product link and so on) should be added additionaly as physical fields to all objects like Product in Order, Product in Invoice, Opportunity product, Product in Contract and so on?

I believe that might be one of the ways to display the needed value. You just need to avoid using linked objects for the portal. 

Can anyone suggest other ways as well to choose the best one?

Show all comments