Developing a workflow task list

(Nick Gorst) #1

Hi,


I'm just new to MySource Matrix. I have been asked if it is possible to develop a summary list of pages waiting in workflow for a specified group. I believe that this functionality does not come out of the box and I thought that it may be possible to build a simple tool that queries the database and returns a list of pages that are waiting for approval by a specified group. The only problem I have is working out what tables to use or even if the relations exist to do this (I'd expect that there should be some way of achieving this).



Can anyone help me work out what tables to query so that I could build an external ap that could do this?



Nick

(Greg Sherwood) #2

This data is stored in the DB as a serialized array, so you will not be able to do the "for this group" part without a PHP script using Matrix function calls. The most a DB query can get you is a list of assets currently in workflow, which I think you can do with an asset listing anyway.

(Nick Gorst) #3

Thanks Greg

Can an asset listing list assets in a workflow grouped by workflow and step? Or for a specific step in a specific workflow? Alternatively, if I wanted to write a program to generate the list by group, Where would I find information on the correct matrix calls to make?
(Greg Sherwood) #4

No it can't. The internals of the workflow system are not exposed to other parts of Matrix.


[quote]Alternatively, if I wanted to write a program to generate the list by group, Where would I find information on the correct matrix calls to make?[/quote]

You'd have to look in the code. A good place to start is core/include/workflow_manager.inc and the /scripts directory (to show you how to load Matrix into your script).