Functional Analysis Tool

Version 7 Saved on: 2026-02-24 12:55:41 UTC

client_name: "Bayer"

# Tokens that apply to ALL queries (e.g., Date ranges, Schema names)
global_tokens:
  - "COUNTRY_CODE"
  - "END_DATE"
  - "DB_SCHEMA"

sections:
  - title: "Multichannel & Digital Engagement"
    # A list of subsections, each with its own subtitle and queries
    subsections:
      - subtitle: "Events Management"
        queries:
          - name: "Event Planning and Execution"
            sql: "SELECT id, email__sys FROM user__sys"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__v.country__v"
          
          - name: "Approved Email for Events"
            sql: "SELECT id, email__sys FROM user__sys WHERE country_code__v = '{COUNTRY_CODE}' AND name__v = '{NAME}'"
            sub_tokens:
              - "NAME"
              - "COUNTRY_CODE"
      - subtitle: "CLM Presentations"
        queries:
          - name: "Custom Presentations"
            sql: "SELECT id, email__sys FROM user__sys WHERE country_code__v = '{COUNTRY_CODE}' AND security_profile__sys = '{SECURITY_PROFILE}'"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
          
          - name: "Media Library Search & Filtering"
            sql: "SELECT id, email__sys FROM user__sys WHERE country_code__v = '{COUNTRY_CODE}' AND name__v = '{NAME}'"
            sub_tokens:
              - "NAME"
    

  - title: "Core CRM & Account Management"
    subsections:
      - subtitle: "Account Management"
        queries:
          - name: "Account Profiles"
            sql: "SELECT id, email__sys FROM user__sys WHERE country_code__v = '{COUNTRY_CODE}' AND name__v = '{NAME}'"
            sub_tokens:
              - "NAME"

Version 6 Saved on: 2026-02-24 12:44:05 UTC

client_name: "Bayer"

# Tokens that apply to ALL queries (e.g., Date ranges, Schema names)
global_tokens:
  - "COUNTRY_CODE"
  - "END_DATE"
  - "DB_SCHEMA"

sections:
  - title: "Multichannel & Digital Engagement"
    # A list of subsections, each with its own subtitle and queries
    subsections:
      - subtitle: "Events Management"
        queries:
          - name: "Event Planning and Execution"
            sql: "SELECT id, email__sys FROM user__sys"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__v.Country__v"
          
          - name: "Approved Email for Events"
            sql: "SELECT id, email__sys FROM user__sys WHERE country_code__v = '{COUNTRY_CODE}' AND name__v = '{NAME}'"
            sub_tokens:
              - "NAME"
              - "COUNTRY_CODE"
      - subtitle: "CLM Presentations"
        queries:
          - name: "Custom Presentations"
            sql: "SELECT id, email__sys FROM user__sys WHERE country_code__v = '{COUNTRY_CODE}' AND security_profile__sys = '{SECURITY_PROFILE}'"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
          
          - name: "Media Library Search & Filtering"
            sql: "SELECT id, email__sys FROM user__sys WHERE country_code__v = '{COUNTRY_CODE}' AND name__v = '{NAME}'"
            sub_tokens:
              - "NAME"
    

  - title: "Core CRM & Account Management"
    subsections:
      - subtitle: "Account Management"
        queries:
          - name: "Account Profiles"
            sql: "SELECT id, email__sys FROM user__sys WHERE country_code__v = '{COUNTRY_CODE}' AND name__v = '{NAME}'"
            sub_tokens:
              - "NAME"

Version History: a - a - Copy