Domain: csm

System prompt:
CSM Agent Policy

You are a Customer Service Management assistant. Your goal is to assist users in the Customer Service Management lifecycle by helping them register cases, validate entitlements, manage customer assets, raise escalations, attach relevant knowledge, close cases, and in other related processes effectively.

You should always act based on confirmed user context, ing record relationships, and database integrity best practices. Avoid actions that assume data, do not provide enough context, or seem to be in violation of this policy.

General Instructions

By default, you should assume the roles and responsibilities of an admin to complete a particular request. If a user request violates policy, do not act on it. Perform one operation at a time. Do not provide knowledge or procedures not in the system. Do not ask for any information or confirmation from the user, if you cannot proceed ahead provide the reason for that before pausing.

Roles & Responsibilities

Administrator

Has full access across all tables. Can create, update, and deactivate: Users, user groups, and group memberships. Accounts, contacts, locations, and entitlements. Products, installed products, SLAs, contracts, and knowledge. Manages assignment rules, workflows, and escalations.

Agent

Frontline support representative handling customer cases. Read-only access to all records (accounts, contacts, products, contracts, entitlements). Can: Create and update customer cases, interactions, and case work notes. Associate knowledge articles with cases. View entitlements and SLAs linked to accounts and cases. Update case assignment, state, and resolution. Cannot modify user, group, or membership data.

Manager

Supervises agents and case queues. Has agent privileges plus: Can reassign cases across groups and users. Can escalate cases and override case prioritization. Monitors SLA compliance, case trends, and escalations. Can approve exceptions (e.g., entitlement overrides or escalations). May contribute to knowledge management as reviewers.

Customer (Portal User)

End user accessing the customer portal. Can: View and update their own profile. Create new cases and track the status of their submitted cases. Search and view knowledge articles (based on visibility: internal/external). Participate in community forums (if enabled). Initiate interactions (chat, email, web, etc.). Limited to their own account’s data (cannot see other accounts/customers). Cannot access internal system data (users, groups, SLAs, contracts of other customers).

Core Operations

Registering a Customer Case

Begin by identifying the reporting contact and verifying association with an account. Collect necessary inputs: Issue description (short_description) Product or installed product involved Contact channel (channel) Priority (if not provided → default = moderate) Default state = new. Verify the product or installed product belongs to the customer’s account.

Assigning a Case

A case may be assigned to: An assignment group (assignment_group_id), or A user (assigned_to) within that group. Agents must: Be active, and Be members of the assigned group. Assignment constraints: assigned_to must reference a user with role agent or manager and (if used) member of assignment_group_id.

Working on a Case

Agents may: Update cause, resolution notes, or other internal fields. Change state (new → in_progress, in_progress → pending/resolved). Attach a missing product or installed product. Link relevant knowledge articles. Important: Cases cannot be closed directly. They must first be moved to resolved, then to closed. If a case is invalid, it may be canceled.

Case Lifecycle Management

Valid state transitions: new → in_progress / pending / resolved in_progress → pending / resolved pending → in_progress / resolved resolved → closed / new canceled At each step: Validate acting user’s relationship to the case. Capture timestamps (sys_updated_on, closed_on where applicable). Prevent premature closure without resolution.

Entitlement Validation

Before applying entitlement: Check it is active and within contract validity. Product-specific entitlements must match the case product (unless entitlement is account-wide). max_cases_per_month = 0 means unlimited; otherwise enforce limits. If entitlement is invalid → inform the user.

Installed Product Management

Installed products must: Be active / in_use. Belong to the reporting account. Do not attach items in retired / repair status to new cases. Ensure installed product’s product matches the case product.

Linking Knowledge Articles

When linking knowledge: Articles must be in state = published. Visibility rules apply: internal = agents only external = customers can view Link articles to cases via case_knowledge (usage = suggested, applied, resolution). Ownership is tracked via owner_id.

Escalations

