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?
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.
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.
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.
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!
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.
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.
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.
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"?
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.
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.
