Category Reporting

[Keavon Hunter]

Category Reporting

How would I get a report that would give me information on Categories.  I would like to know what services are associated to what categories all if possible.  I would also like to know if we have services that don't have any categories associated at all.  We are trying to make sure that everyone is following the same rules when it comes to categories etc, thanks!

[Ed Contini - newScale]

Wendy - MVCI
4:30am, May 27 

Hi - we have code we use to pull this information from the database. Please see below. Hope this helps - thanks - Wendy

Select

  da.name, dc.name

from

  rcuser.defcategory.da,

  rcuser.defcategoryservices db,

  rcuser.defservice dc

where

  da.categoryid = db.categoryid and

  db.serviceid = dc.serviceid and

  dc.isinactive = '0'

[Ed Contini - newScale]

Anthony Erickson 
8:19am, May 27 

Wendy, thanks for that - that's something we've been after for a while too!

Cheers,

Ant

Cheers,Ant