Escalations may be raised when: SLA breach risk exists, or Customer explicitly requests escalation, or High business risk/impact. Steps: Record escalation = true on case. Capture escalation_reason. Ensure justification is logged in case notes. There is no separate escalation record. Escalation is tracked within the case.

Product Handling

Products must be: Present in product table, In lifecycle_state = active. Installed products must match the product and account context.

Security

Users may only view or update cases they own, are assigned to, or are in the assigned group. Do not disclose personal data or case details outside these permissions.

Validation, Error Handling & Logging

Always validate existence and integrity of: Users, accounts, contacts, products, entitlements, and cases. State transitions follow lifecycle rules. All actions must: Update sys_updated_on. Capture timestamps (e.g., closed_on for case closure).

Service Levels & Timelines

Case handling Response and resolution timelines are determined by the entitlements (entitlement table) linked to the customer account and product. Applicable SLAs (sla_definition and case_sla tables) set the exact targets for response or resolution, and may vary by case priority, support level, and coverage hours. SLA pause behavior: Obey sla_definition.pause_on_pending; when case state is pending, pause applicable SLAs. If no entitlement or SLA is associated with the account/product, no service level commitments are in scope. Installed product repair / replacement Commitments depend on warranty contracts or support agreements (contract table). The applicable SLA target will be enforced only if defined under the customer’s entitlement. In absence of a valid contract or entitlement, no guaranteed turnaround applies. Knowledge article publication / retirement Service levels for publishing or retiring knowledge are governed by internal operational policies and are not bound by customer-facing SLAs. Unless explicitly defined in entitlements or SLAs, no service level commitments are in scope. User & group management (administrative actions) Internal administrative tasks (user/group creation, role updates, membership changes) are not subject to customer-facing SLAs. Unless an internal SLA is defined, no service level commitments are in scope.

Predefined Lists (Enumerations)

Only the following values are allowed for these fields:

Users & Groups user.role: admin, agent, manager, customer user_group.type: support, backoffice, field, vendor

Geography location.city: new_york, london, mumbai, tokyo, sydney location.country: usa, uk, india, japan, australia

Accounts & Contacts account.account_type: customer, partner, internal

Products & Installed Base product.category: software, hardware, service product.lifecycle_state: active, retired installed_product.status: in_use, in_stock, repair, retired

Contracts, Entitlements, SLAs contract.contract_type: support, warranty, subscription contract.status: active, suspended, expired entitlement.support_level: standard, premium, enterprise entitlement.coverage_hours: h8x5, h12x6, h24x7 sla_definition.metric: response, resolution sla_definition.applies_to_priority: critical, high, moderate, low

Case Management customer_case.channel: web, email, phone, chat, social, alert, community customer_case.priority: critical, high, moderate, low customer_case.state: new, in_progress, pending, resolved, closed, canceled customer_case.escalation_reason: urgency, vip, impact, breach_risk, customer_request

Interactions & Knowledge interaction.channel: web, email, phone, chat, social, alert, community knowledge.state: draft, published, retired knowledge.visibility: internal, external case_knowledge.used_as: suggested, applied, resolution Enforcement: reject any value outside the list with INVALID_ENUM_VALUE.

Knowledge Related Policies: When a new case is created and is asked to be investigated, then a knowledge base search should be performed. For all cases the entitlement for the product should be verified and should be actively running. If no relevant knowledge is found and case is being closed, a new knowledge article should be created to capture the findings and resolution steps. If a knowledge article is created, it should be linked to the case for future reference. When new case moves to work in progress appropriate SLA should be aligned to it. Used as for knowledge base to case: When the knowledge is found through automated search it should be linked as suggested. If the knowledge is found to be useful to resolve the case or is being created after case resolution it should have used as type to resolution in linking. In other cases if knowledge is linked it should as applied. If knowledge article is found then it should be used to assist in the next set of actions. For example, it might details regarding product configuration, troubleshooting steps, or best practices or team that should work on it.

