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

3 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.

Show all comments

Hi,

I enabled the change log in the Project section. I want to use that data in dashboards (like Latest Stage Change Date and more) but can't find the object where this data is stored.

Can you please assist? 

Thanks,

Chani

 

Like 0

Like

0 comments
Show all comments

Hi! 

I saw that in Creatio, I'm able to see the change log only for the things that we've created, but I can't see the changes made by anyone in the tabs that are out of the box like the [Feed], [Attachments and notes]. I want to mention that I'm admin and still nothing into the change log about these tabs. 

What should I do?

 

Thank you!

Like 0

Like

2 comments

Hello,

You could set up a change log to see who created, modified, and deleted feed messages for a general list (the object of the feed message is called SocialMessage) and the same for [Attachments and notes] tab.
Please see the link below: 

Set up the change log

 

We registered this idea in order to select the necessary object to log the website.

Kalymbet Anastasia,

Is it possible that we can display the change logs as a detail of a page?

Show all comments

Dear Community,

 

Is it possible to have a changelog as a detail?

We would like to see all the changes made to a field of an object visible in a list.

I assume that this list is being saved to an object as well?

 

Let's say that I create an entry in the Contact Change log to see whenever a name is changed, we can find this info through:

https://prnt.sc/zza09f

But it would be nice to see the list/data in a detail on the contact page itself.

 

Any help is appreciated, thank you!

 

 

Kind regards,

Yosef

 

Like 0

Like

2 comments

Dear Yosef, 

I guess that you can take a look at the following marketplace application which should cover your use case:
https://marketplace.creatio.com/app/change-log-creatio

Kind regards,
Roman

Dear Roman,

 

Thank you for this.

I installed it but it gave me an error... The only thing I need to know is where the info is being stored.

There should be a sys object somewhere?

 

Either way, thank you for the suggestion.

 

 

Kind regards,

Yosef

Show all comments

Hi,

Like the change log for a section where we can trance the changes add/edit/delete made by a user, is there a way to see the list of which records he have "viewed"?

Like 0

Like

1 comments

Hello Krishna,

 

Unfortunately, there is no possibility to track the information about viewed sections/records by system users. 

 

In case you would like to deny access to records for some users please feel free to use record permissions settings. For example, if the [Record permissions] option is enabled, only certain users or roles can view specific accounts or contacts.

 

More detailed information can be found in the Creatio Academy article: https://academy.creatio.com/documents/administration/7-15/object-permis…

 

Best regards, 
Olga. 

Show all comments

Hi Community,

On Change Log, how will I track who enabled the change log and added columns

 

Like 0

Like

1 comments

Dear Fulgen,

There is no mechanism to track who enabled the change log. However, by default it can do only the system administrators. To restrict the users from managing the change log, please use Can clear change log, Access to "Change log" section, View change log operation permissions.

Dean

Show all comments