Functional Analysis Tool

Version 10 Saved on: 2026-03-10 11:59:11 UTC

client_name: "Galderma"

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

sections:
  - title: "Account Management"
    # A list of subsections, each with its own subtitle and queries
    subsections:
      - subtitle: "Approved Notes"
        queries:
          - name: "Query"
            sql: "SELECT id, object_type__vr.name__v FROM monitored_text__v WHERE (created_date__v > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')"

      - subtitle: "Consent Capture"
        queries:
          - name: "Query"
            sql: "SELECT id, (SELECT country__vr.name__v FROM account__vr) FROM multichannel_consent__v WHERE (created_date__v > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')"
            # Tokens specific only to this query
            group_by: "account__vr.country__vr.name__v"

      - subtitle: "DCRs"
        queries:
          - name: "Query"
            sql: "SELECT id, created_by__vr.country_code__v FROM data_change_request__v WHERE (created_date__v > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')"
            # Tokens specific only to this query
            group_by: "created_by__vr.country_code__v"

Version 9 Saved on: 2026-03-10 11:58:06 UTC

client_name: "Galderma"

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

sections:
  - title: "Account Management"
    # A list of subsections, each with its own subtitle and queries
    subsections:
      - subtitle: "Approved Notes"
        queries:
          - name: "Account Management - Approved Notes"
            sql: "SELECT id, object_type__vr.name__v FROM monitored_text__v WHERE (created_date__v > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')"

      - subtitle: "Consent Capture"
        queries:
          - name: "Account Management - Approved Notes"
            sql: "SELECT id, (SELECT country__vr.name__v FROM account__vr) FROM multichannel_consent__v WHERE (created_date__v > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')"
            # Tokens specific only to this query
            group_by: "account__vr.country__vr.name__v"

      - subtitle: "DCRs"
        queries:
          - name: "Account Management - Approved Notes"
            sql: "SELECT id, created_by__vr.country_code__v FROM data_change_request__v WHERE (created_date__v > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')"
            # Tokens specific only to this query
            group_by: "created_by__vr.country_code__v"

Version 8 Saved on: 2026-03-10 11:53:14 UTC

client_name: "Bayer"

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

sections:
  - title: "Account Management"
    # A list of subsections, each with its own subtitle and queries
    subsections:
      - subtitle: "Approved Notes"
        queries:
          - name: "Account Management - Approved Notes"
            sql: "SELECT id, object_type__vr.name__v FROM monitored_text__v WHERE (created_date__v > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')"

          - name: "Event Planning and Execution"
            sql: "SELECT id, (SELECT country__vr.name__v FROM account__vr) FROM multichannel_consent__v WHERE (created_date__v > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')"
            # Tokens specific only to this query
            group_by: "account__vr.country__vr.name__v"

          - name: "Event Planning and Execution"
            sql: "SELECT id, created_by__vr.country_code__v FROM data_change_request__v WHERE (created_date__v > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')"
            # Tokens specific only to this query
            group_by: "created_by__vr.country_code__v"

Version 7 Saved on: 2026-03-10 11:28:51 UTC

client_name: "Bayer"

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

sections:
  - title: "Account Management"
    # A list of subsections, each with its own subtitle and queries
    subsections:
      - subtitle: "Approved Notes"
        queries:
          - name: "Account Management - Approved Notes"
            sql: "SELECT id, object_type__vr.name__v FROM monitored_text__v WHERE (created_date__v > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')"

          - name: "Event Planning and Execution"
            sql: "SELECT id, (SELECT country__vr.name__v FROM account__vr) FROM multichannel_consent__v"
            # Tokens specific only to this query
            group_by: "country__vr.name__v"

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

Version 6 Saved on: 2026-03-10 11:26:54 UTC

client_name: "Bayer"

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

sections:
  - title: "Account Management"
    # A list of subsections, each with its own subtitle and queries
    subsections:
      - subtitle: "Approved Notes"
        queries:
          - name: "Account Management - Approved Notes"
            sql: "SELECT id, object_type__vr.name__v FROM monitored_text__v WHERE (created_date__v > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')"

          - name: "Event Planning and Execution"
            sql: "SELECT id, (SELECT country__vr.name__v FROM account__vr) AS country FROM multichannel_consent__v"
            # Tokens specific only to this query
            group_by: "country__vr.name__v"

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

Version 5 Saved on: 2026-03-10 11:23:54 UTC

client_name: "Bayer"

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

sections:
  - title: "Account Management"
    # A list of subsections, each with its own subtitle and queries
    subsections:
      - subtitle: "Approved Notes"
        queries:
          - name: "Account Management - Approved Notes"
            sql: "SELECT id, object_type__vr.name__v FROM monitored_text__v WHERE (created_date__v > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')"

          - name: "Event Planning and Execution"
            sql: "SELECT id, (SELECT country__vr.name__v FROM account__vr) AS country FROM multichannel_consent__v"
            # Tokens specific only to this query
            group_by: "country"

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

Version 4 Saved on: 2026-03-10 11:22:58 UTC

client_name: "Bayer"

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

sections:
  - title: "Account Management"
    # A list of subsections, each with its own subtitle and queries
    subsections:
      - subtitle: "Approved Notes"
        queries:
          - name: "Account Management - Approved Notes"
            sql: "SELECT id, object_type__vr.name__v FROM monitored_text__v WHERE (created_date__v > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')"

          - name: "Event Planning and Execution"
            sql: "SELECT id, (SELECT country__vr.name__v FROM account__vr) AS country FROM multichannel_consent__v"
            # Tokens specific only to this query
            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
            group_by: "vcountry__vr.name__v"

Version 3 Saved on: 2026-03-10 11:22:24 UTC

client_name: "Bayer"

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

sections:
  - title: "Account Management"
    # A list of subsections, each with its own subtitle and queries
    subsections:
      - subtitle: "Approved Notes"
        queries:
          - name: "Account Management - Approved Notes"
            sql: "SELECT id, object_type__vr.name__v FROM monitored_text__v WHERE (created_date__v > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')"

          - name: "Event Planning and Execution"
            sql: "SELECT id, (SELECT country__vr.name__v FROM account__vr) AS country FROM multichannel_consent__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"

Version 2 Saved on: 2026-03-10 11:21:58 UTC

client_name: "Bayer"

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

sections:
  - title: "Account Management"
    # A list of subsections, each with its own subtitle and queries
    subsections:
      - subtitle: "Approved Notes"
        queries:
          - name: "Account Management - Approved Notes"
            sql: "SELECT id, object_type__vr.name__v FROM monitored_text__v WHERE (created_date__v > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')"

          - name: "Event Planning and Execution"
            sql: "SELECT id, (SELECT country__vr.name__v FROM account__vr) AS country FROM multichannel_consent__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 1 Saved on: 2026-03-10 11:14:34 UTC

client_name: "Bayer"

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

sections:
  - title: "Account Management"
    # A list of subsections, each with its own subtitle and queries
    subsections:
      - subtitle: "Approved Notes"
        queries:
          - name: "Account Management - Approved Notes"
            sql: "SELECT id, object_type__vr.name__v FROM monitored_text__v WHERE (created_date__v > '{MIN_DATE}') AND (created_date__v <= '{MAX_DATE}')"

          - 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 History: Galderma - EMEA