Functional Analysis Tool

Version 13 Saved on: 2026-02-24 15:32:14 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 FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM call2__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v, created_by__vr.user_type__v, created_by__vr.profile_name__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id, vcountry__vr.name__v FROM account__v "
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "vcountry__vr.name__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 12 Saved on: 2026-02-24 15:01:33 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 FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM call2__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v, created_by__vr.user_type__v, created_by__vr.profile_name__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id, vcountry__vr.name__v FROM account__v "
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "vcountry__vr.name__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.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 11 Saved on: 2026-02-24 14:23:27 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 FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM call2__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v, created_by__vr.user_type__v, created_by__vr.profile_name__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.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 10 Saved on: 2026-02-24 14:22:09 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 FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM call__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v, created_by__vr.user_type__v, created_by__vr.profile_name__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.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 9 Saved on: 2026-02-24 14:06:01 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 FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.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 8 Saved on: 2026-02-24 13:39:00 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 FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.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 7 Saved on: 2026-02-24 13:36:44 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__vr.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-23 17:02:56 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 5 Saved on: 2026-02-20 16:47:24 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"
          
          - 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 4 Saved on: 2026-02-20 15:50:03 UTC

Test 4

Version 3 Saved on: 2026-02-20 15:49:24 UTC

Test

Version 2 Saved on: 2026-02-20 15:49:11 UTC

New version

Version 1 Saved on: 2026-02-20 15:48:43 UTC

Test

Version History: a - a