object | Community Creatio

Question

16:26 May 01, 2024

Is it possible to create an entity based on a view (so with the "Represents Structure of Database View" checkbox checked, and with the view created using a SQL script) that inherits its record permissions from a "real" entity? I tried to do so by simply checking the record permissions checkbox and specifying the parent object in the "Object to inherit access permissions from" field of the entity, but this doesn't seem to work.

My setup is that we have the OOTB Leads entity, and then I've created a view over the top of it taking all columns but with a filter condition, to be used for reporting over Leads while filtering out certain Leads that should never be included in reporting so we have a more consistent reporting basis and don't have to make sure to include those filters in every widget. I added 2 columns to the view based on the Id and LeadName columns called UsrBaseLeadId and UsrBaseLeadName, which then have a lookup column UsrBaseLead added over them in the view-based entity. This lookup is then used as the "Object to inherit access permissions from" for the view-based entity.

There aren't any errors thrown in the logs when trying to do this, but non-super-users just can't see any of the records. When I tried to check a record in the view's permissions, I could see that the SysRights table for the view entity doesn't exist, so I tried creating that rights "table" as a view in the database that took its data from the Rights Table of the real entity, but while that seemed to work inasmuch as I could check a record's access rights and see that the correct rights were there and was even able to modify those rights, it didn't make it visible to a non-super-user.

0 comments

Show all comments

Question

Object-level business rule to calculate field

Robert Pordes

10:56 Sep 26, 2023

Hello Community!

I'm trying to fill a field with the result of a simple calculation (e.g. field A - field B).

However, when I create the business rule and select "set field" as action, I can only provide a constant value and not a formula...am I missing something?

Here is a screenshot of the

I know that I can use a business process to achieve this, but this would be much more simpler and elegant I think.

BR,

Robert

4 comments

Best reply

Damien Collot

11:15 Sep 26, 2023

It's not yet available in Freedom UI --> Creatio Roadmap indicates for Q4 2023 https://academy.creatio.com/docs/release/creatio-roadmap?check_logged_i…

Robert Pordes

10:57 Sep 26, 2023

I forgot to add that I use version 8.0.10.4735

Damien Collot

11:15 Sep 26, 2023

It's not yet available in Freedom UI --> Creatio Roadmap indicates for Q4 2023 https://academy.creatio.com/docs/release/creatio-roadmap?check_logged_i…

Robert Pordes

12:29 Sep 26, 2023

Damien Collot,

Thanks Damien, at least I know that I did overlook something.

Luis Tinoco Azevedo

11:33 Sep 29, 2023

Hi Damien,

I do not have access to the link to the roadmap.

I get this message:

Access denied

You are not authorized to access this page.

Is it restricted?

It is very interesting information.

Thanks,

Luis

Show all comments

Question

How to add a new System Variable (Object level)

Sasori Oshigaki

15:42 Jul 17, 2023

Hi Community,

Is it possible to add a new System Variable to be used in the Object level, so that we can use it as a default value?

Thank you

Sasori

3 comments

Best reply

Bogdan

13:18 Jul 18, 2023

Hello Sasori,

These values are hardcoded and you can't change them.

Bogdan

11:57 Jul 18, 2023

Hello,

It's possible. Default values can be set via configuration for all replaced objects. For example, if I want to set the default Account for Orders I create replaced object for Order and specify it in the default value field. It can be selected from existing values, system settings, or variables.

Please note that if the selected default value is removed or the type of system variable and lookup is different it can lead to different issues so do not select values that can or will be deleted.

Sasori Oshigaki

12:48 Jul 18, 2023

Hi Bogdan,

Thank you for the explantion but my question was a little bit different.

The question is how/where to configure a new System Variable beside the existing ones:

New ID

New Sequential Id

Current User

Current User Contact

Thank you,

Sasori

Bogdan

13:18 Jul 18, 2023

Hello Sasori,

These values are hardcoded and you can't change them.

Show all comments

Question

object

Atlas_release

Studio_Creatio

I cannot add parent object

Burak Toprak

09:45 Mar 02, 2023

I'm trying to add an object in my local account and add a parent object to the object, but when I try to add it, I get the error that the menu does not appear. I tried typing any name, it still comes up blank. What can I do?

5 comments

Burak Toprak

09:51 Mar 02, 2023

This is the area I mentioned on another computer, could it be related to the installation files?

Sourav Kumar Samal

10:23 Mar 02, 2023

Burak Toprak,

What is the product version you are using?

Burak Toprak

10:30 Mar 02, 2023

Sourav Kumar Samal,

8.0.6

Alla Blinova

15:46 Mar 02, 2023

Hi!

If you are trying to create an object that should inherit properties from other packages, and nothing is being inherited, make sure you have added dependencies to those packages.

To do this, you can open the "Dependencies" section on the package creation page and add dependencies to the packages from which you want to inherit properties. If the package has dependencies, the installation of these dependencies is checked during package installation, so make sure you have added all the necessary dependencies for inheriting properties.

If the problem still persists, make sure you have added the proper object settings according to your requirements. If necessary, refer to the Creatio documentation https://academy.creatio.com/docs/7-17/developer/development_tools/packa….

Ryan Farley

18:00 Mar 02, 2023

To add to what Alla said, whatever object it is that you want to select as your parent, find what package that object is in and then add that package as a dependency to your package. If you're wanting to select BaseEntity, I believe that package is Base.

Ryan

Show all comments

Question

Multiple Object replacement

