Asset list options

Squiz Matrix Support
1

Hi there,


Was wondering if it is possible to create an asset listing that displays a list of the sites pages along with what work-flow the page has applied to it and the permission of the users to that page.



Any help would be gladly appreciated!



Thanks

2

Using an asset listing you can display the statuses of a particular asset, but not the name of the workflow/s applied. Workflow information is only exposed in the editing interfaces of individual assets. That being said if you wanted to do something like show all the assets currently in workflow you could simply list out assets with the status of 'pending approval'.


Exposing permissions is usable by the permissions keywords on the manuals page. If I recall correctly this only shows information about users who have the permission directly applied, and not permissions inherited through group/role membership (which could potentially be quite large).



Best to have a bit of a play with those and see if they suit your needs. Otherwise you might be able to work around display requirements by filtering the results by permission and/or status.

3

Many thanks for your response! :slight_smile:


I was primarily after a quicker method in listing all of the workflow names applied on each page and couldn't find any keywords that could do that- so was just checking before i carried this task out!!



It probably means i need to go through each page and make a note instead!

4

[quote]
Many thanks for your response! :slight_smile:



I was primarily after a quicker method in listing all of the workflow names applied on each page and couldn't find any keywords that could do that- so was just checking before i carried this task out!!



It probably means i need to go through each page and make a note instead!

[/quote]



Probably a good time to learn the database structure, and how to query it with SQL :ph34r:

5

[quote]
Probably a good time to learn the database structure, and how to query it with SQL :ph34r:

[/quote]



Good idea. The database is a little complicated for first timers but all the information is there and you could potentially extract a list using the DB data source asset.

6

Thanks everyone! I can feed back to our database expert :smiley:

7

Hi Zabby


There is a report asset for doing exactly what you are after, except it wont get the permissions for you. The structured asset report will let you create a report that gives you various information for the assets within your site, including the workflow schemas applied. You can view the report on the front end as well.



Cheers

Shane

8

Wow that is extremely useful to know!
Just what i needed :slight_smile:

Thanks alot Shane

9

No problem. There are some traps with report assets though, be careful with how much of your site you try and report on in any one go as they can load the system a bit when you run them.