2

We have a requirement to generate a report on every iteration/version of component published.

For example, if a component published 3 times within the requested date range, then all 3 versions has be retrieved and show them in a report.

It seems like we can get this information by querying WFL_PROCESS_HISTORIES table.

Could you please let me know how to get this data using core services or there is any other approach to generate this kind of report?.

We are using 2011 SP1 version.

Appreciate your inputs.

  • One thing to note, WFL_PROCESS_HISTORIES will have details of publish only if it is done through workflow. If that is not the case always that you publish outside the workflow also then please revisit your question. – Hiren Kaku Jul 13 '15 at 19:08
  • Hiren, At this point of time, we are trying to generate a report on workflow publish items. So trying to see how to to get the old published versions of a component.... – vijay Jul 14 '15 at 14:51
1

If I understand your question correctly you want to display information regarding when an item was published, which version etc.

By default, Tridion does not keep track of historical publish data and keeps overriding the publish information and keeps track of only the last published transaction for any given item.

If you want to capture details of which item version to which target type, by whom, when etc. you have to write event system code to subscribe to the

EventSystem.SubscribeAsync<PublishTransaction, SaveEventArgs>(OnPublishStatus_Initiated, EventPhases.Initiated);

to capture the information. You can get all the information that you are looking for if you subscribe to this event and then capture it from the publish transaction.

We had similar requirement and we wrote event system code which triggers on publish to capture the relevant information and keep it in a custom DB. We have also written a GUI extension to display the information which allows the user to select an item and then with our GUI extension we display the information that we captured for the item which includes which version which target, when, by whom, whether the transaction was successful or not.

Once you capture the information, you can use it as you wish.

Hope this helps.

| improve this answer | |
  • Thanks for the inputs. But in Tridion CME UI, under Workflow management there is process histories section. Under this section we can see all the components(all versions) published by the authors. This data shows that Tridion stores this info in a table and I'm trying to see how to retrieve data from this table and generate a custom report to business. – vijay Jul 13 '15 at 17:04
1

As Vipin says, Tridion does not store this information out of the box.

As well as a custom database, you could also consider writing this information to the Component's/Page's Application Data (using Event System code) and then writing a tool to retrieve this (via the Core Service).

You will need to be aware of anyone purging old versions of content items as part of the normal Tridion maintenance, as this may invalidate your versioning information.

Depending on the reasons for storing this information (legal, etc.), you may want to consider a dedicated archiving tool - such as Archive Manager or PageFreezer.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.