LÉZORAY Nicolas

13:32 Dec 28, 2022

Dear,

I would like to create a custom object to replace the activityparticipant object.

However, when i tryed to create the remplacement object, i ve got the error:

Multiple replacements of same schema in single package are not allowed.

There are effectively two activityparticpant objects :

So how can i create a new activityparticipant custom object ?

Thank you,

Nicolas

4 comments

Bhoobalan Palanivelu

14:27 Dec 28, 2022

hi LÉZORAY Nicolas,

The Error: Multiple replacements of the same schema in a single package are not allowed refers that the object schema is already available in the current package.

Could you confirm the current package doesn't have this Object?

Also do you have any custom created package and where this replacement is tried?

Below is the successful replacement of object in custom development package.

BR,

Bhoobalan Palanivelu.

LÉZORAY Nicolas

15:56 Dec 28, 2022

Hi Bhoobalan Palanivelu !

I don't see how you managed to create the replacement object without error.

In the custom package i have no activityparticipant object:

If i go into Allpackage i have the same files as you (without the DEVLocal one):

Here's how i proceeded:

In the next screen, in the inheritance field, i entered "activityparticipant"

And then i got the error message:

Can you please let me know how you managed to create your custom item ?

Thank you for your help !!!

Have a nice day,

Nicolas

Bhoobalan Palanivelu

16:29 Dec 28, 2022

LÉZORAY Nicolas,

By chance could you please try it in another custom-created package (Custom_Transfer) rather than OOTB Custom?

LÉZORAY Nicolas

16:40 Dec 28, 2022

Bhoobalan Palanivelu,

It works in the another custom package.

I have never used this one.

Thank you !

Show all comments

Question

Financial_Services_Creatio_customer_journey_edition

8.0

Object Permissions are not updated

Petrika Mele

18:50 Aug 25, 2022

Hello Creatio team,

I manage to give access for ( Operations and Records )to this specific object from the Configuration.

Even though these changes are not reflected as can be seen in the printscreen below:

How can i overcome this problem ?

1 comments

Artem

14:34 Aug 26, 2022

Hello,

As we mentioned in the submitted case to support, we do not recommend you manually check those boxes, to properly add them please follow the steps below:

In the object, permissions section add your restrictions
The system will create a "copy" of the object you are working on in the current package as a reference to the original object
In that copy, you will see the checkboxes checked for the chosen options from object permissions.

Please make sure to set the "Current Package" system setting to the one you are developing in.

For further questions please refer to your support case.

Thank you.

Show all comments

Question

Studio_Creatio_enterprise_edition

7.18

Insert data from client module dynamically

Ensar

13:53 Jul 25, 2022

I created a harmony of data which comes from external web services. For example, I retrieved dataA for ColumnA, dataB for ColumnB, dataC for ColumnC etc. I want to INSERT this data to section object table which section page based on.

How can i bind these things?

1 comments

Cherednichenko Nikita

11:53 Jul 27, 2022

Hello,

You can create a business process in which you will fill in the required fields received from the web service.

Details on the academy website:

https://academy.creatio.com/docs/user/bpm_tools/process_elements_refere…

Show all comments

Question

object

Studio_Creatio_free_edition

8.0

Object Creation Error

pubudu

06:54 Jul 18, 2022

2 comments

Kalymbet Anastasia

18:06 Jul 18, 2022

Hello,

Such error may occur if any of the default localizations were deleted (any records from the dbo.SysCulture)

Please flush Redis of your instance and try to create an object again.

pubudu

08:51 Jul 19, 2022

Yes Did It's working Thank you

Show all comments

Question

Sales_Creatio_enterprise_edition

7.18

How to make custom search on object based on detail rows ?

Julien Gunther

11:24 Dec 17, 2021

Hi community,

I need a way to sort the rows of a data grid according to the values present in a detail.

I have my detail in the candidate object like this:

Here is a small simplified diagram of the relationship between my lookup, my detail and my object:

I would like to run this sql query to filter the candidates :

SELECT c.* FROM technocandidats tc
RIGHT JOIN candidats c ON c.id = tc.candidat_id
WHERE tc.techno_id = n OR
tc.techno_id = n OR ...

where "n" will be the techno's id.

Is there a way to do this directly in the section's advanced filters?

Or better still, in a box on top of the section like the one in my candidat object where the detail appears? Or even better, make that in a preconfigured page ?

Best regards,

Julien Gunther

1 comments

Bogdan Spasibov

17:11 Dec 20, 2021

Hello Julien,

I believe this should be possible as you have the connections between your objects. Could you please contact Creatio support team using support@creatio.com so we can help you with the filter setup in your system?

Thank you,

Bogdan S.

Show all comments

Question

object

creation

Studio_Creatio_free_edition

7.18

Primary Column property not set

Robert Towler

01:25 Nov 19, 2021

When I try to create a new object I get the message "Primary Column property not set" I cannot see anywhere in the object creation page to set this.

Can someone direct me to where to set this property

I using the trial version

2 comments

Best reply

Ryan Farley

06:39 Nov 19, 2021

Hi Robert,

Typically, your object should have "BaseEntity" as it's parent. When BaseEntity is selected as the parent, it will inherit an Id column (plus others) and the Id column will be selected as the Id column for the object. The error is letting you know that the object does not have a column selected as the Id column (when you select BaseEntity as the parent it will select the Id column as the objects "Id" property).

Here's an example of what I mean: https://share.customerfx.com/ApuEljAl

Ryan