Catalog Item - Chart Templates
G
Written by Gary Ditsch
Updated over a week ago

1.

Title: Missing Description

Table: sc_cat_item

Chart Type: Score

Aggregate Type: Count

Group by: Catalog

Conditions:

descriptionISEMPTY^typeNOT INbundle,package^sys_class_name!=sc_cat_item_content^sys_class_name!=sc_cat_item_guide^active=true

2.

Title: Missing Short Description

Table: sc_cat_item

Chart Type: Score

Aggregate Type: Count

Group by: Item > Category

Conditions:

short_descriptionISEMPTY^typeNOT INbundle,package^sys_class_name!=sc_cat_item_content^sys_class_name!=sc_cat_item_guide^active=true

3.

Title: Missing Workflow

Table: sc_cat_item

Chart Type: Score

Aggregate Type: Count

Conditions:

typeNOT INbundle,package^sys_class_name!=sc_cat_item_content^sys_class_name!=sc_cat_item_guide^active=true^workflowISEMPTY^delivery_planISEMPTY

4.

Title: Active Catalog Items

Table: sc_cat_item

Chart Type: Score

Aggregate Type: Count

Conditions:

active=true

5.

Title: Active Catalogs

Table: sc_catalog

Chart Type: Score

Aggregate Type: Count

Conditions:


Did this answer your question?