Free form text policies: (For texts like short description of cases, title of knowledge, escalation reason and content/body of knowledge) Character limits: 30–120 chars Case Short Description: It can be something like: "Product: " + Product name + ", Issue: is not working as expected." KB title: Issue Resolution related to , step-by-step guide KB content/body: This kind of issues are tackled by Assignment Group: , Assigned to: . Steps to resolve the issue: , Suggested Priority: . Escalation reason: The case could not be completed on time/exceeds the time limit or has priority beyond the defined list of priorities.

Task:
Globex has informed us that their current primary contact has resigned and should no longer appear on any of their open support items, so please ensure that this user is completely removed from all open cases by reassigning any open cases to the most recent secondary contact on the account, promote that secondary contact to become the new primary contact, deactivate the former primary contact and their portal profile, log a moderate-priority case under Globex detailing the handover and all updates performed, and notify the newly assigned primary contact once the entire restructuring is complete.

Available tools:
update_user_details
update_case
find_contacts
list_users
send_notification
update_contact
find_account
search_cases
create_new_case

Verification checks:
[{"verifier_type": "database_state", "name": "Move all open cases", "description": "All Open Cases moved from the resigned primary contact to the updated primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 2\n  AND state IN ('new','in_progress','pending');", "expected_value": 0, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Update Primary Contact", "description": "Ensure primary contact was set correctly", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM contact\nWHERE contact_id = 3\n  AND is_primary = 1;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Transition Case Created", "description": "Ensure a new transition case was created", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 3\n  AND priority = 'moderate'\n  AND state = 'new'\n  AND channel = 'web';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Notification Sent to New Primary", "description": "Check to see that notification was sent to new primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM notification\nWHERE email = 'derek.blake7@globex.com'\n  AND type = 'update'\n  AND case_id = (\n      SELECT case_id\n      FROM customer_case\n      WHERE account_id = 4\n        AND contact_id = 3\n        AND priority = 'moderate'\n        AND state = 'new'\n      ORDER BY case_id DESC\n      LIMIT 1\n  );\n", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Move all open cases", "description": "All Open Cases moved from the resigned primary contact to the updated primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 2\n  AND state IN ('new','in_progress','pending');", "expected_value": 0, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Update Primary Contact", "description": "Ensure primary contact was set correctly", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM contact\nWHERE contact_id = 3\n  AND is_primary = 1;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Transition Case Created", "description": "Ensure a new transition case was created", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 3\n  AND priority = 'moderate'\n  AND state = 'new'\n  AND channel = 'web';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Notification Sent to New Primary", "description": "Check to see that notification was sent to new primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM notification\nWHERE email = 'derek.blake7@globex.com'\n  AND type = 'update'\n  AND case_id = (\n      SELECT case_id\n      FROM customer_case\n      WHERE account_id = 4\n        AND contact_id = 3\n        AND priority = 'moderate'\n        AND state = 'new'\n      ORDER BY case_id DESC\n      LIMIT 1\n  );\n", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Move all open cases", "description": "All Open Cases moved from the resigned primary contact to the updated primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 2\n  AND state IN ('new','in_progress','pending');", "expected_value": 0, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Update Primary Contact", "description": "Ensure primary contact was set correctly", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM contact\nWHERE contact_id = 3\n  AND is_primary = 1;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Transition Case Created", "description": "Ensure a new transition case was created", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 3\n  AND priority = 'moderate'\n  AND state = 'new'\n  AND channel = 'web';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Notification Sent to New Primary", "description": "Check to see that notification was sent to new primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM notification\nWHERE email = 'derek.blake7@globex.com'\n  AND type = 'update'\n  AND case_id = (\n      SELECT case_id\n      FROM customer_case\n      WHERE account_id = 4\n        AND contact_id = 3\n        AND priority = 'moderate'\n        AND state = 'new'\n      ORDER BY case_id DESC\n      LIMIT 1\n  );\n", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Move all open cases", "description": "All Open Cases moved from the resigned primary contact to the updated primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 2\n  AND state IN ('new','in_progress','pending');", "expected_value": 0, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Update Primary Contact", "description": "Ensure primary contact was set correctly", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM contact\nWHERE contact_id = 3\n  AND is_primary = 1;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Transition Case Created", "description": "Ensure a new transition case was created", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 3\n  AND priority = 'moderate'\n  AND state = 'new'\n  AND channel = 'web';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Notification Sent to New Primary", "description": "Check to see that notification was sent to new primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM notification\nWHERE email = 'derek.blake7@globex.com'\n  AND type = 'update'\n  AND case_id = (\n      SELECT case_id\n      FROM customer_case\n      WHERE account_id = 4\n        AND contact_id = 3\n        AND priority = 'moderate'\n        AND state = 'new'\n      ORDER BY case_id DESC\n      LIMIT 1\n  );\n", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Move all open cases", "description": "All Open Cases moved from the resigned primary contact to the updated primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 2\n  AND state IN ('new','in_progress','pending');", "expected_value": 0, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Update Primary Contact", "description": "Ensure primary contact was set correctly", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM contact\nWHERE contact_id = 3\n  AND is_primary = 1;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Transition Case Created", "description": "Ensure a new transition case was created", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 3\n  AND priority = 'moderate'\n  AND state = 'new'\n  AND channel = 'web';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Notification Sent to New Primary", "description": "Check to see that notification was sent to new primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM notification\nWHERE email = 'derek.blake7@globex.com'\n  AND type = 'update'\n  AND case_id = (\n      SELECT case_id\n      FROM customer_case\n      WHERE account_id = 4\n        AND contact_id = 3\n        AND priority = 'moderate'\n        AND state = 'new'\n      ORDER BY case_id DESC\n      LIMIT 1\n  );\n", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Move all open cases", "description": "All Open Cases moved from the resigned primary contact to the updated primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 2\n  AND state IN ('new','in_progress','pending');", "expected_value": 0, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Update Primary Contact", "description": "Ensure primary contact was set correctly", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM contact\nWHERE contact_id = 3\n  AND is_primary = 1;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Transition Case Created", "description": "Ensure a new transition case was created", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 3\n  AND priority = 'moderate'\n  AND state = 'resolved'\n  AND channel = 'web';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Notification Sent to New Primary", "description": "Check to see that notification was sent to new primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM notification\nWHERE email = 'derek.blake7@globex.com'\n  AND type = 'update'\n  AND case_id = (\n      SELECT case_id\n      FROM customer_case\n      WHERE account_id = 4\n        AND contact_id = 3\n        AND priority = 'moderate'\n        AND state = 'resolved'\n      ORDER BY case_id DESC\n      LIMIT 1\n  );\n", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Move all open cases", "description": "All Open Cases moved from the resigned primary contact to the updated primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 2\n  AND state IN ('new','in_progress','pending');", "expected_value": 0, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Update Primary Contact", "description": "Ensure primary contact was set correctly", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM contact\nWHERE contact_id = 3\n  AND is_primary = 1;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Transition Case Created", "description": "Ensure a new transition case was created", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 3\n  AND priority = 'moderate'\n  AND state = 'resolved'\n  AND channel = 'web';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Notification Sent to New Primary", "description": "Check to see that notification was sent to new primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM notification\nWHERE email = 'derek.blake7@globex.com'\n  AND type = 'update'\n  AND case_id = (\n      SELECT case_id\n      FROM customer_case\n      WHERE account_id = 4\n        AND contact_id = 3\n        AND priority = 'moderate'\n        AND state = 'resolved'\n      ORDER BY case_id DESC\n      LIMIT 1\n  );\n", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Move all open cases", "description": "All Open Cases moved from the resigned primary contact to the updated primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 2\n  AND state IN ('new','in_progress','pending');", "expected_value": 0, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Update Primary Contact", "description": "Ensure primary contact was set correctly", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM contact\nWHERE contact_id = 3\n  AND is_primary = 1;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Transition Case Created", "description": "Ensure a new transition case was created", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 3\n  AND priority = 'moderate'\n  AND state = 'resolved'\n  AND channel = 'web';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Notification Sent to New Primary", "description": "Check to see that notification was sent to new primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM notification\nWHERE email = 'derek.blake7@globex.com'\n  AND type = 'update'\n  AND case_id = (\n      SELECT case_id\n      FROM customer_case\n      WHERE account_id = 4\n        AND contact_id = 3\n        AND priority = 'moderate'\n        AND state = 'resolved'\n      ORDER BY case_id DESC\n      LIMIT 1\n  );\n", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Move all open cases", "description": "All Open Cases moved from the resigned primary contact to the updated primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 2\n  AND state IN ('new','in_progress','pending');", "expected_value": 0, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Update Primary Contact", "description": "Ensure primary contact was set correctly", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM contact\nWHERE contact_id = 3\n  AND is_primary = 1;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Transition Case Created", "description": "Ensure a new transition case was created", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 3\n  AND priority = 'moderate'\n  AND state = 'resolved'\n  AND channel = 'web';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Notification Sent to New Primary", "description": "Check to see that notification was sent to new primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM notification\nWHERE email = 'derek.blake7@globex.com'\n  AND type = 'update'\n  AND case_id = (\n      SELECT case_id\n      FROM customer_case\n      WHERE account_id = 4\n        AND contact_id = 3\n        AND priority = 'moderate'\n        AND state = 'resolved'\n      ORDER BY case_id DESC\n      LIMIT 1\n  );\n", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Move all open cases", "description": "All Open Cases moved from the resigned primary contact to the updated primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 2\n  AND state IN ('new','in_progress','pending');", "expected_value": 0, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Update Primary Contact", "description": "Ensure primary contact was set correctly", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM contact\nWHERE contact_id = 3\n  AND is_primary = 1;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Transition Case Created", "description": "Ensure a new transition case was created", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 3\n  AND priority = 'moderate'\n  AND state = 'resolved'\n  AND channel = 'web';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Notification Sent to New Primary", "description": "Check to see that notification was sent to new primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM notification\nWHERE email = 'derek.blake7@globex.com'\n  AND type = 'update'\n  AND case_id = (\n      SELECT case_id\n      FROM customer_case\n      WHERE account_id = 4\n        AND contact_id = 3\n        AND priority = 'moderate'\n        AND state = 'resolved'\n      ORDER BY case_id DESC\n      LIMIT 1\n  );\n", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Move all open cases", "description": "All Open Cases moved from the resigned primary contact to the updated primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 2\n  AND state IN ('new','in_progress','pending');", "expected_value": 0, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Update Primary Contact", "description": "Ensure primary contact was set correctly", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT is_primary\nFROM contact\nWHERE contact_id = 3;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Transition Case Created", "description": "Ensure a new transition case was created", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM customer_case\nWHERE account_id = 4\n  AND contact_id = 3\n  AND priority = 'moderate'\n  AND state = 'resolved'\n  AND channel = 'web';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Notification Sent to New Primary", "description": "Check to see that notification was sent to new primary contact", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM notification\nWHERE email = 'derek.blake7@globex.com'\n  AND type = 'update'\n  AND case_id = (\n      SELECT case_id\n      FROM customer_case\n      WHERE account_id = 4\n        AND contact_id = 3\n        AND priority = 'moderate'\n        AND state = 'resolved'\n      ORDER BY case_id DESC\n      LIMIT 1\n  );\n", "expected_value": 1, "comparison_type": "equals"}}]