[
{
"category": "All Cases",
"ID": "all_cases",
"table": "sn_customerservice_case",
"view": "csp",
"card_view_primary_column": "number",
"card_view_secondary_column": "short_description",
"card_view_additional_columns": "product|contact|account|priority",
"target_page_id": "standard_ticket",
"guest_view": "connect"
"role_based_views":{
"field_service_agent_view":"snc_field_technician",
"agent_case_view":["snc_customer_service_agent","snc_manager"]
},
"sub_categories": [
{
"sub_category": "Open",
"sub_category_query": "active=true"
},
{
"sub_category": "Closed",
"sub_category_query": "active=false"
}
],
"run_time_filters": [
{
"column": "product",
"selection_type": "multi_select"
},
{
"column": "contact",
"selection_type": "multi_select"
},
{
"column": "account",
"selection_type": "multi_select"
},
{
"column": "priority",
"selection_type": "multi_select"
},
{
"column": "state",
"selection_type": "multi_select"
},
{
"column": "sys_updated_on",
"selection_type": "single_select",
"ranges": [
{
"label": "Last 30 days",
"query": "sys_updated_on<=javascript:gs.endOfToday()^sys_updated_onRELATIVEGT@dayofweek@ago@30"
},
{
"label": "Last 60 days",
"query": "sys_updated_on<=javascript:gs.endOfToday()^sys_updated_onRELATIVEGT@dayofweek@ago@60"
},
{
"label": "Last 90 days",
"query": "sys_updated_on<=javascript:gs.endOfToday()^sys_updated_onRELATIVEGT@dayofweek@ago@90"
},
{
"label": "Before 90 days",
"query": "sys_updated_onRELATIVELT@dayofweek@ago@90"
}
]
}
]
},
{
"category": "Actions Needed",
"table": "sn_customerservice_case",
"view": "Case",
"card_view_primary_column": "number",
"card_view_secondary_column": "short_description",
"card_view_additional_columns": "product|priority|state|contact",
"filter": "stateIN6,18",
"glyph": "check",
"target_page_id": "csm_ticket"
},
{
"category": "Work Orders",
"table": "wm_order",
"card_view_primary_column": "number",
"card_view_secondary_column": "short_description",
"card_view_additional_columns": "priority|state",
"glyph": "briefcase"
}
]
For more information, see
Portal Data List widget JSON parameters.
Each category in the widget displays a list of filtered records from a selected table. The default table is the Case [sn_customerservice_case] table. In a category, you can further
filter the records and display them in tabs using the pre_defined_filters parameter. You can also configure the filter options displayed in the filter icon using the run_time_filters
parameter.