Hi Daniel,

I’d probably try to go through the public activities API rather than taking the values from the Change Log markup. For content activities, I’d use ContentActionType and filter by both type and action:

var query = new ActivityQuery
{
    ActivityType = ActivityType.Content,
    Action = (int)ContentActionType.Publish
};

var activities = await activityQueryService.ListActivitiesAsync(query);

ActivityQuery.Action is documented as the action filter, and it is passed through to netActvitiyLogList as the action parameter, together with ActivityType as type.

So if you still need to call the stored procedure directly, I’d use the enum value rather than hard-coding values copied from the UI markup. I’d also keep the activity type in the filter, since the action value is tied to the activity type.

Hi Wojciech

Thanks for the suggestion. I had wondered if there might be a way to do this using a public API call instead of digging around in the internal details of the database. Also you have answered my query about where the values for ActionType are defined, which is very useful to know - https://world.optimizely.com/csclasslibraries/cms/EPiServer.DataAbstraction.Activities.ContentActionType?version=12.

Regards

Daniel

Hi Daniel,

Glad it helped!

Yes, I’d stay with ActivityQuery if it gives you enough for the reports and only drop down to the stored procedure if you hit a limitation

Regards,
Wojciech

Hi Wojciech

I can see that simply adding a reference to IActivityQueryService into a client class' constructor results in an implementation of that interface being injected. Do you know what magic is doing this? I would have expected to have to configure that in Startup.cs, maybe adding it to the services collection.

Thanks,

Daniel

Hi Daniel,

That’s Optimizely registering it for you.

The default implementation has ServiceConfiguration on it:

[ServiceConfiguration(typeof(ActivityQueryService))]
[ServiceConfiguration(typeof(IActivityQueryService))]
internal class DefaultActivityQueryService : ActivityQueryService

So CMS picks it up during startup and adds it to the service container. That’s why constructor injection works without you adding it manually in Startup.cs

For my own services I’d usually still register them explicitly, but a lot of built-in Optimizely services are registered this way

Hi Wojciech

Thanks so much for the insight! Optimizely / Episerver is a powerful system but I've yet to find a comprehensive guide to what's going on internally, so I must gather the clues as I explore.

Cheers,

Daniel

Hello, 

Yes, the official docs are usually my first stop, especially the class library docs when I’m trying to track down this kind of thing

These two might be useful here:

• https://docs.developers.optimizely.com/content-management-system/docs/dependency-injection

• https://world.optimizely.com/csclasslibraries/cms/EPiServer.ServiceLocation.ServiceConfigurationAttribute?version=11

I also find the community blog posts really useful for the practical side of things, and if it comes down to a very specific implementation detail, looking at the assembly can help as well 

Regards,
Wojciech

Thanks again.

Two gotchas if you build a report on this, checked against the 12.x assembly: the call is IActivityQueryService.ListActivitiesAsync(query) returning IEnumerable<Activity> (cast to ContentActivity), and MaxResults defaults to 100, so page with the FromActivity cursor rather than a huge number. Also CreatedAfter/CreatedBefore are exclusive, which trips you up on month boundaries.